Hello Peter,
That's what I thought. I'll find another way.
Thank you for your time.
Regards,
Nicolas SORNIN
IT Team Lead
This email message as well as all attachments are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
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 versio
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 p
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 reali
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 Windo
> 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 massiv
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()
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 cluste
## 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
--
S
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 TEMP
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 s
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.
P
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
13 matches
Mail list logo
