Re: BUG #2644: pgadmin III foreign key

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of
> Massimiliano Citterio
> Sent: 22 September 2006 09:21
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] BUG #2644: pgadmin III foreign key
>
>
> The following bug has been logged online:
>
> Bug reference: 2644
> Logged by: Massimiliano Citterio
> Email address: massicitte(at)libero(dot)it
> PostgreSQL version: 8.1.4
> Operating system: Windows 2003
> Description: pgadmin III foreign key
> Details:
>
> The referencing column dropdown listbox not filled with fields from
> referenced table.
>
> The case appear after doing the following actions.
>
> Create a schema named like $user (ex. "postgres").
> Delete Schema "Public".
> Refresh the Database View...
> Now the default Schema for the database is "postgres"
>
> create tables, the try to create foreign keys using the GUI.
> There is no way.
>
> If you create a new schema "public" it does not works.
>
> If you create a new schema "public" and rename the "postgres"
> schema to
> something else the it works.
>
> If you drop schema "postgres" create schema "public" and then recreate
> schema postgres and his tables, then foreign key GUI works.
>
> May be the GUI search for schema "public" but it must have an
> OID lesser of
> all other schemas in the searchpath.
>
> Infact the default search path is $user, public.
>
> By the way it does not work if a schema named public does not exist.

I cannot reproduce this in the 1.6 development code - can you test beta
1 please?

Regards, Dave.