Re: PG Admin
От | Bob Pawley |
---|---|
Тема | Re: PG Admin |
Дата | |
Msg-id | 017c01c71812$abc438f0$8e904618@owner обсуждение исходный текст |
Ответ на | PG Admin (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: PG Admin
|
Список | pgsql-general |
Perhaps - but they aren't necessarily meaningless as pure information. Bob ----- Original Message ----- From: "Steve Atkins" <steve@blighty.com> To: "PgSQL General" <pgsql-general@postgresql.org> Sent: Monday, December 04, 2006 4:33 PM Subject: Re: [GENERAL] PG Admin > > On Dec 4, 2006, at 3:53 PM, Raymond O'Donnell wrote: > >> On 4 Dec 2006 at 15:40, Bob Pawley wrote: >> >>> When a row is deleted the serial number and oid are also deleted. The >>> sequence then has gaps which are inadmissible. >> >> This is an issue which has come up at various times on this list in >> the past - it may be worth having a look through the archives. Here's >> one recent thread: >> >> http://archives.postgresql.org/pgsql-general/2006-08/msg00535.php > > Or, better, http://archives.postgresql.org/pgsql-general/2006-09/ > msg00948.php > > I'm sure that PG Admin just generates the numbers in the GUI as it > displays them (as they're meaningless as persistent data). > > Cheers, > Steve > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
В списке pgsql-general по дате отправления: