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
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
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
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
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