Error using pgsql-odbc with OpenOffice

Greetings,

I'm not sure which component is responsible for this error, but I needed
to start somewhere...

Versions I'm using:

Windows XP sp2
OpenOffice 2.2.0
PG 8.2.3 (running on FreeBSD 6.2)
pgODBC 08.02.0200

I've set up a System DSN for my pg database and created a new database
with OO, selecting the "connect to an existing database" and selecting
the DSN I set up. It prompts me for a un and pw and connects without
problems. I can see the list of tables and even create a new table, but
when I try to double-click a table to open it for reading or updating, I
get this error in a dialog:

---
The data content could not be loaded.

ERROR: invalid input syntax for type tid: "(,)";
Error while executing the query

[OK] [More]
---

Clicking "More" gives this additional information:

SQL Status: 22P02
Error code: 7

I tried logging the connection with the driver but did not see the
offending query in the logs. A Google search turned up very little
other than someone asking about this back in 2004 with little or no
resolution. Any insight would be greatly appreciated.

Thanks,
Matthew


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Error using pgsql-odbc with OpenOffice

Matthew Hagerty wrote:
> Greetings,
>
> I'm not sure which component is responsible for this error, but I needed
> to start somewhere...
>
> Versions I'm using:
>
> Windows XP sp2
> OpenOffice 2.2.0
> PG 8.2.3 (running on FreeBSD 6.2)
> pgODBC 08.02.0200
>
> I've set up a System DSN for my pg database and created a new database
> with OO, selecting the "connect to an existing database" and selecting
> the DSN I set up. It prompts me for a un and pw and connects without
> problems. I can see the list of tables and even create a new table, but
> when I try to double-click a table to open it for reading or updating, I
> get this error in a dialog:
>
> ---
> The data content could not be loaded.
>
> ERROR: invalid input syntax for type tid: "(,)";
> Error while executing the query


Could you try the snapshot driver at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?


regards,
Hiroshi Inoue

> [OK] [More]
> ---
>
> Clicking "More" gives this additional information:
>
> SQL Status: 22P02
> Error code: 7
>
> I tried logging the connection with the driver but did not see the
> offending query in the logs. A Google search turned up very little
> other than someone asking about this back in 2004 with little or no
> resolution. Any insight would be greatly appreciated.
>
> Thanks,
> Matthew

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Error using pgsql-odbc with OpenOffice

Hiroshi Inoue wrote:
> Matthew Hagerty wrote:
>> Greetings,
>>
>> I'm not sure which component is responsible for this error, but I
>> needed to start somewhere...
>>
>> Versions I'm using:
>>
>> Windows XP sp2
>> OpenOffice 2.2.0
>> PG 8.2.3 (running on FreeBSD 6.2)
>> pgODBC 08.02.0200
>>
>> I've set up a System DSN for my pg database and created a new
>> database with OO, selecting the "connect to an existing database" and
>> selecting the DSN I set up. It prompts me for a un and pw and
>> connects without problems. I can see the list of tables and even
>> create a new table, but when I try to double-click a table to open it
>> for reading or updating, I get this error in a dialog:
>>
>> ---
>> The data content could not be loaded.
>>
>> ERROR: invalid input syntax for type tid: "(,)";
>> Error while executing the query
>
>
> Could you try the snapshot driver at
> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
>
>
> regards,
> Hiroshi Inoue
>
>> [OK] [More]
>> ---
>>
>> Clicking "More" gives this additional information:
>>
>> SQL Status: 22P02
>> Error code: 7
>>
>> I tried logging the connection with the driver but did not see the
>> offending query in the logs. A Google search turned up very little
>> other than someone asking about this back in 2004 with little or no
>> resolution. Any insight would be greatly appreciated.
>>
>> Thanks,
>> Matthew
>
Okay, that took care of the "(,)" error, now I'm getting this:

---
SQL Status: 42703
Error code: 7

ERROR: column "oid" does not exist;
Error while executing the query
---

Does not matter if the table exists or if I create a new table (which
does work).

Thanks,
Matthew


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly