Add support for data change delta tables

From: PavelTurk <pavelturk2000(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Add support for data change delta tables
Date: 2024-01-13 11:41:09
Message-ID: b85900eb-9e3c-e358-aa8f-5a27b30c17e7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,

Currently PostgreSQL doesn't support data change delta tables. For example, it doesn't support this type of query:

SELECT * FROM NEW TABLE (
    INSERT INTO phone_book
    VALUES ( 'Peter Doe', '555-2323' )
) AS t

PostgreSQL has RETURNING that provides only a subset of this functionality.

So I suggest to add support for data change delta tables. Because this feature is more powerful and it is included
in the SQL Standard.

Best regards, Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-01-13 13:37:03 Re: Documentation to upgrade logical replication cluster
Previous Message Amit Kapila 2024-01-13 11:21:00 Re: Invalidate the subscription worker in cases where a user loses their superuser status