Re: [ADMIN]

2007-08-09 Thread Markus Wollny
Hi! Is there a NAT firewall or something like it involved anywhere between the two machines? If so, the connection may time out at some point in time, and neither server nor client would be notified that the connection is lost. An "ERROR: could not send data to client: Broken pipe" message indi

Re: [ADMIN] How to convert a string to bytea?

2006-08-31 Thread Markus Wollny
On 8/30/06, Chris Hoover <[EMAIL PROTECTED]> wrote: >I am in need of some help. I need to use the encode function > against a text string in one of my pg/plsql functions. > However, the encode function expects a bytea field to be > passed to it. How do I convert my text string into a bytea?

Re: [ADMIN] Checking what is the current query running

2006-07-25 Thread Markus Wollny
Hi, pg_stat_activity has some limitations however; if you use a lot of dynamically generated complex queries, you might stumble over the 255 character limit of current_query in pg_stat_activity, statement-strings longer than that are just cut off. You can get some more information if you need it,

[ADMIN] postmaster shutdown

2002-03-13 Thread Markus Wollny
This behaviour is starting to get on my nerves... Could somebody give me a hint as to what exactly happened here and how I can avoid it in the future? This is the relevant bit of the Logfile: snip 2002-03-06 16:02:52 FATAL 1: Database "template0" is not currently

[ADMIN] postmaster shutdown - LWLockAcquire?

2002-03-07 Thread Markus Wollny
Hello! This behaviour is starting to get on my nerves... Could somebody give me a hint as to what exactly happened here and how I can avoid it in the future? This is the relevant bit of the Logfile: snip 2002-03-06 16:02:52 FATAL 1: Database "template0" is not c