Re: [HACKERS] ARC patent

2005-01-18 Thread Hans-Jürgen Schönig
I think the ARC issue is the same with any other patent ... Recently somebody pointed me to a nice site showing some examples: http://www.base.com/software-patents/examples.html Looking at the list briefly I can find at least five patent problems using any operating system with PostgreSQL. From

[HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread John DeSoi
I'm running 'psql.exe -- version' and I'm getting this dialog: psql.exe - Entry Point Not Found: The procedure entry point SHGetSpecialFolderPathA could not be located in the dynamic link library SHELL32.DLL. I got this for both the version I compiled and psql from the pgInstaller (both

Re: [HACKERS] US Patents vs Non-US software ...

2005-01-18 Thread Andrew Sullivan
On Tue, Jan 18, 2005 at 09:22:58AM +0200, Nicolai Tufar wrote: Greetings, Patents do not transcend international border. They need to be applied for in each country separately. To ease the process of applying for patents in many countries at once Patent Cooperation Treaty (PCT) was

Re: [HACKERS] Is CVS HEAD open for 8.1 commits?

2005-01-18 Thread Marc G. Fournier
On Tue, 18 Jan 2005, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: I'm not convinced Marc got the branching/tagging right; let's wait till the dust settles. I IM'ed him and he said to go ahead. Maybe he said that, but I see no evidence that he's

Re: [HACKERS] Is CVS HEAD open for 8.1 commits?

2005-01-18 Thread Andrew Dunstan
Marc G. Fournier wrote: On Tue, 18 Jan 2005, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: I'm not convinced Marc got the branching/tagging right; let's wait till the dust settles. I IM'ed him and he said to go ahead. Maybe he said that, but

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread John DeSoi
On Jan 18, 2005, at 11:05 AM, Magnus Hagander wrote: Hmm. That would seem to have it. Can you check the version on your SHELL32.DLL? The MSDN docs for the version in question (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ shellc

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread John DeSoi
Hi Magnus, On Jan 18, 2005, at 10:50 AM, Magnus Hagander wrote: I'm running 'psql.exe -- version' and I'm getting this dialog: psql.exe - Entry Point Not Found: The procedure entry point SHGetSpecialFolderPathA could not be located in the dynamic link library SHELL32.DLL. Do you have the IE4

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread Magnus Hagander
I'm running 'psql.exe -- version' and I'm getting this dialog: psql.exe - Entry Point Not Found: The procedure entry point SHGetSpecialFolderPathA could not be located in the dynamic link library SHELL32.DLL. Do you have the IE4 Desktop Update installed? I think so. System

Re: [HACKERS] Is CVS HEAD open for 8.1 commits?

2005-01-18 Thread Marc G. Fournier
On Tue, 18 Jan 2005, Andrew Dunstan wrote: Quite so. Only by direct hacking on the ,v files, AFAIK - i.e. NOT something to be done except in dire emergency. As long as nobody commits to the branch is there any harm done by leaving it there? I presume all the committers know which branch they

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread Magnus Hagander
Hmm. That would seem to have it. Can you check the version on your SHELL32.DLL? The MSDN docs for the version in question (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ shellc c/platform/shell/reference/functions/shgetspecialfolderpath.asp) claims it needs either Win2k

Re: [HACKERS] ARC patent

2005-01-18 Thread jearl
Andrew Dunstan [EMAIL PROTECTED] writes: Simon Riggs wrote: So, it also seems clear that 8.0.x should eventually have a straight upgrade path to a replacement, assuming the patent is granted. We should therefore plan to: 1. improve/replace ARC for 8.1 2. backport any replacement directly onto

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread John DeSoi
Hi Magnus, On Jan 18, 2005, at 1:34 PM, Magnus Hagander wrote: 1) Declare NT4 without IE4 unsupported. This is by far the easiest :P What we'd do later is add a check to the MSI installer to inform the user about this. Seems a bit gross to say that NT4 is supported, but only if you happen to have

[HACKERS] Some things I like to pick from the TODO list ...

2005-01-18 Thread Matthias Schmidt
Hi *, I have some cylcles left and like to pick up something from the TODO list. These are the things I'm interested in: 1) Allow limits on per-db/user connections 2) Allow server log information to be output as INSERT statements 3) Allow GRANT/REVOKE permissions to be applied to all schema

Re: [HACKERS] Some things I like to pick from the TODO list ...

2005-01-18 Thread Alvaro Herrera
On Tue, Jan 18, 2005 at 08:15:10PM +0100, Matthias Schmidt wrote: 1) Allow limits on per-db/user connections Sounds hard to do: what limits? CPU, disk? 2) Allow server log information to be output as INSERT statements Is this really needed? 3) Allow GRANT/REVOKE permissions to be applied

Re: [HACKERS] US Patents vs Non-US software ...

2005-01-18 Thread J. Andrew Rogers
On Tue, 18 Jan 2005 09:22:58 +0200 Many countries do not grant software patents so it is not likely that IBM applied through PCT since a refusal in one country may cause to patent to be refused in all countries. Contrary to popular misconception, virtually all countries grant software patents.

Re: [HACKERS] Some things I like to pick from the TODO list ...

2005-01-18 Thread Tom Lane
Matthias Schmidt [EMAIL PROTECTED] writes: These are the things I'm interested in: 1) Allow limits on per-db/user connections 2) Allow server log information to be output as INSERT statements 3) Allow GRANT/REVOKE permissions to be applied to all schema objects with one 4) Allow PREPARE of

Re: [HACKERS] Some things I like to pick from the TODO list ...

2005-01-18 Thread Stephen Frost
* Matthias Schmidt ([EMAIL PROTECTED]) wrote: 3) Allow GRANT/REVOKE permissions to be applied to all schema objects with one This would be nice. I had to write a perl script to do it here. :) It'd also be nice to be able to specify a set of permissions that will be inheirited by newly created

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Sailesh Krishnamurthy
Jonah == Jonah H Harris [EMAIL PROTECTED] writes: Jonah Replying to the list as a whole: Jonah If this is such a bad idea, why do other database systems Jonah use it? As a businessperson myself, it doesn't seem Jonah logical to me that commercial database companies would

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Jeff Davis
On Tue, 2005-01-18 at 12:45 -0800, Sailesh Krishnamurthy wrote: Jonah == Jonah H Harris [EMAIL PROTECTED] writes: Jonah Replying to the list as a whole: Jonah If this is such a bad idea, why do other database systems Jonah use it? As a businessperson myself, it doesn't seem

Re: [HACKERS] Is CVS HEAD open for 8.1 commits?

2005-01-18 Thread Reinhard Max
On Tue, 18 Jan 2005 at 11:53, Marc G. Fournier wrote: ... if someone knows how to safely remove a branch that has had no commits made to it, please let me know, a little bit of googling brought me to this: http://lists.gnu.org/archive/html/info-cvs/2003-11/msg00166.html --- snip --- How

Re: [HACKERS] Some things I like to pick from the TODO list ...

2005-01-18 Thread Reini Urban
Alvaro Herrera schrieb: On Tue, Jan 18, 2005 at 08:15:10PM +0100, Matthias Schmidt wrote: 1) Allow limits on per-db/user connections Sounds hard to do: what limits? CPU, disk? Note that a typical server limit, the load average, will not be portable. There's no WIN32 solution yet. The CPU load is

Re: [HACKERS] ARC patent

2005-01-18 Thread Neil Conway
On Mon, 2005-01-17 at 15:11 -0500, Andrew Dunstan wrote: There's a very recent paper at http://carmen.cs.uiuc.edu/~zchen9/paper/TPDS-final.ps on an alternative to ARC which claims superior performance ... From a quick glance, this doesn't look applicable. The authors are discussing buffer

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Tom Lane
Jeff Davis [EMAIL PROTECTED] writes: I almost think to not supply an MVCC system would break the I in ACID, would it not? Certainly not; ACID was a recognized goal long before anyone thought of MVCC. You do need much more locking to make it work without MVCC, though --- for instance, a reader

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Sailesh Krishnamurthy
Tom == Tom Lane [EMAIL PROTECTED] writes: Tom People who hang around Postgres too long tend to think that Tom MVCC is the obviously correct way to do things, but much of Tom the rest of the world thinks differently ;-) It works the other way too ... people who come from the locking

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Jeff Davis
Certainly not; ACID was a recognized goal long before anyone thought of MVCC. You do need much more locking to make it work without MVCC, though --- for instance, a reader that is interested in a just-modified row has to block until the writer completes or rolls back. People who hang

Re: [HACKERS] ARC patent

2005-01-18 Thread Neil Conway
On Mon, 2005-01-17 at 18:43 -0500, Tom Lane wrote: I have already suggested to core that we should insist on 8.1 not requiring an initdb, so as to ensure that people will migrate up to it easily from 8.0. So is it firm policy that changes that require a catversion update cannot be made during

Re: [HACKERS] ARC patent

2005-01-18 Thread Alvaro Herrera
On Wed, Jan 19, 2005 at 10:48:00AM +1100, Neil Conway wrote: On Mon, 2005-01-17 at 18:43 -0500, Tom Lane wrote: I have already suggested to core that we should insist on 8.1 not requiring an initdb, so as to ensure that people will migrate up to it easily from 8.0. So is it firm policy

[HACKERS] Viewupdate: Inherit default expressions from columns

2005-01-18 Thread Bernd Helmle
For automatic view update rules we are planning to implement column default value inheritance, so that the view's column definition inherits from their base table columns (and nobody has to use an explicit ALTER TABLE view ALTER col SET DEFAULT ... ). Note that we will do that only for views,

[HACKERS] buildfarm enhancements

2005-01-18 Thread Andrew Dunstan
I have made a new release of buildfarm client code, which has some small bug fixes and enhancements, and also has the substantial changes necessary to allow the client to run on Windows. That client can be obtained from http://pgfoundry.org/frs/?group_id=140 I have also made some modest

Re: [HACKERS] psql 8.0 final not working on NT 4.0sp6

2005-01-18 Thread Mike Mascari
Magnus Hagander wrote: According to this: http://support.microsoft.com/kb/q165695/ Windows Desktop update was included with IE 4, but not with IE 5 or later. Further, if you want to install Windows Desktop Update you have to first remove IE 5 or later. And finally it says that Windows

Re: [HACKERS] ARC patent

2005-01-18 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: On Mon, 2005-01-17 at 18:43 -0500, Tom Lane wrote: I have already suggested to core that we should insist on 8.1 not requiring an initdb, so as to ensure that people will migrate up to it easily from 8.0. So is it firm policy that changes that require a

Re: [HACKERS] Viewupdate: Inherit default expressions from columns

2005-01-18 Thread Tom Lane
Bernd Helmle [EMAIL PROTECTED] writes: For automatic view update rules we are planning to implement column default value inheritance, so that the view's column definition inherits from their base table columns (and nobody has to use an explicit ALTER TABLE view ALTER col SET DEFAULT ... ).

[HACKERS] OS/2 port

2005-01-18 Thread lsunley
I submitted the patches and additional files for the OS/2 port on the patches ML. I might as well claim responsibility for that port and put myself down as the maintainer... Lorne Sunley Winnipeg MB Canada -- --- [EMAIL PROTECTED]

Re: [HACKERS] ARC patent

2005-01-18 Thread Neil Conway
On Tue, 2005-01-18 at 23:26 -0500, Tom Lane wrote: Not yet --- I suggested it but didn't get any yeas or nays. I don't feel this is solely core's decision anyway ... what do the assembled hackers think? I'm not sure it's a great idea. I'm not aware of a recent example of short development

Re: [HACKERS] ARC patent

2005-01-18 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: On Tue, 2005-01-18 at 23:26 -0500, Tom Lane wrote: Not yet --- I suggested it but didn't get any yeas or nays. I don't feel this is solely core's decision anyway ... what do the assembled hackers think? I'm not aware of a recent example of short

Re: [HACKERS] ARC patent

2005-01-18 Thread John Hansen
... not even certain whether an ARC replacement will be needed: we might be able to adapt the existing code to workaround the patent, the patent might not be granted, or IBM might grant us a license to use it. It's also worth emphasizing that this How about contacting IBM to see where