Re: Foreign key match is unknown when using with postgresql 9.3b2

Thanks, fixed.

On Mon, Aug 19, 2013 at 1:00 PM, Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>wrote:

> Hi Dave,
>
> We just go through code and following are the findings.
>
> *Issue :- *
>
> To find out the constraint we are using pg_constraint class. In PG 9.2
> valid values for "confmatchtype" column in pg_constraint class is (f =
> full, p = partial, u = simple) But for PG 9.3 valid values are (f = full,
> p = partial, s = simple).
>
> Because of the above change in PG 9.3 our pgAdmin below logic will fail in
> pgForeignKey.cpp file and it shows value "MATCH UNKNOWN" in SQL Pane.
>
> foreignKey->iSetMatch(
>
> match.IsSameAs('f') ? wxT("FULL") :
>
> match.IsSameAs('u') ? wxT("SIMPLE") : wxT("Unknown"));
>
>
> *Solution:-*
>
> In above code we are comparing values "f" and "u" now we have to add one
> more case for "s".
>
>
> Below is the documentation link for PG 9.2 and PG 9.3 for reference.
>
> http://www.postgresql.org/docs/9.2/static/catalog-pg-constraint.html
>
> http://www.postgresql.org/docs/9.3/static/catalog-pg-constraint.html
>
>
> Please suggest.
>
>
> Thanks,
>
> Neel Patel
>
>
>
>
>
>
> On Mon, Aug 19, 2013 at 3:50 PM, Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>wrote:
>
>> Yes Sure Ashesh.
>>
>> I will look at it.
>>
>> Thanks,
>> Neel Patel
>>
>>
>> On Mon, Aug 19, 2013 at 3:24 PM, Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> Neel,
>>>
>>> Please take a look at it as Dinesh is on leave.
>>>
>>>
>>> On Mon, Aug 19, 2013 at 2:17 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>>> Dinesh, can you take a look at this please?
>>>>
>>>> Thanks.
>>>>
>>>> On Thu, Aug 15, 2013 at 9:32 AM, Attila Soki <atiware(at)gmx(dot)net> wrote:
>>>> > hi,
>>>> >
>>>> > when used with postgresql 9.3, pgadmin shows in table definition
>>>> > ...
>>>> > CONSTRAINT xy_fkey FOREIGN KEY (xy_id)
>>>> > REFERENCES tablename (xy_id) MATCH Unknown
>>>> >
>>>> > insead of
>>>> > MATCH SIMPLE
>>>> >
>>>> >
>>>> > before 9.3 for MATCH SIMPLE was confmatchtype=u
>>>> > since postgresql 9.3 is confmatchtype=s
>>>> >
>>>> > cheers,
>>>> > Attila Soki
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org
>>>> )
>>>> > To make changes to your subscription:
>>>> > http://www.postgresql.org/mailpref/pgadmin-support
>>>>
>>>>
>>>>
>>>> --
>>>> Dave Page
>>>> Blog: http://pgsnake.blogspot.com
>>>> Twitter: @pgsnake
>>>>
>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>>
>>>> --
>>>> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgadmin-support
>>>>
>>>
>>>
>>>
>>> --
>>> --
>>>
>>> Thanks & Regards,
>>>
>>> Ashesh Vashi
>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com>
>>>
>>>
>>>
>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
>>>
>>
>>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company