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

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Attila Soki <atiware(at)gmx(dot)net>, Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Foreign key match is unknown when using with postgresql 9.3b2
Date: 2013-08-19 08:47:11
Message-ID: CA+OCxozMoDM9FgPuS4aqsQduitciAc50JHP=Y3CuROoHgx3DDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2013-08-19 09:54:44 Re: Foreign key match is unknown when using with postgresql 9.3b2
Previous Message Darren Duncan 2013-08-16 21:49:20 Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane