Request a Demo
Home   >   mailing lists

RE: Using curr_val Wisely - Mailing list pgsql-general

From Andrew Snow
Subject RE: Using curr_val Wisely
Date
Msg-id NHEALMDKDACEIPBNOOOCEEICCHAA.als@fl.net.au
Whole thread Raw
In response to Using curr_val Wisely  (Jeff Waugh <jdub@aphid.net>)
Responses Re: Using curr_val Wisely
List pgsql-general
Tree view 
> I'm using curr_val('blah_id_seq') in a transaction like so: (in
> pseudo SQL)

curr_val() returns the current value of the sequence, in the current
transaction.
So an insertion in transaction A won't affect the value of it in existing
transaction B.




Regards,

Andrew

pgsql-general by date:

Previous
From: "Sean Weissensee"
Date:
Subject: Re: PostgreSQL and Access (via ODBC)
Next
From: Philip Warner
Date:
Subject: pg_dump & blobs - editable dump?