Re: Insert statement deletes older table records

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Insert statement deletes older table records
Дата
Msg-id BANLkTikrnXqJU1giX=a9Fqx5p_1qef=okA@mail.gmail.com
обсуждение исходный текст
Ответ на Insert statement deletes older table records  (Rabi Jay <rabijay1@yahoo.com>)
Список pgsql-admin
On Sun, May 29, 2011 at 6:07 PM, Rabi Jay <rabijay1@yahoo.com> wrote:
> Hi,
>
> When I execute an insert statement, older table records are deleted even
> though my insert statement works. It always keeps the maximum number of
> records in the table to 4200 records. So If I added 3 more records, it
> deletes the first three records in the table even though it adds the 3 new
> records.
>
> Based on my research it appears postgreql has no limit to number of records
> in a table - what should I do to avoid this behavior.

This is not normal behaviour.  Can you post a self-contained example
of this behaviour?

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rabi Jay
Дата:
Сообщение: Insert statement deletes older table records
Следующее
От: Tomasz Chmielewski
Дата:
Сообщение: Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?