Re: PG Admin
От | Bob Pawley |
---|---|
Тема | Re: PG Admin |
Дата | |
Msg-id | 013301c71802$36100810$8e904618@owner обсуждение исходный текст |
Ответ на | PG Admin (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
I'm doing something similar - using a control table, dropping and creating the serial column and updating in a manner that does the job. It works - barely. I am seeking a more elegent and stable method. Having a simple update recognizing the row numbers (in version 1.6.1) would be better - perhaps. Bob ----- Original Message ----- From: "Raymond O'Donnell" <rod@iol.ie> To: <pgsql-general@postgresql.org> Sent: Monday, December 04, 2006 3:53 PM Subject: Re: [GENERAL] PG Admin > 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 > > > --Ray. > > > ---------------------------------------------------------------------- > > Raymond O'Donnell > Director of Music, Galway Cathedral, Galway, Ireland > rod@iol.ie > ---------------------------------------------------------------------- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
В списке pgsql-general по дате отправления: