Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Michael Paesold
Neil Conway wrote: IMHO, the patent issue is *not* a potential problem for a lot of people, it *is* a problem -- it makes people uncomfortable to be deploying software that they know might cause them legal headaches down the line. It also makes life difficult for people distributing commercial

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Hannu Krosing
Ühel kenal päeval (kolmapäev, 26. jaanuar 2005, 15:38+1100), kirjutas Neil Conway: Bruce Momjian wrote: So if we have to address it we call it 8.0.7 or something. My point is that we don't need to address it until we actually find out the patent is being enforced against someone, and that

Re: [HACKERS] Concurrent free-lock

2005-01-26 Thread Pailloncy Jean-Gerard
This is a very important thread. Many thanks to Jean-Gerard for bringing the community's attention to this. Thanks Simon. I was working during my PhD on some parallel algorithm. The computer was a 32-grid processor in 1995. In this architecture we need to do the lock on the data, with minimum

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Pailloncy Jean-Gerard
I live in Europe, and right now, the patent, if granted, would not have any effect on me. Even if Europe will have patents on software, I doubt that this ARC algorithm will be patentable in Europe. Is it possible to have an abstraction api where we can plug different algorithms. With two

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Hannu Krosing
Ühel kenal päeval (teisipäev, 25. jaanuar 2005, 21:10-0400), kirjutas Marc G. Fournier: On Tue, 25 Jan 2005, Bruce Momjian wrote: So if we have to address it we call it 8.0.7 or something. My point is that we don't need to address it until we actually find out the patent is being enforced

Re: [HACKERS] RQ: Prepared statements used by multiple connections

2005-01-26 Thread Bojidar Mihajlov
It looks it couldn't happen this a way. Did somebody find out an alternative. Is reasonable some idea based on a connection pool ? -Bozhidar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[HACKERS] IBM patent

2005-01-26 Thread Tommi Maekitalo
Hi, I just read about this IBM-patent-issue at www.heise.de. IBM grants this patens to all projects, which follow one of the licenses, which are approved by the open-source-initiative. And the BSD-license is as far as I see approved (I found New BSD license). When releasing commercial

Re: [HACKERS] WAL: O_DIRECT and multipage-writer

2005-01-26 Thread ITAGAKI Takahiro
Tom Lane [EMAIL PROTECTED] writes: What does XLOG_EXTRA_BUFFERS accomplish? It is because the buffer passed to direct-io must be aligned to the same size of filesystem page, typically 4KB. Buffers allocated with ShmemInitStruct are not necessarily aligned, so we need to allocate extra buffers

Re: [HACKERS] how to add a new column in pg_proc table

2005-01-26 Thread noman naeem
Hello Tom, Now I have been able to generate valid bki file and have been able to avoid all the errors thanks to you,but still have not been able to add that column.Now at initdb the database fails to initialize itself.And the error it gives is. duplicate key violates unique constraint

Re: [ODBC] [HACKERS] RQ: Prepared statements used by multiple connections

2005-01-26 Thread Merlin Moncure
... a prepared version that is local to the backend that invokes the function, yes (i.e. it will be planned once per backend). So ISTM this is equivalent functionality to what you can get using PREPARE or the extended query protocol. Are you sure it's only per-backend? I thought I

Re: [HACKERS] bug w/ cursors and savepoints

2005-01-26 Thread Alvaro Herrera
On Wed, Jan 26, 2005 at 03:33:07PM +1100, Neil Conway wrote: Tom Lane wrote: The routine's comments need a bit of work too. Otherwise it seems OK. Neil or anyone else --- see an issue here? The policy will now be: cursor creation is transaction, but cursor state modifications (FETCH) are

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Well, you've suggested that I should try and reduce the API churn caused by the patch. As I said on -patches, I don't really see this as an issue if we just apply the patch to REL8_0_STABLE. If we do that then the patch will go out with essentially no

[HACKERS] Backporting pg_dump to 7.4

2005-01-26 Thread Christopher Kings-Lynne
I think it would be great to backport 8.0's pg_dump utilities with all their fixes and corrections back to 7.4. I don't think it would take much to alter the output to be 7.4 compatible... Chris ---(end of broadcast)--- TIP 5: Have you checked

Re: [HACKERS] Performance of the temporary table creation and use.

2005-01-26 Thread Luiz Gonzaga da Mata
Tom Lane escreveu: Luiz Gonzaga da Mata [EMAIL PROTECTED] writes: Although to have changed they sort_mem/work_mem it for 1 MB, it did not use this area in available memory for the connection to make the creation of the temporary table. Why would you expect it to, and why would you think

Re: [HACKERS] bug w/ cursors and savepoints

2005-01-26 Thread Alvaro Herrera
On Tue, Jan 25, 2005 at 02:06:24PM -0300, Alvaro Herrera wrote: Hackers, At this point, gdb says that the portal is in PORTAL_READY state. The code says to keep it open and reassign it to the parent subxact. I don't remember what the rationale for this was ... I'll review the discussion

[HACKERS] Data statement format used by the .sh scripts

2005-01-26 Thread noman naeem
Hello Every one, Can some one explain me the under mentioned Data statement format including the insert parameterswhich is excessively used in pg_attribute.h ,pg_class.h,pg_proc.h and at many more places. DATA(insert ( 1255 prosrc 26 -1 -1 -1 0 -1 -1 f x i f f f t 0)); Thanks, Nauman

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Marc G. Fournier
On Wed, 26 Jan 2005, Hannu Krosing wrote: Ühel kenal päeval (teisipäev, 25. jaanuar 2005, 21:10-0400), kirjutas Marc G. Fournier: On Tue, 25 Jan 2005, Bruce Momjian wrote: So if we have to address it we call it 8.0.7 or something. My point is that we don't need to address it until we actually

[HACKERS] Deferrable Unique Constraints

2005-01-26 Thread George Essig
I noticed that implementing deferrable unique constraints is on the TODO list. I don't think its been said yet, but currently you can implement a deferrable unique constraint by using a deferrable constraint trigger together with a procedural language like plpgsql. If you need an index on a

[HACKERS] cvs TIP, tsearch2 and Solaris 8 Sparc

2005-01-26 Thread Darcy Buskermolen
Hello, It looks like teodor's latest commits to tseach2 has broken building on SPARC solaris 8. See http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=potorooodt=2005-01-26%2008:30:02 for more details. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759

Re: [HACKERS] cvs TIP, tsearch2 and Solaris 8 Sparc

2005-01-26 Thread Tom Lane
Darcy Buskermolen [EMAIL PROTECTED] writes: It looks like teodor's latest commits to tseach2 has broken building on SPARC solaris 8. HPUX, too. Patch committed. regards, tom lane ---(end of broadcast)--- TIP 3: if

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Greg Stark
George Essig [EMAIL PROTECTED] writes: I noticed that implementing deferrable unique constraints is on the TODO list. I don't think its been said yet, but currently you can implement a deferrable unique constraint by using a deferrable constraint trigger together with a procedural language

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Serguei A. Mokhov
Hello all, With this paten issue on hand, can't we come up with a pluggable API and pluggable cache-replacement modules so that folks who care not for US patents can simply download and load in the PgARC module, and those who can't, just load the NeilLRU, or a BetterThanARCCacheReplacement module

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: Off the top of my head it seems the way to go about doing this would be to simply not insert the records in the index until commit time. This doesn't actually sound so hard, is there any problem with this approach? Yeah: begin; insert into

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Serguei A. Mokhov
Hello all, As I got the next digest of pg hackers, I see that Jean-Gerard Pailloncy has already advocated this idea. In no means I meant to copy :) as I am on the digest mode. However, I think it's a good path to go anyway as two people at least came up with it. Please do not disregard this idea.

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: Off the top of my head it seems the way to go about doing this would be to simply not insert the records in the index until commit time. This doesn't actually sound so hard, is there any problem with this approach?

Re: [HACKERS] bug w/ cursors and savepoints

2005-01-26 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Our conclusion at the time was that cursors created inside failed subtransactions should remain open. See the proposal and followup discussion starting here: http://archives.postgresql.org/pgsql-hackers/2004-07/msg00700.php If we want to keep this

Re: [HACKERS] bug w/ cursors and savepoints

2005-01-26 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: On Wed, 2005-01-26 at 12:02 -0300, Alvaro Herrera wrote: Hmm ... not sure how hard that is. Would it work to record the sub XID of the deleting subtxn on CLOSE, and then consider whether to really do the deletion when the subtxn commits/aborts? It'd

Re: [HACKERS] bug w/ cursors and savepoints

2005-01-26 Thread Neil Conway
On Wed, 2005-01-26 at 12:02 -0300, Alvaro Herrera wrote: and some regression tests for this behavior, but I'm happy to add that myself if no one beats me to it. Please do. Attached is a patch adding regression tests for this change -- I've already applied it to HEAD. -Neil Index:

Re: [HACKERS] Heads up: upcoming releases in all branches back to

2005-01-26 Thread Neil Conway
On Tue, 2005-01-25 at 13:09 -0500, Tom Lane wrote: Current thought is to wrap these on Thursday for release Friday. If you have any last-minute fixes for the back branches, now's the time to get them in. Sorry for the last minute commit, but I realized that I forgot to backpatch the cursor

Re: [HACKERS] Heads up: upcoming releases in all branches back to

2005-01-26 Thread Marc G. Fournier
Not really last minute, since wrap is tomorrow evening :) On Thu, 27 Jan 2005, Neil Conway wrote: On Tue, 2005-01-25 at 13:09 -0500, Tom Lane wrote: Current thought is to wrap these on Thursday for release Friday. If you have any last-minute fixes for the back branches, now's the time to get them

Re: [HACKERS] Patent issues and 8.1

2005-01-26 Thread Tim Allen
Bruce Momjian wrote: pgman wrote: ... What I would like to do is to pledge that we will put out an 8.0.X to address any patent conflict experienced by our users. This would include ARC or anything else. This way we don't focus just on ARC but have a plan for any patent issues that appear, and we

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Neil Conway
On Wed, 2005-01-26 at 15:48 -0500, Greg Stark wrote: Well presumably you would need a non-unique index created for query execution purposes. The unique index would be purely for enforcing the constraint. Yuck. You could perhaps relax the uniqueness of the index during the transaction itself,

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: You could perhaps relax the uniqueness of the index during the transaction itself, and keep around some backend-local indication of which index entries it have been inserted. Then at transaction-commit you'd need to re-check the inserted index entries to

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Alvaro Herrera
On Thu, Jan 27, 2005 at 03:31:29PM +1100, Neil Conway wrote: You could perhaps relax the uniqueness of the index during the transaction itself, and keep around some backend-local indication of which index entries it have been inserted. Then at transaction-commit you'd need to re-check the

Re: [HACKERS] Deferrable Unique Constraints

2005-01-26 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Yeah, what I've been visualizing is a list of tentative duplicates --- that is, you do the immediate unique check same as now, and if it passes (which hopefully is most of the time) then you're in the clear. I don't see how you're in the clear. If session A

[HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema objects with one command

2005-01-26 Thread Matthias Schmidt
Hi Tom + *, as I learned from severall posts this TODO splits into two distinct TODO's TODO1: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command. TODO2: Assign Permissions to schemas wich get automatically inherited by objects created in the schema. my