[HACKERS] 7.3b5 Supported platforms alpha linux update

2002-11-08 Thread Magnus Naeslund(f)
If it matters, i re-ran the regression tests on psql 7.3b5, and it worked flawlessly, all 89 tests passed. I didn't install, but it passed the last time (b3). System: Redhat Linux 6.2, Alpha EV56, handupgraded to kernel 2.4.19-pre6aa1. Options used: ./configure \ --disable-rpath \ --prefix=/

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > tom, do you have as much confidence in your changes as bruce? if so, why > didn't we just go to RC1, instead of a beta? It's not really "do I think these changes are risky?" --- it's more "do I think we're done yet?" To me, an RC label means we th

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Bruce Momjian
Marc G. Fournier wrote: > On Fri, 8 Nov 2002, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > On Fri, 8 Nov 2002, Bruce Momjian wrote: > > > > > > > The urgency is that we should focus on getting to RC1. The issue is > > > > that we don't have anything to focus on, so why delay? > > > >

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Marc G. Fournier
On Fri, 8 Nov 2002, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Fri, 8 Nov 2002, Bruce Momjian wrote: > > > > > The urgency is that we should focus on getting to RC1. The issue is > > > that we don't have anything to focus on, so why delay? > > > > well, right now, we are waiting for an

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Bruce Momjian
Marc G. Fournier wrote: > On Fri, 8 Nov 2002, Bruce Momjian wrote: > > > The urgency is that we should focus on getting to RC1. The issue is > > that we don't have anything to focus on, so why delay? > > well, right now, we are waiting for an updated 'supported platforms' list > due to having to

Re: [HACKERS] Geometry regression tests (was Re: Float output formatting options)

2002-11-08 Thread Giles Lean
> I'd be interested to hear results of testing CVS tip (now 7.4devel) > on other platforms. Does geometry pass cleanly for you? Yes for NetBSD-1.5.1/i386, where it previously didn't due to processor specific math libraries on this platform. Giles ---(end of broadcast)

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Marc G. Fournier
On Fri, 8 Nov 2002, Bruce Momjian wrote: > The urgency is that we should focus on getting to RC1. The issue is > that we don't have anything to focus on, so why delay? well, right now, we are waiting for an updated 'supported platforms' list due to having to put out beta5 :( -

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Bruce Momjian
Marc G. Fournier wrote: > On Fri, 8 Nov 2002, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > > > Marc G. Fournier wrote: > > > > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > > > > > > > I am loosing tolerance for these last-minut

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Marc G. Fournier
On Fri, 8 Nov 2002, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > Marc G. Fournier wrote: > > > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > > > > > I am loosing tolerance for these last-minute changes. We should not > > > > > > > >

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Robert E. Bruccoleri
Dear Tom, Here's the result of your queries: template1=# set TimeZone TO 'PST8PDT'; SET template1=# select abstime 'May 10, 1947 23:59:12'; abstime 1947-05-10 22:59:12-08 (1 row) template1=# select (abstime 'May 10, 1947 23:59:12')::int4; int4 ---

Re: [HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Tom Lane
"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > There are differences in the regression tests for PostgreSQL > 7.3b2 with handling of times before 1970. I recently sent out a set of > diffs for the changes. I've looked through the datetime.c code, but > it's not obvious to me what the ca

[HACKERS] Problem with 7.3 on Irix with dates before 1970

2002-11-08 Thread Robert E. Bruccoleri
Dear All, There are differences in the regression tests for PostgreSQL 7.3b2 with handling of times before 1970. I recently sent out a set of diffs for the changes. I've looked through the datetime.c code, but it's not obvious to me what the cause of the change is. PostgreSQL 7.2 works fine

Geometry regression tests (was Re: [HACKERS] Float output formatting options)

2002-11-08 Thread Tom Lane
"Pedro M. Ferreira" <[EMAIL PROTECTED]> writes: > [ patch for extra_float_digits ] I've applied this patch along with followup changes to pg_dump (it sets extra_float_digits to 2 to allow accurate dump/reload) and the geometry regression test (it sets extra_float_digits to -3). I find that two ge

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Bruce Momjian
Marc G. Fournier wrote: > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > > > I am loosing tolerance for these last-minute changes. We should not > > > > > > You might be, I'm not ... when we finally release v7.3, it

Re: [HACKERS] RC1 on Friday?

2002-11-08 Thread Marc G. Fournier
On Thu, 7 Nov 2002, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Thu, 7 Nov 2002, Bruce Momjian wrote: > > > > > I am loosing tolerance for these last-minute changes. We should not > > > > You might be, I'm not ... when we finally release v7.3, it will be *as > > solid* as our previous r

[HACKERS] Question about row visibility after locks

2002-11-08 Thread Stephan Szabo
I've been wondering (and probably should look through the code, but figured asking would be faster) if there's any guarantee that I'll see rows inserted by a transaction I'm waiting on in the middle of a query. Basically, if I've got a select that's running using HeapTupleSatisfiesDirty so that I

[HACKERS] Domain Constraints

2002-11-08 Thread Rod Taylor
Any thoughts on how to display the domain constraints in psql? a=# create domain d as integer not null check (value > 4); CREATE DOMAIN a=# create domain f as text check (value > 'bob') check (value < 'zip'); CREATE DOMAIN a=# \dD List of domains Schema | Name | Type | Modifier ---

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Bruce Momjian
Patch applied to 7.3 and CVS, with Tom's correction. --- Larry Rosenman wrote: > Here is diff. Please let me know if you need better wording. > > > > --On Thursday, November 07, 2002 16:50:26 -0600 Larry Rosenman > <[EM

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Bruce Momjian
I will deal with it when I apply. --- Larry Rosenman wrote: > Do y'all want a new diff, or can you deal with it when you do the patch? > > LER > > > --On Friday, November 08, 2002 09:45:44 -0500 Tom Lane <[EMAIL PROTECTED

Re: [HACKERS] Win32 port

2002-11-08 Thread Dave Page
> -Original Message- > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] > Sent: 08 November 2002 16:10 > To: Dave Page > Cc: Steve Howe; Katie Ward; [EMAIL PROTECTED] > Subject: Re: [HACKERS] Win32 port > > I hope I didn't sound too unappreciative of the great > contribution PeerDi

[HACKERS]

2002-11-08 Thread AllannJOS
help [EMAIL PROTECTED] = The Man In The Box - Allann J. O. Silva - uin: 102244786 .~. /V\ / ( ) \ ^^--^^ ___ Yahoo! GeoCities Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e ac

Re: [HACKERS] Win32 port

2002-11-08 Thread Bruce Momjian
Dave Page wrote: > > > > -Original Message- > > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] > > Sent: 08 November 2002 04:54 > > To: Steve Howe > > Cc: Katie Ward; [EMAIL PROTECTED] > > Subject: Re: [HACKERS] Win32 port > > > > > > > > OK, Steve's vote is enough to indicate

Re: [HACKERS] Win32 port

2002-11-08 Thread Katie Ward
I don't know if our code compiles with Mingw. I've never tried it. Right now, all files are built with MS VC++ 6.0 because that's the environment that I'm used to, so it's where I can code/debug the fastest. Katie > -Original Message- > From: [EMAIL PROTECTED] > [mailto:pgsql-hackers-ow

Re: [HACKERS] [GENERAL] [SQL] Problem: Referential Integrity Constraints lost

2002-11-08 Thread Achilleus Mantzios
On Thu, 7 Nov 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > After recreating the missing triggers should i upgrade > > to 7.2.3?? > > Make that "before". > > I frankly suspect pilot error here. Triggers do not simply disappear. > If you did have crash-induced corrupti

Re: [HACKERS] [GENERAL] Database replication... - Mission Critica

2002-11-08 Thread Bill Gribble
On Thu, 2002-11-07 at 19:36, Christopher Kings-Lynne wrote: > Even nastier, what about if the different postgres servers in the cluster > run on different architectures! That way you'd get different floating point > results on each machine... Oh come on! There's no such thing as "perfect" anywh

Re: [HACKERS] PL/Perl and Perl 5.8

2002-11-08 Thread joel w. reed
On 10/18/02, Neil Conway <[EMAIL PROTECTED]> wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > The HAS_CRYPT_R is true because the function is available even without the > > prototype, but the struct is not. A plain bug in Perl's configury > > mechanism. > > Yeah, that's true. The questio

[HACKERS] get the source table.field name from a view's field

2002-11-08 Thread Prime Ho
Hi, Firstly , sorry about my poor english, I'll do my best to explain what I want. Actually, in most cases, We do query via view, in order to improve the query speed, we'll create index in physical table field that is mapped in view's where statement. So, I got an idea to store view statement in a

Re: [HACKERS] Win32 port

2002-11-08 Thread Katie Ward
Hi, all. I just wanted to give you an update on where my company (PeerDirect) is with regards to our native Windows port. We are planning on contributing the code for the native port sometime next month (in December). We would have liked to contribute it earlier, but our work schedules here didn

Re: [HACKERS] [GENERAL] command

2002-11-08 Thread Florian Litot
nobody know if it is possible to have the date in th e same time eache line ? At 11:14 08/11/02, Shridhar Daithankar wrote: On 8 Nov 2002 at 11:03, Florian Litot wrote: > yes it's good but can i have the date with each line? Err.. I don't think so. Sounds like a good addition to me. Any ideas?

[HACKERS] c/sql

2002-11-08 Thread ozsevim
Hello, I know Ansi C language and SQL. I want to embed a sql statement into a c source code. Would you please recommend me some web sites or tutorials regarding this subject. Thank you for your concern, Emrah ---(end of broadcast)--- TIP 4: Don't

Re: [HACKERS] [GENERAL] command

2002-11-08 Thread Neil Conway
"Shridhar Daithankar" <[EMAIL PROTECTED]> writes: > On 8 Nov 2002 at 11:03, Florian Litot wrote: > > yes it's good but can i have the date with each line? > > Err.. I don't think so. Try the log_timestamp GUC option. Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC --

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Larry Rosenman
Do y'all want a new diff, or can you deal with it when you do the patch? LER --On Friday, November 08, 2002 09:45:44 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: +For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare +7.1.2), Includin

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > +For compilers earlier than the one released with OpenUNIX 8.0.0(UnixWare > +7.1.2), Including the 7.1.1b Feature Supplement, you may need to specify -Xb > + in CFLAGS or the CC environment variable. The indication of this is an > +error in compiling t

Re: [HACKERS] Float output formatting options

2002-11-08 Thread Tom Lane
"Pedro M. Frazao F. Ferreira" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Evidently. I have the patch and was planning to apply it myself as soon >> as Pedro does something with the geometry types... > Its done. So it is, dunno what I was thinking. Will work on getting it applied.

Re: [HACKERS] Beta 4

2002-11-08 Thread Michael Furgal
Steve: We know that the readline support is missing from the psql client. It was missing with the cygwin port as well. We made little to no effort to work on the client, our focus was on the server. We have no plans to add the readline support to the client and hope that the hacker community wi

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Larry Rosenman
Here is diff. Please let me know if you need better wording. --On Thursday, November 07, 2002 16:50:26 -0600 Larry Rosenman <[EMAIL PROTECTED]> wrote: OK, I'll try and do up a diff to B5's tonite (probably late, my Daughter's elementary school honors choir has a performance tonite). LER --

Re: [PORTS] [HACKERS] PostgreSQL supported platform report and a

2002-11-08 Thread Olivier PRENANT
Many thanks Larry, Sorry I had omited the -Xb (no secret dance) in my report... On Thu, 7 Nov 2002, Larry Rosenman wrote: > Date: Thu, 07 Nov 2002 15:17:28 -0600 > From: Larry Rosenman <[EMAIL PROTECTED]> > To: Peter Eisentraut <[EMAIL PROTECTED]>, Olivier PRENANT <[EMAIL PROTECTED]> > Cc: Tom L

Re: [HACKERS] Float output formatting options

2002-11-08 Thread Pedro M. Frazao F. Ferreira
HI All, Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: I am confused about this patch. I don't see extra_float_digits defined anywhere. Am I missing a patch ? Probably! :) The definition of extra_float_digits was made in float.c and the diff was sent to the list and Tom befor

Re: [HACKERS] protocol change in 7.4

2002-11-08 Thread snpe
On Friday 08 November 2002 09:29 am, Hannu Krosing wrote: > snpe kirjutas R, 08.11.2002 kell 03:49: > > > PQfsize() is entertaining, but not often what you really want (you > > > really want the width of the widest value in the column after > > > conversion to some string format - it seems reason

Re: [HACKERS] [GENERAL] command

2002-11-08 Thread Shridhar Daithankar
On 8 Nov 2002 at 11:03, Florian Litot wrote: > yes it's good but can i have the date with each line? Err.. I don't think so. Sounds like a good addition to me. Any ideas? Bye Shridhar -- Absentee, n.: A person with an income who has had the forethought to remove himself from the sphere o

Re: [HACKERS] protocol change in 7.4

2002-11-08 Thread Hannu Krosing
snpe kirjutas R, 08.11.2002 kell 03:49: > > PQfsize() is entertaining, but not often what you really want (you really > > want the width of the widest value in the column after conversion to some > > string format - it seems reasonable to let the client applicatin worry > > about that, although m

[HACKERS] Performance on NUMA

2002-11-08 Thread Luis Alberto Amigo Navarro
- Original Message - From: "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> To: "Neil Conway" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 5:02 PM Subject: Re: [HACKERS] a tiny question > A small patch for low performance on NUMA arquitectures could be t

Re: [HACKERS] Win32 port

2002-11-08 Thread Dave Page
> -Original Message- > From: Bruce Momjian [mailto:pgman@;candle.pha.pa.us] > Sent: 08 November 2002 04:54 > To: Steve Howe > Cc: Katie Ward; [EMAIL PROTECTED] > Subject: Re: [HACKERS] Win32 port > > > > OK, Steve's vote is enough to indicate that most want to wait > for PeerDirect'