Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Bruce Momjian
Jean-Michel POURE wrote: Le Mardi 18 Juin 2002 18:42, Serge Adda a ?crit : I am new to PostgreSQL, but I am interested in the Win32 port. I have studied the architecture of other databases like Oracle. Hello, It seems clear that several teams are working without central point

[HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Thomas Lockhart
I've got patches for the CREATE CAST/DROP CAST feature (just a rearrangement of our existing function declaration syntax). The SQL99 form assumes that an existing function will be used for the cast definition, so I've extended the syntax to allow that and to have an alternate form which has more

Re: [HACKERS] ADTs and embedded sql

2002-06-20 Thread Tom Lane
Tony Griffiths(RA) [EMAIL PROTECTED] writes: a) The client-side programmer has to be responsible for parsing the returned string, which could cause problems if the output format of the ADT is changed, and You seem to be proposing that we instead expose the internal storage format of the

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Bruce Momjian
Jan Wieck wrote: Jean-Michel POURE wrote: [...] As for current PostgreSQL organization, can someone explain me which W32 port will make its way to PostgreSQL main source code? Can someone publish a schedule for replication availability? Who is in charge of explaining newbees that MySQL

First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation: let's make a revolution in)

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Bruce Momjian wrote: Jan Wieck wrote: Jean-Michel POURE wrote: [...] As for current PostgreSQL organization, can someone explain me which W32 port will make its way to PostgreSQL main source code? Can someone publish a schedule for replication availability?

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-20 Thread Marc G. Fournier
On 20 Jun 2002, Hannu Krosing wrote: Nobody is in charge, but everybody is welcome to do it, even without being elected or nominated ;) Still, having a success stories or advocacy section on www.postgresq.org seems like a good idea. Being worked on ... we are actually working on totally

Re: [HACKERS] ADTs and embedded sql

2002-06-20 Thread Lincoln Yeoh
At 01:49 PM 6/20/02 +0100, Tony Griffiths(RA) wrote: a) The client-side programmer has to be responsible for parsing the returned string, which could cause problems if the output format of the ADT is changed, and b) The impedance mismatch is much greater than that of the built-in types. One

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Neil Conway
On Thu, 20 Jun 2002 12:09:35 -0400 (EDT) Bruce Momjian [EMAIL PROTECTED] wrote: Jean-Michel POURE wrote: - Replication: development is slow although a lot of people would be interested in helping. But there is no central organization apart from the hackers-list. Replication development

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Jan Wieck
Marc G. Fournier wrote: On Thu, 20 Jun 2002, Bruce Momjian wrote: This line bothers me. With multiple people working on Win32, I would like us to decide how we would _like_ such a port to be implemented. I think this will assist those working on the project to _know_ that their work

Re: [HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Peter Eisentraut
Thomas Lockhart writes: I've got patches for the CREATE CAST/DROP CAST feature (just a rearrangement of our existing function declaration syntax). The SQL99 form assumes that an existing function will be used for the cast definition, so I've extended the syntax to allow that and to have an

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Lamar Owen
On Thursday 20 June 2002 02:57 pm, Jan Wieck wrote: set of triggers where working, and then Stephan did all the others and I forgot who else helped to do the utility commands and CREATE TABLE syntax and tried to decrypt the SQL definitions? Don Baccus? -- Lamar Owen WGCR Internet Radio 1

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Mike Mascari
Jan Wieck wrote: Marc G. Fournier wrote: ... IMHO, that is actually their problem ... without meaning to sound crass about it, but its not like we haven't discussed it extensively here, and openly ... hell, we've even tried to break down the whole project into smaller components to

[HACKERS] Copyright

2002-06-20 Thread Bruce Momjian
I see in ri_triggers.c: * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Copyright 1999 Jan Wieck Jan, are you holding copyright on this or is it dual, and what does dual mean in this case? -- Bruce Momjian| http://candle.pha.pa.us

Re: [HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Rod Taylor
I'm also looking at the SQL99 INFORMATION_SCHEMA views. Is anyone already defining these? Is someone interested in picking this up? I've got some definitions in a contrib-style directory but have not yet mapped them to PostgreSQL. I have a few of the basics done, but nothing really

Re: [HACKERS] Documentation on page files

2002-06-20 Thread Bruce Momjian
Added to CVS. --- Martijn van Oosterhout wrote: On Sun, Apr 21, 2002 at 03:46:07PM +0900, Curt Sampson wrote: On Sat, 20 Apr 2002, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: 2. If not,

[HACKERS] cvs read lock

2002-06-20 Thread David Ford
$ cvs -z3 up -d -P cvs [server aborted]: read lock failed - giving up Hmm, been this way for a while now, something need budging? :) -d ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Stephan Szabo
On Thu, 20 Jun 2002, Jan Wieck wrote: Marc G. Fournier wrote: On Thu, 20 Jun 2002, Bruce Momjian wrote: This line bothers me. With multiple people working on Win32, I would like us to decide how we would _like_ such a port to be implemented. I think this will assist those

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation:

2002-06-20 Thread Jon Franz
It could be helpful to create a mailing list just for this project, since not all members of pg-hackers will/shall participate, and we would probably flood this list quite a bit trying to figure out what is the best way to implement a win32 port. Just like the pg-replication list, this new list

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation:

2002-06-20 Thread Bruce Momjian
Jon Franz wrote: It could be helpful to create a mailing list just for this project, since not all members of pg-hackers will/shall participate, and we would probably flood this list quite a bit trying to figure out what is the best way to implement a win32 port. Just like the

[HACKERS] Our archive searching stinks

2002-06-20 Thread Bruce Momjian
OK, I have finally decided that our archive searching stinks. I have emails in my mailbox that don't appear in the archives. Our main site, http://archives.postgresql.org/ doesn't archive the 'patches' list. (It isn't listed on the main site, and I can't find postings via searching.) Also, why

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Bruce Momjian wrote: Jon Franz wrote: It could be helpful to create a mailing list just for this project, since not all members of pg-hackers will/shall participate, and we would probably flood this list quite a bit trying to figure out what is the best way to

[HACKERS] Domain coercion

2002-06-20 Thread Rod Taylor
I have a few questions about what would be expected from coercing to a type with constraints (Domains mostly -- but complex object types may run into similar issues if implemented). What I intend to do: In gram.y, remove the application of typename directly to the A_Const in makeTypeCast. Use

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-20 Thread Curt Sampson
On Thu, 20 Jun 2002, Bruce Momjian wrote: MS SQL Server has an interesting way of dealing with this. They have a torn bit in each 512-byte chunk of a page, and this bit is set the same for each chunk. When they are about to write out a page, they first flip all of the torn bits and then

Re: [HACKERS] cvs read lock

2002-06-20 Thread David Ford
anoncvs, the lock cleared in the last hour. It didn't actually do any waiting, it aborted almost immediately. David Bruce Momjian wrote: David Ford wrote: $ cvs -z3 up -d -P cvs [server aborted]: read lock failed - giving up Hmm, been this way for a while now, something need budging?

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Bruce Momjian
Martijn van Oosterhout wrote: Since it's currently all for collecting statistics on tables, why can't it collect another type of statistic, like: - How often the estimator gets it wrong? At the end of an index scan, the executor could compare the number of rows returned against what was

Re: [HACKERS] Copyright

2002-06-20 Thread Bruce Momjian
Jan Wieck wrote: Bruce Momjian wrote: I see in ri_triggers.c: * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Copyright 1999 Jan Wieck Jan, are you holding copyright on this or is it dual, and what does dual mean in this case? Sure do I, do I?

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I hate to do that because it makes people think something special is happening for hash, but it isn't. We could throw an elog(NOTICE) stating that hash is not recommended and btree is faster, or something like that. I think the

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Neil Conway
On Thu, 20 Jun 2002 22:50:04 -0400 (EDT) Bruce Momjian [EMAIL PROTECTED] wrote: I have thought that some type of feedback from the executor back into the optimizer would be a good feature. Not sure how to do it, but your idea makes sense. It certainly could update the table statistics after

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Dann Corbit
Here are some class notes that contain some very good ideas with terrific explanations: http://www.cs.duke.edu/education/courses/fall01/cps216/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-20 Thread Oleg Bartunov
We have documented current GiST interface but in russian. http://www.sai.msu.su/~megera/postgres/gist/doc/gist-inteface-r.shtml We have no time to translate it to english :-) I'd appreciate if somebody could help us in documentation - Oleg On Thu, 20 Jun 2002, Bruce Momjian wrote: Tom