Re: [GENERAL] Error dropping non-existent tables

2004-11-20 Thread Bruno Wolff III
On Sat, Nov 20, 2004 at 10:15:46 -0800, Baldeep Hira <[EMAIL PROTECTED]> wrote: > How do I move the "DROP TABLE" commands into a separate transaction? I > could move all the "DROP TABLE" commands into a separate sql-script > file, but then I never know which of the tables are existing in the > da

Re: [GENERAL] Error dropping non-existent tables

2004-11-20 Thread Baldeep Hira
Thanks Bruno. A silly followup question =) On Sat, 20 Nov 2004 10:51:13 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Fri, Nov 19, 2004 at 21:38:33 -0800, > Baldeep Hira <[EMAIL PROTECTED]> wrote: > > > > I am able to drop tables in PostgreSQL, but the problem arises when > > the table d

Re: [GENERAL] Error dropping non-existent tables

2004-11-20 Thread Bruno Wolff III
On Fri, Nov 19, 2004 at 21:38:33 -0800, Baldeep Hira <[EMAIL PROTECTED]> wrote: > > I am able to drop tables in PostgreSQL, but the problem arises when > the table does not exist and I try to execute a "drop table" command. The simplest fix is to do the drop table outside of a transaction (so t

[GENERAL] Error dropping non-existent tables

2004-11-19 Thread Baldeep Hira
Hi, I am a new PostgreSQL user and am not sure if this is the correct list for this question, please redirect me to the correct list, if needed? I recently starting using PostgreSQL 8.0.0-beta4 (Win32) and want to migrate some of the SQL scripts written for MySQL to PostgreSQL. I have the follow