Re: ODBC error

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: ANJANE <softwaredesigns(at)hotmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC error
Date: 2007-01-17 00:06:25
Message-ID: 45AD6881.1010205@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

ANJANE wrote:
> As I said the query works intermittently. Whenever it fails, I get the
> following error message
>
> ..select tp_get_clientusers('1','S%', 'rcursor');fetch all in rcursor;
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> Error while executing the query; ERROR: pg_class_aclcheck: relation 6017860
> not found
>
> /portal/testdb.asp, line 82
>
> the relation oid keeps changing. Not sure what this means.

You can't create tables and use them safely in stored procedures unless
you treat
them via EXECUTE commands..

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2007-01-17 05:23:40 Re: Hiding the Information_Schema from ODBC users.
Previous Message Tom Lane 2007-01-16 16:36:13 Re: ODBC error