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

Re: OpenOffice loops calling SQLForeignKeys

From: Ocke Janssen <Ocke(dot)Janssen(at)sun(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: OpenOffice loops calling SQLForeignKeys
Date: 2002-12-13 07:07:53
Message-ID: 3DF98749.8070701@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The call looks like

SQLRETURN nRetcode = N3SQLForeignKeys(m_aStatementHandle,
                            (SDB_ODBC_CHAR *) pPKQ, (catalog.hasValue() 
&& aPKQ.getLength()) ? SQL_NTS : 0,
                            (SDB_ODBC_CHAR *) pPKO, pPKO ? SQL_NTS : 0,
                            (SDB_ODBC_CHAR *) pPKN, pPKN ? SQL_NTS : 0,
                            (SDB_ODBC_CHAR *) pFKQ, (catalog2.hasValue() 
&& aFKQ.getLength()) ? SQL_NTS : 0,
                            (SDB_ODBC_CHAR *) pFKO, pFKO ? SQL_NTS : 0,
                            (SDB_ODBC_CHAR *) pFKN, SQL_NTS
                            );

where the first 3 arguments are NULL. The last 3 contains the 
information about one table.
Another way to reproduce the bug would be to install the SRX643C version 
of OpenOffice. I just heard from the dev(at)dba(dot)openoffice(dot)org mailing list 
that the snapshot 7.03.0001 shouldn't have the bug anymore.

Best regards,

Ocke

Hiroshi Inoue wrote:

>>-----Original Message-----
>>From: Ocke Janssen
>>
>>Hi all,
>>
>>when using the new PostgreSQL ODBC driver version 7.02.00.05 OpenOffice 
>>loops when calling SQLForeignKeys. This doesn't happen when the old 
>>driver 7.02.00.3 was used.
>>    
>>
>
>Could you send me the example ?
>
>regards,
>Hiroshi Inoue
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>  
>


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



In response to

Responses

pgsql-bugs by date

Next:From: Mathew FrankDate: 2002-12-13 07:37:02
Subject: Re: possible INSERT bug
Previous:From: Tom LaneDate: 2002-12-13 05:40:54
Subject: Re: Bug #847: plpgsql 'raise notice' > 4000 chars disconnects pgsql backend 7.2.1

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