Home > mailing lists

drop if exists - Mailing list pgsql-novice

From	Celia McInnis
Subject	drop if exists
Date	May 3, 2005 21:09:14
Msg-id	20050503205238.M86371@drmath.ca Whole thread Raw
In response to	Re: retrieving a previously defined stored procedure from the database? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

Tree view

What's the easiest way to drop a composite type definition or a table if you
aren't guaranteed that it exists?

I need to do this quite frequently from stored procedures and get booted out
of the stored procedure if I try to DROP something which doesn't currently
exist.

Thanks,
Celia McInnis

pgsql-novice by date:

From: Tom Lane
Date: 03 May 2005, 20:43:30
Subject: Re: retrieving a previously defined stored procedure from the database?

From: "Keith Worthington"
Date: 03 May 2005, 21:21:24
Subject: comparison trigger function

drop if exists - Mailing list pgsql-novice

Previous

Next