| From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
|---|---|
| To: | <zidibik(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: creating "a perfect sequence" column |
| Date: | 2008-07-07 16:33:36 |
| Message-ID: | C497A180.9C9B6%scott_ribe@killerbytes.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> it's sort of a formal document management system. the assigned gapless numbers
> are frozen at the end of each month. until then, an authorized user will be
> able to delete a document. but ...
Another way of dealing with this is to keep the association between the
number and the document it was originally assigned to, and present instead
of the document a message "document deleted", possibly with date & time &
user. Whether you actually delete the document or not, is a detail dependent
on the use case.
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dushyanth | 2008-07-07 16:49:06 | Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ? |
| Previous Message | Ivan Sergio Borgonovo | 2008-07-07 14:47:41 | importing data via SQL statements and different column names |