[HACKERS] Problem with mailing list?

2006-08-22 Thread Zdenek Kotala
Is everything ok with postgres mail server? I have problem to send mail to hackers list and pgadmin-hacker as well. If somebody is on cc, he receives mail correctly, but it does not appear in the list. Any suggestion? Zdenek ---(end of broadcast)---

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Böszörményi Zoltán
Hi, > Robert Treat <[EMAIL PROTECTED]> writes: >> On Tuesday 22 August 2006 16:10, Tom Lane wrote: >>> As I see it, we've effectively got a patch that was rejected once, >>> and Bruce wants to apply it anyway because no replacement has been >>> forthcoming. > >> Well, unless someone is going to co

Re: [HACKERS] [PATCHES] Some minor changes to pgbench

2006-08-22 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > * The schema now uses foreign keys to more accurately reflect a finacial DDL Addition of foreign key checking will certainly impact performance significantly. > * The history table now has a primary key that uses a serial Ditto. > * The respective

Re: [HACKERS] Autovacuum on by default?

2006-08-22 Thread ITAGAKI Takahiro
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > And +1 on Rod's suggestion to make it more aggressive. I always drop the > scale factor to at least 0.2 and 0.1 (though 0.1 and 0.05 don't seem > unreasonable), and typically drop the thresholds to 200 and 100 (though > again, lower is probably warrente

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting

2006-08-22 Thread Joshua D. Drake
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Robert Treat wrote: ... some other tricks people have to make emails more manageable (anyone combine all pg mail to one folder?) Yes, all mine are in one folder, and I use elm ME. It is faster than a GUI email client. All my PG li

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting large result sets in psql using cursors)

2006-08-22 Thread Michael Glaesemann
On Aug 23, 2006, at 12:15 , Robert Treat wrote: On Thursday 17 August 2006 11:55, Peter Eisentraut wrote: Tom Lane wrote: Yeah, that experiment hasn't seemed to work all that well for me either. Do you have another idea to try, or do you just want to revert to the old way? Since almost the

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting large result sets in psql using cursors)

2006-08-22 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Robert Treat wrote: >> ... some other tricks people have to make emails more manageable (anyone >> combine all pg mail to one folder?) > Yes, all mine are in one folder, and I use elm ME. It is faster than a > GUI email client. All my PG list mail go

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting

2006-08-22 Thread Joshua D. Drake
I'm curious, do you combine any other lists like that? I've played around with that idea (for example, I used to combine webmaster emails, pgsql-www, and -slaves emails but the slaves traffic was too high so I had to split it back out). As someone subscribed to a good dozen pg lists, I've a

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES]

2006-08-22 Thread Bruce Momjian
Robert Treat wrote: > On Thursday 17 August 2006 11:55, Peter Eisentraut wrote: > > Tom Lane wrote: > > > Yeah, that experiment hasn't seemed to work all that well for me > > > either. Do you have another idea to try, or do you just want to > > > revert to the old way? > > > > Since almost the fir

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Bruce Momjian
Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > On Tuesday 22 August 2006 16:10, Tom Lane wrote: > >> As I see it, we've effectively got a patch that was rejected once, > >> and Bruce wants to apply it anyway because no replacement has been > >> forthcoming. > > > Well, unless someo

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting large result sets in psql using cursors)

2006-08-22 Thread Robert Treat
On Thursday 17 August 2006 11:55, Peter Eisentraut wrote: > Tom Lane wrote: > > Yeah, that experiment hasn't seemed to work all that well for me > > either. Do you have another idea to try, or do you just want to > > revert to the old way? > > Since almost the first day I hacked on PostgreSQL I ha

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > On Tuesday 22 August 2006 16:10, Tom Lane wrote: >> As I see it, we've effectively got a patch that was rejected once, >> and Bruce wants to apply it anyway because no replacement has been >> forthcoming. > Well, unless someone is going to commit to doing

Re: [HACKERS] news server does not respond

2006-08-22 Thread Christopher Browne
After a long battle with technology, Lukas Kahwe Smith <[EMAIL PROTECTED]>, an earthling, wrote: > Markus Schiltknecht wrote: > >> Marc G. Fournier wrote: >>> Fixed, sorry for delay ... >> Good, thank you. But I've already switched back to IMAP, with >> subfolders and automatic filtering. Has the

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Robert Treat
On Tuesday 22 August 2006 16:10, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > It sucks that patches are posted and no action is taken on them for > > months. I agree with that. > > This particular patch was originally posted during the 8.1 feature > freeze window (2005-09-29),

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > It sucks that patches are posted and no action is taken on them for > > months. I agree with that. > > This particular patch was originally posted during the 8.1 feature > freeze window (2005-09-29), so it was doomed to a certain am

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > What would happen if we just insert DELETE_IN_PROGRESS tuples normally? Would > the only risk be that the index build would fail with a spurious unique > constraint violation? I suppose it would be pretty common though given how > updates work. Yeah, that's

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > Is it not possible to brute force this adding an AM method to insert without > > the uniqueness check? > > Hm. Actually there already is a feature of aminsert to allow > suppressing the unique check, but I'm not s

Re: [HACKERS] [PATCHES] selecting large result sets in psql using

2006-08-22 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > To cut the Gordon knot I'm going to suggest we use: > \set CURSOR_FETCH fetch_count > and \g and ; are modified such that when they see > this variable set to fetch_count > 0 and the buffer > is a select they would use the modified fetch/output code. > Does this sou

Re: [HACKERS] Where is hstore?

2006-08-22 Thread Tom Lane
AgentM <[EMAIL PROTECTED]> writes: > On Aug 22, 2006, at 17:01 , Tom Lane wrote: >> AFAIR the authors have never proposed it for inclusion. > According to http://www.sai.msu.su/~megera/postgres/gist/hstore/ > README.hstore : > "Stable version, included into PostgreSQL distribution, ... version 2

Re: [HACKERS] [BUGS] BUG #2585: Please provide pkg-config support

2006-08-22 Thread Peter Eisentraut
Tom Lane wrote: > Since that was two years ago, maybe we should take another look > and see if pkg-config has gotten better. If it hasn't evolved > some then the answer will probably be the same though. For all intents and purposes, pkg-config is still as broken as it ever was. And I still have

Re: [HACKERS] Where is hstore?

2006-08-22 Thread AgentM
On Aug 22, 2006, at 17:01 , Tom Lane wrote: [EMAIL PROTECTED] writes: I've been set right. Seems hstore was never in contrib. Sorry for the noise. BTW: any reason it isn't? It is very cool... AFAIR the authors have never proposed it for inclusion. According to http://www.sai.msu.su/~meg

Re: [HACKERS] BugTracker (Was: Re: 8.2 features status)

2006-08-22 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > Did you look at http://www.atlassian.com/software/jira/ We had discussed that in an earlier round, but it's not free software, so it's out of the question. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)-

Re: [HACKERS] [PATCHES] selecting large result sets in psql using

2006-08-22 Thread chrisnospam
>> True. They could even put it in .psqlrc if they want. Basically need >> a way to modify \g. Seems a \set is the way we have always done such >> modifications in the past. The big question is whether this is >> somehow different. Personally, I don't think so. > > If you want a \set variable,

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: It's fairly clear that we could support concurrent builds of nonunique indexes, but is that enough of a use-case to justify it? I believe there would be. Most PostgreSQL users I run into, develop in production, which means being ab

Re: [HACKERS] Where is hstore?

2006-08-22 Thread Tom Lane
[EMAIL PROTECTED] writes: > I've been set right. Seems hstore was never in contrib. Sorry for the > noise. > BTW: any reason it isn't? It is very cool... AFAIR the authors have never proposed it for inclusion. regards, tom lane ---(end of broadcas

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: >> It's fairly clear that we could support concurrent builds of nonunique >> indexes, but is that enough of a use-case to justify it? > I believe there would be. Most PostgreSQL users I run into, develop in > production, which means being able to add

Re: [HACKERS] [GENERAL] Queries joining views

2006-08-22 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> We might be able to do something about actually solving the statistical >> problem in 8.3, but I fear it's too late to think about it for 8.2. > I take it you mean you already have a very concrete idea on how to solve > it. Come on,

Re: [HACKERS] [BUGS] BUG #2585: Please provide pkg-config support

2006-08-22 Thread Tom Lane
[ redirecting to pgsql-hackers since this is not a bug ] Alvaro Herrera <[EMAIL PROTECTED]> writes: > Manuel A. Fernandez Montecelo wrote: >> Well, I use around 10 libraries in my project, it's easier to use >> standardized >> methods to gather the compiler/linker options using pkg-config than c

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > It sucks that patches are posted and no action is taken on them for > months. I agree with that. This particular patch was originally posted during the 8.1 feature freeze window (2005-09-29), so it was doomed to a certain amount of languishing on the t

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Joshua D. Drake
Wow, that seems pretty unsatisfactory, all the waiting and locking sounds awful. Yeah, I'm very unhappy. The whole idea may be going down in flames :-( It's fairly clear that we could support concurrent builds of nonunique indexes, but is that enough of a use-case to justify it? I believe t

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > Is it not possible to brute force this adding an AM method to insert without > the uniqueness check? Hm. Actually there already is a feature of aminsert to allow suppressing the unique check, but I'm not sure whether using it for RECENTLY_DEAD tuples helps

Re: [HACKERS] [GENERAL] Queries joining views

2006-08-22 Thread Alvaro Herrera
Tom Lane wrote: > We might be able to do something about actually solving the statistical > problem in 8.3, but I fear it's too late to think about it for 8.2. I take it you mean you already have a very concrete idea on how to solve it. Come on, illuminate us poor dumb souls. -- Alvaro Herrera

Re: [HACKERS] [GENERAL] Queries joining views

2006-08-22 Thread Tom Lane
I wrote: > Thanks. After digging through it a bit, I understand what's happening, > but I'm not seeing any simple fix. I forgot to mention that although I could reproduce your bad plan in 8.1, CVS HEAD doesn't fall into the trap. I don't believe we've done anything to fix the fundamental problem

Re: [HACKERS] [GENERAL] Queries joining views

2006-08-22 Thread Tom Lane
Alban Hertroys <[EMAIL PROTECTED]> writes: >> I'm confused too. Would it be possible for you to send me a dump of >> your database? > Attached is a cleaned out database, the full schema is included, but > only the relevant tables contain any data. Thanks. After digging through it a bit, I unde

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Alvaro Herrera
Hans-Juergen Schoenig wrote: > It has been made as "COPY FROM / TO view" because people wanted it to be > done that way. > My original proposal was in favour of arbitrary SELECTs (just like > proposed by the TODO list) but this was rejected. So, we did it that way > (had to explain to customer

Re: [HACKERS] An Idea for planner hints

2006-08-22 Thread Mark Dilger
Peter Eisentraut wrote: Jim C. Nasby wrote: Meet EXPLAIN ANALYZE. Which does no good for apps that you don't control the code on. Even if you do control the code, you have to find a way to stick EXPLAIN ANALYZE in front of every query, and figure out how to deal with what's comming back. It

Re: [HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > I think we can solve this by having IndexBuildHeapScan not index > DELETE_IN_PROGRESS tuples if it's doing a concurrent build. Sure > It's entirely possible for a tuple that is RECENTLY_DEAD or > DELETE_IN_PROGRESS to have no entry in the index, if it wa

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Hans-Juergen Schoenig
Tom Lane wrote: Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: Bruce Momjian wrote: Well, the patch was submitted in time, and it is a desired feature. If we want to hold it for 8.3 due to lack of time, we can, but I don't think we can decide now that it must wait. well

Re: [HACKERS] PostgreSQL on 64 bit Linux

2006-08-22 Thread Alexander Kirpa
On 21 Aug 2006, at 10:48, [EMAIL PROTECTED] wrote: > On Mon, Aug 21, 2006 at 12:00:58PM +0300, Alexander Kirpa wrote: > > > WRT 64-bit and Postgres, it depends on the CPU as to whether you > > > see a simple performance benefit. On the Opteron you will see a > > > benefit when doing CPU bound wor

Re: [HACKERS] BugTracker (Was: Re: 8.2 features status)

2006-08-22 Thread niederland
Did you look at http://www.atlassian.com/software/jira/ - can use postgresql as database - free to open source projects, used by apache, hiberate, OpenSymphony - bugs may be submitted via email/web - built-in configurable workflow - runs as J2EE webapp on a number of OS's - lots of other features

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

2006-08-22 Thread Josh Berkus
Andrew, > Why are we even dabating a system when it has been reported that the > authors believe it is completely unsuitable for use by the PostgreSQL > project? Not *completely*. More that it would take a couple dozen hours of work to make it good for us, and the resulting version then couldn'

[HACKERS] Tricky bugs in concurrent index build

2006-08-22 Thread Tom Lane
I see fairly nasty problems in the concurrent-index patch when it's trying to build a unique index. I think it's solvable but want some more eyeballs on my reasoning. Look at the code in IndexBuildHeapScan where we are deciding whether or not to include a tuple in the index ("indexIt") and also w

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Andrew Dunstan
Hans-Juergen Schoenig wrote: Tom Lane wrote: Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: Bruce Momjian wrote: Well, the patch was submitted in time, and it is a desired feature. If we want to hold it for 8.3 due to lack of time, we can, but I don't think we can decide now that it

Re: [HACKERS] Where is hstore?

2006-08-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Aug 22, 2006 at 04:06:22PM +, [EMAIL PROTECTED] wrote: > Hi, > > sorry if I'm on the wrong list (tell me so!). I'd like to know whether > hstore [...] I've been set right. Seems hstore was never in contrib. Sorry for the noise. BTW: any

Re: [HACKERS] Where is hstore?

2006-08-22 Thread Stefan Kaltenbrunner
[EMAIL PROTECTED] wrote: > Hi, > > sorry if I'm on the wrong list (tell me so!). I'd like to know whether > hstore isn't supposed to be in contrib any more and where it is supposed > to live nowadays (I was close to file a complaint to my distributor > until I discovered that it isn't in the 8.1 u

Re: [HACKERS] Where is hstore?

2006-08-22 Thread Andrew Dunstan
[EMAIL PROTECTED] wrote: Hi, sorry if I'm on the wrong list (tell me so!). I'd like to know whether hstore isn't supposed to be in contrib any more and where it is supposed to live nowadays (I was close to file a complaint to my distributor until I discovered that it isn't in the 8.1 upstream so

[HACKERS] Where is hstore?

2006-08-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, sorry if I'm on the wrong list (tell me so!). I'd like to know whether hstore isn't supposed to be in contrib any more and where it is supposed to live nowadays (I was close to file a complaint to my distributor until I discovered that it isn't in

Re: [HACKERS] Autovacuum on by default?

2006-08-22 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > If there's a bunch of activity on a table but stats are reset before a > vacuum is run on it and then a vacuum is run, the user will still be > left thinking that the table needs to be vacuumed. Except that autovac *won't* vacuum it if the stats have be

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Tom Lane
Martijn van Oosterhout writes: > Would it be possible to get errcode_for_file_access() to report the > results of GetLastError() for windows, or would that roduce spurious > results. At DEBUG lavel maybe? It would have to be at LOG level, because otherwise it wouldn't get logged at all with the d

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Martijn van Oosterhout
On Tue, Aug 22, 2006 at 10:19:38AM -0400, Tom Lane wrote: > > It may be a good idea to put a elog(LOG) with the error code in the > > failure path of AllocateFile. > > That seems like a plan to me. I had been thinking of making > win32error.c itself log the conversions, but that would not provide

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Stefan Kaltenbrunner
Andrew Dunstan wrote: > Tom Lane wrote: >> Alvaro Herrera <[EMAIL PROTECTED]> writes: >> >>> Tom Lane wrote: >>> It would be interesting to know the actual underlying Windows error code --- I see that win32error.c maps several different codes to EACCES. >> >> >>>

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Andrew Dunstan
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Tom Lane wrote: It would be interesting to know the actual underlying Windows error code --- I see that win32error.c maps several different codes to EACCES. It may be a good idea to put a elog(LOG) with the error co

Re: [HACKERS] Autovacuum on by default?

2006-08-22 Thread Jim C. Nasby
Going back on-list... On Tue, Aug 22, 2006 at 08:47:04AM -0400, Alvaro Herrera wrote: > Jim Nasby wrote: > > On Aug 17, 2006, at 3:19 PM, Alvaro Herrera wrote: > > >Nevermind -- it's just that if you vacuum a table which you haven't > > >touched (insert, update, delete) since the last stats reset,

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> It would be interesting to know the actual underlying Windows error code >> --- I see that win32error.c maps several different codes to EACCES. > It may be a good idea to put a elog(LOG) with the error code in the > failure path of Al

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > It's a close call. On balance I'd be inclined to accept the patch if it > reviews OK, even though we will throw the code away soon (we hope). Well, the patch seems pretty ugly code-wise as well. I'd be willing to clean it up if I thought it wouldn't u

Re: [HACKERS] BugTracker (Was: Re: 8.2 features status)

2006-08-22 Thread Bort, Paul
> > Kenneth Marshall wrote: > > RT is easy to setup/configure/use and works well with PostgreSQL as > > the backend. > > RT works with Postgres, but I wouldn't say well. All queries > in RT are generated by a query generator due to a naive > obsession with database independance. They've achiev

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-08-22 Thread Andrew Dunstan
Michael Glaesemann wrote: On Aug 22, 2006, at 2:52 , Bruce Momjian wrote: Do we want to replace our /contrib/isbn with this, or have it pgfoundry? If contrib/isbn is made obsolete by the pgfoundry ISBN/ISSN/ISMN/EAN13 code, unless there's a compelling reason that the pgfoundry be part of

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Stefan Kaltenbrunner
Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: >> seahorse just failed again with one of the dreaded "permission denied" >> errors we seem to sporadically getting reported on the lists: >> seahorse is just a stock windows XP box (with all patches and >> servicepacks applied) and

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Alvaro Herrera
Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > > seahorse just failed again with one of the dreaded "permission denied" > > errors we seem to sporadically getting reported on the lists: > > seahorse is just a stock windows XP box (with all patches and > > servicepacks applied)

Re: [HACKERS] seahorse again failing

2006-08-22 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > seahorse just failed again with one of the dreaded "permission denied" > errors we seem to sporadically getting reported on the lists: > seahorse is just a stock windows XP box (with all patches and > servicepacks applied) and msys/mingw. > There i

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

2006-08-22 Thread Andrew Dunstan
Marko Kreen wrote: On 8/17/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Alvaro Herrera wrote: > Have you tried to use debbugs? If you can find up-to-date source code for debbugs, we might continue that line of thought. http://www.mail-archive.com/debian-debbugs@lists.debian.org/msg01266.ht

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Andrew Dunstan
Stefan Kaltenbrunner wrote: Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: OK, based on this feedback, I am adding COPY VIEW to the patches queue. I think we have other things that demand our attention more than a half-baked feature.

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > Bruce Momjian wrote: >> Well, the patch was submitted in time, and it is a desired feature. If >> we want to hold it for 8.3 due to lack of time, we can, but I don't >> think we can decide now that it must wait. > well I thought the agreed approa

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Stefan Kaltenbrunner
Bruce Momjian wrote: > Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >>> OK, based on this feedback, I am adding COPY VIEW to the patches queue. >> I think we have other things that demand our attention more than a >> half-baked feature. > > Well, the patch was submitted in time, an

Re: [HACKERS] [PATCHES] COPY view

2006-08-22 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, based on this feedback, I am adding COPY VIEW to the patches queue. > > I think we have other things that demand our attention more than a > half-baked feature. Well, the patch was submitted in time, and it is a desired feature.

Re: [HACKERS] Open 8.2 items

2006-08-22 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian wrote: > > I will try to generate a list of open 8.2 items in 7-10 days so we can > > start focusing on beta. > > FYI, you have three emails about updatable views in the queue, but you > are missing the one I sent today which contains an updated patch that is

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

2006-08-22 Thread Marko Kreen
On 8/17/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Alvaro Herrera wrote: > Have you tried to use debbugs? If you can find up-to-date source code for debbugs, we might continue that line of thought. http://www.mail-archive.com/debian-debbugs@lists.debian.org/msg01266.html ( bzr get http:/

[HACKERS] seahorse again failing

2006-08-22 Thread Stefan Kaltenbrunner
seahorse just failed again with one of the dreaded "permission denied" errors we seem to sporadically getting reported on the lists: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=seahorse&dt=2006-08-22%2002:30:01 we seem to attribute those to AV and other security related software - except t

Re: BugTracker (Was: Re: [HACKERS] 8.2 features status)

2006-08-22 Thread Jim Nasby
On Aug 17, 2006, at 3:40 PM, Alvaro Herrera wrote: The searching capabilities in debbugs are, well, non-existent, which is a real problem in my mind. Well, we can set up our own indexing, like Oleg and Teodor have done in http://www.pgsql.ru/ That seems like quite a hack for something th

Re: [HACKERS] pgstattuple extension for indexes

2006-08-22 Thread Jim Nasby
On Aug 17, 2006, at 4:10 PM, Martijn van Oosterhout wrote: On Thu, Aug 17, 2006 at 02:54:20PM -0500, Jim C. Nasby wrote: On Thu, Aug 17, 2006 at 02:23:48PM +0200, Martijn van Oosterhout wrote: On Thu, Aug 17, 2006 at 12:55:28PM +0900, ITAGAKI Takahiro wrote: But the method has the above probl

Re: [HACKERS] BugTracker (Was: Re: 8.2 features status)

2006-08-22 Thread Andrew Hammond
Kenneth Marshall wrote: > RT is easy to setup/configure/use and works well with PostgreSQL > as the backend. RT works with Postgres, but I wouldn't say well. All queries in RT are generated by a query generator due to a naive obsession with database independance. They've achieved database independ

Re: [HACKERS] [PATCHES] Use of backslash in tsearch2

2006-08-22 Thread Teodor Sigaev
Teodor, are the new attached regression results correct? If so, I will apply the patch and update the expected file. Patch isn't full, simple test (values are took from regression.diffs): # create table tt (tv tsvector, tq tsquery); # insert into tt values (E'''1 \\''2''', NULL); # insert into

Re: [HACKERS] news server does not respond

2006-08-22 Thread Lukas Kahwe Smith
Markus Schiltknecht wrote: Marc G. Fournier wrote: Fixed, sorry for delay ... Good, thank you. But I've already switched back to IMAP, with subfolders and automatic filtering. Has the advantage of being available from any IMAP capable client _and_ saving the flags. Looks like the news ser

Re: [HACKERS] Unable to post to -patches (was: Visual C++ build files)

2006-08-22 Thread Magnus Hagander
> > a.hub.org[200.46.208.251], delay=1, status=sent (250 2.7.1 Ok, > > discarded, id=258 > > 35-09 - BANNED: P=p003,L=1,M=multipart/mixed | > > P=p002,L=1/2,M=application/x-gzip ,T=gz,N=vcbuild.tar.gz | > P=p...) > > > Seems -patches is rejecting any mail with attached .tar.gz files, > if I > > re

Re: [HACKERS] news server does not respond

2006-08-22 Thread Markus Schiltknecht
Marc G. Fournier wrote: Fixed, sorry for delay ... Good, thank you. But I've already switched back to IMAP, with subfolders and automatic filtering. Has the advantage of being available from any IMAP capable client _and_ saving the flags. Looks like the news server is not used that much, if

Re: [HACKERS] BugTracker

2006-08-22 Thread Chris Browne
[EMAIL PROTECTED] (Peter Eisentraut) writes: > Am Mittwoch, 16. August 2006 14:10 schrieb Robert Treat: >> I'm not sure I follow this, since currently anyone can email the bugs list >> or use the bugs -> email form from the website. Are you looking to >> increase the barrier for bug reporting? > >