Re: [BUGS] [PATCH v2] Use CC atomic builtins as a fallback

2011-12-21 Thread Martin Pitt
Hello Tom, all, Tom Lane [2011-12-20 21:14 -0500]: > Getting this thread back to the original patch ... I'm afraid that if we > apply this as-is, what will happen is that we fix ARMv7 and break older > versions. Right, I guess it's dependent on the compiler version, too. That's why my original pa

Re: [BUGS] Incorrect comment in heapam.c

2011-12-21 Thread Peter Geoghegan
On 20 December 2011 18:11, Tom Lane wrote: > Simon Riggs writes: >> On Tue, Dec 20, 2011 at 5:50 PM, Peter Geoghegan >> wrote: >>> In fact, that macro is defined in access/htup.h...should it be? > >> IMHO comment is wrong, code is in the right place. > > It used to be in heapam.h ... evidently,

R: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-21 Thread Andrea Grassi
Then I meet my colleague who is the systems engineer that takes care of the machine and I explain your hints (suggested by Craig Ringer) about how detect and log kernel issues. If it can be useful, the content of file /proc/$pid/wchan in the moment of block is "_stext". In the meantime, to be sure

Re: [BUGS] [PATCH v2] Use CC atomic builtins as a fallback

2011-12-21 Thread Tom Lane
Martin Pitt writes: > Tom Lane [2011-12-20 21:14 -0500]: >> Another thing that is bothering me is that according to the gcc >> manual, eg here, >> http://gcc.gnu.org/onlinedocs/gcc-4.1.2/gcc/Atomic-Builtins.html >> __sync_lock_test_and_set is nominally provided for datatypes 1, 2, >> 4, or 8 bytes

Re: R: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-21 Thread Tom Lane
"Andrea Grassi" writes: > In internet I searched for detailed specifications of poll/select system > functions but I didn't understand one thing, that is which one of the 2 > statement is true: > 1) poll/select wait only for FUTURE modifications of ready-read state of > sockets > 2) poll/select ch

[BUGS] BUG #6349: Cannot install on 32 bit platform

2011-12-21 Thread cmjnov92
The following bug has been logged on the website: Bug reference: 6349 Logged by: Chandramouli Email address: cmjno...@gmail.com PostgreSQL version: 9.1.2 Operating system: Windows 7 32 bit Description: Hello. I downloaded the insatller of postgresql from the internet

[BUGS] BUG #6348: PROBLEMAS DELETE

2011-12-21 Thread wilsoncamago
The following bug has been logged on the website: Bug reference: 6348 Logged by: wilson camargo Email address: wilsoncam...@gmail.com PostgreSQL version: 9.1.2 Operating system: win linux Description: hace algun tiempo tube el inconveniente de eliminar de una tabla re

Re: [BUGS] BUG #6348: PROBLEMAS DELETE

2011-12-21 Thread Alvaro Herrera
Excerpts from wilsoncamago's message of mié dic 21 11:26:39 -0300 2011: > hace algun tiempo tube el inconveniente de eliminar de una tabla relacionada > en una subconsulta y eliminando 1 aprox se demoraba 20 seg la consulta > era > DELETE FROM saldo_detalle_cartera > WHERE saldo_detalle_ca

[BUGS] BUG #6350: Delete a role which is still in use

2011-12-21 Thread marc
The following bug has been logged on the website: Bug reference: 6350 Logged by: Marc Balmer Email address: m...@msys.ch PostgreSQL version: 9.1.1 Operating system: NetBSD Description: A role can be deleted although it is still referenced in a column privilege. Here

Re: [BUGS] BUG #6349: Cannot install on 32 bit platform

2011-12-21 Thread Kevin Grittner
wrote: > I downloaded the insatller of postgresql from the internet and > when I try to install it says "Cannot install a 64 bit installer > on a 32 bit platform".Where can I get a 32bit installed. This is not a bug. Please post futures questions like this to a more appropriate list, like pgs

[BUGS] script for #6350

2011-12-21 Thread Marc Balmer
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to

[BUGS] script for #6350

2011-12-21 Thread Marc Balmer
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to

Re: [BUGS] BUG #6350: Delete a role which is still in use

2011-12-21 Thread Tom Lane
m...@msys.ch writes: > A role can be deleted although it is still referenced in a column privilege. Hmm, it looks like ALTER TABLE OWNER forgets to update the grantors in column privileges. Table privileges are processed properly, but not columns. regards, tom lane -- S

[BUGS] BUG #6351: ERROR: btree index keys must be ordered by attribute

2011-12-21 Thread christian_oederan
The following bug has been logged on the website: Bug reference: 6351 Logged by: Christian Rudolph Email address: christian_oede...@gmx.de PostgreSQL version: 9.0.6 Operating system: openSUSE Description: Hi, our OR-Mapper accidently created an index that contained t

Re: [BUGS] BUG #6204: Using plperl functions generate crash

2011-12-21 Thread Shahaf
I'm running into the same issue. I can "create language plperl;" successfully, but as soon as I try to create a function (as shown above), Postgres dies. Guimaraes - did you find a solution using standard installers? sachin - have you tried on win7? pasman - what's the process to install from sou

Re: [BUGS] BUG #6204: Using plperl functions generate crash

2011-12-21 Thread l
Shahaf wrote > > I'm running into the same issue. I can "create language plperl;" > successfully, but as soon as I try to create a function (as shown above), > Postgres dies. > > Guimaraes - did you find a solution using standard installers? > No, I didn’t. In fact, þanks God I did not have