Ref to last INSERT on a table without OIDs?

Поиск
Список
Период
Сортировка
От Mark Cave-Ayland
Тема Ref to last INSERT on a table without OIDs?
Дата
Msg-id C1379626F9C09A4C821D6977AA6A5457033E52@webbased8.wb8.webbased.co.uk
обсуждение исходный текст
Ответы Re: Ref to last INSERT on a table without OIDs?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Ref to last INSERT on a table without OIDs?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Hi there,

Hopefully just a quick one: how is it possible to obtain a reference to
the last inserted record in a table which is created without oids? I
would like to dump/restore some of our larger tables so they don't use
oids, however I am concerned that simply getting the current PK sequence
value after insertion within a transaction is not safe when many people
are accessing the table/sequence at once? Can anyone clarify this? We're
using the latest and greatest 7.3.1.


Many thanks,

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446


This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.



В списке pgsql-general по дате отправления:

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Using RSYNC for replication?
Следующее
От: "Nisha Joseph"
Дата:
Сообщение: Inserting large objects