From: Neil Darlow <neil@darlow.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: PsqlODBC and Qualified Table Names
Date: Tue, 20 Jul 1999 20:49:09 GMT
Message-ID: <19990720.20490900@ideal.intranet> (raw)
Hi,
I am using PsqlODBC (as part of unixODBC) with StarOffice 5.1 Pro
to manage PostgreSQL 6.4.2 databases and tables.
I can create and delete databases without difficulty but am having
trouble creating tables with StarOffice.
I have determined that the cause of the problem is that StarOffice
generates SQL to create a table in the following format:
create databasename."TABLENAME" ( fieldname fieldtype, ... )
PostgreSQL appears to have difficulty with databasename."TABLENAME"
and will either not generate a table or generates a table with an
uppercase name that is reported as existing by \dt in psql. However,
any attempt to select from this table with SQL results in an error
message to the effect that the table doesn't exist.
Is this a known problem with PsqlODBC, or perhaps PostgreSQL itself,
and is there a work-around?
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: PsqlODBC and Qualified Table Names
In-Reply-To: <19990720.20490900@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