473,320 Members | 1,949 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

postgresql@[local][itn]>SET client_min_messages TO error;
SET
postgresql@[local][itn]>SHOW client_min_messages;
client_min_messages
---------------------
error
(1 row)

postgresql@[local][itn]>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
postgresql@[local][itn]>SHOW client_min_messages;
client_min_messages
---------------------
error
(1 row)

postgresql@[local][itn]>

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

Nov 23 '05 #1
2 2847
Alex Soto <ap****@gmail.com> 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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2
Thanks Tom,

Embarassingly correct guesses. Thanks for the quick response.
On Tue, 07 Sep 2004 11:29:17 -0400, Tom Lane <tg*@sss.pgh.pa.us> wrote:
Alex Soto <ap****@gmail.com> 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

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jp Calderone | last post by:
When using PyChecker on a project which uses bsddb, dozens of messages like the following are reported: warning: couldn't find real module for class bsddb._db.DBAccessError (module name:...
3
by: Steve Holden | last post by:
If nobody has a quick answer I'll go to the PIL list, but I'm having problems with PIL JPEG support on Windows, and figured someone on c.l.py might have solved this problem. I built the Cygwin...
2
by: Aki Niimura | last post by:
Hello everyone, I'm encountering a weird problem and couldn't find any Internet postings that are relevant to my problem and it seems coming from the Pmw Balloon widget inside. I have...
1
by: Bill Grigg | last post by:
Gentlemen, I am hoping to be able to use GForge on my windows PC. To that end I have installed: 1. cygwin 2. reinstalled cygwin and selected cygipc, postgreSQL and a few other things 3. PHP...
2
by: Alex Soto | last post by:
Hi All, I'm developing some scripts to create my schema to be run by other developers and I'd like to have them not spit out those NOTICE messages when you create a table regarding the implicit...
4
by: reachsamdurai | last post by:
Hello, Can you please let me know the procedure to reach db2 command prompt from a cygwin window (hence without using Start-> Run -> db2cmd method). I'm planning to write shell scripts which...
2
by: Wade Ward | last post by:
First-time poster here in perl-land: I had a close working relationship with a fellow at the University of Minnesota named Kevin. He ran the whole show with perl. I am trying to do something...
20
by: macca | last post by:
Hi, I just started a new web developer job (my first actually) and the machine they gave me to use is a Mac. Two days in and I'm running a Win XP environment on my Mac at work (using VMWare), ...
6
by: josequinonesii | last post by:
I've searched, I've read, I've tested and re-read numerous post but to no avail yet... Quite simply, the settings I've applied to my httpd.conf, httpd-vhost.conf and my hosts files simply does not...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.