From: Neil Darlow <neil@darlow.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Qualified Table Names and PsqlODBC.
Date: Sun, 18 Jul 1999 10:57:12 GMT
Message-ID: <19990718.10571200@ideal.intranet> (raw)
Greetings,
I'm attempting to use StarOffice 5.1 Pro with unixODBC and
PostgreSQL-6.4.2.
unixODBC uses PsqlODBC to implement the interface to PostgreSQL.
The problem I'm observing is that when I create a Table in StarOffice
an SQL
statement of the following form is generated:
create databasename."TABLENAME" ( fieldname fieldtype, ... )
PostgreSQL seems to have difficulty with the databasename."TABLENAME"
syntax
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
in
psql but attempting to select from the table presents a message
that the
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)
but he
states that the unixODBC Driver Manager just passes SQL directly from
StarOffice to PsqlODBC without modification. This implies that any
corrective
action will have to be done in PsqlODBC.
Is this a known problem, and does a solution exist.
Regards,
Neil Darlow
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: neil@darlow.co.uk
Subject: Re: Qualified Table Names and PsqlODBC.
In-Reply-To: <19990718.10571200@ideal.intranet>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox