Re: - Mailing list pgadmin-support

From Dave Page
Subject Re:
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC391E@ratbert.vale-housing.co.uk
Whole thread Raw
In response to  ("Prashanthi Muthyala" <pmuthyal@spsu.edu>)
Responses Re:  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support

> -----Original Message-----
> From: Cristinel Angheluta [mailto:acristi@mymail.ro]
> Sent: 04 November 2005 10:30
> To: Dave Page
> Subject: Re: [pgadmin-support]
>
>
> No I didn't get an error message.
> On "New Foreign key" dialog I'm not able to see any of the
> referencing
> table's fields( bottom most combobox on "Colums" tab). That's
> why I told
> you I'unable to create foreign keys.
> On "Properties" tab -> "References" combobox, all tables
> (except publics'
> ones) don't have as prefix the schema name (ex. schema2.table2).

Hmm, sorry - I still can't reproduce this or any other problems when
creating fkeys from either the table dialogue or when directly using the
foreign key dialogue.

Andreas (or anyone else) can you reproduce this, or think of any
cisrcumstances in which it might happen?

> One more thing that I discovered in 1.4.0 RC1 is that
> creation of a third
> schema helped me to solve this issue. Even if you delete/drop
> the third
> schema "New Foreign key" dialog works properly after that.

Hmm, I wonder if this is a refresh thing - you didn't create the
referenced table through the SQL dialogue, so it's not actually found
until the tree is refreshed perhaps?

Regards, Dave.


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re:
Next
From: Joost Kraaijeveld
Date:
Subject: Debian AMD64 compile problem