Re: [BUGS] possible bug: orphaned files left after immediate shutdown during DDL

2011-02-09 Thread Jeff Davis
On Wed, 2011-02-09 at 22:58 -0500, Tom Lane wrote: > It's intentional ... not that other people haven't complained about it > before. Remember that what you have done is forced a crash, and > recovery from it is crash recovery. If we proactively removed such > files we would very possibly be dest

Re: [BUGS] possible bug: orphaned files left after immediate shutdown during DDL

2011-02-09 Thread Tom Lane
Jeff Davis writes: > Case: > BEGIN; > CREATE TABLE foo AS SELECT generate_series(1,1000); > CHECKPOINT; > SELECT relfilenode FROM pg_class WHERE relname='foo'; > Let's say that returns 23456. Send the postmaster a SIGQUIT (immediate > shutdown), and then restart. The file 23456 is still

Re: [BUGS] [Fwd: ERROR: cannot extract system attribute from minimal tuple]

2011-02-09 Thread Tom Lane
Alvaro Herrera writes: > Hmm, yeah, in an assert-enabled build of HEAD it dies with: > TRAP: FailedAssertion(«!(attno > 0)», Archivo: > «/pgsql/source/HEAD/src/backend/executor/execJunk.c», Línea: 251) > I don't have time to track this down right now ... It's a shortcoming in the PlanRowM

[BUGS] possible bug: orphaned files left after immediate shutdown during DDL

2011-02-09 Thread Jeff Davis
Case: BEGIN; CREATE TABLE foo AS SELECT generate_series(1,1000); CHECKPOINT; SELECT relfilenode FROM pg_class WHERE relname='foo'; Let's say that returns 23456. Send the postmaster a SIGQUIT (immediate shutdown), and then restart. The file 23456 is still in the filesystem, but there's no

Re: [BUGS] [Fwd: ERROR: cannot extract system attribute from minimal tuple]

2011-02-09 Thread Alvaro Herrera
Excerpts from Denis Feklushkin's message of mié feb 09 16:53:28 -0300 2011: > Query: > > SELECT currency_id1 > FROM bug0.currency_pairs p > FOR SHARE; > > returns error: > ERROR: cannot extract system attribute from minimal tuple Hmm, yeah, in an assert-enabled build of HEAD it dies with: TRA

Re: [BUGS] BUG #5875: can not make a backup

2011-02-09 Thread Kevin Grittner
"Andi Sielicki" wrote: > message: database not exist > > this is wrong, database always exist > > version 9.0.1.1 make it right We would need a little more information to do anything with this report. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-

[BUGS] BUG #5875: can not make a backup

2011-02-09 Thread Andi Sielicki
The following bug has been logged online: Bug reference: 5875 Logged by: Andi Sielicki Email address: it-asieli...@t-online.de PostgreSQL version: 9.0.3.1 Operating system: xp windows Description:can not make a backup Details: can not make a backup (dump) message:

[BUGS] [Fwd: ERROR: cannot extract system attribute from minimal tuple]

2011-02-09 Thread Denis Feklushkin
Пересылаемое сообщение От: Denis Feklushkin Кому: sub...@bugs.debian.org Тема: ERROR: cannot extract system attribute from minimal tuple Дата: Sat, 05 Feb 2011 09:50:06 +0700 Package: postgresql-9.0 Version: 9.0.3-1 Severity: normal Tags: upstream Query: SELECT currency_id1 FR

Re: [BUGS] sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD

2011-02-09 Thread Peter Eisentraut
On sön, 2011-02-06 at 11:06 -0500, Tom Lane wrote: > I don't know the state of affairs on FreeBSD for sure, but I do know > that the UTF-8 locales are fairly broken on Mac OS X, which is a BSD > derived platform too. It looks like nobody in BSD-land has bothered > to put in the work to make multib

[BUGS] BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters

2011-02-09 Thread Jan-Peter Seifert
The following bug has been logged online: Bug reference: 5874 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@gmx.de PostgreSQL version: 8.4.7 Operating system: Windows 7 64-Bit Description:pg_dumpall CREATE DATABASE statements 'missing' parameters Detai