Hi all,
Encountered a possible bug today. In short, it appears that the rule system is
not deferring the constraint checking as specified. Here is an example.
create table "parent" (
"id" uuid primary key
);
create table "children" (
"id" uuid primary key
default gen_random_uuid()
On Wed, 2022-09-21 at 01:19 +, Louis Tian wrote:
> Encountered a possible bug today. In short, it appears that the rule system
> is not deferring the constraint checking as specified. Here is an example.
> > create table "parent" (
> > "id" uuid primary key
> > );
> >
> > create table "chil
On 9/20/22 18:54, Theodore M Rolle, Jr. wrote:
And Tom’s English is excellent!
As opposed to mine?
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
I'm trying to download the Windows x64 binaries only for PostgreSQL 10.22 in
order to perform a minor upgrade. However, the download
(postgresql-10.22-1-windows-x64-binaries.zip) from my usual go-to place:
(https://www.enterprisedb.com/download-postgresql-binaries) gives me a file
that Windows
Hi Richard,
I ran into this issue as well, the issue is with the length of the paths
for the subdirectories,windows is unable to open them, they can be unzipped
in powershell and 7-zip see
https://www.postgresql.org/message-id/CA+RCjaw=GH-Lyxe5=5-un6sqjo-cqjhtebdomixowqdrvvy...@mail.gmail.com
On
> On 21/09/2022 15:34 CEST Thomas, Richard
> wrote:
>
> I’m trying to download the Windows x64 binaries only for PostgreSQL 10.22 in
> order to perform a minor upgrade. However, the download
> (postgresql-10.22-1-windows-x64-binaries.zip) from my usual go-to place:
> (https://www.enterprisedb
We are troubleshooting an issue where autovacuum is not cleaning up a table.
The application using this database runs with autocommit turned off. We can
see in pg_stat_activity lots of sessions "idle in transaction" even though
those sessions have not executed any DML- they have executed sele
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
> We are troubleshooting an issue where autovacuum is not cleaning up a table.
> The application using this database runs with autocommit turned off.
> We can see in pg_stat_activity lots of sessions “idle in transaction” even
> though those
Laurenz Albe writes:
> I just tried your commands, and it works as you expect on my PostgreSQL v15
> database.
It does fail for me, but I think it's a well-known trap rather than
a bug (or at least, it's not something that anyone wishes to redesign
the rule system to change). The problem is tha
Thanks very much - 7-zip (from https://www.7-zip.org/) was just the job to
unpack the archive where Windows "Extract all" failed.
Richard
> -Original Message-
> From: Erik Wienhold
> Sent: 21 September 2022 14:44
> To: Thomas, Richard ; pgsql-
> gene...@lists.postgresql.org
> Subject: R
On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
>> We are troubleshooting an issue where autovacuum is not cleaning up a table.
>> The application using this database runs with autocommit turned off.
>> We can see in pg_stat_activity lots of sessions “idle in transaction”
>> even though
> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve
> wrote:
>
> On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
>>> We are troubleshooting an issue where autovacuum is not cleaning up a table.
>>> The application using this database runs with autocommit turned off.
>>> We can see in pg_
> On Sep 20, 2022, at 10:03 PM, Tom Lane wrote:
>
> Rob Sargent writes:
>>> then keepalives aren't necessarily the solution anyway. When is
>>> this failure occurring ... is it while trying to establish the
>>> database connection in the first place? Or does it only happen
>>> if you've lef
Few days before one of the user having same issue and they find out it
was some file name issue
Link of email:
https://www.postgresql.org/message-id/CA%2BRCjax7d3djH6YMRb9bnHzmtz6hFhexq9YsYbtYdeOVUwh5%2BQ%40mail.gmail.com
On 9/21/22 20:57, Thomas, Richard wrote:
Thanks very much - 7-zip (from
>> On Sep 21, 2022, at 9:32 AM, Dirschel, Steve
>> wrote:
>>
>> On Wed, 2022-09-21 at 14:11 +, Dirschel, Steve wrote:
We are troubleshooting an issue where autovacuum is not cleaning up a
table.
The application using this database runs with autocommit turned off.
We can
Hi Folks,
Hope you are doing well.
I am in process of configuring pgbackrest, I have followed documents and
configured backup from backup server. I have a setup of Primary and Hot
Standby, when I configured pgbackrest the standby DB got un-synced and now I am
unable to recover it, can anyone h
Hi Ron,
Thank you for the response.
Actually we are in a starting phase and I have done instance level encryption
(CYBERTECH TDE Patch) but if someone take dump and restore it on another server
the data get restored successfully. Also the problem is that the data is in
plain text.
So I want t
17 matches
Mail list logo
