Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?

Поиск
Список
Период
Сортировка
От Zoltan Boszormenyi
Тема Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?
Дата
Msg-id 45E6C1BC.8070908@dunaweb.hu
обсуждение исходный текст
Ответ на Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?  ("Florian G. Pflug" <fgp@phlo.org>)
Список 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 по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Revitalising VACUUM FULL for 8.3
Следующее
От: "Vishal Arora"
Дата:
Сообщение: Re: POSTGRES WAL