Postgresql “alter column type” creates an event which contains “temp_table_xxx”

From: Zehra Gül Çabuk <zgul(dot)cabuk(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Postgresql “alter column type” creates an event which contains “temp_table_xxx”
Date: 2017-07-25 06:18:29
Message-ID: CAJsoEnNqNmgmmZ3PBvtyRF_GhN2ypW3GkxqE9p9soDhc31n53A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

I'm using "logical wal decoding" feature of postgresql. I've executed a
sample for data insert, update, delete operations successfully. Now I'm
trying to change my table schema like:

=> CREATE TABLE test( x varchar );CREATE TABLE=> insert into test(x)
values ('14'), ('42');INSERT 0 2=>
=> 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?

Thanks in advance.

--
Zehra Gül ÇABUK

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2017-07-25 07:04:38 Re: PgFDW connection invalidation by ALTER SERVER/ALTER USER MAPPING
Previous Message Rushabh Lathia 2017-07-25 05:41:09 Re: cache lookup failed error for partition key with custom opclass

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2017-07-25 14:18:58 Re: [SQL] Postgresql “alter column type” creates an event which contains “temp_table_xxx”
Previous Message srilinux 2017-07-22 23:43:43 Re: How to duplicate postgres 9.4 database