Postgres Pro
Downloads
Home   >   mailing lists

Thread: OpenOffice and PostgreSQL: query with inner join

OpenOffice and PostgreSQL: query with inner join

From
Ocke Janssen
Date:
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?

Best regards,

Ocke

--
dba.OpenOffice.org
            Example isn't another way to teach,
            it is the only way to teach.
            Albert Einstein

Re: OpenOffice and PostgreSQL: query with inner join

From
Hiroshi Inoue
Date:
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
  http://www.geocities.jp/inocchichichi/psqlodbc/ .

Thanks.
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/

Re: OpenOffice and PostgreSQL: query with inner join

From
Ocke Janssen
Date:
Yes, it works. Thx.

Best regards,

Ocke

Hiroshi Inoue wrote:

>Ocke Janssen wrote:
>
>
>Maybe I found the cause.
>Please try the snapshot dll at
>  http://www.geocities.jp/inocchichichi/psqlodbc/ .
>
>Thanks.
>Hiroshi Inoue
>    http://www.geocities.jp/inocchichichi/psqlodbc/
>
>


--

            Example isn't another way to teach,
            it is the only way to teach.
            Albert Einstein