Re: currval() within one statement - Mailing list pgsql-sql

From sad
Subject Re: currval() within one statement
Date
Msg-id 4795A152.3080400@bankir.ru
Whole thread
In response to Re: currval() within one statement  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: currval() within one statement
Re: currval() within one statement
List pgsql-sql
A. Kretschmer wrote:

>> is it expected that the currval() changes its value between calls within 
>> one statement ?

> Conclusion, don't call nextval() within a TRIGGER, and insert either
> nextval() for the column or omit this column.

I only note that i still want to discuss the titled problem or to be
given an exact pointer to documentation regarding the currval() behavior
in the described situation, that i had.



pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: currval() within one statement
Next
From: Stuart Brooks
Date:
Subject: TIMESTAMP comparison problem