Skip site navigation (1) Skip section navigation (2)

Re: OpenOffice and PostgreSQL: query with inner join

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Ocke Janssen <Ocke(dot)Janssen(at)sun(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: OpenOffice and PostgreSQL: query with inner join
Date: 2003-02-04 08:48:18
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Ocke Janssen wrote:
> Hello,
> my name is Ocke Janssen. I'm a developer of the database component in
> OpenOffice and I encounter a problem (BUG) we have when executing a
> query which contains two tables with a primary key. The statement looks
> like this:
> SELECT "test1"."name", "test1_1"."name" FROM "test1" "test1", "test1"
> "test1_1" WHERE ( "test1"."id" = "test1_1"."id" )
> When setting the statement attributes to KeysetDriven, I get the error
> message that CTID is ambiguous. As far as I could see in the moment the
> problem is in the fucntion inner_process_tokens in file convert.c where
> CTID is added to the statemement. Is this problem known?

Maybe I found the cause.
Please try the snapshot dll at .

Hiroshi Inoue

In response to


pgsql-odbc by date

Next:From: Nick GorhamDate: 2003-02-04 09:46:13
Subject: Re: unixODBC, PostgreSQL 7.3 + ODBC V3 drivers?
Previous:From: Hiroshi InoueDate: 2003-02-04 05:22:52
Subject: Re: Driver crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group