Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Hannu Krosing
On Sun, 2008-08-24 at 08:05 +0200, Pavel Stehule wrote: > 2008/8/23 Tom Lane <[EMAIL PROTECTED]>: > > Hannu Krosing <[EMAIL PROTECTED]> writes: > >> On Sat, 2008-08-23 at 08:21 +0200, Pavel Stehule wrote: > >>> record or hash table - it's implementation - second step. We have to > >>> find syntax a

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread Hannu Krosing
On Sat, 2008-08-23 at 14:42 -0400, Andrew Dunstan wrote: > > D'Arcy J.M. Cain wrote: > > On Thu, 21 Aug 2008 21:04:07 -0400 > > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > > > >>> There's still the question of whether this covers any needs that aren't > >>> met just as well by XML or CSV ou

Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Pavel Stehule
Hello 2008/8/24 Hannu Krosing <[EMAIL PROTECTED]>: > On Sun, 2008-08-24 at 08:05 +0200, Pavel Stehule wrote: >> 2008/8/23 Tom Lane <[EMAIL PROTECTED]>: >> > Hannu Krosing <[EMAIL PROTECTED]> writes: >> >> On Sat, 2008-08-23 at 08:21 +0200, Pavel Stehule wrote: >> >>> record or hash table - it's im

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Martijn van Oosterhout
On Sat, Aug 23, 2008 at 11:44:59PM -0400, Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'm not sure all browsing setups support tooltips nicely. > > > Any half way modern browser that is not text based should support tool tips. > > Are we in the busines

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread Merlin Moncure
On Sun, Aug 24, 2008 at 2:00 AM, D'Arcy J.M. Cain <[EMAIL PROTECTED]> wrote: > On Sat, 23 Aug 2008 14:57:50 -0400 > Tom Lane <[EMAIL PROTECTED]> wrote: >> Also, having now looked at the proposed patch, it seems clear that it >> isn't addressing the issue of quoting/escaping at all; so I wonder how

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

2008-08-24 Thread Merlin Moncure
On Fri, Aug 22, 2008 at 11:36 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > I assume there is no TODO here. Well, there doesn't seem to be a TODO for partial/restartable vacuums, which were mentioned upthread. This is a really desirable feature for big databases and removes one of the reasons

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread D'Arcy J.M. Cain
On Sun, 24 Aug 2008 09:16:43 -0400 "Merlin Moncure" <[EMAIL PROTECTED]> wrote: > Personally I think it's rather nice to be able to have some extra > flexibility in how psql prints out data. Maybe, instead of the dry > and uninformative 'border 2', there could be a set of ouput control > options.

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Steven Lembark
Are we in the business of excluding text-based browsers? Or obsolete ones, for that matter? I don't think we would want to be in the business of dealing successfully with every quirk of every browser ever released. Another way to look at it is supporting standards: If graphical browsers supp

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Tom Lane wrote: I'm not sure all browsing setups support tooltips nicely. Any half way modern browser that is not text based should support tool tips. Are we in the business of excluding text-based browsers? Or obsolete ones, f

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

2008-08-24 Thread Joshua D. Drake
Merlin Moncure wrote: On Fri, Aug 22, 2008 at 11:36 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: I assume there is no TODO here. Well, there doesn't seem to be a TODO for partial/restartable vacuums, which were mentioned upthread. This is a really desirable feature for big databases and remov

Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > 2008/8/23 Hannu Krosing <[EMAIL PROTECTED]>: >> Why not just use some standard record syntax, like > do you thing, so is it simpler? It's not about being "simpler", it's about pointing out that there are ways to do what you need without creating compa

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Tom Lane
Steven Lembark <[EMAIL PROTECTED]> writes: >>> Are we in the business of excluding text-based browsers? Or obsolete >>> ones, for that matter? > I don't think we would want to be in the business of > dealing successfully with every quirk of every browser > ever released. That's nothing but a str

[HACKERS] xml plans for postgres?

2008-08-24 Thread Greg Fausak
Recently Postgres has added a data type 'xml' which allows for a well formed document to be inserted as a column in a Postgres database. At the moment it doesnot have much utility, you can *almost* get the same thing done with a text column. It's obviously the first step. Is there a document tha

[HACKERS] Extending error-location reports deeper into the system

2008-08-24 Thread Tom Lane
We currently have the ability to generate error location pointers, such as regression=# select nosuchcolumn from int8_tbl; ERROR: column "nosuchcolumn" does not exist LINE 1: select nosuchcolumn from int8_tbl; ^ for grammar-detected syntax errors and for errors during first-level

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread Tom Lane
"D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > On Sat, 23 Aug 2008 14:57:50 -0400 > Tom Lane <[EMAIL PROTECTED]> wrote: >> So, quite aside from the question of whether we care to support ReST, >> my opinion is that this patch fails to do so, and a significantly more >> invasive patch would be nee

Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Pavel Stehule
2008/8/24 Tom Lane <[EMAIL PROTECTED]>: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: >> 2008/8/23 Hannu Krosing <[EMAIL PROTECTED]>: >>> Why not just use some standard record syntax, like > >> do you thing, so is it simpler? > > It's not about being "simpler", it's about pointing out that there ar

Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Martijn van Oosterhout
On Sun, Aug 24, 2008 at 12:00:01PM -0400, Tom Lane wrote: > So I feel that the proposal for labeled parameters as such is dead > in the water, and that the only usefulness this thread has had is > (re-) exploring the syntactic alternatives available for named params. FWIW, I think the way that pyt

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread D'Arcy J.M. Cain
On Sun, 24 Aug 2008 13:22:38 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > > I suppose it is my fault for mentioning ReST. That was the reason I > > looked into this but that is not what the final proposal is. > > Well, if you can't just paste your output into ReST without having to > hand-munge it

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

2008-08-24 Thread Matthew T. O'Connor
Joshua D. Drake wrote: Merlin Moncure wrote: Well, there doesn't seem to be a TODO for partial/restartable vacuums, which were mentioned upthread. This is a really desirable feature for big databases and removes one of the reasons to partition large tables. I would agree that partial vacuums wo

Re: [HACKERS] Extending error-location reports deeper into the system

2008-08-24 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: "Tom Lane" <[EMAIL PROTECTED]> writes: > If we didn't set the locations to unknown, then errors complaining about > problems arising within a rule would try to print pointers to locations in > the calling query's text having the same offsets as the problemat

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

2008-08-24 Thread Tom Lane
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: > I think everyone agrees that partial vacuums would be useful / *A Good > Thing* but it's the implementation that is the issue. I'm not sure how important it will really be once we have support for dead-space-map-driven vacuum.

Re: [HACKERS] Extending error-location reports deeper into the system

2008-08-24 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> If we didn't set the locations to unknown, then errors complaining about >> problems arising within a rule would try to print pointers to locations in >> the calling query's text having the same offsets as the pro

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Stefan Kaltenbrunner
Alvaro Herrera wrote: Stefan Kaltenbrunner wrote: Tom Lane wrote: Can you modify the buildfarm's description of that machine to mention the special malloc debug flags? It'd probably stop me from asking you this question again ;-) hmm - would take somebody with SQL-level access to do this - t

Re: [HACKERS] xml plans for postgres?

2008-08-24 Thread Peter Eisentraut
On Sunday 24 August 2008 19:19:24 Greg Fausak wrote: > Is there a document  that describes the direction Postgres > will take relative to xml technology? There is some information at http://wiki.postgresql.org/wiki/XML_Todo, but these items are mainly aiming to complete the approach taken in 8.3.

[HACKERS] IN, BETWEEN, spec compliance, and odd operator names

2008-08-24 Thread Tom Lane
I was looking just now at gram.y's handling of various peculiar SQL constructs, and was reminded of a point that's bothered me before, but I don't recall if it's ever been discussed explicitly on -hackers. As an example, take the production for BETWEEN ASYMMETRIC: a_expr BETWEEN opt_a

[HACKERS] can't stop autovacuum by HUP'ing the server

2008-08-24 Thread Dave Cramer
I'd like to stop autovac by changing the conf file then sending the server a HUP This "appears" to work, the logs show autovac terminated by administrative command. Then a few minutes later I see a vacuum process spawned. Is it possible that there are timers that aren't being properly t

Re: [HACKERS] can't stop autovacuum by HUP'ing the server

2008-08-24 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > I'd like to stop autovac by changing the conf file then sending the > server a HUP Uh ... why should that stop an autovac already in progress? I'd only expect it to affect future launches. regards, tom lane -- Sent via pgsql-h

Re: [HACKERS] can't stop autovacuum by HUP'ing the server

2008-08-24 Thread Alvaro Herrera
Hi Dave, Dave Cramer wrote: > I'd like to stop autovac by changing the conf file then sending the > server a HUP > > This "appears" to work, the logs show autovac terminated by > administrative command. Then a few minutes later I see a vacuum process > spawned. > > Is it possible that there a

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

2008-08-24 Thread Matthew T. O'Connor
Tom Lane wrote: "Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: I think everyone agrees that partial vacuums would be useful / *A Good Thing* but it's the implementation that is the issue. I'm not sure how important it will really be once we have support for dead-space-map-driven vac

Re: [HACKERS] IN, BETWEEN, spec compliance, and odd operator names

2008-08-24 Thread Martijn van Oosterhout
On Sun, Aug 24, 2008 at 09:24:23PM -0400, Tom Lane wrote: > My own feeling is that we should avoid imputing particular semantics > to particular operator names, and so these constructs should always be > defined by reference to operators found in a default opclass for the > datatype, rather than by

Re: [HACKERS] Extending grant insert on tables to sequences

2008-08-24 Thread Jaime Casanova
On Fri, Aug 22, 2008 at 10:19 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > Added to September commit fest. > why? there isn't a new patch yet... i haven't sent it because i want to see the column level privileges patch first because Tom's complaints -- regards, Jaime Casanova Soporte y capac