Re: Using oids - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Using oids
Date
Msg-id 3F560CE2.3020004@fireserve.net
Whole thread Raw
In response to Re: Using oids  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Using oids
List pgsql-general
Why is that, anyway, and why should it be?

Oliver Elphick wrote:

>On Wed, 2003-09-03 at 12:19, Martijn van Oosterhout wrote:
>
>
>>If I were doing it would extract the primary key of each table on startup
>>and then change that one line of code to:
>>
>>os << "SELECT * FROM " << sTable << " WHERE "
>>   << prikey << " = currval('" << sTable << "_" << prikey << "_seq')";
>>
>>
>
>You cannot use currval() until you have used nextval() on the same
>sequence in the same session.
>
>
>


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: What is the good equivalent for ENUM ?
Next
From: Dennis Gearon
Date:
Subject: Re: Using oids