Re: dev 1.15 wxwidgets - constraints with multiple tables

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Colin Beckingham <colbec(at)start(dot)ca>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: dev 1.15 wxwidgets - constraints with multiple tables
Date: 2012-04-06 18:40:55
Message-ID: 1333737655.20329.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Fri, 2012-04-06 at 08:03 -0400, Colin Beckingham wrote:
> Given 3 tables, authors, books and words, each has a primary key.
>
> Attempting to use pgadmin to add a foreign key to books to link authors
> to books, and a key to words to link words to books.
>
> The first step works ok (ignoring previously reported backtrace) and the
> foreign key is added to books linking it to authors. However when
> attempting to add a foreign key to words, pgadmin can still only see the
> authors table as a reference table.
>
> Tried reloading and refreshing but pgadmin does not seem to see beyond
> the authors table for the 'referencing' dropdown.
>
> Maybe I am missing a step. table books definitely has a primary key.

Can you give us your tables' definition? Thanks.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Colin Beckingham 2012-04-06 19:11:29 Re: dev 1.15 wxwidgets - constraints with multiple tables
Previous Message Guillaume Lelarge 2012-04-06 18:40:06 Re: dev 1.15 wxwidgets 2.9.3 - adding constraints