On Mon, May 30, 2011 at 1:07 AM, Rabi Jay <rabijay1@xxxxxxxxx> wrote: > 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. If this is a real report, please come back with further details of the actions you are performing, version numbers and related details. If what you say is correct then this is a data loss bug and this project takes such things very seriously. Having said that, this is the second time in last few months that some "hearsay" has emerged relating to there being a limit on the number of rows in a PostgreSQL database. So I'm a little skeptical as to this as a credible bug report. PostgreSQL has never had a bug filed of this nature. The described behaviour would certainly have been picked up in testing or production usage if it was a bug, especially since tables with 1 billion+ rows in are fairly common. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
