Skip site navigation (1) Skip section navigation (2)

pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Date: 2004-04-07 05:05:50
Message-ID: 20040407050550.B0810D1BCB2@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	momjian(at)svr1(dot)postgresql(dot)org	04/04/07 02:05:50

Modified files:
	doc/src/sgml   : runtime.sgml 
	src/backend/tcop: postgres.c 
	src/backend/utils/misc: guc.c postgresql.conf.sample 
	src/include/tcop: tcopprot.h 
	src/include/utils: guc.h 

Log message:
	> >>1. change the type of "log_statement" option from boolean to string,
	> >>with allowed values of "all, mod, ddl, none" with default "none".
	
	OK, here is a patch that implements #1.  Here is sample output:
	
	test=> set client_min_messages = 'log';
	SET
	test=> set log_statement = 'mod';
	SET
	test=> select 1;
	?column?
	----------
	1
	(1 row)
	
	test=> update test set x=1;
	LOG:  statement: update test set x=1;
	ERROR:  relation "test" does not exist
	test=> update test set x=1;
	LOG:  statement: update test set x=1;
	ERROR:  relation "test" does not exist
	test=> copy test from '/tmp/x';
	LOG:  statement: copy test from '/tmp/x';
	ERROR:  relation "test" does not exist
	test=> copy test to  '/tmp/x';
	ERROR:  relation "test" does not exist
	test=> prepare xx as select 1;
	PREPARE
	test=> prepare xx as update x set y=1;
	LOG:  statement: prepare xx as update x set y=1;
	ERROR:  relation "x" does not exist
	test=> explain analyze select 1;;
	QUERY PLAN
	------------------------------------------------------------------------------------
	Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.006..0.007 rows=1 loops=1)
	Total runtime: 0.046 ms
	(2 rows)
	
	test=> explain analyze update test set x=1;
	LOG:  statement: explain analyze update test set x=1;
	ERROR:  relation "test" does not exist
	test=> explain update test set x=1;
	ERROR:  relation "test" does not exist
	
	It checks PREPARE and EXECUTE ANALYZE too.  The log_statement values are
	'none', 'mod', 'ddl', and 'all'.  For 'all', it prints before the query
	is parsed, and for ddl/mod, it does it right after parsing using the
	node tag (or command tag for CREATE/ALTER/DROP), so any non-parse errors
	will print after the log line.


pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-04-07 14:21:39
Subject: pgsql-server/src/template darwin
Previous:From: Tom LaneDate: 2004-04-06 18:46:25
Subject: pgsql-server/src/backend/optimizer/path Tag: R ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group