Re: [BUGS] BUG #5716: Regression joining tables in UPDATE with composite types

2010-10-20 Thread Andrew Tipton
On 20 October 2010 06:15, Tom Lane wrote: > "Andrew Tipton" writes: > > Attempting to execute an UPDATE that joins to another table where the > join > > condition is comparing a composite type fails with the (presumably > internal) > > error message "psql:testcase.sql:29: ERROR: could not find

[BUGS] BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

2010-10-20 Thread Aleksandr Dushein
The following bug has been logged online: Bug reference: 5718 Logged by: Aleksandr Dushein Email address: adush...@rutube.ru PostgreSQL version: 9.0.1 Operating system: FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:36:49 UTC 2010 r...@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GE

Re: [BUGS] BUG #5708: configuration php.ini

2010-10-20 Thread Robert Haas
On Tue, Oct 12, 2010 at 1:21 PM, paulo pillon wrote: > > The following bug has been logged online: > > Bug reference:      5708 > Logged by:          paulo pillon > Email address:      paulo.pil...@bol.com.br > PostgreSQL version: 8.3 > Operating system:   windows 7 > Description:        configura

Re: [BUGS] BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

2010-10-20 Thread Alvaro Herrera
Excerpts from Aleksandr Dushein's message of mié oct 20 06:44:09 -0300 2010: > FATAL: invalid cache id: 19 Hmm, try removing pg_internal.init from directories under "base/" and restart single mode. (You then need to run vacuum on the specified database to get out of the other problem). -- Álv

Re: [BUGS] BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

2010-10-20 Thread Tom Lane
"Aleksandr Dushein" writes: > Description:Cannot start postgres (FATAL: invalid cache id: 19) > Hello. I was upgraded my database from 8.4.4 то 9.0.1 one week ago by > pg_dump/pg_restore. Yesterday database stop responding with message ERROR: > database is not accepting commands to av