Re: [GENERAL] PostGreSQL 7.0.3 hangs in SuSE

2001-04-07 Thread Martin Jacobs
ps. Regards Martin -- Dipl-Ing. Martin Jacobs * Windsbach * Germany Registered Linux User #87175, http://counter.li.org/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] postmaster of 7.0.3 listening but pslq cannot connect

2000-12-04 Thread Martin Jacobs
Peter Eisentraut schrieb: > Martin Jacobs writes: > > > Now, postmaster is listening, I can connect with telnet, netstat > > tells that there is a connection, but psql fails to connect to > > any database. > > What did you do and what response did you get? Not

Re: [GENERAL] strange error (32 512)

2000-12-01 Thread Martin Jacobs
is missing, at least a search path and psql isn't found. Try to use an absolute path. Try to run this command as batch job, don't throw it's output away and look the resulting e-mail message. Good Luck! Martin -- Dipl-Ing. Martin Jacobs Registered Linux User #87175, http://counter.li.org/

Re: [GENERAL] Regression tests of plain 7.0.2 fails

2000-10-10 Thread Martin Jacobs
Tom Lane schrieb: > [EMAIL PROTECTED] (Martin Jacobs) writes: > > Ignoring the minor floatingpoint errors, the first annoying > > severe was in parallel group2 > > sequential test create_type ... FAILED > > > ERROR: TypeCreate: function 

Re: [GENERAL] Newbie, Howto access Array-Slots in user defined functions?

2000-10-07 Thread Martin Jacobs
Tom Lane wrote: > > [EMAIL PROTECTED] (Martin Jacobs) writes: > > CREATE FUNCTION lessbyte (_bytea, _bytea) RETURNS bool > > AS > > 'SELECT $1[1] < $2[1];' LANGUAGE 'sql'; > > ERROR: Unable to identify an operator '<

Re: [GENERAL] Newbie, Howto access Array-Slots in user defined functions?

2000-10-06 Thread Martin Jacobs
an underscore to make it an array reference, but how to access a dedicated elment, also called slot? Any ideas? > > > Shouldn't the above be: > SELECT $1[1] < $1[2] ? > > You probably need the field reference in both places. I have never used > arrays so I don&#