Foreign key match is unknown when using with postgresql 9.3b2

From: Attila Soki <atiware(at)gmx(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Foreign key match is unknown when using with postgresql 9.3b2
Date: 2013-08-15 08:32:59
Message-ID: 5B2C82FC-E6D0-414C-93ED-9FB6A4E12DCB@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Stephen Cook 2013-08-15 22:56:59 PGAdmin3 runs pg_dump etc
Previous Message Paragon Corporation 2013-08-15 05:39:25 MATERIALIZED VIEW not showing MATERIALIZED in SQL pane