From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Errors & notices in pgAdmin log-files broken |
Date: | 2008-03-28 20:16:28 |
Message-ID: | 47ED521C.20002@falter.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi developers! Hi Dave!
Testing pgAdmin v.1.8.2 (Feb 5 2008), rev: 7050, on WinXP; host: pg 8.2.6 on
Debian Etch
pgAdmin does not log errors or notices, if I chose
[x] Errors only
or
[x] Errors and Notices
in the setting in File->Options->Logging. Actually, nothing is logged at all.
If set it to
[x] Errors, Notices, SQL
or
[x] Debug (not recommended for normal use)
I get two copies (!) of notices, but still not errors. SQL & Debug stuff
seems to work.
The following example should give me 1 SQL statement, 1 notice and 1 error in
the log file. The name for the primary key has been used before.
(Do you need the German part translated? HINWEIS = NOTICE, FEHLER = ERROR.)
CREATE TABLE foo (foo_id integer, CONSTRAINT event_pkey PRIMARY KEY (foo_id));
Message in SQL window:
~~~~~~~~~~~~~~~~~~~~~~
HINWEIS: CREATE TABLE / PRIMARY KEY erstellt implizit einen Index
»event_pkey« für Tabelle »foo«
FEHLER: Relation »event_pkey« existiert bereits
********** Error **********
FEHLER: Relation »event_pkey« existiert bereits
SQL state: 42P07
Log file:
~~~~~~~~~
2008-03-28 20:53:35 QUERY : Thread Query CREATE TABLE foo (foo_id integer,
CONSTRAINT event_pkey PRIMARY KEY (foo_id));
2008-03-28 20:53:35 QUERY : HINWEIS: CREATE TABLE / PRIMARY KEY erstellt
implizit einen Index »event_pkey« für Tabelle »foo«
2008-03-28 20:53:35 QUERY : HINWEIS: CREATE TABLE / PRIMARY KEY erstellt
implizit einen Index »event_pkey« für Tabelle »foo«
Regards
Erwin
P.S.: The SQL window tries to make up for the log file and states the error
message twice, thus restoring balance of things.
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Brandstetter | 2008-03-28 20:21:19 | (Maybe) helpful data surrounding crashes |
Previous Message | svn | 2008-03-27 19:14:13 | SVN Commit by dpage: r7206 - in branches/REL-1_8_0_EDB/pgadmin3: . pgadmin/schema |