Re: [GENERAL] Extension coverage

2017-08-27 Thread Michael Paquier
On Sat, Aug 26, 2017 at 6:28 PM, Gabriel Furstenheim Milerud wrote: > Not sure I follow. Do you have an example that I could check? > I have the impression that my problem is that no .gcda files are created. If > I just run the lcov part: > lcov -d . -c -o lcov.info > > I get >Found gcov v

Re: [GENERAL] Retrieving query results

2017-08-27 Thread Michael Paquier
On Sun, Aug 27, 2017 at 12:12 AM, Tom Lane wrote: > Michael Paquier writes: >> On Fri, Aug 25, 2017 at 8:10 AM, Tom Lane wrote: >>> I think the real problem occurs where we realloc the array bigger. > >> Looking at the surroundings, I think that it would be nice to have >> pqAddTuple and PQsetva

[GENERAL] Logging the fact that a log was shipped

2017-08-27 Thread Ron Johnson
Hi, How is this done in v8.4? (I tried adding "date; rsync ..." but pg didn't like that *at all*.) Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] hrs, mins and seconds do not appear with to_char

2017-08-27 Thread Peter Koukoulis
thanks. didn't realise they were different. I discovered the difference when using a MD5 comparison between the 2 databases in a C++ utility. All values were matching apart from dates. Cheers P On Sun, 27 Aug 2017 at 21:35 Tom Lane wrote: > Peter Koukoulis writes: > > I am unsure as to why th

Re: [GENERAL] hrs, mins and seconds do not appear with to_char

2017-08-27 Thread Tom Lane
Peter Koukoulis writes: > I am unsure as to why the hrs, mins and seconds do not appear for a date > column. Uh, because it's a date. > When performing the exact same queries in Oracle, I get the full date > formatted to "mmddhh24miss", but cannot get the same for PostgreSQL, > for example:

Re: [GENERAL] Using the dollar sign as a prefix for named parameter of prepared statement.

2017-08-27 Thread Dmitry Igrishin
2017-08-27 18:32 GMT+03:00 Dmitry Igrishin : > > > 2017-08-27 18:13 GMT+03:00 Tom Lane : > >> Dmitry Igrishin writes: >> > I'm working on finishing beta release of my C++ API for PostgreSQL. The >> > library >> > have simple SQL parser (preprocessor) to support the queries like that: >> >> > SE

[GENERAL] hrs, mins and seconds do not appear with to_char

2017-08-27 Thread Peter Koukoulis
Hi I am unsure as to why the hrs, mins and seconds do not appear for a date column. I am using PostgreSQL 9.6.3 on Linux. When performing the exact same queries in Oracle, I get the full date formatted to "mmddhh24miss", but cannot get the same for PostgreSQL, for example: ft_node=# create ta

Re: [GENERAL] Log shipping in v8.4.7

2017-08-27 Thread Christoph Moench-Tegeder
## Ron Johnson (ron.l.john...@cox.net): > > On today's LANs, total archiving time is dominated by connection > > startup time (how long does it take to transfer 16MB on a 10GbE link? > > See...). > > And if we've only got a WAN link from one DC to another 360 miles away? Well... TCP handshake wi

Re: [GENERAL] Log shipping in v8.4.7

2017-08-27 Thread Ron Johnson
On 08/27/2017 02:23 PM, Christoph Moench-Tegeder wrote: ## Ron Johnson (ron.l.john...@cox.net): Everything I've read says that you should use "rsync -a". Is there any reason why we can't/shouldn't use "rsync -az" so as to reduce transfer time? On today's LANs, total archiving time is dominate

Re: [GENERAL] Log shipping in v8.4.7

2017-08-27 Thread Christoph Moench-Tegeder
## Ron Johnson (ron.l.john...@cox.net): > Everything I've read says that you should use "rsync -a". Is there > any reason why we can't/shouldn't use "rsync -az" so as to reduce > transfer time? On today's LANs, total archiving time is dominated by connection startup time (how long does it take t

[GENERAL] Log shipping in v8.4.7

2017-08-27 Thread Ron Johnson
Hi, (Yes, its old. Nothing I can do about that.) Everything I've read says that you should use "rsync -a". Is there any reason why we can't/shouldn't use "rsync -az" so as to reduce transfer time? Also, does that change require a full restart (difficult with production systems)? Thanks

Re: [GENERAL] Using the dollar sign as a prefix for named parameter of prepared statement.

2017-08-27 Thread Dmitry Igrishin
2017-08-27 18:13 GMT+03:00 Tom Lane : > Dmitry Igrishin writes: > > I'm working on finishing beta release of my C++ API for PostgreSQL. The > > library > > have simple SQL parser (preprocessor) to support the queries like that: > > > SELECT :"column", $tag$constant string$tag$ > > FROM :tab

Re: [GENERAL] Using the dollar sign as a prefix for named parameter of prepared statement.

2017-08-27 Thread Tom Lane
Dmitry Igrishin writes: > I'm working on finishing beta release of my C++ API for PostgreSQL. The > library > have simple SQL parser (preprocessor) to support the queries like that: > SELECT :"column", $tag$constant string$tag$ > FROM :tables > WHERE name LIKE :'name' AND > se

[GENERAL] Using the dollar sign as a prefix for named parameter of prepared statement.

2017-08-27 Thread Dmitry Igrishin
Hi all, I'm working on finishing beta release of my C++ API for PostgreSQL. The library have simple SQL parser (preprocessor) to support the queries like that: SELECT :"column", $tag$constant string$tag$ FROM :tables WHERE name LIKE :'name' AND sex = $1 AND age > $ag