Re: [BUGS] IN does not negate, exists does

2004-02-06 Thread Achilleus Mantzios
O kyrios Tom Lane egrapse stis Feb 5, 2004 : > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > Whereas IN seems to not working ok when negated as shown below: > > If the sub-select returns any NULLs then this behavior is per SQL spec. Thanx a lot! > > regards, tom lane

Re: [BUGS] BUG #1073: JDBC "time with time zone"

2004-02-06 Thread Kris Jurka
> Bug reference: 1073 > Logged by: Bob Messenger > Email address: [EMAIL PROTECTED] > Description:JDBC "time with time zone" > > Details: > > create table a(b time with time zone); > > insert into a values ('00:00:00'); > > System.out.println(rs.getTimestamp(1

[BUGS] plperl problem

2004-02-06 Thread Pavel Stehule
Hello When I try add "use" cmd into my code, I get following error: ERROR: creation of function failed: 'require' trapped by operation mask at (eval 2) line 1. Code without use command works fine. work=# select version(); versi

Re: [BUGS] plperl problem

2004-02-06 Thread Hans-Jürgen Schönig
I guess you are using pl/perl and not pl/perlU. Using untrusted modules in trusted functions is not a good idea. I guess you will need pl/perlU. Cheers, Hans Pavel Stehule wrote: Hello When I try add "use" cmd into my code, I get following error: ERROR: creation of function failed: 'requ

[BUGS] BUG #1074: postgresql crashes

2004-02-06 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1074 Logged by: Neeraj K Sharma Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: linux 7.3.4 Description:postgresql crashes Details: I was running a test that initially insert 50