Received: from lin.local.lan ([216.221.221.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3AJ9T854998 for ; Tue, 10 Apr 2001 15:09:29 -0400 (EDT) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@najm.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id TAA02835; Tue, 10 Apr 2001 19:33:24 GMT Message-ID: <3AD49F8D.F997B256@mondo-live.com> Date: Wed, 11 Apr 2001 14:16:45 -0400 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: Joel Burton CC: pgsql Subject: Re: Re: \i command References: Content-Type: multipart/mixed; boundary="------------57DFA7A2B862709B6D6DFA94" X-Archive-Number: 200104/142 X-Sequence-Number: 2490 This is a multi-part message in MIME format. --------------57DFA7A2B862709B6D6DFA94 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --------------57DFA7A2B862709B6D6DFA94 Content-Type: text/x-vcard; charset=us-ascii; name="najm.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Najm Hashmi Content-Disposition: attachment; filename="najm.vcf" begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard --------------57DFA7A2B862709B6D6DFA94--