Re: PG Admin
От | Bob Pawley |
---|---|
Тема | Re: PG Admin |
Дата | |
Msg-id | 020f01c71885$cd719b00$8e904618@owner обсуждение исходный текст |
Ответ на | PG Admin (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: PG Admin
|
Список | pgsql-general |
Perhaps I can - it will be learning curve for me. However, the development would be so much easier to apply if it were available in PostgreSQL in a form similar to generating a serial column. Bob ----- Original Message ----- From: "Alban Hertroys" <alban@magproductions.nl> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Steve Atkins" <steve@blighty.com>; "PgSQL General" <pgsql-general@postgresql.org> Sent: Tuesday, December 05, 2006 1:31 AM Subject: Re: [GENERAL] PG Admin > Bob Pawley wrote: >>> I'm sure that PG Admin just generates the numbers in the GUI as it >>> displays them (as they're meaningless as persistent data). > >> Perhaps - but they aren't necessarily meaningless as pure information. > > Can't you just do the same - generate the numbers within your > application - and only store them once this "construction phase" ends? > > It seems weird to keep some arbitraty numbering scheme in the database. > > What does it signify in that phase? Does order matter at all - or is > that what it's supposed to be? > > You could also use a mixed solution: > - use a sequence during the construction phase to order by, > - generate the "real" numbering in your client application based on that > order, > - store the generated numbers instead of the sequence values once the > construction phase is finished. > > PS. please don't top post, I had to reconstruct your message to let it > make sense. > -- > Alban Hertroys > alban@magproductions.nl > > magproductions b.v. > > T: ++31(0)534346874 > F: ++31(0)534346876 > M: > I: www.magproductions.nl > A: Postbus 416 > 7500 AK Enschede > > // Integrate Your World // > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ >
В списке pgsql-general по дате отправления: