OpenOffice and PostgreSQL: query with inner join

Поиск
Список
Период
Сортировка
Искать
От
Ocke Janssen
Тема
OpenOffice and PostgreSQL: query with inner join
Дата
Msg-id
3E3E7536.9060702@sun.com
Список
Дерево обсуждения
Re: OpenOffice and PostgreSQL: query with inner join Hiroshi Inoue <Inoue@tpf.co.jp>
Re: OpenOffice and PostgreSQL: query with inner join Ocke Janssen <Ocke.Janssen@sun.com>
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


В списке pgsql-odbc по дате отправления
От: Tambet Matiisen
Дата:
Сообщение: Re: psqlodbc.dll crash
От: Andrea Aime
Дата:
Сообщение: Driver crash
FAQ