From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?WmVocmEgR8O8bCDDh2FidWs=?= <zgul.cabuk@gmail.com>
cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [SQL]
 =?UTF-8?Q?Postgresql_=E2=80=9Calter_column_type=E2=80=9D_creates_an_event_?=
 =?UTF-8?Q?which_contains_=E2=80=9Ctemp=5Ftable=5Fxxx=E2=80=9D?=
In-reply-to: 
 <CAJsoEnNqNmgmmZ3PBvtyRF_GhN2ypW3GkxqE9p9soDhc31n53A@mail.gmail.com>
References: 
 <CAJsoEnNqNmgmmZ3PBvtyRF_GhN2ypW3GkxqE9p9soDhc31n53A@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?WmVocmEgR8O8bCDDh2FidWs=?=
 <zgul.cabuk@gmail.com>
	message dated "Tue, 25 Jul 2017 09:18:29 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4791.1500992338.1@sss.pgh.pa.us>
Date: Tue, 25 Jul 2017 10:18:58 -0400
Message-ID: <4792.1500992338@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

=?UTF-8?B?WmVocmEgR8O8bCDDh2FidWs=?= <zgul.cabuk@gmail.com> writes:
>  => ALTER TABLE test ALTER COLUMN x TYPE integer USING
> (trim(x)::integer);ALTER TABLE
> Last command I've executed to alter column data type creates an event like
> this:
> BEGIN 500913table public.pg_temp_1077668: INSERT: x[integer]:14table
> public.pg_temp_1077668: INSERT: x[integer]:42COMMIT 500913
> How could I find "real" table name using this record? Is there any way to
> see real table name in fetched record?

That is the real name --- table rewrites create a table with a temporary
name and the desired new column layout, then fill it with data, then
exchange the data area with the old table, then drop the temp table.

Evidently logical decoding is exposing some of this infrastructure
to you.  I bet it isn't exposing the critical "swap data" step though,
so I wonder how exactly a logical decoding plugin is supposed to make
sense of what it can see here.

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers