From: | "P(dot)M" <pmdanger(at)yahoo(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | "PostgreSQL General \(EN\)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: drop user / role if exists |
Date: | 2006-05-21 10:31:10 |
Message-ID: | 20060521103110.59216.qmail@web33207.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
first of all, it's not -i as i wrote but \i
i work under windows OS.
and my script is working now.
thanks for your help
Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote: On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote:
> To run the script i use :
>
> under psql command line, i load my SQL script file via :
>
> psql -i myfile;
Don't know what -i does, it's not a supported option, perhaps you mean
-f?
In any case, my version of postgres 7.4.7 works fine:
$ cat /tmp/f
drop user idontexist;
drop user indontexisteither;
drop user foo;
$ psql -f /tmp/f kleptog
psql:/tmp/f:1: ERROR: user "idontexist" does not exist
psql:/tmp/f:2: ERROR: user "indontexisteither" does not exist
psql:/tmp/f:3: ERROR: user "foo" does not exist
$
So I think you need to post the actual error before we can help you
further.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2006-05-21 16:55:18 | Re: advice on schema for multilingual text |
Previous Message | Devrim GUNDUZ | 2006-05-21 10:17:09 | Re: drop user / role if exists |