Received: from web1.lighthouseasp.com (gw.lighthouseasp.com [216.191.176.98] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3BE9J874691 for ; Wed, 11 Apr 2001 10:09:19 -0400 (EDT) (envelope-from cbell@lighthouseasp.com) Received: from lighthouseasp.com ([216.191.139.105]) by web1.lighthouseasp.com (8.9.3/8.8.7) with ESMTP id KAA17425; Wed, 11 Apr 2001 10:08:07 -0400 Message-ID: <3AD456B1.D74555E2@lighthouseasp.com> Date: Wed, 11 Apr 2001 09:05:53 -0400 From: cbell Organization: Lighthouse ASP X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: Najm Hashmi CC: pgsql Subject: Re: Re: \i command References: <3AD49F8D.F997B256@mondo-live.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/157 X-Sequence-Number: 2505 I don't know if you've resolved your problem, but if not, you could try deleting and recreating the indexes on the table... Najm Hashmi wrote: > Joel Burton wrote: > > > On Wed, 11 Apr 2001, Najm Hashmi wrote: > > > > > Hi All, > > > From pgsql, I try to insert data in table using the \i command. Nothing > > > takes place and after this command pgsql is hung... i cant use it any more. > > > The same command works with all other tables but this is only one I am having > > > problem with. > > > I have attached my file with message. Could someone help me out here what is > > > the reason for this behaviour. > > > > Works just fine for me (Pg7.1 RC3, Linux). > > > > Can you do manual inserts into the table? > > Can you insert just a few records using \i? > > Can you vacuum the table? > > > > -- > > Joel Burton > > Director of Information Systems, Support Center of Washington > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > Hi, No I can't even do manaul insert on that particular table. This is really > weird. Could this table's internals be corrupted? > One more thing, if I run the same file on another db it works just fine. I am > just wondering what is wrong with the structure. > Thank you for replying..... Anyone else has an idea about it???? > Regards. > > ------------------------------------------------------------------------ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl