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

Re: Wrong OID for Primary Key and UNIQUE constraints shown in property pane

From: Dave Page <dpage(at)postgresql(dot)org>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Wrong OID for Primary Key and UNIQUE constraints shown in property pane
Date: 2007-04-06 08:06:07
Message-ID: 4615FF6F.5090905@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-support
Harald Armin Massa wrote:
> Dave,
> 
> 
>     Thanks Harald - it was showing the OID of the index, not the constraint
>     record. I've fixed that, and modified the code to display the index OID
>     as a seperate property.
> 
> 
> thanks for fixing. One question: why did it work correctly on foreign 
> key constraints? (not to be nitpicking, just to make sure there is no 
> other bug hidden)

No problem - we like to spread the knowledge!

It worked for fkeys because they aren't index based constraints. The 
pkey and unique constraint code is actually derived from the pgIndexBase 
class, so 95% of the code used is the same as pgIndex. fkeys are a whole 
seperate class.

Regards, Dave

In response to

pgadmin-support by date

Next:From: Sidnei VladisauskisDate: 2007-04-06 16:39:53
Subject: RES: pgAgent - where is the node jobs?
Previous:From: Harald Armin MassaDate: 2007-04-06 07:58:52
Subject: Re: Wrong OID for Primary Key and UNIQUE constraints shown in property pane

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