[BUGS] PATCH: Uninitialized variable usage in contrib/pg_autovacuum

2003-11-21 Thread Craig Boston
Sorry about the cross-post -- I'm not 100% sure which list this should be sent to. I noticed in the 7.4 release that in contrib/pg_autovacuum, args->logfile is not initialized if a log file is not specified on the command line. This causes an immediate segfault on systems that fill allocated m

Re: [BUGS] PERFORM bug with FOUND?

2003-11-21 Thread Tom Lane
[EMAIL PROTECTED] (David Fetter) writes: > I've written a little hack, here included, which is supposed to find > whether a user is in a group. I'd intended to do a PERFORM instead of > SELECT INTO, but PERFORM appears to set FOUND to true no matter what. What version are you using? It seems to

[BUGS] PERFORM bug with FOUND?

2003-11-21 Thread David Fetter
Kind people, I've written a little hack, here included, which is supposed to find whether a user is in a group. I'd intended to do a PERFORM instead of SELECT INTO, but PERFORM appears to set FOUND to true no matter what. What's going on here? The hack in question... CREATE OR REPLACE FUNCTION

Re: [BUGS] Notes about behaviour of SIMILAR TO operator

2003-11-21 Thread Tom Lane
Adam Buraczewski <[EMAIL PROTECTED]> writes: > ('a' similar to 'a' escape null) is true (should be unknown!) Yeah, you are right; this is because we are overloading a "null" second parameter to mean "the ESCAPE part wasn't present", which in hindsight wasn't such a hot idea. > I think that

Re: [BUGS] Notes about behaviour of SIMILAR TO operator

2003-11-21 Thread Adam Buraczewski
Hallo Tom, I decided to improve similar_escape() function during the weekend. Thank you very much for the excerpt from SQL standard (I think this is much more complete than the text I found in a Working Draft from August 1994). However, there are some more issues I'd like to make clear before fun