[SQL] UNIT-tests and SQL

2005-07-01 Thread KÖPFERL Robert
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

[SQL] SQLCloseCursor() or SQLFreeStmt does not free memory allcated to read CLOB field in Oracle.

2005-07-01 Thread Vadivel Subramaniam
Hi, This is query realated to ODBC and CLOB field in Oracle. I feel some of you

[SQL] 'show full processlist' in postgres?

2005-07-01 Thread Erik Wasser
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

Re: [SQL] 'show full processlist' in postgres?

2005-07-01 Thread Jim Buttafuoco
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

Re: [SQL] 'show full processlist' in postgres?

2005-07-01 Thread Erik Wasser
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 |

Re: [SQL] Some help please

2005-07-01 Thread Josh Berkus
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

Re: [SQL] 'show full processlist' in postgres?

2005-07-01 Thread Tom Lane
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

Re: [despammed] Re: [SQL] 'show full processlist' in postgres?

2005-07-01 Thread Andreas Kretschmer
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 |