Re: [Slashcode-development] PgSql no LAST_INSERT_ID()

[Alessio B. <al...@al...>]

Chris Nandor wrote:

> Is this per-connection, like last_insert_id is in MySQL?

Yes.

> So if two
> separate httpds do inserts at the same time, would they both get back the
> same value if they then asked for currval('templates_tpid_seq')? 

Nope, it's safe and backend-isolated.

> No, not at all.  PostgreSQL inherits from MySQL.

Ahh, sorry. I thought they were at the same level (didn't check
carefully the module).

> places,
> like this one, that do need porting, and haven't yet been ported.

Ok, I will check if they are MySql-isms :-) that haven't been ported.

-- 
Alessio F. Bragadini		al...@al...
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925