Re: [Postgres-xc-developers] ERROR: unexpected varno 6 in JOIN RTE 5

[Abbas B. <abb...@en...>]

Could you please send the table definition of tag? A CREATE TABLE statement
would do.


On Wed, Feb 5, 2014 at 6:06 AM, David E. Wheeler <da...@ju...>wrote:

> Hi there,
>
> I'd like to release an updated version of Sqitch, but would like to
> resolve this issue, first. Anyone had a chance to look into it?
>
> Thanks,
>
> David
>
> On Jan 30, 2014, at 5:35 PM, Koichi Suzuki <koi...@gm...> wrote:
>
> > Ashutosh, do you have a time to look into it?
> >
> > 2014-01-31 David E. Wheeler <da...@ju...>:
> >> 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?
>
>
>
>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>



-- 
-- 
*Abbas*
 Architect

Ph: 92.334.5100153
 Skype ID: gabbasb
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>

*Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community>and
more<http://www.enterprisedb.com/resources-community>