Re: Foreign Keys

> -----Original Message-----
> From: Friesen, James [mailto:jfriesen(at)hcjb(dot)org(dot)ec]
> Sent: 29 January 2003 19:13
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Foreign Keys
>
>
> I would like a graphical interface that would help me manage
> my foreign keys. I thought PgAdmin II would do this (it has
> the Foreign Key object
> type) but when I create a foreign key in PG and then try and
> see it in PgAdmin II it I don't see anything. I can't create
> new ones either using the interface. Am I using the program
> wrong or is this capability not implemented yet?

Hi James,

You can create fkeys when you create a table in pgAdmin, or browse
existing keys. You cannot add additional or drop existing keys yet
though, unless you enter the SQL manually. If you do so, you will need
to right-click and Refresh the relevant bit of the treeview to see the
changes.

Regards, Dave.