Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Alvaro Herrera
Robert Haas escribió: > 2009/8/27 Alvaro Herrera : > > Robert Haas escribió: > > > >> Para obtener ayuda en espan~ol, tal vez puede Ud. tratar > >> pgsql-es-ay...@postgresql.org.  Creo que no tenemos una list de correo > >> en Portugue's. > > > > It lives in another list server: > > https://listas.

Re: [HACKERS] [BUGS] fillfactor hides autovacuum parameters in 8.4.0

2009-08-27 Thread Itagaki Takahiro
Alvaro Herrera wrote: > So I'm going to apply your patch to both 8.4 and HEAD; we can always > improve it later, I guess. Thank you for your applying. I think the fix is ugly, too. We need to introduce cleaner solution for 8.5. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
2009/8/27 Alvaro Herrera : > Robert Haas escribió: > >> Para obtener ayuda en espan~ol, tal vez puede Ud. tratar >> pgsql-es-ay...@postgresql.org.  Creo que no tenemos una list de correo >> en Portugue's. > > It lives in another list server: > https://listas.postgresql.org.br/cgi-bin/mailman/listin

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Alvaro Herrera
Robert Haas escribió: > Para obtener ayuda en espan~ol, tal vez puede Ud. tratar > pgsql-es-ay...@postgresql.org. Creo que no tenemos una list de correo > en Portugue's. It lives in another list server: https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral -- Alvaro Herrera

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
On Thu, Aug 27, 2009 at 12:49 PM, Eduardo wrote: > > The following bug has been logged online: > > Bug reference:      5019 > Logged by:          Eduardo > Email address:      edua...@vip10.com.br > PostgreSQL version: 8.3 > Operating system:   Vista 64 bits > Description:        Nao funciona > Det

Re: [BUGS] Memory error

2009-08-27 Thread Tom Lane
Daniel Weinberger writes: > Yesterday I ran an SQL import. It failed after 3.33 hours with following > message: > ERROR: out of memory Looks like the memory consumption is here: > AfterTriggerEvents: 317710336 total in 49 blocks; 1312 free (42 chunks); > 317709024 used Perhaps you should

Re: [BUGS] BUG #5017: unsigned packages in RHEL4 8.3 packages

2009-08-27 Thread Devrim GÜNDÜZ
On Thu, 2009-08-27 at 08:18 +, Nikola Ciprich wrote: > not really a postgresql but rather a pgdg packaging bug, there are > some unsigned packages in RHEL4 repo for 8.3 postgres. > those are for example: > compat-postgresql-libs-4-1PGDG.rhel4.i386.rpm > compat-postgresql-libs-debuginfo-4-1PGDG

[BUGS] Memory error

2009-08-27 Thread Daniel Weinberger
Yesterday I ran an SQL import. It failed after 3.33 hours with following message: ERROR: out of memory DETAIL: Failed on request of size 32. ** Error ** ERROR: out of memory SQL state: 53200 Detail: Failed on request of size 32. The log file is as follows; 2009-08-26

Re: [BUGS] BUG #5016: dlltool error in libecpg_compatdll.def

2009-08-27 Thread Tom Lane
Magnus Hagander writes: > 2009/8/27 Tom Lane : >> Magnus Hagander writes: >>> Fix applied - exports.txt had a tab in it, instead of spaces, to >>> separate the field from the number. >> >> Hmm, maybe it would be better to fix whatever sed script is presuming >> the form of the whitespace?  Becau

Re: [BUGS] BUG #5016: dlltool error in libecpg_compatdll.def

2009-08-27 Thread Magnus Hagander
2009/8/27 Tom Lane : > Magnus Hagander writes: >> Fix applied - exports.txt had a tab in it, instead of spaces, to >> separate the field from the number. > > Hmm, maybe it would be better to fix whatever sed script is presuming > the form of the whitespace?  Because otherwise we'll surely get bitt

Re: [BUGS] BUG #5016: dlltool error in libecpg_compatdll.def

2009-08-27 Thread Tom Lane
Magnus Hagander writes: > Fix applied - exports.txt had a tab in it, instead of spaces, to > separate the field from the number. Hmm, maybe it would be better to fix whatever sed script is presuming the form of the whitespace? Because otherwise we'll surely get bitten again.

[BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Eduardo
The following bug has been logged online: Bug reference: 5019 Logged by: Eduardo Email address: edua...@vip10.com.br PostgreSQL version: 8.3 Operating system: Vista 64 bits Description:Nao funciona Details: Utilizava a versao do Vista 32 bits e o Post gres rodava no

Re: [BUGS] BUG #5016: dlltool error in libecpg_compatdll.def

2009-08-27 Thread Magnus Hagander
2009/8/27 Itagaki Takahiro : > > The following bug has been logged online: > > Bug reference:      5016 > Logged by:          Itagaki Takahiro > Email address:      itagaki.takah...@oss.ntt.co.jp > PostgreSQL version: 8.5 Alpha 1 > Operating system:   Windows XP (mingw) > Description:        dlltoo

Re: [BUGS] BUG #5008: Server Startup Problem - When server is configured for SSL

2009-08-27 Thread Magnus Hagander
2009/8/27 Jalaj Negi : > Hi, > I tried by setting the requirement for certificates only on non-localhost > addresses. It works perfectly fine in that case. > Whats the solution in case of requesting client certificates on localhost > connection? > > One temporary solution I found for above questi

Re: [BUGS] fillfactor hides autovacuum parameters in 8.4.0

2009-08-27 Thread Alvaro Herrera
Itagaki Takahiro wrote: > > Here is a patch to fix a bug in handling default values in reloptions. > This fix should be applied to HEAD and 8.4.0. > > I used 'magic number -1' to propagate "not-specified" information to > autovacuum process. It might look strange because the default value is > ou

Re: [BUGS] BUG #5008: Server Startup Problem - When server is configured for SSL

2009-08-27 Thread Jalaj Negi
Hi, I tried by setting the requirement for certificates only on non-localhost addresses. It works perfectly fine in that case. Whats the solution in case of requesting client certificates on localhost connection? One temporary solution I found for above question is to set PGSSLCERT, PGSSLKEY, PGSS

Re: [BUGS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-27 Thread WANGRUNGVICHAISRI, SHIVESH
Hi Craig, Firstly, I would like to say I'm sorry for the stupid kind of query that I had in the test program. It did indeed make the test program appeared to be "leaking" and I obviously misinterpreted the result. Secondly, thank you for taking the time to look into this issue. Your assessment

[BUGS] BUG #5017: unsigned packages in RHEL4 8.3 packages

2009-08-27 Thread Nikola Ciprich
The following bug has been logged online: Bug reference: 5017 Logged by: Nikola Ciprich Email address: nikola.cipr...@linuxbox.cz PostgreSQL version: 8.3.7 Operating system: redhat enterprise linux Description:unsigned packages in RHEL4 8.3 packages Details: not rea

Re: [BUGS] BUG #5018: Window function alias

2009-08-27 Thread Tom Lane
Heikki Linnakangas writes: > Marko Tiikkaja wrote: >> I came across this: >> >> => SELECT lead(foo) OVER(ORDER BY foo) AS foo FROM (VALUES(0)) bar(foo); >> ERROR: window functions not allowed in window definition >> >> Changing the *column alias* to something else gives the expected answer. Is

Re: [BUGS] BUG #5018: Window function alias

2009-08-27 Thread Heikki Linnakangas
Marko Tiikkaja wrote: > I came across this: > > => SELECT lead(foo) OVER(ORDER BY foo) AS foo FROM (VALUES(0)) bar(foo); > ERROR: window functions not allowed in window definition > > Changing the *column alias* to something else gives the expected answer. Is > this really the desired behaviour?

Re: [BUGS] BUG #5015: MySQL migration wizard does not start

2009-08-27 Thread Ashesh Vashi
Hi Ken Smith, We found that - the jar files, we packaged with the installers are corrupted. Please find the set of jar files as a zip @ http://uploads.enterprisedb.com/download.php?file=86fb5b8e61f63c7d27525d2616f6. Replace them with existing MigrationWizard.jar and lib folder found unde

[BUGS] BUG #5018: Window function alias

2009-08-27 Thread Marko Tiikkaja
The following bug has been logged online: Bug reference: 5018 Logged by: Marko Tiikkaja Email address: marko.tiikk...@cs.helsinki.fi PostgreSQL version: 8.4.0 Operating system: Linux Description:Window function alias Details: I came across this: => SELECT lead(foo)

Re: [BUGS] BUG #5008: Server Startup Problem - When server is configured for SSL

2009-08-27 Thread Magnus Hagander
On Wed, Aug 26, 2009 at 22:47, Tom Lane wrote: > Magnus Hagander writes: >> On Wed, Aug 26, 2009 at 15:57, Tom Lane wrote: >>> Magnus Hagander writes: But that will still fail if the user has set it up to require a client certificate. >>> >>> But not till it gets to the pg_hba checks.