Hi, On Sun, 2006-05-21 at 02:25 -0700, P.M wrote:
> 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 :-( I think you are running your query inside a transaction. Remove the BEGIN and COMMIT parts... -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match