X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A162F474E5C for ; Tue, 11 Feb 2003 10:01:12 -0500 (EST) Received: from mail.interchange.ca (ns.interchange.ca [216.126.79.2]) by postgresql.org (Postfix) with ESMTP id 2323C474E53 for ; Tue, 11 Feb 2003 10:01:12 -0500 (EST) Received: by mail.interchange.ca (Fastmailer, from userid 555) id E438B4F50; Tue, 11 Feb 2003 10:01:24 -0500 (EST) Received: from 24.43.130.193 by www.fastmail.ca with HTTP; Tue, 11 Feb 2003 15:01:24 +0000 (UTC) MIME-Version: 1.0 Message-Id: <3E491044.000001.72557@ns.interchange.ca> To: pgsql-sql@postgresql.org Subject: vacuum failure... Date: Tue, 11 Feb 2003 10:01:24 -0500 (EST) From: "Michael Richards" X-Fastmail-IP: [24.43.130.193] X-Virus-Scanned: by AMaViS new-20020517 Content-Transfer-Encoding: 7bit Content-Type: Text/Plain X-Archive-Number: 200302/213 X-Sequence-Number: 11611 I've got a problem vacuuming a table and can't seem to find a way to fix it... vacuum full verbose analyze folders; NOTICE: --Relation folders-- NOTICE: Pages 18598: Changed 0, reaped 18598, Empty 0, New 0; Tup 69849: Vac 0, Keep/VTL 0/0, UnUsed 1870572, MinLen 64, MaxLen 88; Re- using: Free/Avail. Space 139159408/139159408; EndEmpty/Avail. Pages 0/18598. CPU 0.34s/0.09u sec elapsed 0.51 sec. ERROR: No one parent tuple was found -Michael _________________________________________________________________ http://fastmail.ca/ - Fast Secure Web Email for Canadians From pgsql-sql-owner@postgresql.org Tue Feb 11 10:34:16 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B8543475AAC for ; Tue, 11 Feb 2003 10:34:15 -0500 (EST) Received: from trill.maridan.net (unknown [217.6.52.210]) by postgresql.org (Postfix) with ESMTP id 4148F475A9E for ; Tue, 11 Feb 2003 10:34:13 -0500 (EST) Received: from polonium.de ([212.121.156.162]) by trill.maridan.net (8.9.3/8.9.3) with ESMTP id QAA24667 for ; Tue, 11 Feb 2003 16:34:12 +0100 Message-ID: <3E491854.9080401@polonium.de> Date: Tue, 11 Feb 2003 16:35:48 +0100 From: Rafal Kedziorski Organization: POLONIUM User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: constrains questios .. Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/214 X-Sequence-Number: 11612 Hi, is better to create constrains while creating table or after the table is created? I'm working on sql script which should create about 40 tables. Best Regards, Rafal