Re: [BUGS] BUG #8335: trim() un-document behaviour

Finally could make it using regexp_replace (my_field_to_trim, '.+my_triming_string' , '') for the "leading" case regexp_replace (my_field_to_trim, 'my_triming_string(.+)' , '') for the "trailing" case And both of them in this order a for the "both" one. I don't know why, but  could not use '*?'

Re: [BUGS] Enable WAL Archive in Replication server

On Mon, Aug 12, 2013 at 1:53 AM, ascot.m...@gmail.com wrote: > I want to enable WAL archive on the replica, I am advised that WAL archive > can only be enabled on the Master, can you please advise if this is a bug > and any workaround available? Archiving a WAL file is only done once its generatio

[BUGS] BUG #8381: data base inconsistancy

The following bug has been logged on the website: Bug reference: 8381 Logged by: Rohit Gupta Email address: rohit.gupta...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: linux Description: Background:- There were a large no. of INSERT/UPDATE/DELET

[BUGS] Enable WAL Archive in Replication server

Hi, I want to enable WAL archive on the replica, I am advised that WAL archive can only be enabled on the Master, can you please advise if this is a bug and any workaround available? regards now you can only enable WAL archive on the Master server,it will not take effect on replication se

Re: [BUGS] BUG #8380: initdb ignore options

On 8/10/2013 4:57 PM, karsten.l...@gmx.ch wrote: The following bug has been logged on the website: Bug reference: 8380 Logged by: Karsten Lenz Email address: karsten.l...@gmx.ch PostgreSQL version: 9.2.4 Operating system: CentOS 6.4 Description: Hello, initdb is ignoring

Re: [BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

Hi, according to the previous thread, can you update the documentation, please: http://www.postgresql.org/docs/current/static/functions-math.html so there is clean what results do you get eg. on "NULL + 1" (and "1 + NULL"), which gives you null and it is different from sum(x), where it gives 1