Re: [HACKERS] v6.5 release ToDo - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] v6.5 release ToDo
Date
Msg-id 199905101537.LAA04804@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] v6.5 release ToDo  (Ole Gjerde <gjerde@icebox.org>)
List pgsql-hackers
> Hey,
> Got a couple of problems that could hopefully be fixed before 6.5 gets
> released.  This is straight from CVS april 5th.
> 
> Prob #1: 
> DROP TABLE <table> doesn't removed "extended" files.
> i.e., if you have 2GB db on Linux(i386), it will only delete the main
> file and not the .1, .2, etc table files.

Added to TODO list.


> 
> Prob #2:
> While running postmaster at the command line like this:
> /home/postgres/bin/postmaster -B 1024 -D/home/postgres/data -d 9 -o "-S
> 4096 -s -d 9 -A"
> 
> the current backend for the following CREATE TABLE would
> die(consistently):
> CREATE TABLE oletest (
>         id                      serial,
>         number                  int,
>         string                  varchar(255)
> );
> 

Not sure how to address this.



> This was the only query it died on however.  I have made huge indexes and
> regular selects while running it the same way.  There was only one
> postgres backend running at the time.
> 
> Thanks,
> Ole Gjerde
> 
> 
> 
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] INSERT INTO
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Pretty bad bug in Postgres.