[BUGS] BUG #5264: could not create shared memory segment: Invalid argument

2010-01-05 Thread venkat nemani
The following bug has been logged online: Bug reference: 5264 Logged by: venkat nemani Email address: nemani.venka...@gmail.com PostgreSQL version: 8.4 Operating system: ubuntu 9.10 Description:could not create shared memory segment: Invalid argument Details: * Rest

Re: [BUGS] BUG #5264: could not create shared memory segment: Invalid argument

2010-01-05 Thread Craig Ringer
On 5/01/2010 3:06 PM, venkat nemani wrote: 2010-01-05 12:30:00 IST HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the

[BUGS] BUG #5265: incomplete startup packet

2010-01-05 Thread AI Rumman
The following bug has been logged online: Bug reference: 5265 Logged by: AI Rumman Email address: irum...@gmail.com PostgreSQL version: 8.3.8 Operating system: Linux Description:incomplete startup packet Details: Jan 5 18:19:35 dev04 postgres[14342]: [1419-1] DEBUG

Re: [BUGS] BUG #5265: incomplete startup packet

2010-01-05 Thread Alvaro Herrera
AI Rumman escribió: > > The following bug has been logged online: > > Bug reference: 5265 > Logged by: AI Rumman > Email address: irum...@gmail.com > PostgreSQL version: 8.3.8 > Operating system: Linux > Description:incomplete startup packet > Details: Not a bug. P

[BUGS] BUG #5266: erros no servidor web

2010-01-05 Thread robson
The following bug has been logged online: Bug reference: 5266 Logged by: robson Email address: robsonott0...@gmail.com PostgreSQL version: 8 Operating system: windows xp Description:erros no servidor web Details: Warning: pg_connect() [function.pg-connect]: Unable t

Re: [BUGS] BUG #5263: Query execution fails with "ERROR: FULL JOIN is only supported with merge-joinable join conditions"

2010-01-05 Thread Tom Lane
"Jozsef Szalay" writes: > Execute the following query: > SELECT * > FROM (SELECT id, 0 AS value > FROM test > WHERE description = 'abc' > ) t1 > FULL OUTER JOIN > (SELECT id, 1 AS value > FROM test > WHERE description = 'def' > ) t2 USING (id, value);

Re: [BUGS] BUG #5263: Query execution fails with "ERROR: FULL JOIN is only supported with merge-joinable join conditions"

2010-01-05 Thread Jozsef Szalay
Well, this is a real-world case for us :-). The actual sql is a lot more complicated (and it is machine-generated), but the bottom line is that we need to project constants as columns, and we need to be able to "combine" the results coming out of the sub-queries. Years ago (8.1.x), we found tha

Re: [BUGS] BUG #5263: Query execution fails with "ERROR: FULL JOIN is only supported with merge-joinable join conditions"

2010-01-05 Thread Tom Lane
Jozsef Szalay writes: > Well, this is a real-world case for us :-). The actual sql is a lot more > complicated (and it is machine-generated), but the bottom line is that we > need to project constants as columns, and we need to be able to "combine" the > results coming out of the sub-queries. >