Re: how to check PEM version

Hi Atul, copy from program is your friend ;P https://www.postgresql.org/docs/current/sql-copy.html On 2020-09-10 05:49, Atul Kumar wrote: Hi, I have installed pem in centos 7, now i want to check the version of PEM using sql query. Please let me know, how should i do that. My postgres

Re: PG13 partitioned table logical replication

On 2020-09-10 14:13, Nicolas Sornin wrote: I just made some test of upcoming version of porstgresql, especially the ability to publish partitioned table via root partition. I tried to setup PG13 to PG12 replication with different partitioning schemes. My first attempt was to replicate time

Re: PKEY getting corrupted

Danny, On 2020-Sep-10, Abraham, Danny wrote: > We have seen several times a situation where a PKEY is compromised and > duplicate values are created within a table. Yeah, this is not unheard of. > This has happened so far on PG 928 on Linux and Windows, and also on > PG955 on AIX. You do

Re: PKEY getting corrupted

On 9/10/20 3:43 AM, Abraham, Danny wrote: Hi, We have seen several times a situation where a PKEY is compromised and duplicate values are created within a table. Table definition? The situation is? Postgres log entries from the error? This has happened so far on PG 928 on Linux and

Re: PKEY getting corrupted

> On Sep 10, 2020, at 6:43 AM, Abraham, Danny wrote: > > Hi, > > We have seen several times a situation where a PKEY is compromised and > duplicate values are created within a table. > > This has happened so far on PG 928 on Linux and Windows, and also on PG955 on > AIX. > > We ran

Re: Return value of CREATE TABLE

Thanks , exactly what I was looking for On Thu, 10 Sep 2020 at 13:16, Christoph Moench-Tegeder wrote: > ## Mike Martin (redt...@gmail.com): > > > So basically I would like to be able to know what namespace a temp table > is > > created in, so that I can constrain lookup. > > pg_my_temp_schema()

PG13 partitioned table logical replication

Dear community, I just made some test of upcoming version of porstgresql, especially the ability to publish partitioned table via root partition. I tried to setup PG13 to PG12 replication with different partitioning schemes. My first attempt was to replicate time partitioned table in PG13

Re: Return value of CREATE TABLE

## Mike Martin (redt...@gmail.com): > So basically I would like to be able to know what namespace a temp table is > created in, so that I can constrain lookup. pg_my_temp_schema() returns the OID of the session's temporary schema ("or 0 if none", according to the docs). Regards, Christoph --

Return value of CREATE TABLE

Is this possible? Basically I want to manage temp table status for use in a procedure. The procedure looks at pg_catalog to get information for processing. So basically I would like to be able to know what namespace a temp table is created in, so that I can constrain lookup. example CREATE

PKEY getting corrupted

Hi, We have seen several times a situation where a PKEY is compromised and duplicate values are created within a table. This has happened so far on PG 928 on Linux and Windows, and also on PG955 on AIX. We ran massive test on PG10.4 but it has not recreated the problem. Has anyone faced the

Re: how to check PEM version

On Thu, Sep 10, 2020 at 2:19 PM Atul Kumar wrote: > Hi, > > I have installed pem in centos 7, now i want to check the version of > PEM using sql query. > > Please let me know, how should i do that. PEM is EnterpriseDB proprietary product, please avoid asking questions about that on this list.

how to check PEM version

Hi, I have installed pem in centos 7, now i want to check the version of PEM using sql query. Please let me know, how should i do that. My postgres version is 11.8 Regards, Atul