I'm attempting to use StarOffice 5.1 Pro with unixODBC and
unixODBC uses PsqlODBC to implement the interface to PostgreSQL.
The problem I'm observing is that when I create a Table in StarOffice
statement of the following form is generated:
create databasename."TABLENAME" ( fieldname fieldtype, ... )
PostgreSQL seems to have difficulty with the databasename."TABLENAME"
which leads to one of two outcomes:
1) No table is created by PostgreSQL
2) A table is created with an uppercase name that can be seen with \dt
psql but attempting to select from the table presents a message
table doesn't exist.
In either case, StarOffice reports "Error recording data to database".
I have been in contact with the unixODBC project leader (Nick Gorham)
states that the unixODBC Driver Manager just passes SQL directly from
StarOffice to PsqlODBC without modification. This implies that any
action will have to be done in PsqlODBC.
Is this a known problem, and does a solution exist.
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 1999-07-18 14:43:21|
|Subject: Re: [INTERFACES] Asynchronous connect using libpq |
|Previous:||From: eem21||Date: 1999-07-18 10:51:26|
|Subject: Asynchronous connect using libpq|