Message-ID: <19990613082557.97125.qmail@hotmail.com>
From: "Brent Waldrop" <waldrop_brent@hotmail.com>
To: <pgsql-interfaces@postgreSQL.org>
Subject: odbc?
Date: Sun, 13 Jun 1999 03:28:05 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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