From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "P(dot)M" <pmdanger(at)yahoo(dot)com> |
Cc: | "PostgreSQL General (EN)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: drop user / role if exists |
Date: | 2006-05-21 10:13:11 |
Message-ID: | 20060521101311.GC10443@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2006-05-21 10:17:09 | Re: drop user / role if exists |
Previous Message | P.M | 2006-05-21 09:59:25 | Re: drop user / role if exists |