Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements
Date: 2026-07-21 19:41:24
Message-ID: CAN4CZFPDdBEhhWqOPhWircwjij00Gkz2oZeF2h6afcYxcARhgw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

The smallint case still doesn't work:

CREATE TABLE idt (a int GENERATED BY DEFAULT AS IDENTITY);
ALTER SEQUENCE idt_a_seq AS smallint;

and we get:

CREATE TABLE public.idt (a integer GENERATED BY DEFAULT AS IDENTITY
(AS smallint) NOT NULL);

which still can't be executed because of the direct smallint mention.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-07-21 19:53:10 Re: [PATCH] Add pg_get_event_trigger_ddl() function
Previous Message Ivan Kush 2026-07-21 19:41:14 Re: [PATCH] Fix memory leak in pg_config