What's your experience concerning unit tests for stored procedures on
postgres?
I'd expect to write wrappers for any *unit - programming language and use
its *unit variant to do the actual testing.
From my feeling SQLunit is kind of too xml-ish and I'm not sure wheter I can
save the output of
Hi,
This is query realated to ODBC and CLOB field in Oracle. I feel some of
you
Hallo pgsql-sql@postgresql.org,
I'm looking for a way to display the active querys of postgres. The
mysql way is a 'show [full] processlist'.
After I've read http://pgsqld.active-venture.com/monitoring-stats.html I
set STATS_COMMAND_STRING, STATS_BLOCK_LEVEL, STATS_ROW_LEVEL and
did you restart postgresql and use the pg_stat_activity view instead (just to
save some typing).
Jim
-- Original Message ---
From: Erik Wasser [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Sent: Fri, 1 Jul 2005 15:58:46 +0200
Subject: [SQL] 'show full processlist' in
On Friday 01 July 2005 18:24, Jim Buttafuoco wrote:
did you restart postgresql and use the pg_stat_activity view instead
(just to save some typing).
No. Is a restart necessary or will a 'reload' do also the trick?
I've done the restart:
postgres=# SELECT * from pg_stat_activity ;
datid |
Nick,
I'm interested in using the connectby() function which I gather from the
lists can be used in a similar way to the Oracle connect by ... PRIOR
functionality. Does anybody know where there's an example of this in use
or better still could somebody post an example.
Examples are in the
Erik Wasser [EMAIL PROTECTED] writes:
But 'current_query' is still always empty... B-(
The pg_stats views lag reality by a certain amount, so checking for your
own query is generally not gonna work. Try starting a long-running
query in another session.
regards, tom lane
am 01.07.2005, um 19:13:36 +0200 mailte Erik Wasser folgendes:
postgres=# SELECT * from pg_stat_activity ;
datid | datname | procpid | usesysid | usename | current_query |
query_start
-+---+-+--+---+---+-
7349453 |