Logical decoding document

Started by Tatsuo Ishiialmost 11 years ago3 messages
#1Tatsuo Ishii
ishii@postgresql.org

Hi, I need help.

In "46.6.4.5 Change Callback"

Note: Only changes in user defined tables that are not unlogged
(see UNLOGGED) and not temporary (see TEMPORARY or TEMP) can be
extracted using logical decoding.

I cannot parse the sentence above. Maybe logical decoding does not
decode a table if it is an unloged table or a temporary table?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

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

#2Andres Freund
andres@2ndquadrant.com
In reply to: Tatsuo Ishii (#1)
Re: Logical decoding document

Hi,

On 2015-02-12 22:55:33 +0900, Tatsuo Ishii wrote:

Hi, I need help.

In "46.6.4.5 Change Callback"

Note: Only changes in user defined tables that are not unlogged
(see UNLOGGED) and not temporary (see TEMPORARY or TEMP) can be
extracted using logical decoding.

I cannot parse the sentence above. Maybe logical decoding does not
decode a table if it is an unloged table or a temporary table?

It basically is saying that you won't see changes made to temporary
and/or unlogged tables. But the begin/commit callbacks being called for
the relevant transaction.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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

#3Tatsuo Ishii
ishii@postgresql.org
In reply to: Andres Freund (#2)
Re: Logical decoding document

Hi, I need help.

In "46.6.4.5 Change Callback"

Note: Only changes in user defined tables that are not unlogged
(see UNLOGGED) and not temporary (see TEMPORARY or TEMP) can be
extracted using logical decoding.

I cannot parse the sentence above. Maybe logical decoding does not
decode a table if it is an unloged table or a temporary table?

It basically is saying that you won't see changes made to temporary
and/or unlogged tables. But the begin/commit callbacks being called for
the relevant transaction.

Oh, thanks.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

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