Venkateswara Rao Bondada 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 that the operating
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
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 crea
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 th
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ø og i
