Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA21441; Thu, 17 Oct 91 15:46:47 -0700
Message-Id: <9110172246.AA21441@postgres.Berkeley.EDU>
From: kemnitz@hermes.Berkeley.EDU
Subject: Re: A strange Postgres Story
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 15 Oct 91 19:49:06 PDT."
             <9110160249.AA25827@postgres.Berkeley.EDU> 
Date: Thu, 17 Oct 91 15:46:27 PDT
From: kemnitz@hermes.Berkeley.EDU


The following is a known bug in 3.0:

begin                 /* start a transaction */
create foo (a = int4)
abort                 /* abort a transaction - file _should_ go away */
create foo (a = int4) /* Postgres will complain and abort the xact */

If you start a transaction during which you created a class, and you abort
it or Postgres crashes before that xact commits, you should delete the class
file in

~postgres/data/base/<dbname>/<classname>

by hand with rm.  (Note that if you are not the "postgres" user, you cannot
do this.)

	Greg Kemnitz
	kemnitz@postgres.berkeley.edu