On Jan 23, 2008 4:25 AM, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote:
> Does PG have any way of doing $subject without writing a plpgsql-function
> which does it by querying the catalog manually?
No.
---(end of broadcast)---
TIP 6: explain analyz
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 "
--
Andreas Joseph Krogh <[EMAIL PROTECTED]>
Senior Software Developer / Manager
+---
if the constraint are named $1 $2 etc you will need to quote them eg
ALTER TABLE xyz DROP CONSTRAINT "$1" ;
in some version you may require
ALTER TABLE xyz DROP CONSTRAINT "$1" RESTRICT;
What is ur version btw?
try to post the table structure also.
regds mallah.
Elielson Fontanezi wrote:
H
It works in 7.3.2.
George
- Original Message -
From:
Elielson Fontanezi
To: pgsql-general ; pgsql-sql
Sent: Wednesday, July 30, 2003 10:52
AM
Subject: [SQL] ALTER TABLE ... DROP
CONSTRAINT
Hi
all!
Who can tell me what postgres version supports
I think you can do some constraints in 7.2, but 7.3 will allow dropping
them all in that fashion.
On Wed, 2003-07-30 at 11:52, Elielson Fontanezi wrote:
> Hi all!
>
> Who can tell me what postgres version supports ALTER TABLE... DROP
> CONSTRAINT without
> the need of droping the table to re
Hi
all!
Who can tell me what postgres version supports
ALTER TABLE... DROP CONSTRAINT without
the need
of droping the table to remove a simple coinstraint.
(link)
>\\\!/< 55
11 5080
9283
Hi
all!
Who can tell me what postgres version supports ALTER TABLE... DROP
CONSTRAINT without
the need of
droping the table to remove a simple coinstraint. (link)
>\\\!/< 55
11 5080
9283
!_"""_! Elielson
