From: Brent Waldrop <waldrop_brent@hotmail.com>
To: pgsql-interfaces@postgreSQL.org
Subject: odbc?
Date: Sun, 13 Jun 1999 03:28:05 -0500
Message-ID: <19990613082557.97125.qmail@hotmail.com> (raw)
HI i have a couple of basic and specific questions about odbc access using
Access 97. First of all, when i try to add a entry in my access database
that is connected to my posgres database i get an error that says "ERROR:
parser: attribute 'salary' is of type 'money' but expression is of type
'float8' you will need to rewrite or cast the expression how can i fix t his
so that i am able to add entries to the postgres database? I directly linked
these tables with the odbc driver for postgres. Second think is why would
you ever want to include the OID section...i noticed there is a option to
include it in the connection options of the ODBC driver and can't see why
you would want to do this if your keys are set up properly? The next thing i
want to ask is would you evern want to include the pg_* tables in your
access database? I can't see why you would want to? and the last question
is...is there anyway to import relationship type of data into access using
the odbc driver so you don't have to set it up manually through access?
thanks
Brent
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: waldrop_brent@hotmail.com
Subject: Re: odbc?
In-Reply-To: <19990613082557.97125.qmail@hotmail.com>
* 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