Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key match is unknown when using with postgresql 9.3b2 - Mailing list pgadmin-support

From Dave Page
Subject Re: Foreign key match is unknown when using with postgresql 9.3b2
Date
Msg-id CA+OCxozMoDM9FgPuS4aqsQduitciAc50JHP=Y3CuROoHgx3DDA@mail.gmail.com
Whole thread Raw
In response to Foreign key match is unknown when using with postgresql 9.3b2  (Attila Soki <atiware@gmx.net>)
Responses Re: Foreign key match is unknown when using with postgresql 9.3b2  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-support
Tree view 
Dinesh, can you take a look at this please?

Thanks.

On Thu, Aug 15, 2013 at 9:32 AM, Attila Soki <atiware@gmx.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@postgresql.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

pgadmin-support by date:

Previous
From: Darren Duncan
Date:
Subject: Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Next
From: Ashesh Vashi
Date:
Subject: Re: Foreign key match is unknown when using with postgresql 9.3b2