[BUGS] BUG #4744: Windows 2008: FATAL: could not reattach to shared memory: 487

2009-04-01 Thread grouvi
The following bug has been logged online: Bug reference: 4744 Logged by: grouvi Email address: g...@sylob.com PostgreSQL version: 8.3.7 Operating system: Windows Server 2008 Standard SP1 Description:Windows 2008: FATAL: could not reattach to shared memory: 487 Detail

[BUGS] BUG #4745: Errors in installing add-ons for postgresql-8.3.msi

2009-04-01 Thread
The following bug has been logged online: Bug reference: 4745 Logged by: Email address: nelk...@yahoo.es PostgreSQL version: postgresql-8.3. Operating system: windows xp Description:Errors in installing add-ons for postgresql-8.3.msi Details: >From StackBuilder: in

Re: [BUGS] BUG #4745: Errors in installing add-ons for postgresql-8.3.msi

2009-04-01 Thread Dave Page
2009/4/1 : > > The following bug has been logged online: > > Bug reference:      4745 > Logged by: > Email address:      nelk...@yahoo.es > PostgreSQL version: postgresql-8.3. > Operating system:   windows xp > Description:        Errors in installing add-ons for postgresql-8.3.msi > Details: > >

[BUGS] BUG #4746: relation with OID #### doesnot exists

2009-04-01 Thread Igor
The following bug has been logged online: Bug reference: 4746 Logged by: Igor Email address: mayorsh...@ua.fm PostgreSQL version: 8.3.6-1 Operating system: Windows XP SP2 Description:relation with OID doesnot exists Details: Good day. Repeated error: "relation

Re: [BUGS] BUG #4744: Windows 2008: FATAL: could not reattach to shared memory: 487

2009-04-01 Thread Alvaro Herrera
grouvi wrote: > I have the following messages in logs. > > 2009-04-01 07:01:05 CEST Tx[0] cmd[] PID[2224] DB[] WARNING: worker took > too long to start; cancelled > FATAL: could not reattach to shared memory (key=288, addr=01FF): 487 "worker took too long" is an autovacuum launcher message

Re: [BUGS] shared_buffers/SHMMAX defaults?

2009-04-01 Thread Tom Lane
Martin Pitt writes: > Tom Lane [2009-03-30 20:29 -0400]: >> Consider >> (4) Lobby your kernel packagers to install saner SHMMAX/SHMALL >> defaults. > Sounds good. :-) > Those are the current defaults: > kernel.shmmax = 33554432 > kernel.shmall = 2097152 > kernel.shmmni = 4096 Hm, those shmall

[BUGS] BUG #4747: Some type names accepted in place of column name.

2009-04-01 Thread Bruce Toll
The following bug has been logged online: Bug reference: 4747 Logged by: Bruce Toll Email address: bt...@dhsus.com PostgreSQL version: 8.4devel Operating system: GNU/Linux (Ubuntu Hardy) Description:Some type names accepted in place of column name. Details: Hello,

Re: [BUGS] BUG #4747: Some type names accepted in place of column name.

2009-04-01 Thread Tom Lane
"Bruce Toll" writes: > For instance, the pg_catalog.pg_class table has no > column "name", yet the following query returns rows from the pg_class > table: > SELECT pg_class.name FROM pg_class limit 2; > name > --

[BUGS] consulta de phpESP postgres error

2009-04-01 Thread Beto Piragauta
Les cuento estoy montando el sistema de scrip para encuestas phpESP en linux, por defecto phpESP viene con base de datos mysql, pero el trabajo es que phpESP funcione con postgres, en mi maquina tengo instalado posgtres 8.3.7, pero me sale el siguiente error al conectarme con postgres: WARNING: Che

Re: [BUGS] BUG #4741: Domain constraint violation with trigger

2009-04-01 Thread Tom Lane
"Brice Maron & Duchesne P-A" writes: > we've got a problem with a NOT Null constraint on a domain in a trigger. > When, in a trigger, we put a null into the not nullable domain, postgresql > doesn't throw an error. Thanks, fixed. (Just remove the if (!isnull) test in exec_simple_cast_value())