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@svana.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.