Re: [HACKERS] Developers page is down

2004-09-04 Thread Shahbaz Javeed
I've always considered a table definition to be an unordered hash so the concept of putting something in the "middle of a table" from that view doesn't seem to have a point. Just my $0.02 Shahbaz Javeed On Sat, 04 Sep 2004 21:44:24 +0200, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > Christopher

Re: [HACKERS] Adding columns in the middle of tables

2004-09-04 Thread Christopher Kings-Lynne
> Given the 8.0 ALTER TABLE feature of being able to rewrite the whole > table, one could now think about doing it without decoupling logical > and physical numbers: just rewrite the table with the new column > inserted in the proper place. This moves the problem to a different > area, which is be

Re: [HACKERS] Adding columns in the middle of tables

2004-09-04 Thread Christopher Kings-Lynne
> I want to clarify this. > The point of the core is they won't do it because > they have things more important to do, or, the feature > will never be part of the postgresql even if someone > else contribute it. > > Maybe i am not capable of contribute it but i will > try if the feature will be bec

Re: [HACKERS] invalid string enlargment PG 7.4.5 ( SOLVED )

2004-09-04 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > |> ERROR: invalid string enlargement request size 1476395004 > |> DEBUG: AbortCurrentTransaction > |> WARNING: AbortTransaction and not in in-progress state > |> ERROR: could not send data to client: Broken pipe > |> PANIC: error during error recov

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Marc G. Fournier
On Sun, 5 Sep 2004, Gaetano Mendola wrote: Christopher Browne wrote: ... And since APR isn't BSD licensed, that would probably cause a problem. They are changin license for APR and I'll be not surprised if they adopth the BSD one. Since Apache has developed their own license, and I've seen at leas

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes: |>I don't know if APR provide a spin lock mechanism, | | | You don't even know that, but you're confident that we can throw away | our spinlock work and use APR anyway. You're wasting our ti

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Christopher Browne wrote: ... And since APR isn't BSD licensed, that would probably cause a problem. They are changin license for APR and I'll be not surprised if they adopth the BSD one. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if po

[HACKERS] AIX and v8 beta1

2004-09-04 Thread Rod Taylor
Attempted to install PostgreSQL 8.0beta1 on AIX 5.2 on a POWER4+ system today. 7.4.5 worked fine (with header warnings), but 8.0 failed to compile. Full log attached. Uname -a: AIX newman_l1 2 5 61FA4C00 Log snippit: gmake[3]: Leaving directory `/tmp/sitesell/postgresql-8.0.0beta1/src/timez

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Andrew Dunstan
Gaetano Mendola wrote: Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: now that Apache Portable Runtime was release why don't use it on Postgres? The sense of the question is backwards. Why *should* we use it? In order to avoid all the annoyance that someone else had in write code p

[HACKERS] invalid string enlargment PG 7.4.5 ( SOLVED )

2004-09-04 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't see the last post about the issue I had and that was solved ( due I think to last days problems), I post it here again: Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > Don't you think that use of APR could save time ? No, because we've already *done* the work it would purport to save. It would cost us work to adapt our code to sit on top of APR, and it's not clear to me that we'd be getting anything for it. IIRC, th

Re: [HACKERS] Adding columns in the middle of tables

2004-09-04 Thread Tom Lane
=?iso-8859-1?q?Jaime=20Casanova?= <[EMAIL PROTECTED]> writes: > The point of the core is they won't do it because > they have things more important to do, or, the feature > will never be part of the postgresql even if someone > else contribute it. We looked at this and decided that it would be vas

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: now that Apache Portable Runtime was release why don't use it on Postgres? The sense of the question is backwards. Why *should* we use it? In order to avoid all the annoyance that someone else had in write code portable. I mean, how much

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] on behalf of D'Arcy J.M. Cain Sent: Sat 9/4/2004 2:24 PM To: Jim C. Nasby Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Thesis on PostgreSQL > The only "generation" differentiation I have ever heard about i

[HACKERS] Adding columns in the middle of tables

2004-09-04 Thread Jaime Casanova
--- Gaetano Mendola <[EMAIL PROTECTED]> escribió: > Jaime Casanova wrote: > > > Hi guys i was looking for the > > http://developer.postgresql.org/todo.php in order > >to view what things are you posponing for later > > versions > > but the entire developer.postgresql.org site is > > down. > > > >

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > now that Apache Portable Runtime was release why don't > use it on Postgres? The sense of the question is backwards. Why *should* we use it? regards, tom lane ---(end of broadcast)-

Re: [HACKERS] huge execution time difference with almost same plan

2004-09-04 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > I've been playing with OSDL DBT-3 for a while and found very strange > phenomemon. What can you tell us about the physical ordering of the tables involved? The only way I can think of to explain these results is that "orders" is more or less physically in

Re: [HACKERS] huge execution time difference with almost same plan

2004-09-04 Thread Hannu Krosing
On L, 2004-09-04 at 17:35, Tatsuo Ishii wrote: > Hi, > > I've been playing with OSDL DBT-3 for a while and found very strange > phenomemon. The query in question is Q4: > > select o_orderpriority, count(*) as order_count from orders where > o_orderdate >= date '1997-10-01' and o_orderdate < (date

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread Hannu Krosing
On L, 2004-09-04 at 16:24, D'Arcy J.M. Cain wrote: > On Fri, 3 Sep 2004 15:11:54 -0500 > "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > > I'm not aware of any generally accepted definitions of generations > > > of > > database management systems. > > > > Nor am I, but I'd say MySQL would be at lea

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Marc G. Fournier
On Sat, 4 Sep 2004, Gaetano Mendola wrote: Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Short question: why? what does it give us, other then potential reliance on another project to build ... ? Marc G. Fournier Hub.Org Networking Services (ht

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Andrew Dunstan
Gaetano Mendola wrote: Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Now that we have discovered the formula for green cheese, why don't we remake the moon out of it? cheers andrew ---(end of broadcast)--- TIP 8

[HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Developers page is down

2004-09-04 Thread Gaetano Mendola
Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. What do you mean by "in a middle of a table?" A relation is simply a set of attributes

Re: [HACKERS] Developers page is down

2004-09-04 Thread Gaetano Mendola
Jaime Casanova wrote: Hi guys i was looking for the http://developer.postgresql.org/todo.php in order to view what things are you posponing for later versions but the entire developer.postgresql.org site is down. By the way, will be a way in postgresql 8 to add a column in a middle of a table. just

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread D'Arcy J.M. Cain
On Fri, 3 Sep 2004 15:11:54 -0500 "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > I'm not aware of any generally accepted definitions of generations > > of > > database management systems. > > Nor am I, but I'd say MySQL would be at least 2 if not 3 or 4 > generations behind PostgreSQL if there was

[HACKERS] huge execution time difference with almost same plan

2004-09-04 Thread Tatsuo Ishii
Hi, I've been playing with OSDL DBT-3 for a while and found very strange phenomemon. The query in question is Q4: select o_orderpriority, count(*) as order_count from orders where o_orderdate >= date '1997-10-01' and o_orderdate < (date '1997-10-01' + interval '3 month')::date and o_orderkey in (

Re: [HACKERS] www.postgresql.org hacked ?

2004-09-04 Thread Marc G. Fournier
venus went down on Thursday, late ... as soon as I realized it was going to be down for longer then normal (I hate fsck), I changed the DNS so that it pointed to the www*.us.postgresql.org mirrors, which, of course, didn't work since they are all using VirtualNameHosts as opposed to IP ... once

Re: [HACKERS] Thesis on PostgreSQL

2004-09-04 Thread Jim C. Nasby
On Sat, Sep 04, 2004 at 09:24:04AM -0400, D'Arcy J.M. Cain wrote: > On Fri, 3 Sep 2004 15:11:54 -0500 > "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > > I'm not aware of any generally accepted definitions of generations > > > of > > database management systems. > > > > Nor am I, but I'd say MySQL