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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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