Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id A07E8B5D8BD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 29 May 2011 21:14:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 99372-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 30 May 2011 00:14:15 +0000 (UTC)
X-Greylist: delayed 00:06:22.541646 by SQLgrey-1.7.6
Received: from nm14.bullet.mail.bf1.yahoo.com (nm14.bullet.mail.bf1.yahoo.com
	[98.139.212.173])
	by mail.postgresql.org (Postfix) with SMTP id 40BE8B5D80A
	for <pgsql-admin@postgresql.org>; Sun, 29 May 2011 21:14:14 -0300 (ADT)
Received: from [98.139.212.149] by nm14.bullet.mail.bf1.yahoo.com with NNFMP;
	30 May 2011 00:07:52 -0000
Received: from [98.139.212.193] by tm6.bullet.mail.bf1.yahoo.com with NNFMP;
	30 May 2011 00:07:52 -0000
Received: from [127.0.0.1] by omp1002.mail.bf1.yahoo.com with NNFMP;
	30 May 2011 00:07:52 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 221250.53239.bm@omp1002.mail.bf1.yahoo.com
Received: (qmail 77446 invoked by uid 60001); 30 May 2011 00:07:52 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1306714072; bh=r8/B+Nu8+xFBEhwK6UX+52owsPavcFL8R2m5YgpAaRs=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=Py7w5ZlCi8o0teVVXyceO1rt7vhODtSOgTwpnBdwvDug4Y2lVP0GH0UtLj11hb8ird6yxLU5iXXMxptTKf18SAa4zK7biOX5mFMmukAdVfJuuBcOc+w3HAKG1W1EUkc/bDiTqv738JCT9KiJBDmevl4oHFNFb/aRu7xWku8JHuk=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=29k+yi8S37gk6CgyuFbGJYmb0P/lJ0RDijRVShT/uxwKf/2Y98amA+vWYJxUNjlDnKhiZXkh/WpGfy29f3KluF04V6FopOvJwF9IYEjmCjFDmbdZC581EaRFkNACF6FRTNbaVK+gbJa/pw0y7ikcjKE8A1OsC1H9WD1X4cEHs24=;
Message-ID: <149933.64856.qm@web161512.mail.bf1.yahoo.com>
X-YMail-OSG: ZtQ9EZUVM1n80NbvPZurK6ck_dJvq6OYrW7SZu00GXTjeyd
	IOmP70HOkAwgM__LRhdA14sYaWTW3ysg7WoKi950GBXHGcKXNC3wbivHVml.
	_yYZLpznv4In.UmKHWNXLMXsvZlfEXBUJtAh4QgFul5wCn6Wg5paW26FJ4lT
	qHmA8YbgB7ByPSCwdLgwTTTweE.YZHCzkIuvMoH4xCfXLx5JuWTwWQE7Hm2X
	8efc1O84pic613A6XuyK0UjypMriaIS7cwT16eY2UmGK4sCFdDp9lFoxy3QU
	h673XE5CHgJe6Slu.m2KelyKcAsqpYuy.vDwAJfaT4CNjvNb2etf1qRXdMIw
	WJlFo4C95H9od4sV2Kuha2n.xdRu2smUy99m.HXEybmN9B8wkvHbxGEA-
Received: from [98.221.80.24] by web161512.mail.bf1.yahoo.com via HTTP;
	Sun, 29 May 2011 17:07:52 PDT
X-Mailer: YahooMailWebService/0.8.111.304355
Date: Sun, 29 May 2011 17:07:52 -0700 (PDT)
From: Rabi Jay <rabijay1@yahoo.com>
Reply-To: Rabi Jay <rabijay1@yahoo.com>
Subject: Insert statement deletes older table records 
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1400738912-1306714072=:64856"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.497 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001,
	FREEMAIL_REPLYTO_END_DIGIT=1.151, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: ***
X-Archive-Number: 201105/177
X-Sequence-Number: 37614

--0-1400738912-1306714072=:64856
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,=0A=A0=0AWhen I execute an insert statement, older table records are del=
eted even though my insert statement works. It always keeps the maximum num=
ber 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 n=
ew records.=0A=A0=0ABased on my research it appears postgreql has no limit =
to number of records in a table - what should I do to avoid this behavior.=
=0A=A0=0AThanks.
--0-1400738912-1306714072=:64856
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div style=3D"RIGHT: =
auto">Hi,</div>
<div style=3D"RIGHT: auto">&nbsp;</div>
<div style=3D"RIGHT: auto">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.</div>
<div style=3D"RIGHT: auto">&nbsp;</div>
<div style=3D"RIGHT: auto">Based on my research it appears postgreql has no=
 limit to number of records in a table - what should I do to avoid this beh=
avior.</div>
<div style=3D"RIGHT: auto">&nbsp;</div>
<div style=3D"RIGHT: auto">Thanks.<VAR id=3Dyui-ie-cursor></VAR></div></div=
></body></html>
--0-1400738912-1306714072=:64856--