From: Tom Lane <tgl@sss.pgh.pa.us>
To: bgunter@alef.gcsu.edu
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Tables acting funny with pgaccess
Date: Mon, 01 Mar 1999 09:40:48 -0500
Message-ID: <14012.920299248@sss.pgh.pa.us> (raw)
In-Reply-To: <36D9DE96.49ED337@alef.gcsu.edu>
bgunter@alef.gcsu.edu (Ben Gunter) writes:
> I'm having a problem with pgaccess that's confounding me.
> If I create a table with psql, I have no problems using pgaccess for
> queries. However, if I create a table using pgaccess, things go awry.
>> PostgreSQL error message: ERROR: func_get_detail: No such attribute or function 'lastname'
> It's only if I ask for a specific
> field from a table created by pgaccess.
At a guess, pgaccess is generating the table with case of field names
preserved? Ordinarily, table and field names are implicitly downcased,
but not if you put double quotes around 'em.
My bet is that pgaccess is quoting your field names during CREATE TABLE
but not doing so during SELECT ... a bad combination.
regards, tom lane
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: tgl@sss.pgh.pa.us, bgunter@alef.gcsu.edu
Subject: Re: [INTERFACES] Tables acting funny with pgaccess
In-Reply-To: <14012.920299248@sss.pgh.pa.us>
* 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