[GENERAL] Non-capturing expressions

2014-10-25 Thread Thom Brown
Hi all, It must be that I haven't had enough caffeine today, but I can't figure out why the following expression captures the non-capturing part of the text: # SELECT regexp_matches('postgres','(?:g)r'); regexp_matches {gr} (1 row) I'm expecting '{r}' in the output as I

Re: [GENERAL] Emulating flexible regex replace

2014-10-25 Thread Francisco Olarte
Hi: On Fri, Oct 24, 2014 at 6:13 PM, twoflower standa.ku...@gmail.com wrote: It works very vell. However, I am not completely satisfied with i as it's unnecessarily loading larger data set than it absolutely must. Besides, I'd also like to get some experience in DB programming. That's

Re: [GENERAL] Non-capturing expressions

2014-10-25 Thread Thom Brown
On 25 October 2014 11:49, Francisco Olarte fola...@peoplecall.com wrote: Hi Thom: On Sat, Oct 25, 2014 at 11:24 AM, Thom Brown t...@linux.com wrote: It must be that I haven't had enough caffeine today, but I can't figure out why the following expression captures the non-capturing part of

Re: [GENERAL] dblink password required

2014-10-25 Thread Oliver Kohll - Mailing Lists
select * from dblink(‘dbname=database2 username=db_link password=mypassword','select username, email from appuser') as t1(username text, email text);: I think the problem is the above- ^^^ username=db_link should be user=db_link The accepted keywords are here:

Re: [GENERAL] Finding date intersections

2014-10-25 Thread hari . fuchs
John McKown john.archie.mck...@gmail.com writes: ​I've been think about this for a bit. But I'm not getting a real solution. I have an approach, shown below, that I think might be the bare beginnings of an approach, but I'm just not getting any more inspiration. Perhaps it will spark an idea

Re: [GENERAL] Finding date intersections

2014-10-25 Thread Joe Van Dyk
On Sat, Oct 25, 2014 at 5:00 AM, hari.fu...@gmail.com wrote: John McKown john.archie.mck...@gmail.com writes: ​I've been think about this for a bit. But I'm not getting a real solution. I have an approach, shown below, that I think might be the bare beginnings of an approach, but I'm

[GENERAL] pg killed by oom-killer, invalid contrecord length 2190 at A6C/331AAA90 on slaves

2014-10-25 Thread Joe Van Dyk
One of my postgres backends was killed by the oom-killer. Now, one of my streaming replication slaves is reporting invalid contrecord length 2190 at A6C/331AAA90 in the logs and replication has paused. I have other streaming replication slaves that are fine. Is that expected? It's happened twice