Re: Sequence and nextval problem - Mailing list pgsql-sql

From Craig Ringer
Subject Re: Sequence and nextval problem
Date
Msg-id 492B82BE.2010704@postnewspapers.com.au
Whole thread Raw
In response to Re: Sequence and nextval problem  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Earlier, Craig Ringer wrote:

> for sample operator/cast definitions. There are some notes in the top of 
> the "passthrough.txt" module I attached that explain the ODBC driver 
> options you'll want.

Also, note that in the message I just posted the function DSN() must be 
adapted to include the approprate DSN for your database. You can most 
easily obtain this by opening an ODBC linked table in design mode 
(ignore the warning about changes not being saved), opening the 
properties palette, and fishing the linked table DSN out from there.

Thinking about it, I should adjust my code to pull the DSN out of a 
linked table at runtime. When I initially put it together I didn't 
realise it was stored as a linked table property, so I hand-wrote a 
suitable DSN.

If you try to use the module I attached without changing the DSN to 
match your database it just won't work.

--
Craig Ringer



pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Sequence and nextval problem
Next
From: "John Lister"
Date:
Subject: Full text search ordering question