Re: dropping anonymous constraints - Mailing list pgsql-general

From Ben Liblit
Subject Re: dropping anonymous constraints
Date
Msg-id Pine.LNX.4.44.0207170112500.14316-100000@brawnix.CS.Berkeley.EDU
Whole thread Raw
In response to Re: dropping anonymous constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Try psql's \d command to check out constraint names.

That did it.  Thank you for the speedy reply.

(I can't help but shake my head at the design of ALTER TABLE's constraint
manipulation facilities, whose non-orthogonality requires one to step
outside the language and use things like "\d" to accomplish this sort of
task.  Perhaps when I have more database experience under my belt that
will feel like less of a kludge.)

In any case, thanks again for the help!



pgsql-general by date:

Previous
From: Adrian 'Dagurashibanipal' von Bidder
Date:
Subject: Re: MySQL vs. PostgreSQL
Next
From: "Stephen Birch"
Date:
Subject: Re: timestamped archive data index searches