Re: [SQL] Problems when copy data from dump file

2009-08-04 Thread Richard Huxton
Klas Stockhem wrote: SQL error: ERROR: syntax error at or near 5 LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn#... ^ COPY artikkel (id, tittel, tekst) FROM stdin; 5Slitasje og vedlikeholdPRAKTISKE OPPLYSNINGER\r\n\r\nSn#248; og

Re: [SQL] Problems when copy data from dump file

2009-08-04 Thread Richard Huxton
Klas Stockhem wrote: Thanks for your mail! Remember to cc: the mailing list too. Just hit reply to all. Oh, and perhaps don't top-quote. It makes it difficult for others to follow the message. 1. Yes, the 5 and other text are at line 2 (a new line). I tried to put the whole command on the

Re: [SQL] Create table command fails with permission denied

2009-08-04 Thread Rob Sargent
Moderately curious. I wonder if 'cms' is on a different tablespace? Are there tables in that db? Btw, I don't have 7.4 so I'm only guessing based on 8.3 rjs Venkateswara Rao Bondada wrote: Hi Rob, I'm using postgres account (which is a superuser in the database) to create table. Table

Re: [SQL] Create table command fails with permission denied

2009-08-04 Thread Venkateswara Rao Bondada
Hi Rob, I'm using postgres account (which is a superuser in the database) to create table. Table creation is working fine in other databases except in this. As postgres user, I granted CREATE, USAGE ALL privileges to postgres account, still it didn't work. Please find the snapshots below where

Re: [SQL] Create table command fails with permission denied

2009-08-04 Thread Tom Lane
Venkateswara Rao Bondada venkateswar...@infosys.com writes: camd=# \c cms postgres You are now connected to database cms as user postgres. cms=# create table test(id character varying(80)); ERROR: could not create relation test: Permission denied Actually, what that is complaining about is