Re: [LUG] postgresql inserts

["Robert Nowik" <robert.nowik@xxxxxxxxxxxxxxx>]

Hi, thanks for this idea.

As this reqiures 2 SQL commands, I am worried that there may be some problems if this procedure should be run by a different user inbetween these commands. I would consider transaction locking, however sequences values are not locked. Any ideas on how to secure this?

 

Thanks

Rob Nowik

 

 

----- Original Message -----

From: Henshall, Stuart - Design & Print

To: 'list@xxxxxxxxxxxx'

Sent: Monday, April 14, 2003 4:21 PM

Subject: RE: [LUG] postgresql inserts

You cand o:

SELECT currval('sequence_name') as cv;

The default sequence names for serial are, IIRC: <table_name>_<column_name>_seq

Alternativley you can do a nextval('seq_name') then insert that value (which is the way I prefer).

Cheers,

- Stuart

 

-----Original Message-----
From: chris [mailto:chris@xxxxxxxxxxxxxxxxxx]
Sent: 14 April 2003 16:24
To: list@xxxxxxxxxxxx
Subject: RE: [LUG] postgresql inserts

Does postgres have stored procedures or similar?

-----Original Message-----
From: owner-list@xxxxxxxxxxxx [mailto:owner-list@xxxxxxxxxxxx]On Behalf Of Robert Nowik
Sent: 14 April 2003 16:05
To: List@xxxxxxxxxxxx
Subject: [LUG] postgresql inserts

Hi,

Not really a linux specific problem, but in postgreSQL i am trying to have an INSERT statement, that has a serial as the only unique identifier. This serial is not set by myself (postgres handles this) but as this is the only unqiue identifier, i need to return it as I do the insert. Any suggestions?

 

 

Cheers

 

Rob Nowik



******************************************************************************
This email has been virus checked by the Eclipse Internet MAILsafe service
******************************************************************************
www: http://www.eclipse.net.uk/ email: eclipse@xxxxxxxxxxxxxx
******************************************************************************


DISCLAIMER:The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.