and overhead will increase in these 20 minutes.
Igor
> On Oct 5, 2017, at 12:58, Vladimir Nicolici <vla...@gmail.com> wrote:
>
> Some further updates about the issue.
>
> I did a bit of benchmarking on the disk system with iozone, and the during
> the test th
corruptions, that would not be fixed
by a block copy in wal files. I think such corruptions should not happen, and I
saw a few instances where running rsync seemed to work.
I’m curious if somebody is aware about a situation where a corruption is likely
to happen.
Igor
> On Sep 27, 2017, at 12:48, Sc
Sorry, here are the missing details, if it helps:
Postgres 9.6.5 on CentOS 7.2.1511
> On Sep 27, 2017, at 10:56, Igor Polishchuk <ora4...@gmail.com> wrote:
>
> Hello,
> I have a multi-terabyte streaming replica on a bysy database. When I set it
> up, repetative rsyncs take
, which I may not notice for a while on such a huge database.
Any educated opinions on the subject here?
Thank you
Igor Polishchuk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
wal_lsn() - confirmed_flush_lsn) AS lsn_distance
FROM pg_catalog.pg_replication_slots
WHERE slot_name = '';
provides a measure in Logical Replication environment of how far did (or did
not) Subscriber fell behind Publisher, and hence some kind of measure of how
much "extra&qu
Thx.
So it is referring to the command not a "command returning no data". ;-)
On Wed, Sep 20, 2017 at 1:42 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 9/20/2017 10:34 AM, Igor Korot wrote:
>
> >From the documentation:
> https://www.postgresql.org/docs/9.1/st
Hi, John,
On Wed, Sep 20, 2017 at 12:02 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 9/20/2017 6:30 AM, Igor Korot wrote:
>
> Hi, guys,
>
> On Wed, Sep 20, 2017 at 12:20 AM, Allan Harvey
> <allan.har...@libertyonesteel.com> wrote:
>
> How do I properly c
Hi, guys,
On Wed, Sep 20, 2017 at 12:20 AM, Allan Harvey
<allan.har...@libertyonesteel.com> wrote:
>
>>How do I properly check if the record exists from libpq?
>
> Igor,
> I use PQntuples() to check the number of ... tuples, for > 0
I was actually curious - isn'
Hi, ALL,
draft=# SELECT 1 FROM abcattbl WHERE abt_tnam = 'leagues';
?column?
--
(0 rows)
However running it thru the PQexecParam() I am getting "PGRES_TUPLES_OK"
which means that the such record exist.
How do I properly check if the record exists from libpq?
--
Sent via
Hi, ALL,
I am trying to write a program that is using libpq.
For testing purposes I am trying to connect to the remote server, which
is running on my home network on a different machine.
Sometimes during debugging my program crashes or just produces incorrect
results. In this case I have to stop
Hi,
On Thu, Aug 24, 2017 at 7:18 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Igor Korot <ikoro...@gmail.com> writes:
>> So there is no way to retrieve an arbitrary number of rows from the query?
>> That sucks...
>
> The restriction is on the number of rows in o
Michael et al,
On Thu, Aug 24, 2017 at 6:57 PM, Michael Paquier
wrote:
> On Thu, Aug 24, 2017 at 11:56 PM, Tom Lane wrote:
>> I haven't tried it, but it sure looks like it would, if you don't hit
>> OOM first. pqAddTuple() isn't doing anything to
Hi, guys,
On Thu, Aug 24, 2017 at 8:51 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Michael Paquier <michael.paqu...@gmail.com> writes:
>> On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikoro...@gmail.com> wrote:
>>> [quote]
>>> PQntuples
>>>
Hi,
On Tue, Aug 22, 2017 at 6:18 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Melvin et al,
>
> On Tue, Aug 22, 2017 at 12:55 PM, Melvin Davidson <melvin6...@gmail.com>
> wrote:
>
>>
>>
>>
>> *While the information_schema is useful
Hi, Michael,
On Tue, Aug 22, 2017 at 8:32 PM, Michael Paquier
<michael.paqu...@gmail.com> wrote:
> On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot <ikoro...@gmail.com> wrote:
>> [quote]
>> PQntuples
>>
>> Returns the number of rows (tuples) in the query result.
NO ACTION|NONE
1|0|playersinleague|id|id|NO ACTION|NO ACTION|NONE
1|1|playersinleague|playerid|playerid|NO ACTION|NO ACTION|NONE
2|0|leagues|id|id|NO ACTION|NO ACTION|NONE
Can I get something from PostgreSQL?
Thank you.
>
> On Tue, Aug 22, 2017 at 12:42 PM, Igor Korot <ikoro...@gma
Hi, ALL,
[quote]
PQntuples
Returns the number of rows (tuples) in the query result. Because it
returns an integer result, large result sets might overflow the return
value on 32-bit operating systems.
int PQntuples(const PGresult *res);
[/quote]
Is there another way to not to overflow the
le, delete_rule ) );
This is my target.
Thank you.
>
>
> On Tue, Aug 22, 2017 at 12:42 PM, Igor Korot <ikoro...@gmail.com> wrote:
>
>> Hi, David,
>>
>> On Tue, Aug 22, 2017 at 12:06 PM, David G. Johnston
>> <david.g.johns...@gmail.com> wrote:
>>
Hi, David,
On Tue, Aug 22, 2017 at 12:06 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Tue, Aug 22, 2017 at 8:43 AM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> Or this is the bug in 9.1?
>> Since it looks like there are 2 columns with
Or this is the bug in 9.1?
Since it looks like there are 2 columns with the same info in 1 table/view
Thank you.
On Tue, Aug 22, 2017 at 12:08 AM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi, ALL,
> draft=# SELECT * FROM information_schema.key_column_usage WHERE
> table_s
Hi, ALL,
draft=# SELECT * FROM information_schema.key_column_usage WHERE
table_schema = 'public' AND table_name = 'leaguescorehitter';
constraint_catalog | constraint_schema |constraint_name
| table_catalog | table_schema |table_name | column_name |
ordinal_position |
Hi, Daniel,
On Sat, Aug 19, 2017 at 12:51 PM, Daniel Verite <dan...@manitou-mail.org> wrote:
> Igor Korot wrote:
>
>> If I do PQexec() call, the results will be interpreted as binary or text?
>>
>> I'm trying to get an int field from the query and wonder
omano - NotOrAnd.IT
> Information Technologies
> --
> NON QVIETIS MARIBVS NAVTA PERITVS
>
> Il 18 ago 2017 20:45, "Igor Korot" <ikoro...@gmail.com> ha scritto:
>>
>> Hi, Vincenzo,
>>
>> On Fri, Aug 18, 2017 at 1:51 PM, Vincenzo Romano
>> <
t need to
do anything?
I.e. no ntoh() call?
Thank you.
>
>
>
> --
> Vincenzo Romano - NotOrAnd.IT
> Information Technologies
> --
> NON QVIETIS MARIBVS NAVTA PERITVS
>
> Il 18 ago 2017 19:46, "Igor Korot" <ikoro...@gmail.com> ha scritto:
>
Hi,
I looked at the documentation, but couldn't find it.
If I do PQexec() call, the results will be interpreted as binary or text?
I'm trying to get an int field from the query and wonder if I need to do
hton() call or not?
Thank you.
--
Sent via pgsql-general mailing list
Also, I presume that the address in this file is the address of the
machine where the server is located, not the address from where the
connection is initiated.
On Sun, Aug 13, 2017 at 10:53 AM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi,
> OK, I found it under the root account.
ug 13, 2017 at 10:37 AM, Christoph Berg <m...@debian.org> wrote:
> Re: Igor Korot 2017-08-13
> <ca+fnntz8h-2tkrmv4uyn-fkrfu601cws9-us7vwfpr-fka0...@mail.gmail.com>
>> draft=# SHOW hba_file
>> draft-# SHOW hba_file;
>> ERROR: syntax error at or near &q
e it? Or it has to stay for "root" only?
Thank you.
>
> Hope this helps
>
>
>
> On Aug 13, 2017, at 9:00 AM, Igor Korot <ikoro...@gmail.com> wrote:
>
> Hi,
> I have a Mac with OSX 10.8 installed. It has Postgre 9.1.
> According to
> https://www.postgresql
Hi, Christoph,
On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg <m...@debian.org> wrote:
> Re: Igor Korot 2017-08-13
> <CA+FnnTwxiLXD2H_njPS6yf=nhjae8vcwwfdvppzbcuadmxt...@mail.gmail.com>
>> I need to modify the pg_hba.conf file to get access to the DB
>> remotel
Hi,
I have a Mac with OSX 10.8 installed. It has Postgre 9.1.
According to https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html
and
http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/?utm_source=tuicool
I need to modify the pg_hba.conf file to get access to the
Hi, ALL,
Quick question - what is the best way to compile libpq only on Linux?
I just checked and currently my distro (I didn't updated in a long time)
has 9.5 version as current.
Should I grab it, unpack it and do configure and then make inside
libpq directory
manually? Or there is some other
Hi, Dan,
On Sat, Aug 5, 2017 at 8:52 PM, Dan Cooperstock at Software4Nonprofits
wrote:
> No, Carl, when I created the sequence, I didn't put its name in double
> quotes, so therefore its name wasn't being forced to stay upper case. So in
> the nextval() command,
Hi,
Did you try bringing it to SAP?
Thank you.
On Sat, Aug 5, 2017 at 2:39 PM, Dan Cooperstock at Software4Nonprofits
wrote:
> Yes my direct SQL testing used all caps and worked fine.
>
> There is no error message. It's just that PowerBuilder's built-in mechanism
John et al,
On Mon, Jul 31, 2017 at 12:13 AM, Igor Korot <ikoro...@gmail.com> wrote:
> John,
>
> On Sun, Jul 30, 2017 at 5:32 PM, Igor Korot <ikoro...@gmail.com> wrote:
>> Hi, John,
>>
>> On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pie...@hogranch.
Hi, guys,
On Fri, Aug 4, 2017 at 5:01 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Igor Korot <ikoro...@gmail.com> writes:
>> I have a following piece of code:
>
>> [code]
>> PGresult *res = PQexecPrepared();
>> status = PQresultStatue( res );
>> if(
Hi, Michael,
On Fri, Aug 4, 2017 at 3:26 PM, Michael Paquier
<michael.paqu...@gmail.com> wrote:
> On Fri, Aug 4, 2017 at 9:12 PM, Igor Korot <ikoro...@gmail.com> wrote:
>> Am I missing something? How do I fix the crash?
>
> Based on what I can see here, I see no
Hi, ALL,
I have a following piece of code:
[code]
PGresult *res = PQexecPrepared();
status = PQresultStatue( res );
if( status == PGRES_TUPLES_OK )
{
for( int j = 0; j < PQntuples( res ); j++ )
{
char *foo = PQgetValue( res, j, 0 );
char *bar = PQgetValue( res, j, 1 );
Hi, ALL,
Is there a way to do such a check from the libpq?
I'm trying to call a function from 2 different places of the
application and want to
see if I already had the call to PQprepare();
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
John,
On Sun, Jul 30, 2017 at 5:32 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi, John,
>
> On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pie...@hogranch.com> wrote:
>> On 7/30/2017 1:43 PM, Igor Korot wrote:
>>
>> what encodings are default on you
Hi, John,
On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 7/30/2017 1:43 PM, Igor Korot wrote:
>
> what encodings are default on your system ?`\l+` in psql should show the
> encodings.
>
> Is this "backslash + pipe + plus-sign&qu
Hi, John,
On Sun, Jul 30, 2017 at 4:34 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 7/30/2017 1:19 PM, Igor Korot wrote:
>>
>> I am using a database for my project that I created inside SQLite3.
>> This database contains a table called "abc<ALT+225>&q
Hi, ALL,
I am using a database for my project that I created inside SQLite3.
This database contains a table called "abc" (it is "abc" +
symbol with the code 225 -
greek letter "beta or a German symbol for "ss").
All I did was to export that database into the text file and then imported
Hi,
The query below should get foreign keys for a specific table:
draft=# SELECT DISTINCT kcu.ordinal_position AS ordinal,
kcu.position_in_unique_constraint AS position, tc.constraint_name AS
name, tc.constraint_schema AS schema, tc.table_name AS table,
kcu.column_name AS column, ccu.table_name
Hi, John,
On Wed, Jul 26, 2017 at 11:08 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 7/26/2017 7:25 PM, Igor Korot wrote:
>>
>> When I tried to query the database table with the column "char(129)" I
>> get:
>>
>> "My field tex
Hi,
I'm testing my program and got an interesting issue.
I have an OSX 10.8 with iODBC manager and PostgreSQL ODBC driver.
When I tried to query the database table with the column "char(129)" I get:
"My field text"
(the text with the bunch of spaces at the end).
The
Hi, Christoph,
On Sun, Jul 23, 2017 at 5:30 PM, Christoph Moench-Tegeder
<c...@burggraben.net> wrote:
> ## Igor Korot (ikoro...@gmail.com):
>
>> >> Is "IF" operator not supported by PostgreSQL
>> So how do I write this properly?
>
> There is docume
Hi, David,
On Sun, Jul 23, 2017 at 5:07 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Sunday, July 23, 2017, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> Is "IF" operator not supported by PostgreSQL
So how do I write this properly?
Than
Hi, ALL,
draft=# IF NOT EXISTS( SELECT 1 FROM pg_class c, pg_namespace n WHERE
n.oid = c.relnamespace AND c.relname = 'abcattbl_tnam_ownr' AND
n.nspname = 'public' ) THEN CREATE INDEX "abcattbl_tnam_ownr" ON
"abcattbl"("abt_tnam" ASC, "abt_ownr" ASC);
ERROR: syntax error at or near "IF"
LINE 1:
Thx.
The split_part() works perfectly.
On Sat, Jul 22, 2017 at 10:49 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Igor Korot <ikoro...@gmail.com> writes:
>> But it works incorrectly - it should return:
>> 9.5.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 6.3.1 2
Hi, John,
On Sat, Jul 22, 2017 at 8:44 AM, John McKown
<john.archie.mck...@gmail.com> wrote:
> On Fri, Jul 21, 2017 at 10:21 PM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> Hi, guys,
>> Below query does not even run:
>>
>> SELECT version(), substr
Hi, guys,
Below query does not even run:
SELECT version(), substring( version() from position( '\s' in version() ) );
Could you spot the error?
On Fri, Jul 21, 2017 at 12:11 PM, Igor Korot <ikoro...@gmail.com> wrote:
> David et al,
>
> On Fri, Jul 21, 2017 at 12:00 PM, Da
David et al,
On Fri, Jul 21, 2017 at 12:00 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Fri, Jul 21, 2017 at 8:49 AM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> MySQL uses this:
>> https://dev.mysql.com/doc/refman/5.7/en/mysql-get-server-vers
Hi, guys,
On Thu, Jul 20, 2017 at 11:58 PM, Tom Lane wrote:
> John R Pierce writes:
>> On 7/20/2017 8:40 PM, Tom Lane wrote:
>>> Hm, we need to update that text for the new 2-part version numbering
>>> scheme, don't we?
>
>> will 10 return like 100100 if
ALso, I presume there is no special libpg function, right?
Thank you.
On Thu, Jul 20, 2017 at 10:44 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi, David,
>
> On Thu, Jul 20, 2017 at 10:23 PM, David G. Johnston
> <david.g.johns...@gmail.com> wrote:
>> On Thu,
Hi, David,
On Thu, Jul 20, 2017 at 10:23 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Thu, Jul 20, 2017 at 7:13 PM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> Hi, ALL,
>> According to the documentation PostgreSQL 9.6 (latest) support
Hi, guys,
On Thu, Jul 20, 2017 at 10:19 PM, Andreas Kretschmer
<andr...@a-kretschmer.de> wrote:
> On 21 July 2017 04:13:47 GMT+02:00, Igor Korot <ikoro...@gmail.com> wrote:
>>Hi, ALL,
>>According to the documentation PostgreSQL 9.6 (latest) supports
>>
>>
Hi, ALL,
According to the documentation PostgreSQL 9.6 (latest) supports
CREATE INDEX IF NOT EXIST
However, the version 9.4 and below supports only
CREATE INDEX.
Is there a query or a libpg function which can return the version of
the server I'm running?
And in the latter case - is there a
Hi, ALL
On Thu, May 11, 2017 at 6:47 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/11/2017 07:26 AM, Igor Korot wrote:
>>
>> Adrian et al,
>>
>> On Thu, May 11, 2017 at 9:54 AM, Adrian Klaver
>> <adrian.kla...@aklaver.com> wrote:
>
Hi, ALL,
Is it possible to get the table ID (or OID) from information_schema somewhere?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thx, David.
On Mon, Jun 19, 2017 at 12:09 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> Hi, ALL,
>> Is there some magic in order to turn on remote connection to Postg
Hi, ALL,
Is there some magic in order to turn on remote connection to PostgreSQL?
There are some extra steps to turn it on for MS SQL and MySQL, so I figured
it should be the same for Postgre.
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Hi, David,
On Thu, Jun 15, 2017 at 4:46 PM, David G. Johnston
<david.g.johns...@gmail.com> wrote:
> On Thu, Jun 15, 2017 at 1:23 PM, Igor Korot <ikoro...@gmail.com> wrote:
>>
>> And could you clarify on the first part of this?
>> From the quote I poste it s
Hi, Adrian,
On Thu, Jun 15, 2017 at 4:13 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 06/15/2017 12:02 PM, Igor Korot wrote:
>>
>> Hi, again,
>>
>> On Thu, Jun 15, 2017 at 2:59 PM, Igor Korot <ikoro...@gmail.com> wrote:
>>>
>
Hi, again,
On Thu, Jun 15, 2017 at 2:59 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi, ALL,
> I'm looking at the documentation at
> www.postgresql.org/docs/current/static/libpq-connect.html
> section 32.1.2.
>
> The part for "option" reads:
>
> [quote]
Hi, ALL,
I'm looking at the documentation at
www.postgresql.org/docs/current/static/libpq-connect.html
section 32.1.2.
The part for "option" reads:
[quote]
Specifies command-line options to send to the server...
[/quote]
Does this mean that if I'm writing a C/C++ program, I shouldn't care
I wonder, does plpgsql compilation check for existence of the add_job_history
function or is that a runtime check?
At runtime.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Igor Neyman
Sent: Friday, June 02, 2017 9:45 AM
To: PAWAN SHARMA <er.pawanshr0...@gmail.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Oracle database into PostgreSQL using Ora2P
date, LOCALTIMESTAMP,
OLD.job_id, OLD.department_id);
RETURN NEW;
END
$BODY$
LANGUAGE 'plpgsql';
Regards,
Igor Neyman
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Thursday, May 25, 2017 3:13 PM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BE
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 24, 2017 7:06 PM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BE
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 24, 2017 10:00 AM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BET
Hi, ALL,
Does anybody have a ready-to-use solution for libpq binaries for the
Debug build on Windows?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
New thread created.
Thank you.
On Wed, May 24, 2017 at 10:24 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/24/2017 07:18 AM, Igor Korot wrote:
>>
>> On Wed, May 24, 2017 at 10:14 AM, Adrian Klaver
>> <adrian.kla...@aklaver.com> wrote:
>>&
On Wed, May 24, 2017 at 10:14 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/24/2017 06:58 AM, Igor Korot wrote:
>>
>> Adrian,
>>
>> On Wed, May 24, 2017 at 12:09 AM, Adrian Klaver
>> <adrian.kla...@aklaver.com> wrote:
>
&
Adrian,
On Wed, May 24, 2017 at 12:09 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/23/2017 08:03 PM, Igor Korot wrote:
>>
>> Adrian,
>>
>> On Tue, May 23, 2017 at 10:45 PM, Igor Korot <ikoro...@gmail.com> wrote:
>>>
>>>
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 7:42 PM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BE
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 5:48 PM
To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 08:15 AM, Igor Neyman
Adrian,
On Tue, May 23, 2017 at 10:45 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Adrian,
>
> On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver
> <adrian.kla...@aklaver.com> wrote:
>> On 05/23/2017 04:15 PM, Igor Korot wrote:
>>>
>>> Adrian,
>&g
Adrian,
On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/23/2017 04:15 PM, Igor Korot wrote:
>>
>> Adrian,
>>
>> On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver
>> <adrian.kla...@aklaver.com> wrote:
>
Adrian,
On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/23/2017 09:12 AM, Igor Korot wrote:
>>
>> Hi, ALL,
>> Is it possible to have just libpg installer for main OSes: Win, Linux,
>> Mac?
>
>
> AFAIK there
+, Igor Neyman <iney...@perceptron.com> wrote:
>Interestingly, when I add this line to pg_hba.conf:
>
>localall all md5
>
>Postgres is not starting with the following error in the log file:
>
>2017-05-23 11:02:10.397 EDT [4796] LOG: local conn
Hi, ALL,
Is it possible to have just libpg installer for main OSes: Win, Linux, Mac?
And then just the source code of the client library to compile, since
I don't have latest OSX available?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Tue, May 23, 2017 at 10:54 AM, John McKown
<john.archie.mck...@gmail.com> wrote:
> On Tue, May 23, 2017 at 9:39 AM, Albe Laurenz <laurenz.a...@wien.gv.at>
> wrote:
>>
>> Igor Korot wrote:
>>
>> > Can I put libpg sources into my project? Or I will ha
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Tuesday, May 23, 2017 10:04 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:52 AM, Igor
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 10:31 AM
To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 07:05 AM, Igor Neyman
Hi, ALL,
Can I put libpg sources into my project? Or I will have to provide binaries?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 9:45 AM
To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:33 AM, Igor Neyman
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Tuesday, May 23, 2017 9:46 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
Igor Neyman schrieb am
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 9:26 AM
To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:17 AM, Igor Neyman
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, May 22, 2017 7:56 PM
To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/22/2017 12:33 PM, Igor Neyman wrote
oreign tables
to access tables on the "source" server, and see select from these foreign
tables.
Please let me know if my description is not clear.
Regards,
Igor
the behavior.
Why does the query planner choose to ignore the index when the command is
parameterised?
It’s because when optimizer builds execution plan for parametrized queiry, it
doesn’t know what values for t1 and t2 will be provided for WHERE clause.
Regards,
Igor Neyman
Adrian et al,
On Thu, May 11, 2017 at 9:54 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
> On 05/11/2017 06:24 AM, Igor Korot wrote:
>>
>> Melvin et al,
>>
>
>>
>> Now are you saying that the information about the fields in the table can
>>
Melvin et al,
On Thu, May 11, 2017 at 8:50 AM, Melvin Davidson <melvin6...@gmail.com>
wrote:
>
> On Wed, May 10, 2017 at 11:26 PM, Igor Korot <ikoro...@gmail.com> wrote:
>
>> Hi, John et al,
>>
>> On Wed, May 10, 2017 at 11:02 PM, John R Pierce <pie...@h
Hi, John et al,
On Wed, May 10, 2017 at 11:02 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 5/10/2017 7:45 PM, Igor Korot wrote:
>>
>> I found
>> this:https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns,
>> but now I need
>> to conne
Hi, guys,
On Sun, May 7, 2017 at 1:40 PM, Igor Korot <ikoro...@gmail.com> wrote:
> David,
>
> On Sun, May 7, 2017 at 8:57 AM, David Rowley
> <david.row...@2ndquadrant.com> wrote:
>> On 8 May 2017 at 00:42, Igor Korot <ikoro...@gmail.com> wrote:
>>> Bas
David,
On Sun, May 7, 2017 at 8:57 AM, David Rowley
<david.row...@2ndquadrant.com> wrote:
> On 8 May 2017 at 00:42, Igor Korot <ikoro...@gmail.com> wrote:
>> Basically what I'd like to see is the definition of each column and
>> whether this column is
>
Tom et al,
On Sun, May 7, 2017 at 1:09 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Igor Korot <ikoro...@gmail.com> writes:
>> On Sat, May 6, 2017 at 8:22 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>>> I do not see any arrays named "length", nor even
David,
On Sun, May 7, 2017 at 7:57 AM, David Rowley
<david.row...@2ndquadrant.com> wrote:
> On 7 May 2017 at 16:43, Igor Korot <ikoro...@gmail.com> wrote:
>> I'm trying to retrieve an information about the table. Query is below:
>>
>> SELECT
Andreas,
On Sun, May 7, 2017 at 6:02 AM, Andreas Kretschmer
<akretsch...@spamfence.net> wrote:
> Igor Korot <ikoro...@gmail.com> wrote:
>
>> Hi,
>> I'm trying to retrieve an information about the table. Query is below:
>>
>&g
1 - 100 of 503 matches
Mail list logo