Re: Insert statement deletes older table records - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Insert statement deletes older table records
Date
Msg-id BANLkTikrnXqJU1giX=a9Fqx5p_1qef=okA@mail.gmail.com
Whole thread Raw
In response to Insert statement deletes older table records  (Rabi Jay <rabijay1@yahoo.com>)
List 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 by date:

Previous
From: Rabi Jay
Date:
Subject: Insert statement deletes older table records
Next
From: Tomasz Chmielewski
Date:
Subject: Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?