Skip site navigation (1) Skip section navigation (2)

ForeignKey dialog does not show columns of tables in same shema

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: ForeignKey dialog does not show columns of tables in same shema
Date: 2006-04-03 07:48:07
Message-ID: 7be3f35d0604030048s19caa1bcqb85e09c42d9e8189@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Version 1.4.2 on Windows XP, freshly installed from the "official" .msi


situation:

database schema ibox containts table

filestore
- id_fs inet
- content bytea
- morecol text

and fs2objekt
- id_fs inet
- whatever text

I try to create a foreign key on f2objekt, referencing filestore

The dialogue does show all the tables within schema ibox, but if I select on
"dialog tab 1" filestore as referred table, I cannot select ANY column of
filestore on the second tab.
On selecting one of the fully qualified public tables (i.e.
public.pg_ts_parser) on tab1, I can select columns of that table in tab2

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra├če 202b
70197 Stuttgart
0173/9409607
-
PostgreSQL - supported by a community that does not put you on hold

pgadmin-support by date

Next:From: Dave PageDate: 2006-04-03 07:49:40
Subject: Re: Compile on x86_64
Previous:From: Ravi KumarDate: 2006-04-03 06:52:37
Subject: Problems while installing pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group