Re: Cannot see foreign key

Hi,

Can you download and try pgAdmin 1.3.60 please. The code that is at fault here has be significantly overhauled since 1.2.0 and your problem may well not exist any more.

Thanks, Dave.

> -----Original Message-----
> From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> Sent: 13 August 2002 01:31
> To: Dave Page
> Subject: RE: [pgadmin-support] Cannot see foreign key
>
>
> Hi there!
> Now, I know what you meant, I just remembered that I
> transfered the path to the log files that's why I didn't see
> any log file yesterday. Here is a part of the log file.....
> Thank you again for your time. ü
>
>
>
> Properties="DRIVER={PostgreSQL};DATABASE=tempMPS;SERVER=lychee
> ;PORT=5432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDIN
> DEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNS
> ETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=2
> 54;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPTIMIZER=1;KSQO
> =1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR
> =1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFI
> XES=dd_")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Get Identifier()
> 2002-08-13 08:19:03 - Entering
> pgSchema:ForeignKeys.iAdd(352452,
> "stock_trans_in_area_id_fkey", 6,
> "stock_trans_in_area_id_fkey stock_trans area UNSPECIFIED
> stock_trans_in_area_id area_id ", False, False)
> 2002-08-13 08:19:03 - Entering pgSchema:pgServer.Property Get
> LastSystemOID()
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let SystemObject(False)
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let OID(352452)
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let Name("stock_trans_in_area_id_fkey")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let Table("stock_trans")
> 2002-08-13 08:19:03 - Entering pgSchema:ForeignKeys.Property
> let TableOID(301418)
> 2002-08-13 08:19:03 - Entexñÿ¿àÏring
> pgSchema:pgForeignKey.Property Let ReferencedTable("area")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let LocalColumns(""stock_trans_in_area_id"|")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let ReferencedColumns(""area_id"|")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let Deferrable(False)
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let Initially("Immediate")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Let Identifier("stock_trans_in_area_id_fkey -> area")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Set Connection(Connection: Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=tempMPS;SERVER=lychee
> ;PORT=5432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDIN
> DEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNS
> ETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=2
> 54;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPTIMIZER=1;KSQO
> =1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR
> =1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFI
> XES=dd_")
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Property
> Get Identifier()
> 2002-08-13 08:19:03 - Entering pgSchema:pgForeignKey.Class_Terminate()
>
> 2002-08-13 08:19:03 -
> *******************************************************************
> 2002-08-13 08:19:03 - Error
> 2002-08-13 08:19:03 -
> *******************************************************************
> 2002-08-13 08:19:03 - Error in pgAdmin II:frmMain.tvTable:
> 457 - This key is already associated with an element of this
> collection
> 2002-08-13 08:19:03 - Windows Version: Windows 2000 v5.0 build 2195
> 2002-08-13 08:19:03 - pgSchema Version: 1.2.0
> 2002-08-13 08:19:03 - MDAC Version: 2.5
> 2002-08-13 08:19:03 - DBMS Version: 07.01.0009 PostgreSQL
> 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
> 2002-08-13 08:19:03 - Connection String (Master Connection):
> Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=lych
> ee;PORT=5432;UID=postgresxñÿ¿àÏ;PWD=********;READONLY=0;PROTOC
> OL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYST
> EMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;
> MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;
> OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNO
> WNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EX
> TRASYSTABLEPREFIXES=dd_"
>
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> Date: Mon, 12 Aug 2002 12:36:21 +0100
> To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>
> Subject: RE: [pgadmin-support] Cannot see foreign key
>
>
> > Yes it would, but I want to exampine the logfile it creates.
> >
> > Regards, Dave.
> >
> > > -----Original Message-----
> > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > Sent: 12 August 2002 12:33
> > > To: Dave Page
> > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > >
> > >
> > > I've tried logging to full debug mode but it still gives out
> > > the same error which is: This key is already associated with
> > > an element of this collection.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> > > Date: Mon, 12 Aug 2002 10:39:26 +0100
> > > To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>
> > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > >
> > >
> > > > Can you please switch logging to full debug under Tools
> Options,
> > > > recreate the error and send me the logs?
> > > >
> > > > Thanks, Dave.
> > > >
> > > > > -----Original Message-----
> > > > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > > > Sent: 12 August 2002 10:03
> > > > > To: Dave Page
> > > > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > > > >
> > > > >
> > > > >
> > > > > Im using pgAdmin 1.2.0 and PostgreSQL 7.2.1-1
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> > > > > Date: Mon, 12 Aug 2002 08:22:47 +0100
> > > > > To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>,
> > > > > <pgadmin-support(at)postgresql(dot)org>
> > > > > Subject: RE: [pgadmin-support] Cannot see foreigxñÿ¿àÏn key
> > > > >
> > > > >
> > > > > >
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > > > > > Sent: 12 August 2002 05:07
> > > > > > > To: pgadmin-support(at)postgresql(dot)org
> > > > > > > Subject: [pgadmin-support] Cannot see foreign key
> > > > > > >
> > > > > > >
> > > > > > > Good day!
> > > > > > > Why is it that when I added a foreign key, it is not
> > > displayed
> > > > > > > in pgAdmin and when I clicked that table I got
> this message...
> > > > > > > Xòÿ¿àÏ
> > > > > > > An error has occured in pgAdmin II:fromMain.tvTable:
> > > > > > > Number 457
> > > > > > > Description:This key is already associated with
> an element of
> > > > > > > this collection
> > > > > > >
> > > > > > > What are the possible causes why I got this error message?
> > > > > > >
> > > > > > > Thanks in advance ü
> > > > > >
> > > > > > What version of pgAdmin & PostgreSQL are you running?
> > > > > >
> > > > > > Regards, Dave.
> > > > > >
> > > > >
> > > > > --
> > > > > Get your free email from www.linuxmail.org
> > > > >
> > > > >
> > > > > Powered by Outblaze
> > > > >
> > > >
> > >
> > > --
> > > Get your free email from www.linuxmail.org
> > >
> > >
> > > Powered by Outblaze
> > > ried logging to full debug mode but it still gives out the
> > > same error which is: This key is already associated with an
> > > element of this collection.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> > > Date: Mon, 12 Aug 2002 10:39:26 +0100
> > > To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>
> > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > >
> > >
> > > > Can you please switch logging to full debug under Tools
> Options,
> > > > recreate the error and send me the logs?
> > > >
> > > > Thanks, Dave.
> > > >
> > > > > -----Original Message-----
> > > > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > > > Sent: 12 August 2002 10:03
> > > > > To: Dave Page
> > > > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > > > >
> > > > >
> > > > >
> > > > > Im using pgAdmin 1.2.0 and PostgreSQL 7.2xñÿ¿àÏ.1-1
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> > > > > Date: Mon, 12 Aug 2002 08:22:47 +0100
> > > > > To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>,
> > > > > <pgadmin-support(at)postgresql(dot)org>
> > > > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > > > >
> > > > >
> > > > > >
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > > > > > Sent: 12 August 2002 05:07
> > > > > > > To: pgadmin-support(at)postgresql(dot)org
> > > > > > > Subject: [pgadmin-support] Cannot see foreign key
> > > > > > >
> > > > > > >
> > > > > > > Good day!
> > > > > > > Why is it that when I added a foreign key, it is not
> > > displayed
> > > > > > > in pgAdmin and when I clicked that table I got
> this message...
> > > > > > > Xòÿ¿àÏ
> > >
> >
>
> --
> Get your free email from www.linuxmail.org
>
>
> Powered by Outblaze
> running?
> > > > > >
> > > > > > Regards, Dave.
> > > > > >
> > > > >
> > > > > --
> > > > > Get your free email from www.linuxmail.org
> > > > >
> > > > >
> > > > > Powered by Outblaze
> > > > >
> > > >
> > >
> > > --
> > > Get your free email from www.linuxmail.org
> > >
> > >
> > > Powered by Outblaze
> > > ried logging to full debug mode but it still gives out the
> > > same error which is: This key is already associated with an
> > > element of this collection.
> > >
> > >
> > > ----- Original Message -----
> > > From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> > > Date: Mon, 12 Aug 2002 10:39:26 +0100
> > > To: "Purple Skies" <purple_sky(at)linuxmail(dot)org>
> > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > >
> > >
> > > > Can you please switch logging to full debug under Tools
> Options,
> > > > recreate the error and send me the logs?
> > > >
> > > > Thanks, Dave.
> > > >
> > > > > -----Original Message-----
> > > > > From: Purple Skies [mailto:purple_sky(at)linuxmail(dot)org]
> > > > > Sent: 12 August 2002 10:03
> > > > > To: Dave Page
> > > > > Subject: RE: [pgadmin-support] Cannot see foreign key
> > > > >
> > > > >
> > > > >
> > > > > Im using pgAdmin 1.2.0 and PostgreSQL 7.2xñÿ¿àÏ
>