| Lists: | pgsql-odbc |
|---|
| From: | Ocke Janssen <Ocke(dot)Janssen(at)sun(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | OpenOffice and PostgreSQL: query with inner join |
| Date: | 2003-02-03 13:57:10 |
| Message-ID: | 3E3E7536.9060702@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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
| 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: | 3E3F7E52.93D93C4B@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
http://www.geocities.jp/inocchichichi/psqlodbc/ .
Thanks.
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
| From: | Ocke Janssen <Ocke(dot)Janssen(at)sun(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: OpenOffice and PostgreSQL: query with inner join |
| Date: | 2003-02-05 11:53:58 |
| Message-ID: | 3E40FB56.2070407@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
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