On 28.08.2013 02:28, Valentine Gogichashvili wrote:
Running this sproc on the master:CREATE OR REPLACE FUNCTION public.f() RETURNS integer LANGUAGE plpgsql AS $function$ begin CREATE TEMP TABLE temp_table_to_test_replication AS SELECT s.i as id from generate_series(1, 100) as s(i); DROP TABLE temp_table_to_test_replication; RETURN 1; end; $function$ leads to writing of WAL files. Is it an expected behavior? Is it expected that WAL files are filled when the only thing, that sproc is supposed to do is to create and drop a temporary table. Are these catalog changes?
Yep, creating/dropping temp tables are catalog changes, which are WAL-logged.
- Heikki -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
