Re: [HACKERS] cascading column drop to index predicates

2003-12-21 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > The thing is, if you drop a column that is used in a normal index, yes > the index is now useless - drop it. > However, since you can have (and I have) indexes like this: > CREATE INDEX asdf ON table (a, b, c) WHERE d IS NOT NULL; > If I drop c

[HACKERS] cascading column drop to index predicates

2003-12-21 Thread Christopher Kings-Lynne
Hey Tom, With regards to our previous conversation about dropping columns now properly dropping indexes that contain predicates that reference that column, I now find it a bit disconcerting that such indexes are automatically removed when the column is dropped, instead of requiring a CASCADE.

Re: [HACKERS] What to do with my patch?

2003-12-21 Thread Bruce Momjian
Tom Lane wrote: > Dennis Bjorklund <[EMAIL PROTECTED]> writes: > > The 14 december I submitted a patch that implements named function > > arguments. So far no one have said anything about that. > > I have it on my to-look-at list, but I've been too busy trying to get > 7.4.1 ready to do anything w

Re: [HACKERS] 7.4.1 tag'd and bundled ...

2003-12-21 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > will do a general announce Monday afternoon, but if someone can test and > confirm that I haven't missed anything, that would be great... Looks solid from here ... regards, tom lane ---(end of broadc

[HACKERS] 7.4.1 tag'd and bundled ...

2003-12-21 Thread Marc G. Fournier
will do a general announce Monday afternoon, but if someone can test and confirm that I haven't missed anything, that would be great... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON

2003-12-21 Thread Andrew Dunstan
Marc G. Fournier wrote: On Sun, 21 Dec 2003, Joshua D. Drake wrote: Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? If we were going to do this, I would suggest just go

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-21 Thread Marc G. Fournier
On Sun, 21 Dec 2003, Joshua D. Drake wrote: > > >> > >>Would this be at all useful? > >> > >> > > > >Someone mentioned that the 'fees' were relatively high though ... that you > >lose a fair amount off the top *to* Sourceforge? > > > > > > > If we were going to do this, I would suggest just going

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-21 Thread Joshua D. Drake
Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? If we were going to do this, I would suggest just going right through paypal. Marc G. Fournier

Re: [HACKERS] What to do with my patch?

2003-12-21 Thread Tom Lane
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > The 14 december I submitted a patch that implements named function > arguments. So far no one have said anything about that. I have it on my to-look-at list, but I've been too busy trying to get 7.4.1 ready to do anything with pending patches.

Re: [HACKERS] [GENERAL] Backwards index scan

2003-12-21 Thread Tom Lane
Gaetano Mendola <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I have committed a fix into 7.5devel to do this properly. I think this >> is the last case wherein btree is unnecessarily inefficient for large >> numbers of equal keys. > Any chance to have it on 7.4.1 ? No. It's inadequately tes

Re: [HACKERS] What to do with my patch?

2003-12-21 Thread Dennis Bjorklund
On Sun, 21 Dec 2003, Bruce Momjian wrote: > Uh, I don't remember seeing your patch, and I don't have it in my > mailbox? Which email list did you send it to? Perhaps the email is > stuck waiting for Marc to accept it. http://archives.postgresql.org/pgsql-patches/2003-12/msg00176.php -- /Denni

Re: [HACKERS] What to do with my patch?

2003-12-21 Thread Bruce Momjian
Dennis Bjorklund wrote: > The 14 december I submitted a patch that implements named function > arguments. So far no one have said anything about that. It would be nice > if someone could look at it and either reject, accept, put on queue, or > anything else. > > The patch is very big (400k), but m

Re: [HACKERS] [GENERAL] Backwards index scan

2003-12-21 Thread Gaetano Mendola
Tom Lane wrote: I have committed a fix into 7.5devel to do this properly. I think this is the last case wherein btree is unnecessarily inefficient for large numbers of equal keys. Any chance to have it on 7.4.1 ? Regards Gaetano Mendola ---(end of broadcast)---

[HACKERS] What to do with my patch?

2003-12-21 Thread Dennis Bjorklund
The 14 december I submitted a patch that implements named function arguments. So far no one have said anything about that. It would be nice if someone could look at it and either reject, accept, put on queue, or anything else. The patch is very big (400k), but most of that size comes from trival c