Re: [HACKERS] configure error in HP-UX 11.00

2003-09-02 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: I've put the config.log on: http://www.pgsqldb.org/config.log configure:10847: cc -Ae -c +O2 -D_XOPEN_SOURCE_EXTENDED conftest.c >&5 (Bundled) cc: warning 480: The -A option is available only with the C/ANSI C prod

Re: [HACKERS] configure error in HP-UX 11.00

2003-09-02 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: Check the config.log, it said that the configure script can't find the argument types fo 'accept()'. Could you show us the relevant section of config.log, instead of giving a summary with no details? I'

[HACKERS] configure error in HP-UX 11.00

2003-09-02 Thread Weiping He
When trying to build the CVS source on a HP-UX 11.00 box: HP-UX hpux B.11.00 A 9000/800 We got the configure error: checking types of arguments for accept()... configure: error: could not determine argument types Check the config.log, it said that the configure script can't find the argument t

[HACKERS] cvs version compile error on AIX 4.3.3 using xlc (long)

2003-07-08 Thread Weiping He
Hi, just try to compile newly updated 7.4-devl version on a AIX 4.4.3 box, (just checkouted about 24 hours) but seems got problem: 8<--- make[3]: Entering directory `/home/

Re: [HACKERS] cvs version compile error

2003-07-04 Thread Weiping He
Tom Lane wrote: I think Bruce already fixed this. How old is your CVS pull? regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings upgraded this morning, around 2003-07-04 09:29:00 CST or 2003

[HACKERS] cvs version compile error

2003-07-03 Thread Weiping He
Hi, I'm trying to compile pgsql-7.4devl on Solaris8, but got the error below: 8<- numeric.c: In function `PGTYPESnumeric_cmp': numeric.c:1308: `INT_MAX' undeclared (first use in this fu

Re: [HACKERS] a problem with index and user define type

2003-06-26 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: because the data type (UUID) is a struct, and the uuid_eq() function accept two pointer to the value of struct uuid, if make it IMMUTABLE, postgresql would think it should not try to run the function, but return the cached value i

Re: [HACKERS] a problem with index and user define type

2003-06-24 Thread Weiping He
Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: we found the problem: We used IMMUTABLE modifier in our CREATE FUNCTION definition, though it's correct for our function to return same value if input the same *data*, but our data are passed by reference, not by value, so, so

Re: [HACKERS] a problem with index and user define type

2003-06-23 Thread Weiping He
he problem. So, it seems to make it clear in docs would be a good help to function writers, would commit a documentation patch later if necessary. Thank you! Regards Laser Tom Lane wrote: Weiping He <[EMAIL PROTECTED]> writes: the situation trun worse: now the explain shows the

Re: [HACKERS] a problem with index and user define type

2003-06-22 Thread Weiping He
Tom Lane wrote: "Wang Mike" <[EMAIL PROTECTED]> writes: but this query: select * from test_uuid where id = 'df2b10aa-a31d-11d7-9867-0050babb6029'::uuid dosn't use index QUERY PLAN --- Seq Scan on te