Re: return records in DB load order??
От | Maksim Likharev |
---|---|
Тема | Re: return records in DB load order?? |
Дата | |
Msg-id | 56510AAEF435D240958D1CE8C6B1770A016D2D3E@mailc03.aurigin.com обсуждение исходный текст |
Ответ на | return records in DB load order?? ("Maksim Likharev" <mlikharev@aurigin.com>) |
Список | pgsql-general |
It is 32 bit, but discussion slept into different direction, so really I have freshly loaded DB where present set of 2 tables, one [to] many, where many has a primary record, of cause without indication that is primary but ancient knowledge exists that primary record was first during a DB load. In order to fix that, I just want to use oid as indication of first in order, and I guess that's will work. -----Original Message----- From: weigelt@metux.de [mailto:weigelt@metux.de] Sent: Friday, June 13, 2003 1:49 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] return records in DB load order?? On Fri, Jun 13, 2003 at 01:36:46PM -0700, Dann Corbit wrote: <snip> > What happens when you have 2^32 + 1 rows in a table? A 4 byte OID > cannot contain it. Isnt the oid type now 64 bits wide ? cu -- --------------------------------------------------------------------- Enrico Weigelt == metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de cellphone: +49 174 7066481 smsgate: sms.weigelt@metux.de --------------------------------------------------------------------- Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
В списке pgsql-general по дате отправления: