Problems doing a copy to a table

From: "Chris Williams" <chris_d_williams(at)itd(dot)sterling(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Problems doing a copy to a table
Date: 1999-02-01 19:48:23
Message-ID: 014f01be4e1b$d4524ec0$edfe04c7@itd.sterling.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am creating a text file to do file dumps into postgres using the copy command. The copy command
executes fine but when I do a count on the table, I get zero records. But when I do a vacuum
command on that table, here is what is says

sdbm=> vacuum verbose D_TERM_APPROACH;
NOTICE: --Relation d_term_approach--
NOTICE: Pages 490: Changed 0, Reapped 490, Empty 0, New 0; Tup 0: Vac 11530, Crash 11530, UnUsed 0,
MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 3964040/0; EndEmpty/Avail. Pages 490/0. Elapsed 0/1
sec.
NOTICE: Rel d_term_approach: Pages: 490 --> 0.

I know the 11530 is the correct number of tuples that should have been added to the table. Any
ideas on what may be happening or how I can debug this problem. I am using version 6.4 on Solaris
2.5.1.
Thanks
---------
Chris Williams
Sterling Software
Rome, New York
Phone: (315) 336-0500
Email: chris_d_williams(at)sterling(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-02-01 20:08:49 Re: [GENERAL] big bad join problems
Previous Message Bruce Momjian 1999-02-01 19:19:31 Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'