Re: Why would queries fail with 'could not stat file' after CLUSTER? - Mailing list pgsql-admin

template1=# create database test with encoding='SQL_ASCII';

CREATE DATABASE

template1=# \connect test

You are now connected to database "test".

test=# create table a (x text);

CREATE TABLE

test=# insert into a values ('');

test=# select * from a;

x

--

(1 row)

test=# update pg_database set encoding =

pg_catalog.pg_char_to_encoding('UTF8') where datname='test';

UPDATE 1

test=# select * from a;

x

--

(1 row)

test=# \connect template1

You are now connected to database "template1".

template1=# \connect test

You are now connected to database "test".

test=# select * from a;

x

--

(1 row)

--Raghu