Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id A3DD32E0064
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 23 Jan 2008 06:26:12 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 31941-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 23 Jan 2008 06:26:06 -0400 (AST)
Received: from ns1.officenet.no (ns1.officenet.no [193.212.174.3])
	by postgresql.org (Postfix) with ESMTP id CB5582E0202
	for <pgsql-sql@postgresql.org>; Wed, 23 Jan 2008 06:26:06 -0400 (AST)
Received: from [193.212.174.32]
	by ns1.officenet.no with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.63) (envelope-from <andreak@officenet.no>)
	id 1JHcnt-00064q-Gu
	for pgsql-sql@postgresql.org; Wed, 23 Jan 2008 11:26:03 +0100
From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: pgsql-sql@postgresql.org
Subject: ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ?
Date: Wed, 23 Jan 2008 11:25:44 +0100
User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405)
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200801231125.44180.andreak@officenet.no>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/177
X-Sequence-Number: 30030

Does PG have any way of doing $subject without writing a plpgsql-function=20
which does it by querying the catalog manually?

I'm looking for an equivalent of "DROP TABLE IF EXISTS <mytable>"

=2D-=20
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
=2D-----------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Karenslyst All=C3=A9 11      | know how to do a thing and to watch         |
PO. Box 529 Sk=C3=B8yen      | somebody else doing it wrong, without       |
0214 Oslo               | comment.                                    |
NORWAY                  |                                             |
Tlf:    +47 24 15 38 90 |                                             |
=46ax:    +47 24 15 38 91 |                                             |
Mobile: +47 909  56 963 |                                             |
=2D-----------------------+---------------------------------------------+