Re: [HACKERS] updateable cursors visibility

2003-03-25 Thread snpe
Hello Neil, I try example for Oracle jdbc 1.4 driver This is sample and results. I hope that is helps. If you want yet another example, please tell me. regards Haris Peco /** * A simple sample to check the availability of scrollable result sets. * * Please use jdk1.2 or later version

[HACKERS] Bison 1.875 now required.

2003-03-25 Thread Lee Kindness
For those using Linux, the RPMs at: http://services.csl.co.uk/postgresql/ are probably handy. L. Bruce Momjian writes: Sorry, I meant bison 1.875 is now required, not 1.85. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] |

Re: [HACKERS] to_char(interval) --- done?

2003-03-25 Thread Josh Berkus
Karel, If I see this I must agree with Peter that to_char() is something other than interval to interval-as-string convertor. The current code use date/time as complex of date/time information _based_ on calendar practice -- The other words: current to_char(interval) is interval to

Re: [HACKERS] 7.4devel auth failed

2003-03-25 Thread Andreas Pflug
Ok Bruce, I found out what's happening. I'm running a Suse 8.1 2.4.19 standard kernel which has IPV6 enabled by default. When connecting locally over IP (pgaccess), hba is checked against IPV6 patterns in pg_hba.conf. My pgadmin2 machine will connect with an IP4-to-6 mapped address of

Re: [HACKERS] IO scheduler vs PostgreSQL performance measurement

2003-03-25 Thread Nick Piggin
scott.marlowe wrote: On Mon, 17 Mar 2003, Nick Piggin wrote: Dear PostgreSQL hackers, I am developing a disk IO scheduler for Linux and am aiming to have it included in the stable 2.6 release. Due to its design, performance regressions do appear, and are often more specific to the workload in

Re: [HACKERS] Threaded Python vs. PostGreSQL plpython

2003-03-25 Thread Mike Meyer
In [EMAIL PROTECTED], Shridhar Daithankar [EMAIL PROTECTED] typed: On 24 Mar 2003 at 11:45, Mike Meyer wrote: Just to clarify, the current situation is that I have things working, but I also have a libpython.so that isn't threaded. I'm not happy about the latter, and worry about rebuilding an

Re: [HACKERS] 7.4devel auth failed

2003-03-25 Thread Kurt Roeckx
On Tue, Mar 25, 2003 at 12:28:43PM +0100, Andreas Pflug wrote: Ok Bruce, I found out what's happening. I'm running a Suse 8.1 2.4.19 standard kernel which has IPV6 enabled by default. When connecting locally over IP (pgaccess), hba is checked against IPV6 patterns in pg_hba.conf. My

Re: [HACKERS] Autoheader plan

2003-03-25 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: I want to make pg_config.h.in be automatically generated by autoheader so we don't have to edit it by hand, but there is a lot of stuff in pg_config.h.in that isn't directly generated by configure, so it needs to be moved elsewhere. Maybe I'm just a

Re: [HACKERS] 7.4devel auth failed

2003-03-25 Thread Kurt Roeckx
On Wed, Mar 26, 2003 at 12:36:00AM +0100, Andreas Pflug wrote: Kurt, for my opinion, ConvSockAddr6to4 works wrong. The resulting ip address looks good for the eye, but only if printed as an integer which will interpret it little-endian (host byte order). Oops, I didn't see that one.

[HACKERS] Persistent variables between cross-calls in C functions

2003-03-25 Thread Fabio Furia Silva
Dear all: I could not find any way to store a value in a C function between calls inside the same session. For example, the following function doesn't work as expected: // #include postgres.h #include fmgr.h PG_FUNCTION_INFO_V1(next_value);

Re: [HACKERS] [GENERAL] Persistent variables between cross-calls in C functions

2003-03-25 Thread Stephan Szabo
On Tue, 25 Mar 2003, Fabio Furia Silva wrote: For example, the following function doesn't work as expected: // #include postgres.h #include fmgr.h PG_FUNCTION_INFO_V1(next_value); Datum next_value(PG_FUNCTION_ARGS) { static int

Re: [HACKERS] New structers for optimazing R-tree

2003-03-25 Thread Oleg Bartunov
Anton, I'd suggest you to start from contrib/rtree_gist. Hacking main source tree isn't easy task. Oleg On Tue, 25 Mar 2003, Anton V. Kozub wrote: Good day all. My name is Anton Kozub. I'm student 5 course of Saint-Petersburg State University, faculty mathematics and mechanics,