Обсуждение: 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
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
>> 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