Commitb688f8f

Thomas G. Lockhart

committed

Fix query for primary keys to reflect new DISTINCT ON () syntax.

Reported by "Tibor Laszlo" <ltibor@mail.tiszanet.hu> and fix suggested by "Hiroshi Inoue" <Inoue@tpf.co.jp>.

1 parentdcdcada commitb688f8fCopy full SHA for b688f8f

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2135,7 +2135,7 @@ Int2 result_cols;`
`2135`	`2135`	`returnSQL_ERROR;`
`2136`	`2136`	`}`
`2137`	`2137`
`2138`		`-sprintf(tables_query,"select distinct on attnum a2.attname, a2.attnum from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where c.relname = '%s_pkey' AND c.oid = i.indexrelid AND a1.attrelid = c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum OR i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] = a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum",pktab);`
	`2138`	`+sprintf(tables_query,"select distinct on(attnum) a2.attname, a2.attnum from pg_attribute a1, pg_attribute a2, pg_class c, pg_index i where c.relname = '%s_pkey' AND c.oid = i.indexrelid AND a1.attrelid = c.oid AND a2.attrelid = c.oid AND (i.indkey[0] = a1.attnum OR i.indkey[1] = a1.attnum OR i.indkey[2] = a1.attnum OR i.indkey[3] = a1.attnum OR i.indkey[4] = a1.attnum OR i.indkey[5] = a1.attnum OR i.indkey[6] = a1.attnum OR i.indkey[7] = a1.attnum) order by a2.attnum",pktab);`
`2139`	`2139`
`2140`	`2140`	`mylog("SQLPrimaryKeys: tables_query='%s'\n",tables_query);`
`2141`	`2141`

Comments

(0)