D&C Lug - Home Page
Devon & Cornwall Linux Users' Group

[ Date Index ][ Thread Index ]
[ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] postgresql inserts



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

Lynx friendly