Re: Column property / Drop constraint

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 26 May 2003 17:17
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Column property / Drop constraint
>
> 2) Drop constraint does not work
> It seems that the correct syntax is:
> ALTER TABLE schema.table DROP CONSTRAINT constraint
> and not
> ALTER TABLE schema.table DROP CONSTRAINT schema.constraint

My bad - should be fixed now.

Andreas - notived something odd when looking at this that I haven't
looked at further: when I added a check to a table, it re-added some of
the category sub-nodes again:

Table
Columns
Constraints (2)
Triggers
Columns
Constraints (3)
Triggers

I also had to add the check from the properties dialogue, I couldn't do
it from the context menu, though I could add a unique constraint there.
Dunno if that's related to the gtk issue...

Regards, Dave.