Home > mailing lists

Query to check Progress of Alter Statements PostgreSQL - Mailing list pgsql-admin

From	Raj kumar
Subject	Query to check Progress of Alter Statements PostgreSQL
Date	July 22, 2022 12:11:25
Msg-id	CACxU--Uso3-GbyNXM8aEHL-yFK2MhBBa+p3Fbs24D-MnEAnkpQ@mail.gmail.com Whole thread Raw
List	pgsql-admin

Hi,

Is there a system table to query the progress of Alter Statements like Type Modification and Key Creation in PostgreSQL?

alter table seqentry1 alter column "timestamp" type text USING "timestamp"::text;
ALTER TABLE ONLY public.seqentry2 ADD CONSTRAINT fk_seq2 FOREIGN KEY (seq_id) REFERENCES public.seqshow(seq_id);

Thanks,

Raj Kumar

From: pig lee
Date: 21 July 2022, 10:23:24
Subject: Re: About limitation of using postgresql in china

From: Murthy Nunna
Date: 22 July 2022, 19:19:42
Subject: pg_upgrade failure upgrading from v10.8 to v14.4