Postgres Pro
Downloads
Home   >   mailing lists

DROP TYPE without error? - Mailing list pgsql-sql

From Philippe Lang
Subject DROP TYPE without error?
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F4208057C@poweredge.attiksystem.ch
Whole thread Raw
Responses Re: DROP TYPE without error?  (Mischa <mischa.Sandberg@telus.net>)
Re: DROP TYPE without error?  (Jeff Boes <jboes@nexcerpt.com>)
Re: DROP TYPE without error?  (Craig Addleman <craiga-@-sharechive.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION
Next
From: "Dinesh Pandey"
Date:
Subject: createlang 'pltclu' with postgreSQL.