From: David E. W. <da...@ju...> - 2014-01-31 00:27:28
|
XCers, Sqitch has a query that looks like this: INSERT INTO tags ( tag_id , tag , project , change_id , note , committer_name , committer_email , planned_at , planner_name , planner_email ) SELECT tid, tg, proj, chid, n, name, email, at, pname, pemail FROM ( VALUES (?, ?, ?, ?, ?, ?, ?, ?::timestamptz, ?, ?) ) i(tid, tg, proj, chid, n, name, email, at, pname, pemail) LEFT JOIN tags ON i.tid = tags.tag_id WHERE tags.tag_id IS NULL Works fine on 8.4-9.3, but XC does not like it: ERROR: unexpected varno 6 in JOIN RTE 5 I have no idea what that means. I tried renaming some of the column aliases in the VALUES subselect, but it made not difference. Any ideas? Thanks, David |