Re: [BUGS] BUG #7903: EAN13s are shown ISBN values

2013-02-26 Thread Peter Geoghegan
On 26 February 2013 21:45, Peter Eisentraut wrote: > Have each user create their custom domain? That's likely to be the most effective solution, yes. I'd take the fact that people haven't been complaining about contrib/isn more as suggestive of people figuring this out for themselves than suggest

Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Frost
On 02/26/13 09:08, Jeff Janes wrote: > > They're all number of xlog based and the first one doesn't remove any, > that's not surprising, > > > What was the state of the pg_xlog directory before you started the test? If > it were not full up to check_point segments * 2, (which is likely was

Re: [BUGS] BUG #7903: EAN13s are shown ISBN values

2013-02-26 Thread Peter Eisentraut
On 2/23/13 2:10 PM, Peter Geoghegan wrote: > But then, contrib/isn also sanitises both ISBN > ranges and EAN country codes using its own internal database, which > ought to be kept in lockstep with an external database whose > maintenance is highly decentralised - regional authorities make > certai

[BUGS] Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.

2013-02-26 Thread fburgess
On tuesday, February 26, 2013, Freddie Burgess wrote:   We have a Postgres database that was recently upgraded from 8.4.3 to 9.1.6.  We have noticed unusual growth in the data files and generated a script to perform the following actions.1. Query pg_class for all records2. Generate a file listing o

[BUGS] BUG #7907: BEFORE DELETE TRIGGER (not instead of, my trigger BEFORE)not row delete...

2013-02-26 Thread ibrahimkocaoglutr
The following bug has been logged on the website: Bug reference: 7907 Logged by: İBRAHIM KOCAOGLU Email address: ibrahimkocaogl...@gmail.com PostgreSQL version: 9.1.0 Operating system: debian-6.stable Description: -- Function: f_is_isletme_sayim_hazirlik_delete() --

[BUGS] BUG #7904: can´t load DBI-Link

2013-02-26 Thread pedro . ferro
The following bug has been logged on the website: Bug reference: 7904 Logged by: Pedro Email address: pedro.fe...@gmail.com PostgreSQL version: 9.2.3 Operating system: Windows 64bits Description: Hi, I can not install DBI-Link in Postgresql. I have a machine with

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-26 Thread jimbob
So, I have some observations. Is this what you are seeing as well? So when we CLUSTER a table heavily-updated table: CLUSTER does appear to reset *n_dead_tup*, *n_tup_ins*, *n_tup_del*, *n_tup_hot_upd*, but NOT *n_live_tup* pg_stat_reset() truly clears out all the statistics counters. I tried

[BUGS] BUG #7906: pg_dump exits successfully after an error

2013-02-26 Thread adam . tomjack
The following bug has been logged on the website: Bug reference: 7906 Logged by: Adam Tomjack Email address: adam.tomj...@zuerchertech.com PostgreSQL version: 9.2.1 Operating system: Linux 2.6.32-39-server #86-Ubuntu SMP x86_64 Description: I have a database that uses

Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Janes
On Sunday, February 24, 2013, Jeff Frost wrote: > > This is how the log_checkpoint output looks during the run: > > 2013-02-24 21:06:31.156 UTC,,,1624,,51282598.658,114,,2013-02-23 02:12:40 > UTC,,0,LOG,0,"checkpoint starting: immediate force wait","" > 2013-02-24 21:06:31.216 UTC,,,16

Re: [BUGS] BUG #7902: lazy cleanup of extraneous WAL files can cause out of disk issues

2013-02-26 Thread Jeff Janes
On Friday, February 22, 2013, wrote: > The following bug has been logged on the website: > > Bug reference: 7902 > Logged by: Jeff Frost > Email address: j...@pgexperts.com > PostgreSQL version: 9.2.3 > Operating system: Ubuntu 12.04 > Description: > > While doing acceptance