Query history

From: Michal Kozusznik <kozusznik(dot)michal(at)ifortuna(dot)cz>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Query history
Date: 2012-07-25 16:15:17
Message-ID: 50101B95.4070205@ifortuna.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

While trying to use query history, I found 2 issue limiting the power
of this feature:

A)
query history is filled by whole script, not only but queries run. It
fills query history by the same script multiple times even if script is
not changing.
How to reproduce:
1. Use following script
SELECT 1;
SELECT 2;

2. Select first line and execute.
3. Select second line and execute
4. Check query history - the whole script is stored on 2 slots on query
history

There are 2 possible ways of how it should work:
1. store only executed part of script
2. make sure that the same script is not already stored (valid also for
suggestion #1)

B)
Only one query history exists - same for all defined servers. I would
like to see separate history for each server.
I found useless to use queries from db on another one while both
databases may be significantly different

with regards
Michal Kozusznik

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-07-25 20:53:24 Re: Feature - data view
Previous Message Vjacheslav A. 2012-07-25 12:13:44 Data view - when query returns error