| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Rabi Jay <rabijay1(at)yahoo(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Insert statement deletes older table records |
| Date: | 2011-05-30 04:21:34 |
| Message-ID: | BANLkTikrnXqJU1giX=a9Fqx5p_1qef=okA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, May 29, 2011 at 6:07 PM, Rabi Jay <rabijay1(at)yahoo(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Chmielewski | 2011-05-30 09:18:17 | Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now? |
| Previous Message | Rabi Jay | 2011-05-30 00:07:52 | Insert statement deletes older table records |