Error dropping non-existent tables

From: Baldeep Hira <baldeephira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error dropping non-existent tables
Date: 2004-11-20 05:38:33
Message-ID: 6c1f039a041119213853956b17@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 following SQL command, is there an equivalent version for
PostgreSQL?

"DROP TABLE IF EXISTS my_table CASCADE;"

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.

thanks in advance,
Baldeep.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Böck 2004-11-20 12:58:58 infinite recursion detected in rules for relation "..."
Previous Message Premsun Choltanwanich 2004-11-20 01:57:12 Re: How to make lo_import and lo_export to use file