Re: Help needed for the resolution of memory leak

Thanks, I'll take a look. Regards, Sasmit Utkarsh +91-7674022625 On Wed, Jan 17, 2024 at 4:12 AM Merlin Moncure wrote: > On Tue, Jan 16, 2024 at 9:10 AM Sasmit Utkarsh > wrote: > >> Hi Merlin et al. >> >> I have tried to have the above change added in the missing places. Still, >> I see the

Re: WAL file clean up

On Tue, Jan 16, 2024 at 10:03 PM Brad White wrote: > I have the 'archive_cleanup_command' command specified, but I still have > WAL files. > The documentation seems to indicate that it will run automatically, but it > doesn't seem to be running. > > archive_cleanup_command =

Re: postgres sql assistance

Hi Jim, Thank you so much for the kind review. Architect is pressing for a native procedure to data load. I shall Google ans try to find more suitable one than writing one by myself. Thanks again, Arun On Wed, 17 Jan, 2024, 01:58 Jim Nasby, wrote: > On 1/16/24 6:34 AM, arun chirappurath

WAL file clean up

I have the 'archive_cleanup_command' command specified, but I still have WAL files. The documentation seems to indicate that it will run automatically, but it doesn't seem to be running. archive_cleanup_command = 'pg_archivecleanup DISKSTATION\\AccessData\\Prod\\WALfiles %r'

Re: replication not replicating

On Tue, Jan 16, 2024 at 7:33 PM Brad White wrote: > On Tue, Jan 16, 2024 at 6:24 PM Ron Johnson > wrote: > >> On Tue, Jan 16, 2024 at 6:26 PM Brad White wrote: >> >>> On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson >>> wrote: >>> > What database version? >>> v15 >>> >>>

Re: replication not replicating

On Tue, Jan 16, 2024 at 6:24 PM Ron Johnson wrote: > On Tue, Jan 16, 2024 at 6:26 PM Brad White wrote: > >> On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson >> wrote: >> >>> What database version? >>> >> v15 >> >> >>> Streaming or Logical replication? >>> >> IDK >> >>> Using a slot? >>> >> No.

Re: Parameter value in RDS

On 1/16/24 3:20 PM, Bruce Momjian wrote: We can't answer RDS-specific questions here. I suggest you ask the vendor. Okay, it seems someone here_did_ answer the question.  Yeah, but still best that people go to vendors for stuff that's not community. If for no other reason than one of the

Re: Mimic ALIAS in Postgresql?

On 1/16/24 17:39, Jim Nasby wrote: On 1/16/24 4:57 PM, Rob Sargent wrote:     Or perhaps you have to beef the sed up to use word boundaries just     in case. I'm not a Java web developer...  You need to adjust you glasses if that's what you see me as. Reality is that basically all modern

Re: Mimic ALIAS in Postgresql?

On 1/16/24 17:03, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote: On 1/16/24 15:39, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you

Re: Mimic ALIAS in Postgresql?

On 1/16/24 4:57 PM, Rob Sargent wrote: Or perhaps you have to beef the sed up to use word boundaries just in case. I'm not a Java web developer...  You need to adjust you glasses if that's what you see me as. Reality is that basically all modern (as in last 20 years) SQL access is

Re: replication not replicating

On Tue, Jan 16, 2024 at 6:26 PM Brad White wrote: > On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson > wrote: > >> On Tue, Jan 16, 2024 at 4:10 PM Brad White wrote: >> >>> Errors from the primary >>> >>> 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment >>> 0001000200A2

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote: > On 1/16/24 15:39, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > >> On 1/16/24 10:20, Ron Johnson wrote: >> >> Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a >> different name (while also

Re: replication isn't replicating

On Tue, Jan 16, 2024 at 3:53 PM Emanuel Calvo <3man...@gmail.com> wrote: > > El mar, 16 ene 2024 a las 22:47, Brad White () > escribió: > >> Errors from the Primary server >> >> 2024-01-15 00:01:06.166 CST [1428] ERROR: requested WAL segment >> 0001000200A2 has already been removed

Re: replication not replicating

On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson wrote: > On Tue, Jan 16, 2024 at 4:10 PM Brad White wrote: > >> Errors from the primary >> >> 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment >> 0001000200A2 has already been removed >> 2024-01-15 00:00:51.157 CST [2660]

Re: Mimic ALIAS in Postgresql?

On 1/16/24 15:39, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have

Re: Help needed for the resolution of memory leak

On Tue, Jan 16, 2024 at 9:10 AM Sasmit Utkarsh wrote: > Hi Merlin et al. > > I have tried to have the above change added in the missing places. Still, > I see the below leaks reported by the address sanitizer. Please see > the attachments for the leak reported and the function definition

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > On 1/16/24 10:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name). > > We have an application running on DB2/UDB which (for

Re: replication not replicating

On Tue, Jan 16, 2024 at 4:10 PM Brad White wrote: > Errors from the primary > > 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment > 0001000200A2 has already been removed > 2024-01-15 00:00:51.157 CST [2660] STATEMENT: START_REPLICATION > 2/A200 TIMELINE 1 >

Re: Mimic ALIAS in Postgresql?

On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current

Re: Tips on troubleshooting slow DELETE (suspect cascades)

Adrian Klaver writes: > On 1/16/24 09:45, Jim Vanns wrote: >> I have a slow (CPU bound) DELETE statement I'm attempting to debug and I >> suspect that its actually the ON DELETE CASCADE on the foreign key thats >> causing it. 99% of the time, the cause is lack of an index on the foreign key's

Re: Mimic ALIAS in Postgresql?

On Tue, 16 Jan 2024, 17:21 Ron Johnson, wrote: > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name). > > We have an application running on DB2/UDB which (for reasons wholly > unknown to me, and probably also

Re: Moving to Postgresql database

Dominique Devienne writes: > But sure, I take your point, you can emulate statement-level (implicit) > rollback via an explicit SAVEPOINT, and ROLLBACK to the savepoint instead. > But my point remains, that something like what that extension does should > be an option of PostgreSQL itself, not

Re: replication isn't replicating

El mar, 16 ene 2024 a las 22:47, Brad White () escribió: > Errors from the Primary server > > 2024-01-15 00:01:06.166 CST [1428] ERROR: requested WAL segment > 0001000200A2 has already been removed > 2024-01-15 00:01:06.166 CST [1428] STATEMENT: START_REPLICATION > 2/A200

Re: replication isn't replicating

Sorry for the repeat. It looked like it hadn't been sent.  >

replication isn't replicating

Errors from the Primary server 2024-01-15 00:01:06.166 CST [1428] ERROR: requested WAL segment 0001000200A2 has already been removed 2024-01-15 00:01:06.166 CST [1428] STATEMENT: START_REPLICATION 2/A200 TIMELINE 1 2024-01-15 00:01:11.158 CST [3472] ERROR: requested WAL segment

Re: Parameter value in RDS

> On Jan 16, 2024, at 4:19 PM, David G. Johnston > wrote: > > On Tuesday, January 16, 2024, Atul Kumar wrote: > Hi, > > I am new to RDS postgres, I have version 14 running on it with m7g.large > > I found that lots of parameters has DBInstanceClassMemory written, so what > exactly is the

Re: Parameter value in RDS

On Tue, Jan 16, 2024 at 04:19:55PM -0500, Bruce Momjian wrote: > On Wed, Jan 17, 2024 at 02:42:16AM +0530, Atul Kumar wrote: > > Hi, > > > > I am new to RDS postgres, I have version 14 running on it with m7g.large > > > > I found that lots of parameters has DBInstanceClassMemory written, so what

Re: Parameter value in RDS

On Wed, Jan 17, 2024 at 02:42:16AM +0530, Atul Kumar wrote: > Hi, > > I am new to RDS postgres, I have version 14 running on it with m7g.large > > I found that lots of parameters has DBInstanceClassMemory written, so what > exactly is the value of this variable ? > > How should I calculate it?

Re: Parameter value in RDS

On Tuesday, January 16, 2024, Atul Kumar wrote: > Hi, > > I am new to RDS postgres, I have version 14 running on it with m7g.large > > I found that lots of parameters has DBInstanceClassMemory written, so what > exactly is the value of this variable ? > > How should I calculate it? > > IIRC it’s

Parameter value in RDS

Hi, I am new to RDS postgres, I have version 14 running on it with m7g.large I found that lots of parameters has DBInstanceClassMemory written, so what exactly is the value of this variable ? How should I calculate it? Regards.

replication not replicating

Errors from the primary 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment 0001000200A2 has already been removed 2024-01-15 00:00:51.157 CST [2660] STATEMENT: START_REPLICATION 2/A200 TIMELINE 1 2024-01-15 00:00:56.158 CST [492] ERROR: requested WAL segment

Re: Mimic ALIAS in Postgresql?

On 1/16/24 11:20 AM, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the

Re: pg_dump Running Slow

On 1/16/24 12:55 PM, Yongye Serkfem wrote: Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I

Re: postgres sql assistance

On 1/16/24 6:34 AM, arun chirappurath wrote: I am trying to load data from the temp table to the main table and catch the exceptions inside another table. I don't have a specific answer, but do have a few comments: - There are much easier ways to do this kind of data load. Search for

Re: data migration using EXTENSION tds_fdw

On 1/15/24 1:17 PM, Adrian Klaver wrote: I don't use tds_fdw, so the best I can do is point you at information Hopefully someone with practical experience will chime in with more specific information. The information I could find is:

Re: Add support for data change delta tables

On 1/15/24 4:40 AM, Pavel Stehule wrote: PostgreSQL is not a project where somebody says, you will do this, and you will do this, in this and this priority. There are a lot of nice features from standard - SQL standard is big, but a) you have to have funds to pay the developers, b) you have to

Re: Why scan all columns when we select distinct c1?

On 1/14/24 9:46 AM, Tom Lane wrote: Ron Johnson writes: You can't scan just one column of a row-oriented table. Technically you kinda can, depending on your definition of "scan". The real question is why it mentions c2. The planner did that so that the SeqScan step doesn't have to perform

Re: Mimic ALIAS in Postgresql?

On 1/16/24 11:40 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 2:24 PM Adrian Klaver wrote: On 1/16/24 10:11 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: On 1/16/24 09:20, Ron Johnson wrote: > Some RDBMSs have CREATE ALIAS,

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 2:24 PM Adrian Klaver wrote: > > On 1/16/24 10:11 AM, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver > wrote: > >> On 1/16/24 09:20, Ron Johnson wrote: >> > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by >> a >> > different

Re: Mimic ALIAS in Postgresql?

On 1/16/24 10:11 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: On 1/16/24 09:20, Ron Johnson wrote: > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name).

Re: pg_dump Running Slow

On 1/16/24 10:55 AM, Yongye Serkfem wrote: Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

Whoops! Wrong SO link. Here's the correct SO link: https://stackoverflow.com/questions/77808615/how-to-use-logical-decoding-with-pg-recvlogical-to-pass-changes-through-a-non-tr On Tue, Jan 16, 2024 at 1:15 PM David Ventimiglia < davidaventimig...@hasura.io> wrote: > Thanks for the reply, Jim.

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

Thanks for the reply, Jim. No, I'm afraid that's not the missing piece. I knew enough to use jq to transform the JSON output into SQL statements. What I didn't know enough was about jq. No, the missing piece turned out not to have anything to do with PostgreSQL or pg_recvlogical (I guessed

Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

On 1/13/24 3:34 PM, David Ventimiglia wrote: The business problem I'm trying to solve is: "How do I capture logical decoding events with the wal2json output encoder, filter them with jq, and pipe them to psql, using pg_recvlogical?" I think the missing piece here is that you can't simply

pg_dump Running Slow

Hello Engineers, I trust you are all doing well. I need help on how to improve the speed of pg_dump. I took a pg_dump on a 1TB database, which took almost a whole day. I used this command: "pg_dump -U postgres -d dynamic -f /backups/." Also, how do I check on the progression of the process?

Re: What should I expect when creating many logical replication slots?

On 1/11/24 6:17 PM, Antonin Bas wrote: Hi all, I have a use case for which I am considering using Postgres Logical Replication, but I would like to scale up to 100 or even 200 replication slots. I have increased max_wal_senders and max_replication_slots to 100 (also making sure that 

Re: Moving to Postgresql database

On 1/16/24 11:59 AM, Ron Johnson wrote: >      > Hi. One of the biggest pitfall of PostgreSQL, from the app-dev >     perspective, >      > is the fact any failed statement fails the whole transaction, with >      > ROLLBACK as the only recourse. > >     

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 1:09 PM Adrian Klaver wrote: > On 1/16/24 09:59, Ron Johnson wrote: > > > Performance-killing alternatives are not really altternatives. > > Unless it is the only one that solves your problem. > Amputating one head cures one's migraines, but nobody thinks it's a viable

Re: Mimic ALIAS in Postgresql?

On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: > On 1/16/24 09:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > > different name (while also referring to it by the original name). > > > > > > > Maybe updatable views? > > CREATE VIEW

Re: Moving to Postgresql database

On 1/16/24 09:59, Ron Johnson wrote: Performance-killing alternatives are not really altternatives. Unless it is the only one that solves your problem. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Moving to Postgresql database

On 1/16/24 09:23, Dominique Devienne wrote: On Tue, Jan 16, 2024 at 6:10 PM Adrian Klaver > wrote: Technically, it's still a ROLLBACK, so that is indeed the only recourse. Actually ROLLBACK TO: https://www.postgresql.org/docs/current/sql-rollback-to.html

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 12:10 PM Adrian Klaver wrote: > On 1/16/24 09:04, Dominique Devienne wrote: > > On Tue, Jan 16, 2024 at 5:07 PM Adrian Klaver > > wrote: > > > > On 1/16/24 00:06, Dominique Devienne wrote: > > > On Mon, Jan 15, 2024 at 5:17 AM

Re: postgres sql assistance

"*invalid input syntax for type boolean: "15"*" That is the problem. You can't insert 15 into a column of type "boolean". On Tue, Jan 16, 2024 at 7:35 AM arun chirappurath wrote: > Dear all, > > I am an accidental postgres DBA and learning things every day. Apologies > for my questions if not

Re: Tips on troubleshooting slow DELETE (suspect cascades)

On 1/16/24 09:45, Jim Vanns wrote: Hi, I have a slow (CPU bound) DELETE statement I'm attempting to debug and I suspect that its actually the ON DELETE CASCADE on the foreign key thats causing it. I suspect this because the dry-run mode of the same query (a SELECT instead of DELETE) doesn't

Tips on troubleshooting slow DELETE (suspect cascades)

Hi, I have a slow (CPU bound) DELETE statement I'm attempting to debug and I suspect that its actually the ON DELETE CASCADE on the foreign key thats causing it. I suspect this because the dry-run mode of the same query (a SELECT instead of DELETE) doesn't suffer the same fate. The statement is

Re: Mimic ALIAS in Postgresql?

On 1/16/24 09:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). Maybe updatable views? CREATE VIEW mtqry.sometable AS SELECT * FROM mtuser.sometable; Assuming sometable is the

Re: Mimic ALIAS in Postgresql?

On 1/16/24 09:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 6:10 PM Adrian Klaver wrote: > On 1/16/24 09:04, Dominique Devienne wrote: > > On Tue, Jan 16, 2024 at 5:07 PM Adrian Klaver > > wrote: > > > > On 1/16/24 00:06, Dominique Devienne wrote: > > > On Mon, Jan 15, 2024 at 5:17 AM

Mimic ALIAS in Postgresql?

Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current developer) extensively uses this with two

Re: Moving to Postgresql database

On 1/16/24 09:04, Dominique Devienne wrote: On Tue, Jan 16, 2024 at 5:07 PM Adrian Klaver > wrote: On 1/16/24 00:06, Dominique Devienne wrote: > On Mon, Jan 15, 2024 at 5:17 AM veem v mailto:veema0...@gmail.com> >

Re: Postgres Database Service Interruption

On 1/16/24 09:29, Bablu Kumar Nayak wrote: Dear PostgreSQL Team, I am writing to inform you that our PostgreSQL database service is currently down. We are experiencing an unexpected interruption, and we are seeking your expertise to help us resolve this issue promptly. We would greatly

Re: Postgres Database Service Interruption

On 1/16/24 08:29, Bablu Kumar Nayak wrote: Dear PostgreSQL Team, I am writing to inform you that our PostgreSQL database service is currently down. We are experiencing an unexpected interruption, and we are seeking your expertise to help us resolve this issue promptly. We would greatly

Re: Moving to Postgresql database

On Tue, Jan 16, 2024 at 5:07 PM Adrian Klaver wrote: > On 1/16/24 00:06, Dominique Devienne wrote: > > On Mon, Jan 15, 2024 at 5:17 AM veem v > > wrote: > > Is any key design/architectural changes should the app development > > team [...], should really aware

Postgres Database Service Interruption

Dear PostgreSQL Team, I am writing to inform you that our PostgreSQL database service is currently down. We are experiencing an unexpected interruption, and we are seeking your expertise to help us resolve this issue promptly. We would greatly appreciate your immediate attention to this

Re: Moving to Postgresql database

On 1/16/24 00:06, Dominique Devienne wrote: On Mon, Jan 15, 2024 at 5:17 AM veem v > wrote: Is any key design/architectural changes should the app development team [...], should really aware about Hi. One of the biggest pitfall of PostgreSQL, from the

Re: Nested-Internal Functions

On Tue, 2024-01-16 at 13:15 +0100, Rossana Ocampos wrote: > I have a query about creating nested functions in PostgreSQL. There are no "nested functions" in PostgreSQL. You'd need to rewrite that to use a proper stand-alone function. Yours, Laurenz Albe

Re: postgres sql assistance

On 1/16/24 06:00, Raul Giucich wrote: Hi Arun, can you share the sql used for this insert. Visually it seems some character are affecting the data. Best regards, Raul Raul, the OP attached the sq.

Re: Nested-Internal Functions

On Tuesday, January 16, 2024, Rossana Ocampos wrote: > *Hello ,* > > *I have a query about creating nested functions in PostgreSQL.* > > *I am currently using PostgreSQL 15 and I am trying to create a nested > function with the following structure:* > > *CREATE OR REPLACE FUNCTION

Re: postgres sql assistance

Hi Arun, can you share the sql used for this insert. Visually it seems some character are affecting the data. Best regards, Raul El mar, 16 ene 2024 a la(s) 9:35 a.m., arun chirappurath ( arunsnm...@gmail.com) escribió: > Dear all, > > I am an accidental postgres DBA and learning things every

Aw: Nested-Internal Functions

> I am currently using PostgreSQL 15 and I am trying to create a nested > function with the following structure: ...   > However, I get an error What *is* the error ? Karsten

Nested-Internal Functions

Hello , I have a query about creating nested functions in PostgreSQL. I am currently using PostgreSQL 15 and I am trying to create a nested function with the following structure: CREATE OR REPLACE FUNCTION external_function () RETURNS void AS $$ DECLARE external_variable; --

postgres sql assistance

Dear all, I am an accidental postgres DBA and learning things every day. Apologies for my questions if not properly drafted. I am trying to load data from the temp table to the main table and catch the exceptions inside another table. temp table is cast with the main table data type and trying

/usr/local/sisis-pap/pgsql-15.1/bin/postmaster SIGSEGV in podman container on MacOS

Hello, I've built a podman container on MacOS which includes - a SuSE amd64 OS from registry.suse.com/bci/bci-base:15.4 - enough installed commands: vim openssh-server tar gzip which awk libgnutls30 glibc-locale strace telnet openssh-clients lsof gdb - installed our application packes,

RE: data migration using EXTENSION tds_fdw

Hello, 1)TURKISH_CI_AS at sql server database 2)Encoding : UTF8 Collate: en_US.UTF-8 at Postgresql Thank u for fast response Best Regards Eyup Liste Senior Database Administrator ___ TurkNet Iletisim M: +905452120762 E:

Re: Software Bill of Materials (SBOM)

thank you Julian for your answer. SCANOSS is very good, but it is probably not suitable for searching external libraries that POSTGRESQL uses. Therefore, I again ask you to tell me if there is a ready-made SBOM file for project POSTGRESQL, or a tool that can create it based on the source code C

Re: Moving to Postgresql database

On Mon, Jan 15, 2024 at 5:17 AM veem v wrote: > Is any key design/architectural changes should the app development team > [...], should really aware about > Hi. One of the biggest pitfall of PostgreSQL, from the app-dev perspective, is the fact any failed statement fails the whole transaction,