[GENERAL] help turning of NOTICE messages
Hi All, I'm developing some scripts to create my schema to be run by other folks and I'd like to have them not spit out those NOTICE messages when you create a table regarding the implicit indexes that are made since it just makes it harder to see when there is a real error. I've tried running psql with the quiet argument, I've set the QUIET variable to true and the VERBOSITY level to terse but the NOTICE messages still appear. I searched the archives and found one post from a developer where he stated that this is a feature that's been asked for and would be available in 7.3 and I have 7.4.5. Other than that I haven't been able to find any documentation or mention of it. Can anyone point me in the right direction? Thanks, Alex ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] supressing NOTICE messages on Windows/cygwin only not working?
Hi, I'm noticing NOTICE messages can't be turned off with my cygwin-based platform. I've had other's confirm it works on linux. Here is my session: $ psql -U postgresql itn Welcome to psql 7.4.5, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit [EMAIL PROTECTED]SET client_min_messages TO error; SET [EMAIL PROTECTED]SHOW client_min_messages; client_min_messages - error (1 row) [EMAIL PROTECTED]CREATE TABLE foobar( itn(# id INTEGER NOT NULL, itn(# PRIMARY KEY (id) itn(# ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index foobar_pkey for table foobar CREATE TABLE [EMAIL PROTECTED]SHOW client_min_messages; client_min_messages - error (1 row) [EMAIL PROTECTED] See anything wrong with what I did? There must be some setting I haven't done. I'm on windows xp pro using the cygwin standard install. TIA ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] supressing NOTICE messages on Windows/cygwin only not working?
Thanks Tom, Embarassingly correct guesses. Thanks for the quick response. On Tue, 07 Sep 2004 11:29:17 -0400, Tom Lane [EMAIL PROTECTED] wrote: Alex Soto [EMAIL PROTECTED] writes: I'm noticing NOTICE messages can't be turned off with my cygwin-based platform. I've had other's confirm it works on linux. The SET will definitely turn off messages that the backend thinks it is delivering to the client. However, it won't turn off logging of those same messages in the postmaster log --- which may just be standard error. Allow me to guess a couple things: 1. You originally launched the postmaster from the same terminal window you are now running psql in, and you didn't do anything to redirect its error log to a file or /dev/null or syslog or whatever. 2. Before you changed client_min_messages you were actually seeing *two* copies of these messages, one sent through psql and one popping up because you are reading the postmaster's stderr. While you could make this go away by changing log_min_messages, a better idea would be to redirect postmaster stderr someplace when you start it. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
