[BUGS] BUG #4243: Idle in transaction

2008-06-17 Thread Clemens Wagner
The following bug has been logged online: Bug reference: 4243 Logged by: Clemens Wagner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.7 and 8.3.1 Operating system: Linux 2.6.18-53.1.14.el5 Description:Idle in transaction Details: I have sometimes hanging

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 5:21 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Sorry, late the information. > My patch was applied after the review of Ralf-san. However, The timing of a > release was different. Then, patch is only current CVS-HEAD. > http://cvs.ossp.org/chngview?cn=6001 >

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Hiroshi Saito
Hi. Um, I will arrange information and write wiki. . Is it a suitable place? This is some information. http://winpg.jp/~saito/pg_work/OSSP_win32/ uuid-ossp.dll(MinGW compile) is this. http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp.zip Regards, Hiroshi Saito - Origi

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 10:25 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Um, I will arrange information and write wiki. . Is it a suitable place? A README file at http://winpg.jp/~saito/pg_work/OSSP_win32/ would be enough. > This is some information. http://winpg.jp/~saito/pg_work/OSS

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Hiroshi Saito
Hi. Please this. http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ P.S) sorry, It did not have a machine, when it mailed with you before. Regards, Hiroshi Saito - Original Message - From: "Dave Page" <[EMAIL PROTECTED]> On Tue, Jun 17, 2008 at 10:25 AM, Hiroshi Saito <[EMAIL PROTE

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 11:17 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Please this. > http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ Ahh, a makefile - that makes things somewhat clearer :-) Thanks - I've updated the build machine so future releases will include this fix. -- Dave

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-17 Thread Meetesh Karia
Using the dll from the link that Hiroshi posted actually fixed v1 in my case (though perhaps it's just an unrelated side-effect caused by using a different random number generator which might be slower???). Thanks! Anyhow, I would have expected v1 to work fine in this case too as the ossp-uui

[BUGS] BUG #4244: ALTER TABLE ... NO INHERIT problem

2008-06-17 Thread Tatsuhito Kasahara
The following bug has been logged online: Bug reference: 4244 Logged by: Tatsuhito Kasahara Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: RedHat Linux 5.2 Description:ALTER TABLE ... NO INHERIT problem Details: Hi. I performed "NO INH

Re: [BUGS] BUG #4244: ALTER TABLE ... NO INHERIT problem

2008-06-17 Thread Tom Lane
"Tatsuhito Kasahara" <[EMAIL PROTECTED]> writes: > The comment in tablecmds.c says "AccessShareLock is probably enough". > But it actually needs more strong lock mode ? > ATExecDropInherit(Relation rel, RangeVar *parent) > /* >* AccessShareLock on the parent is probably enough, seein

Re: [BUGS] BUG #4243: Idle in transaction

2008-06-17 Thread Andrew Sullivan
On Tue, Jun 17, 2008 at 06:49:57AM +, Clemens Wagner wrote: > I have sometimes hanging psql backend processes with "idle in transaction" There is no bug here. Some transaction is stuck waiting for something else, or else you've left a transaction hanging around that way (is your JDBC driver o

[BUGS] BUG #4245: Product Name...

2008-06-17 Thread Kevin
The following bug has been logged online: Bug reference: 4245 Logged by: Kevin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows Description:Product Name... Details: Last week I placed a new product in the catalog. By mistake I named

Re: [BUGS] BUG #4245: Product Name...

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 2:57 PM, Kevin <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 4245 > Logged by: Kevin > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: Windows > Description:Product Name

[BUGS] BUG #4247: (Possible) SQL miscontruct not flagged

2008-06-17 Thread J6M
The following bug has been logged online: Bug reference: 4247 Logged by: J6M Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.13 Operating system: Linux x86-64 Description:(Possible) SQL miscontruct not flagged Details: Hi, This European afternoon, I was tr

Re: [BUGS] BUG #4247: (Possible) SQL miscontruct not flagged

2008-06-17 Thread Tom Lane
"J6M" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.1.13 > I wrote : > select distinct(ean13),(select count(*) into zz from fiart where > ean13=a.ean13) as n from fiart as a ; > I am not an expert in the most intricate shades of the SQL language. Should > the SQL interpreter not flag the q

[BUGS] BUG #4250: subquery in query

2008-06-17 Thread Wojciech Tylek
The following bug has been logged online: Bug reference: 4250 Logged by: Wojciech Tylek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1,8.2,8.3 Operating system: Linux Description:subquery in query Details: There are two example tables: create table a (

Re: [BUGS] BUG #4250: subquery in query

2008-06-17 Thread Kevin Grittner
>>> "Wojciech Tylek" <[EMAIL PROTECTED]> wrote: > Why the query like: > > select * from b where a_id in (select a_id from a where b_id in (10,20)); > > does not return error? > The table "a" does not have b_id! This is a correlated subquery. A previous list post on the topic: http://arch