Thread: Bug in 0.9.1

If I right-click a table and change a security setting (using the show
users for privileges option), and that table has a foreign key
constraint, when trying to update the table, I get this error:

ERROR: parser: parse error at or near "CONSTRAINT" at character 2

On the SQL tab of the properties dialog, it reads:

CONSTRAINT "$1" "$1" FOREIGN KEY

where it should read:

CONSTRAINT "$1" FOREIGN KEY

which it does in the SQL pane when I select the table using the left
mouse button.

ahp

Added to bugs list.

> -----Original Message-----
> From: Adam H.Pendleton [mailto:fmonkey@fmonkey.net]
> Sent: 11 August 2003 00:36
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Bug in 0.9.1
>
>
> If I right-click a table and change a security setting (using
> the show
> users for privileges option), and that table has a foreign key
> constraint, when trying to update the table, I get this error:
>
> ERROR: parser: parse error at or near "CONSTRAINT" at character 2
>
> On the SQL tab of the properties dialog, it reads:
>
> CONSTRAINT "$1" "$1" FOREIGN KEY
>
> where it should read:
>
> CONSTRAINT "$1" FOREIGN KEY
>
> which it does in the SQL pane when I select the table using the left
> mouse button.
>
> ahp
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>