Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ? - Mailing list pgsql-hackers

From Zoltan Boszormenyi
Subject Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?
Date
Msg-id 45E6C1BC.8070908@dunaweb.hu
Whole thread Raw
In response to Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
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.

Best regards,
Zoltán Böszörményi



pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Revitalising VACUUM FULL for 8.3
Next
From: "Vishal Arora"
Date:
Subject: Re: POSTGRES WAL