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

2013-08-20 Thread Dave Page
Thanks, fixed. On Mon, Aug 19, 2013 at 1:00 PM, Neel Patel 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

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

2013-08-19 Thread Neel Patel
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 =

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

2013-08-19 Thread Neel Patel
Yes Sure Ashesh. I will look at it. Thanks, Neel Patel On Mon, Aug 19, 2013 at 3:24 PM, Ashesh Vashi wrote: > Neel, > > Please take a look at it as Dinesh is on leave. > > > On Mon, Aug 19, 2013 at 2:17 PM, Dave Page wrote: > >> Dinesh, can you take a look at this please? >> >> Thanks. >> >>

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

2013-08-19 Thread Ashesh Vashi
Neel, Please take a look at it as Dinesh is on leave. On Mon, Aug 19, 2013 at 2:17 PM, Dave Page wrote: > Dinesh, can you take a look at this please? > > Thanks. > > On Thu, Aug 15, 2013 at 9:32 AM, Attila Soki wrote: > > hi, > > > > when used with postgresql 9.3, pgadmin shows in table defin

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

2013-08-19 Thread Dave Page
Dinesh, can you take a look at this please? Thanks. On Thu, Aug 15, 2013 at 9:32 AM, Attila Soki 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 > MAT

[pgadmin-support] Foreign key match is unknown when using with postgresql 9.3b2

2013-08-15 Thread Attila Soki
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