DROP TYPE without error?

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: DROP TYPE without error?
Date: 2005-04-06 12:59:02
Message-ID: 6C0CF58A187DA5479245E0830AF84F4208057C@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Since it is not possible to use CREATE OR REPLACE TYPE, is there a way
of using DROP TYPE on a non-existing type, without causing the entire
script to abort? It may sound crazy to ask for this, but it could be
really useful in my case, where Pl/Pgsql and Pl/Perl code is being
generated automatically, based on data found in a database.

Thanks

-----------------
Philippe Lang

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Pandey 2005-04-06 14:09:02 createlang 'pltclu' with postgreSQL.
Previous Message Dinesh Pandey 2005-04-06 08:38:42 CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION