From: Ben Gunter <bgunter@alef.gcsu.edu>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Tables acting funny with pgaccess
Date: Sun, 28 Feb 1999 19:25:58 -0500
Message-ID: <36D9DE96.49ED337@alef.gcsu.edu> (raw)
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.
Whenever I run a query (using psql or pgaccess) asking for specific
fields from a table created by pgaccess, I get an error similar to the
following:
> Error executing query
> declare mycursor cursor for select t0.lastname from "Present" t0
> PostgreSQL error message: ERROR: func_get_detail: No such attribute or function 'lastname'
> PostgreSQL status: PGRES_FATAL_ERROR
But if it's a table created by psql, it works. Also, if I run a "select
*" query, it has no problem either. It's only if I ask for a specific
field from a table created by pgaccess.
I'm using the visual query designer to create the queries. I'm running
an AMD K6-2 300, 128MB RAM, RedHat Linux 5.2 (without the old Postgres
rpm's), kernel 2.2.1, PostgreSQL 6.4.2, and I have encountered this
error with pgaccess 0.93 and 0.94. I have also seen the very same error
with pgaccess on a Sun Sparc 20 workstation running RedHat 5.2, kernel
2.0.35. This also happens when using pgaccess for Windows NT 4.0 to
access the database on the Sun.
Any help would be greatly appreciated.
Thanks!
Ben
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: bgunter@alef.gcsu.edu
Subject: Re: Tables acting funny with pgaccess
In-Reply-To: <36D9DE96.49ED337@alef.gcsu.edu>
* 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