[BUGS] BUG #2100: CREATE TABLE AS - may not supply table specification

2005-12-09 Thread Robert Bengtsson
The following bug has been logged online: Bug reference: 2100 Logged by: Robert Bengtsson Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL Data Operating system: Windows Server 2003, Web Edition Description:CREATE TABLE AS - may not supply table specifi

Re: [BUGS] BUG #2099: too many private dirs ?

2005-12-09 Thread Tom . Zschockelt
Hi, I've found the following additional lines in postmaster.log 2005-12-08 15:42:02 ERROR: too many private dirs demanded 2005-12-08 15:42:03 ERROR: too many private dirs demanded 2005-12-08 15:42:04 PANIC: too many private files demanded 2005-12-08 15:42:04 CONTEXT: writing block 236 of rela

[BUGS] BUG #2104: pg_xlog/ trace files not reclaimed by server

2005-12-09 Thread Reuben Pasquini
The following bug has been logged online: Bug reference: 2104 Logged by: Reuben Pasquini Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: linux redhat-4.1 Description:pg_xlog/ trace files not reclaimed by server Details: Hello! It appears

[BUGS] BUG #2103: System column oid is not unique

2005-12-09 Thread wangshj
The following bug has been logged online: Bug reference: 2103 Logged by: wangshj Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: CentOS 4 Description:System column oid is not unique Details: The following is my test. oidtest=# CREATE TA

[BUGS] BUG #2101: Postmaster Crash Using PL/PgSQL With %TYPE on Non-Exisiting Column

2005-12-09 Thread Will Szopko
The following bug has been logged online: Bug reference: 2101 Logged by: Will Szopko Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Debain Linux (Sarge)/Mac OS X 10.3.9 (Panther) Description:Postmaster Crash Using PL/PgSQL With %TYPE on N

[BUGS] pgsql8.1: About COPY Command and system clomn oid

2005-12-09 Thread wangshj
The following is my test. oidtest=# CREATE TABLE oidtest( name text ) WITH OIDS; CREATE TABLE oidtest=# INSERT INTO oidtest ( name ) VALUES( 'name1' ) ; INSERT 54512 1 oidtest=# COPY oidtest (name) WITH OIDS FROM stdin; Enter data to be copied followed by a newline. End with a backslash and a peri

Re: [BUGS] There is a doubt of fatal bug on PostgreSQL 8.0.4.

2005-12-09 Thread Kasahara Kenichi
What locale is the database using? Strange comparison behavior is fairly common if the locale expects a different encoding than you are using... locale is 'C'. client_encoding is 'SJIS'. Locale 'C' is the same settings when I used version 8.0.3. I think this is right..Or should I appoint "no l

[BUGS] BUG #2102: Backend reports wrong number of affected rows for a table that uses rules

2005-12-09 Thread Brent Reid
The following bug has been logged online: Bug reference: 2102 Logged by: Brent Reid Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Linux dl380 2.6.14.2 #2 SMP Wed Nov 16 09:51:56 MST 2005 i686 i686 i386 GNU/Linux Description:Backend repor

Re: [BUGS] BUG #2100: CREATE TABLE AS - may not supply table specification

2005-12-09 Thread Tom Lane
"Robert Bengtsson" <[EMAIL PROTECTED]> writes: > while the following generates an error: > CREATE TABLE l_modeltext > ( > id serial NOT NULL, > text varchar(60), > make varchar(30), > model varchar(30), > make_id int4, > model_id int4 > ) WITHOUT OIDS AS (SELECT distinct modeltext as t

Re: [BUGS] BUG #2104: pg_xlog/ trace files not reclaimed by server

2005-12-09 Thread Tom Lane
"Reuben Pasquini" <[EMAIL PROTECTED]> writes: > It appears that when my 8.1 database is forced > to generate more than > 2*checkpoint_segments + 1 > trace files under pg_xlog/, that the database > becomes confused and stops recycling the trace files. That's fairly hard to believe, espe

Re: [BUGS] BUG #2103: System column oid is not unique

2005-12-09 Thread Tom Lane
"wangshj" <[EMAIL PROTECTED]> writes: > Description:System column oid is not unique There isn't, and never has been nor will be, any promise that it is, except to the extent that uniqueness is enforced by a unique index on a particular table. OID is just a kind of serial sequence generato

Re: [BUGS] BUG #2101: Postmaster Crash Using PL/PgSQL With %TYPE on Non-Exisiting Column

2005-12-09 Thread Tom Lane
"Will Szopko" <[EMAIL PROTECTED]> writes: > The postmaster in 8.1.0 crashes when creating or replacing a PL/PgSQL > function containing an invalid variable declaration. Reproduced here --- thanks for the test case! regards, tom lane ---(end of broa

Re: [BUGS] BUG #2102: Backend reports wrong number of affected rows for a table that uses rules

2005-12-09 Thread Tom Lane
"Brent Reid" <[EMAIL PROTECTED]> writes: > Our Java application depends upon the return values from the various JDBC > insert, update, and delete routines. We noticed that the value is always > zero when the table that is referenced has rules associated with it. Have you read http://www.postgresq

Re: [BUGS] BUG #2101: Postmaster Crash Using PL/PgSQL With %TYPE on Non-Exisiting Column

2005-12-09 Thread Tom Lane
"Will Szopko" <[EMAIL PROTECTED]> writes: > The postmaster in 8.1.0 crashes when creating or replacing a PL/PgSQL > function containing an invalid variable declaration. Looks like a copy-and-paste mistake... Index: pl_comp.c === RCS

Re: [BUGS] BUG #2100: CREATE TABLE AS - may not supply table specification

2005-12-09 Thread Bruce Momjian
Robert Bengtsson wrote: > > The following bug has been logged online: > > Bug reference: 2100 > Logged by: Robert Bengtsson > Email address: [EMAIL PROTECTED] > PostgreSQL version: PostgreSQL Data > Operating system: Windows Server 2003, Web Edition > Description:CREA

Re: [BUGS] There is a doubt of fatal bug on PostgreSQL 8.0.4.

2005-12-09 Thread Tom Lane
"Kasahara Kenichi" <[EMAIL PROTECTED]> writes: >> What locale is the database using? Strange comparison behavior is >> fairly common if the locale expects a different encoding than you >> are using... > locale is 'C'. Hm, it should work OK with C locale. I get apparently-correct output on my 8.

Re: [BUGS] [PATCHES] Patch to allow contrib/pgbench files to have blank lines

2005-12-09 Thread David Fetter
On Wed, Nov 23, 2005 at 10:24:00PM +0900, Tatsuo Ishii wrote: > > Having blank lines in -f scripts was causing silent failures. > > This fixes it, for some value of "fixes." If it's OK, please > > apply to 8.1 CURRENT and CVS TIP :) > > Thanks. I have committed your patches to current and 8.1 sta

Re: [BUGS] [PATCHES] Patch to allow contrib/pgbench files to have blank lines

2005-12-09 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > Please apply the following patch that removes an unneeded (and broken) > counter increment. Done. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planne