BUG #2644: pgadmin III foreign key

From: "Massimiliano Citterio" <massicitte(at)libero(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2644: pgadmin III foreign key
Date: 2006-09-22 08:20:43
Message-ID: 200609220820.k8M8Khxf079941@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Victor Snezhko 2006-09-22 09:55:44 Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous Message Victor Snezhko 2006-09-22 08:04:35 Re: BUG #1931: ILIKE and LIKE fails on Turkish locale