Re: drop user / role if exists

Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored procedure.

And when i run the SQL script, PostgreSQL stops just on first error....so if user does not exist, my script is not any longer run :-(

do you have any idea how to pass over this issue ?

thanks a lot,

Maileen

Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote: On Sun, May 21, 2006 at 02:08:38AM -0700, P.M wrote:
> Hi,
>
> How under postgreSQL 7 do the equivalent as DROP USER / ROLE IF EXISTS ?
> my web provider only support postgreSQL 7 :-(

Do the DROP USER and ignore the error if it doesn't exist.
--
Martijn van Oosterhout http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

---------------------------------
Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice.