[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] Error messages --- now that we've got it, do you like

2003-07-03 Thread Nigel J. Andrews
Oops, just remembered I was going to look at the new style error codes to answer one of your emails before. Just not had the time. On Thu, 3 Jul 2003, Tom Lane wrote: > First fruits of all that work on error message rejiggering ... > > regression=# \set VERBOSE terse > > regression=# select 1

Re: [HACKERS] 7.4 feature freeze is here

2003-07-03 Thread Philip Yarra
On Fri, 4 Jul 2003 04:03 pm, Josh Berkus wrote: > I don't quite understand this. This doesn't mean that *postgresql* is > threaded, does it? I was just referring to the client interfaces ECPG and libpq. AFAIK the back-end is not threaded (and I'm beginning to understand why not). So my app star

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Christopher Kings-Lynne
> > > > Out of interest - is it completely backwards compatible? > > > > > > unfortunately, no > > > > Then surely fully replacing tsearch will cause badness? > > I see, so are you suggesting separate dir for tsearch v2 ? Well, we use tserach 1 extensively. I want to be able to upgrade to 7.4 and

Re: [HACKERS] Mirro updates

2003-07-03 Thread Josh Berkus
Guys, > On Fri, Jun 13, 2003 at 10:18:06PM +0100, Dave Page wrote: > > Yes, this is expected. Currently the website is not being mirrored due > > to it's dependency on a backend database. We are considering different > > ways of overcoming this problem in a useful way. Bricolage? i.e. generatio

Re: [HACKERS] 7.4 feature freeze is here

2003-07-03 Thread Josh Berkus
Folks, > > You might like to mention that (as far as I can tell) ECPG is now safe > > for pthreads on Linux and FreeBSD. The recursive mutex locks are removed, > > so > > even > > > platforms that implement the earlier version of pthreads ought to work as > > well, once configure supports them (an

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Oleg Bartunov
On Fri, 4 Jul 2003, Christopher Kings-Lynne wrote: > > > > we still have no r/w access to CVS, so I'm asking authoritative > > > > developers to grab archive > > > > > > > > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz > > > > and submit it to CVS for 7.4 beta. >

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Christopher Kings-Lynne
> > > we still have no r/w access to CVS, so I'm asking authoritative > > > developers to grab archive > > > > > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz > > > and submit it to CVS for 7.4 beta. > > > > Out of interest - is it completely backwards compatible?

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Oleg Bartunov
On Fri, 4 Jul 2003, Christopher Kings-Lynne wrote: > > we still have no r/w access to CVS, so I'm asking authoritative > > developers to grab archive > > > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz > > and submit it to CVS for 7.4 beta. > > Out of interest - i

Re: [HACKERS] btree index growth

2003-07-03 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > How "fixed" is the btree index growth issue in 7.4? Does it mean no more > reindexing ever? Or does it mean reindexing once a month instead of once a > week? Try it and tell us ;-). I think it will depend on your usage patterns to some ext

[HACKERS] Error messages --- now that we've got it, do you like it?

2003-07-03 Thread Tom Lane
First fruits of all that work on error message rejiggering ... regression=# \set VERBOSE terse regression=# select 1!! ; ERROR: operator does not exist: integer !! regression=# \set VERBOSE default regression=# select 1!! ; ERROR: operator does not exist: integer !! HINT: No operator matches

Re: [HACKERS] btree index growth

2003-07-03 Thread Josh Berkus
Chris, > How "fixed" is the btree index growth issue in 7.4? Does it mean no more > reindexing ever? Or does it mean reindexing once a month instead of once a > week? The Free Space Map has been extended to cover indexes. So this means that with proper FSM tuning, one may be able to eliminate

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread The Hermit Hacker
On Thu, 3 Jul 2003, Oleg Bartunov wrote: > Marc, we hope to get an access to be able submit patches. I sent back a note to Teodor earlier this evening letting him know that I think I got the password issue fixed with CVS, but asked him to test and get back to me ... ---(

[HACKERS] btree index growth

2003-07-03 Thread Christopher Kings-Lynne
How "fixed" is the btree index growth issue in 7.4? Does it mean no more reindexing ever? Or does it mean reindexing once a month instead of once a week? Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? h

Re: [HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Christopher Kings-Lynne
> we still have no r/w access to CVS, so I'm asking authoritative > developers to grab archive > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz > and submit it to CVS for 7.4 beta. Out of interest - is it completely backwards compatible? Chris --

Re: [HACKERS] 7.4 feature freeze is here

2003-07-03 Thread Christopher Kings-Lynne
> On Thu, Jul 03, 2003 at 10:18:23 +0800, > Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > > > It might be killer than that PHP support for Apache2 requires that all PHP > > modules be thread-safe... > > Is that true if you are using the prefork MPM? Dunno. Chris -

Re: [HACKERS] [pgadmin-support] [GENERAL] pgAdmin III - Call for Translators

2003-07-03 Thread Dave Page
> -Original Message- > From: A. van Roggen [mailto:[EMAIL PROTECTED] > Sent: 03 July 2003 11:33 > To: Dave Page > Cc: [EMAIL PROTECTED]; > [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] [GENERAL] pgAdmin III - Call > fo

Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument

2003-07-03 Thread Kurt Roeckx
On Thu, Jul 03, 2003 at 10:44:31AM +0900, Kenji Sugita wrote: > > From: Kurt Roeckx <[EMAIL PROTECTED]> > To: Kenji Sugita <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Date: Wed, 2 Jul 2003 19:20:11 +0200 > > ;;; What system are you running on, and does it have a getaddrinfo() > ;;; or not? > >

Re: [HACKERS] Are we backwards on the sign of timezones?

2003-07-03 Thread scott.marlowe
The date / time of your message at the top of my email client was: Thu, 03 Jul 2003 13:18:09 -0400 And most of my stuff is -0600 or -0700 and I live in Colorado. Every instance I've seen that shows the correction for me has been a -0600/-0700 depending on daylight savings. So, it looks like t

Re: [HACKERS] Mirro updates

2003-07-03 Thread Dave Page
> -Original Message- > From: Andrew Sullivan [mailto:[EMAIL PROTECTED] > Sent: 03 July 2003 17:24 > To: pgsql-hackers list > Subject: Re: [HACKERS] Mirro updates > > > (Sorry, been _way_ behind on the email reading.) > > On Fri, Jun 13, 2003 at 10:18:06PM +0100, Dave Page wrote: > > Y

[HACKERS] Are we backwards on the sign of timezones?

2003-07-03 Thread Tom Lane
Currently, the extract(timezone_hour ...) and extract(timezone_minute ...) constructs (also the equivalent date_part() calls) return positive values for timezones west of Greenwich, and negative values for timezones east of Greenwich. While the SQL92 spec was quite vague on the subject of the sign

Re: [HACKERS] compile failure in ecpg

2003-07-03 Thread Michael Meskes
On Wed, Jul 02, 2003 at 04:20:09PM -0400, Greg Stark wrote: > bash-2.05b$ flex -V > flex 2.5.31 I have 2.5.4. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM: michaelmeskes, Jabber: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use Postgre

Re: [HACKERS] Compile failure in ecpg/pgtypeslib/numeric.c

2003-07-03 Thread Michael Meskes
On Wed, Jul 02, 2003 at 11:49:25PM +0200, Kurt Roeckx wrote: > It seems someone removed some include files in revision 1.11 from > interfaces/ecpg/pgtypeslib/numeric.c. One of them was limits.h, > which is needed for INT_MAX and LONG_MAX. Hmm, I added postgres_fe.h and removed all includes that

Re: [HACKERS] 7.4 feature freeze is here

2003-07-03 Thread Bruno Wolff III
On Thu, Jul 03, 2003 at 10:18:23 +0800, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > It might be killer than that PHP support for Apache2 requires that all PHP > modules be thread-safe... Is that true if you are using the prefork MPM? ---(end of broadcast)

Re: [HACKERS] Mirro updates

2003-07-03 Thread Andrew Sullivan
(Sorry, been _way_ behind on the email reading.) On Fri, Jun 13, 2003 at 10:18:06PM +0100, Dave Page wrote: > Yes, this is expected. Currently the website is not being mirrored due > to it's dependency on a backend database. We are considering different > ways of overcoming this problem in a usefu

[HACKERS] How to submit Tsearch V2 ?

2003-07-03 Thread Oleg Bartunov
Hi there, we still have no r/w access to CVS, so I'm asking authoritative developers to grab archive http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz and submit it to CVS for 7.4 beta. Please, completely remove old tsearch directory from contrib. Regards,