[SQL] createuser problem

2001-02-14 Thread fion yong
It gives the following error when i tried to a new user createuser demouser1Connection to database 'template1' failed.FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow' how should i solve this problem?

Re: [SQL] createuser problem

2001-02-14 Thread Oliver Elphick
"fion yong" wrote: It gives the following error when i tried to a new user createuser demouser1 Connection to database 'template1' failed. FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow' how should i solve this problem? Become user postgres before you try to run

Re: [SQL] createuser problem

2001-02-14 Thread Jie Liang
run this as user 'postgres' instead of 'fion' Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Tue, 13 Feb 2001, fion yong wrote: It gives the following

[SQL] createuser

2000-10-04 Thread Craig May
Hi, I'm having trouble with the createuser command. createuser -adq username returns invalid option adq Could someone post an example using these args. Regards, Craig May Enth Dimension http://www.enthdimension.com.au

Re: [SQL] createuser

2000-10-04 Thread Peter Eisentraut
Craig May writes: createuser -adq username returns invalid option adq createuser -a -d -q -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/