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 |

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 la

Re: [SQL] Some help please

2005-07-01 Thread Nick Stone
That's great - thanks very much Nick -Original Message- From: Josh Berkus [mailto:[EMAIL PROTECTED] Sent: 01 July 2005 18:30 To: Nick Stone Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Some help please Nick, > I'm interested in using the connectby() function which I gather from >

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 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] '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 postgre

[SQL] Some help please

2005-07-01 Thread Nick Stone
Hi, 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. Many thanks Nick

[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 STATS_START_CO

[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 might

[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 som