Re: [HACKERS] 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
Re: [HACKERS] 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
[HACKERS] 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? 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