Florian G. Pflug írta:
> Yes, of course you can prevent gaps by just filling them
> with garbage/invalid records of whatever. But I don't see
> why this is usefull - either you want, say, your invoice
> number to be continuous because it's required by law - or
> you don't. But if the law required your invoice numbers to be
> continous, surely just filling the gaps with fake invoices
> it just as illegal as having gaps in the first place.
Not fake invoice, "stornoed" for whatever reason.
But you have to keep the record to show you didn't delete anything.
In response to
pgsql-hackers by date
|Next:||From: Vishal Arora||Date: 2007-03-01 12:20:09|
|Subject: Re: POSTGRES WAL|
|Previous:||From: Simon Riggs||Date: 2007-03-01 12:02:23|
|Subject: Revitalising VACUUM FULL for 8.3|