pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
2+ messages / 2 participants
[nested] [flat]
* ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
@ 2008-01-23 10:25 Andreas Joseph Krogh <andreak@officenet.no>
2008-01-24 15:44 ` Re: ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Andreas Joseph Krogh @ 2008-01-23 10:25 UTC (permalink / raw)
To: pgsql-sql
Does PG have any way of doing $subject without writing a plpgsql-function
which does it by querying the catalog manually?
I'm looking for an equivalent of "DROP TABLE IF EXISTS <mytable>"
--
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Karenslyst Allé 11 | know how to do a thing and to watch |
PO. Box 529 Skøyen | somebody else doing it wrong, without |
0214 Oslo | comment. |
NORWAY | |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
2008-01-23 10:25 ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Andreas Joseph Krogh <andreak@officenet.no>
@ 2008-01-24 15:44 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-01-24 15:44 UTC (permalink / raw)
To: Andreas Joseph Krogh <andreak@officenet.no>; +Cc: pgsql-sql
On Jan 23, 2008 4:25 AM, Andreas Joseph Krogh <andreak@officenet.no> wrote:
> Does PG have any way of doing $subject without writing a plpgsql-function
> which does it by querying the catalog manually?
No.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-01-24 15:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-23 10:25 ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Andreas Joseph Krogh <andreak@officenet.no>
2008-01-24 15:44 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox