[HACKERS] Operator startegies for an access method

2002-09-07 Thread ljguo_1234
Hello everyone. When I studied system catolog,I can't understand a concept operator strategies for an access method, Who can tell me what it's that and where I could find document on the Web. Thanks for your reponse very much, especially thank Hannu Krosing. Guo longjiang Harbin

Re: [JDBC] [HACKERS] problem with new autocommit config parameter and jdbc

2002-09-07 Thread snpe
On Saturday 07 September 2002 02:55 am, Bruce Momjian wrote: Barry Lind wrote: Haris, You can't use jdbc (and probably most other postgres clients) with autocommit in postgresql.conf turned off. Hackers, How should client interfaces handle this new autocommit feature? Is it

[HACKERS] About connectby()

2002-09-07 Thread Masaru Sugawara
Now I'm testing connectby() in the /contrib/tablefunc in 7.3b1, which would be a useful function for many users. However, I found the fact that if connectby_tree has the following data, connectby() tries to search the end of roots without knowing that the relations are

Re: [JDBC] [HACKERS] problem with new autocommit config parameter and

2002-09-07 Thread Bruce Momjian
snpe wrote: On Saturday 07 September 2002 02:55 am, Bruce Momjian wrote: Barry Lind wrote: Haris, You can't use jdbc (and probably most other postgres clients) with autocommit in postgresql.conf turned off. Hackers, How should client interfaces handle this new

Re: [HACKERS] Inheritance

2002-09-07 Thread Oliver Elphick
On Fri, 2002-09-06 at 19:00, elein wrote: There was a comment earlier that was not really addressed. What can you do with table inheritance that you can not do with a relational implementation? Or what would work *better* as inheritance? (you define better) There is nothing that you

Re: [HACKERS] About connectby()

2002-09-07 Thread Joe Conway
Masaru Sugawara wrote: Now I'm testing connectby() in the /contrib/tablefunc in 7.3b1, which would be a useful function for many users. However, I found the fact that if connectby_tree has the following data, connectby() tries to search the end of roots without knowing that the relations

[HACKERS] Mac OS X 10.2/Darwin 6.0

2002-09-07 Thread Ajay Ayyagari
I'm trying to compile PostgreSQL 7.2.2 under the Mac OS X 10.2/Darwin 6.0 (Jaguar) and having some difficulties. I'm using a clean install so there shouldn't be any customizations hindering the compilation process. I have it stored in /usr/local/pgsql and I configure it as below: ./configure

[HACKERS] bug?

2002-09-07 Thread Joe Conway
I found the following while poking around. RangeVarGetRelid takes a second parameter that is intended to allow it to not fail, returning InvalidOid instead. However it calls LookupExplicitNamespace, which does not honor any such request, and happily generates an error on a bad namespace name:

Re: [HACKERS] Rule updates and PQcmdstatus() issue

2002-09-07 Thread Bruce Momjian
Tom Lane wrote: Steve Howe [EMAIL PROTECTED] writes: BM I suggest you read the TODO detail on the item and make a proposal on BM how it _should_ work and if you can get agreement from everyone, you may BM be able to nag someone into doing a patch. I think it should return the number of

Re: [HACKERS] Rule updates and PQcmdstatus() issue

2002-09-07 Thread Steve Howe
Hello Tom, Saturday, September 7, 2002, 5:42:33 PM, you wrote: TL Steve Howe [EMAIL PROTECTED] writes: BM I suggest you read the TODO detail on the item and make a proposal on BM how it _should_ work and if you can get agreement from everyone, you may BM be able to nag someone into doing a

[HACKERS] Testing for failures in configure.in

2002-09-07 Thread Bruce Momjian
[ Discussion moved to hackers.] I recently added a test for JAVA_HOME to configure.in to issue a more helpful message when Ant can't be run rather than throwing a more generic Ant failure message and expecting people to look in config.log. My question is should we be doing such checks to try

Re: [JDBC] [HACKERS] problem with new autocommit config parameter

2002-09-07 Thread Barry Lind
Yes it is possible, but according to the jdbc spec, a new connection in jdbc is always initialized to autocommit=true. So jdbc needs to ignore whatever the current server setting is and reset to autocommit=true. --Barry snpe wrote: On Saturday 07 September 2002 02:55 am, Bruce Momjian

Re: [HACKERS] SIMILAR TO

2002-09-07 Thread Thomas Lockhart
SIMILAR TO doesn't implement the SQL standard, it's only a wrapper around the POSIX regexp matching, which is wrong. I thought someone wanted to fix that, but if it's not happening it should be removed. Please be specific on what you would consider correct. I'm not recalling any details of

Re: [HACKERS] [GENERAL] Making small bits of code available

2002-09-07 Thread Bruno Wolff III
I am almost done. While working on the regression test I found a significant bug in the original earth distance package, so this really does need to get updated. While I was doing that I switched it to use the haversine formula as that is more accurate for short distances than the formula they

Re: [HACKERS] --with-maxbackends

2002-09-07 Thread Matthew T. O'Connor
On Saturday 07 September 2002 12:52 pm, Bruce Momjian wrote: Peter Eisentraut wrote: Didn't we want to remove that option? I didn't know it was still in there. I see no reason for it. How about --enable-depend, that's not still needed is it? Or is that something other than the new