| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Logging option |
| Date: | 2002-04-03 19:07:41 |
| Message-ID: | 200204031907.g33J7f212383@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Samuel J. Sutjiono wrote:
> Does anybody know how to prevent this message from being displayed on the screen ? (I just want this message to be logged in the log file). The other question is how do you control the types of error to log ?
>
> NOTICE: Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
> I have rolled back the current transaction and am going to terminate your database system connection and exit.
> Please reconnect to the database system and repeat your query.
>
> I appreciate your help.
>
In 7.3, you will be able to suppress all WARNING messages to the client
with client_min_messages, but in 7.2.X there is no way except modifying
postgres.c. Sorry.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel J. Sutjiono | 2002-04-03 19:25:50 | Re: [SQL] Logging option |
| Previous Message | impala | 2002-04-03 18:58:32 | Increment primary key |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernd von den Brincken | 2002-04-03 19:15:44 | Named column in a Function fails at ORDER BY (PgSQL 7.1) |
| Previous Message | Jan Wieck | 2002-04-03 16:44:59 | Re: Update in trigger |