Re: [LUG] postgresql inserts

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

Yes, I think it does. it allows embedded C, perl functions etc.

 

I would use transaction locking, but seqeunces in postgres can be affected even when a transaction is locked.

 

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

From: chris

To: list@xxxxxxxxxxxx

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

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
******************************************************************************