Re: [BUGS] pgcrypto decrypt_iv() issue

2012-01-26 Thread Tom Lane
Stefan Kaltenbrunner writes: > from some looking at the code in pgcrypto.c it seems to me that the > coding pattern in most functions there only checks for errors from the > corresponding initialization function, in the case of say decrypt_iv() > that means only the IV and the key are actually "va

Re: [BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions

2012-01-26 Thread Jeff Davis
On Thu, 2012-01-26 at 20:43 -0500, Tom Lane wrote: > Jeff Davis writes: > > => select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE > > count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ; > > ERROR: cannot extract attribute from empty tuple slot > > I believe this

Re: [BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions

2012-01-26 Thread Tom Lane
Jeff Davis writes: > In REL8_4_STABLE and REL9_0_STABLE: > => select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE > count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ; > ERROR: cannot extract attribute from empty tuple slot I believe this is the same case fixed h

[BUGS] 8.4, 9.0 bug (doesn't exist in 9.1) related to window functions

2012-01-26 Thread Jeff Davis
In REL8_4_STABLE and REL9_0_STABLE: => select ntile(3) OVER ( ORDER BY CASE WHEN count(i) = 0 THEN NULL ELSE count(i) END asc ) from ( SELECT NULL::integer as i limit 0 ) s ; ERROR: cannot extract attribute from empty tuple slot A different error appears in 9.1.0 ("could not find pathkey item t

[BUGS] Doc-bug; minor typo in auto_explain documentation

2012-01-26 Thread Peter Geoghegan
I noticed the following in the auto_explain documentation: "This can have extremely negative impact on performance." Surely it should say: "This can have an extremely negative impact on performance." -- Peter Geoghegan       http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Tra

Re: [BUGS] Windows x86-64 One-Click Install (9.1.2-1, 9.0.6-1) hangs on "initialising the database cluster" (with work-around)

2012-01-26 Thread Eric Borts
Also, here is a link to the same issue on StackOverflow: http://stackoverflow.com/questions/3559719/wscript-shell-run-doesnt-work-consistently Also solved using %COMSPEC% /c, though it doesn't say why this is a problem. Cheers, Eric On 1/26/2012 11:37 AM, Eric Borts wrote: On 1/26/2012 1:17 AM

Re: [BUGS] BUG #6411: Backend process' crash when a foreign table is used in a dependent subquery on select clause

2012-01-26 Thread Heikki Linnakangas
On 26.01.2012 14:46, emre.haseg...@tart.com.tr wrote: The following bug has been logged on the website: Bug reference: 6411 Logged by: Using a Foreign Table in a Dependent Subquery Email address: emre.haseg...@tart.com.tr PostgreSQL version: 9.1.2 Operating system: Linux 3.0

Re: [BUGS] Windows x86-64 One-Click Install (9.1.2-1, 9.0.6-1) hangs on "initialising the database cluster" (with work-around)

2012-01-26 Thread Eric Borts
On 1/26/2012 1:17 AM, Dave Page wrote: Dharmendra, can you look into this please? Eric, is there anything unusual about the configuration of your machine? Suffice it to say, this doesn't normally happen. Hi Dave, I'm guessing the answer to that question is "yes". The machine came preinstalled

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"

2012-01-26 Thread Robert Haas
On Thu, Jan 26, 2012 at 5:43 AM, Vik Reykja wrote: > On Wed, Jan 25, 2012 at 22:19, Giuseppe Sucameli > wrote: >> >> thinking you have no skills, I wrote a patch too and posted it to >> hackers ML about 2 days ago, but I didn't subscribe that list so >> it is stalled, waiting for someone's approv

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"

2012-01-26 Thread Vik Reykja
On Wed, Jan 25, 2012 at 22:19, Giuseppe Sucameli wrote: > thinking you have no skills, I wrote a patch too and posted it to > hackers ML about 2 days ago, but I didn't subscribe that list so > it is stalled, waiting for someone's approval. > > For this reason my email is not displayed in the archi

Re: [BUGS] One question about VACUUMDB command - please

2012-01-26 Thread Euler Taveira de Oliveira
On 26-01-2012 05:31, sasa.petro...@falc.biz wrote: > Why this comand that I write belove ask me for password, even I create user > into DB with same password like user on my server that execute this command? > PostgreSQL doesn't inherit authentication properties from operational system. Instead yo

[BUGS] BUG #6411: Backend process' crash when a foreign table is used in a dependent subquery on select clause

2012-01-26 Thread emre . hasegeli
The following bug has been logged on the website: Bug reference: 6411 Logged by: Using a Foreign Table in a Dependent Subquery Email address: emre.haseg...@tart.com.tr PostgreSQL version: 9.1.2 Operating system: Linux 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 2 Description:

[BUGS] One question about VACUUMDB command - please

2012-01-26 Thread Sasa . Petrovic
Dear Sirs, I'm trying to put some scipt into scheduler on my server 2000 to make auto vacuum one time in mouth. Why this comand that I write belove ask me for password, even I create user into DB with same password like user on my server that execute this command? Can you suggest me some othe

[BUGS] BUG #6409: [NPGSQL]Fail to cast Int64 to System.Data.Common.DbParameter

2012-01-26 Thread aaron . kb . h
The following bug has been logged on the website: Bug reference: 6409 Logged by: AaronHuang Email address: aaron.k...@gmail.com PostgreSQL version: 9.1.2 Operating system: Windows 7 Ultimate Description: [Exception] InvalidCastException:Unable to cast object of type '

[BUGS] BUG #6410: Windows say a unpleasant warning when stop a pgsql service

2012-01-26 Thread harukat
The following bug has been logged on the website: Bug reference: 6410 Logged by: TAKATSUKA Haruka Email address: haru...@sraoss.co.jp PostgreSQL version: 9.1.2 Operating system: Windows Server 2008 R2 Description: (I also tested 8.3.17, 8.4.9 and 9.2-dev.) Windows sa