Skip site navigation (1) Skip section navigation (2)

Problems in 6.5.3 with Multi-Byte encoding

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Cc: 50388(at)bugs(dot)debian(dot)org
Subject: Problems in 6.5.3 with Multi-Byte encoding
Date: 1999-11-19 10:19:49
Message-ID: 199911191019.KAA00665@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
With PostgreSQL compiled with support for locales and multi-byte encoding:

initdb -e BIG5

[start postmaster]
psql template1
\dS causes a segmentation fault in the backend

>From the log:

StartTransactionCommand
query: SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user 
WHERE usesysid = relowner and ( relkind = 'r' OR relkind = 'i' OR relkind = 
'S') and relname ~ '^pg_' and (relkind != 'i' OR relname !~ '^xinx') ORDER BY 
relname
ProcessQuery
/usr/lib/postgresql/bin/postmaster: reaping dead processes...
/usr/lib/postgresql/bin/postmaster: CleanupProc: pid 294 exited with status 11


This can be isolated to the pattern-matching operator:

template1=> select * from pg_class where relname ~ '^pg_' ;
pqReadData() -- backend closed the channel unexpectedly.

------- Forwarded Message

Date:    Thu, 18 Nov 1999 19:48:39 +0800
From:    Chuan-kai Lin <cklin(at)oink(dot)cc(dot)ntu(dot)edu(dot)tw>
To:      Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Subject: Re: Bug#50388: Backend close client-server channel unexpectedly

On Thu, Nov 18, 1999 at 09:18:34AM +0000, Oliver Elphick wrote:
> Something must have happened to the database as it was being created.
> At the moment, I would put it down to cosmic rays or something.

Through a friend who specializes in metaphysics and astronomy, I
have traced down the exact cause of our problem: PostgreSQL does
not like BIG5 encoding.  If you supply "-e BIG5" to initdb, the
resulting database will be hosed.  Plain and simple.

This looks like a tough one... somebody better notify the upstream
developers about this.

- -- Chuan-kai Lin


------- End of Forwarded Message


-- 
      Vote against SPAM: http://www.politik-digital.de/spam/
                 ========================================
Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "To show forth thy lovingkindness in the morning, and 
      thy faithfulness every night."     Psalms 92:2 



Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 1999-11-19 11:19:00
Subject: Re: [BUGS] Problems in 6.5.3 with Multi-Byte encoding
Previous:From: Tom LaneDate: 1999-11-19 07:02:45
Subject: Re: [HACKERS] 7.0 status request

pgsql-bugs by date

Next:From: Oleg BartunovDate: 1999-11-19 11:19:00
Subject: Re: [BUGS] Problems in 6.5.3 with Multi-Byte encoding
Previous:From: ashish srivastavaDate: 1999-11-18 22:57:02
Subject: Installing Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group