The following bug has been logged online:

Bug reference:      6041
Logged by:          Emanuel
Email address:      postgres(dot)arg(at)gmail(dot)com
PostgreSQL version: 9.1 beta
Operating system:   Ubuntu
Description:        Unlogged table was created bad in slave node
Details: 

MASTER=6666
SLAVE SYNC=6667
SLAVE ASYNC=6668

root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6666
psql (9.1beta1)
Type "help" for help.

postgres=# CREATE UNLOGGED TABLE voidy AS SELECT i, random() FROM
generate_series(1,1000) i(i);
SELECT 1000
postgres=# \q
root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6667
psql (9.1beta1)
Type "help" for help.

postgres=# \d voidy
     Unlogged table "public.voidy"
 Column |       Type       | Modifiers 
--------+------------------+-----------
 i      | integer          | 
 random | double precision | 

postgres=# select * from voidy ;
ERROR:  could not open file "base/12071/17034": No existe el archivo o
directorio
postgres=# \q
root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6668
psql (9.1beta1)
Type "help" for help.

postgres=# \d voidy
     Unlogged table "public.voidy"
 Column |       Type       | Modifiers 
--------+------------------+-----------
 i      | integer          | 
 random | double precision | 

postgres=# select * from voidy ;
ERROR:  could not open file "base/12071/17034": No existe el archivo o
directorio

Responses

• Re: BUG #6041: Unlogged table was created bad in slave node at 2011-05-26 16:00:05 from Euler Taveira de Oliveira

pgsql-hackers by date

Next:	From: Peter Geoghegan	Date: 2011-05-26 11:58:33
	Subject: Re: Latch implementation that wakes on postmaster death on both win32 and Unix
Previous:	From: Pavan Deolasee	Date: 2011-05-26 10:40:37
	Subject: Re: Proposal: Another attempt at vacuum improvements

pgsql-bugs by date

Next:	From: Euler Taveira de Oliveira	Date: 2011-05-26 16:00:05
	Subject: Re: BUG #6041: Unlogged table was created bad in slave node
Previous:	From: Jordi Areny	Date: 2011-05-26 07:43:31
	Subject: BUG #6040: ODBC 64 + SSL Hangs