Pastebin

[postgres@malbec]~/smssender #psql -d sosms -Usosmsrw -W -h localhost                  [/dev/pts/7 # 74 - 0 - 2 # 0 day 01:55:08 # 0.30 - 0.32 - 0.31]
Password for user sosmsrw:                                                                                                                            
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.                                                                                           

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

sosms=> SELECT * FROM customer;
 customerid | customername  |         inserttime         |         updatetime         | smsprice
------------+---------------+----------------------------+----------------------------+----------
         10 | Sikkerhed.org | 2009-06-08 10:41:53.70934  | 2009-06-08 10:41:53.70934  |       50
         11 | LHK           | 2009-06-08 10:42:04.541294 | 2009-06-08 10:42:04.541294 |       50
         12 | VipGroup      | 2009-06-08 10:42:11.181731 | 2009-06-08 10:42:11.181731 |       50
         13 | Codelab       | 2009-06-08 10:42:16.989596 | 2009-06-08 10:42:16.989596 |       50
(4 rows)

sosms=> INSERT INTO customer(customerid, customername) VALUES(13, 'Codelab');
ERROR:  duplicate key value violates unique constraint "pkcustomer"
sosms=> INSERT INTO smsqueue(customerId, appnr, appPrice, msisdnTo, msisdnFrom, content, dryrun, callbackId, smstype)
sosms-> VALUES('10', '1255', '1', '+45xxxxxxxx', '+45xxxxxxxx', 'Hello World!', 'true', '034769d2-ed65-40d2-92dd-bc41b9c74947', 'A')
sosms-> ;
ERROR:  permission denied for sequence smsqueue_smsqueueid_seq
sosms=> \z
                                        Access privileges for database "sosms"
 Schema |            Name             |   Type   |                          Access privileges
--------+-----------------------------+----------+---------------------------------------------------------------------
 public | customer                    | table    | {postgres=arwdxt/postgres,sosmsro=r/postgres,sosmsrw=arwd/postgres}
 public | sms                         | table    | {postgres=arwdxt/postgres,sosmsro=r/postgres,sosmsrw=arwd/postgres}
 public | sms_smsid_seq               | sequence | {postgres=rwU/postgres,sosmsro=r/postgres,sosmsrw=r/postgres}
 public | smshistory                  | table    | {postgres=arwdxt/postgres,sosmsro=r/postgres,sosmsrw=arwd/postgres}
 public | smshistory_smshistoryid_seq | sequence | {postgres=rwU/postgres,sosmsro=r/postgres,sosmsrw=r/postgres}
 public | smsorder                    | table    | {postgres=arwdxt/postgres,sosmsro=r/postgres,sosmsrw=arwd/postgres}
 public | smsorder_smsorderid_seq     | sequence | {postgres=rwU/postgres,sosmsro=r/postgres,sosmsrw=r/postgres}
 public | smsqueue                    | table    | {postgres=arwdxt/postgres,sosmsro=r/postgres,sosmsrw=arwd/postgres}
 public | smsqueue_smsqueueid_seq     | sequence | {postgres=rwU/postgres,sosmsro=r/postgres,sosmsrw=r/postgres}
(9 rows)

sosms=>