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
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 |
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 |