Re: [HACKERS] half OOT, plv8js group created ^^

2009/10/31 David Fetter : > Please send a patch! :) :) :) Here's my working directory. Kiswono, thanks for adding me to your google code project. I prefer the license would be New BSD rather than GPL. >From instant README: plv8 version 2009/11/01 * OVERVIEW plv8 is shared library that provides

Re: [HACKERS] per-tablespace random_page_cost/seq_page_cost

On Tue, Oct 27, 2009 at 9:13 PM, Tom Lane wrote: > Robert Haas writes: >> I confess that I'm a bit mystified about the design of the reloptions >> stuff. It seems kind of odd to store structured data as text[]; it's >> kind of the opposite of what I would normally recommend as good >> database de

Re: [HACKERS] Patch set under development to add usage reporting.

Tom Lane writes: > Peter Eisentraut writes: > > I don't really get the point of the SHOW STATISTICS command. There is > > already a command whose purpose is to retrieve data in tabular form, > > namely SELECT. > > I presume we need not worry about that, since the SQL committee are > cert

Re: [HACKERS] Patch set under development to add usage reporting.

Peter > > I had taken a look at existing statistics reporting (at > > least in the 7.4.x tree) and didn't see a good analog to what this > > provides. > > The statistics collector detailed at > > appears to do pr

Re: [HACKERS] WIP: push AFTER-trigger execution into ModifyTable node

On Sat, Oct 31, 2009 at 5:00 PM, Marko Tiikkaja wrote: > Greg Stark wrote: >> >> On Thu, Oct 29, 2009 at 7:17 AM, Tom Lane wrote: >>> >>> Pipelined execution would be nice but I really doubt that it's worth >>> what we'd have to give up to have it.  The one-at-a-time behavior will >>> be simple t

Re: [HACKERS] WIP: push AFTER-trigger execution into ModifyTable node

Greg Stark wrote: On Thu, Oct 29, 2009 at 7:17 AM, Tom Lane wrote: Pipelined execution would be nice but I really doubt that it's worth what we'd have to give up to have it. The one-at-a-time behavior will be simple to understand and reliable to use. Concurrent execution won't be either. I

Re: [HACKERS] Weird PL/Python elog output

On 10/31/09, Peter Eisentraut wrote: > On fre, 2009-10-30 at 17:13 +0200, Marko Kreen wrote: > > I vote for handling tuple with 1 element better, otherwise keep old > > behaviour. > > > > I don't think breaking multi-arg calls is good idea, as they may be used > > only in special situations.

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

Roger Leigh wrote: On Sat, Oct 31, 2009 at 12:25:22PM -0400, Andrew Dunstan wrote: Roger Leigh wrote: Wouldn't it be much simpler all around to add a "csv" output format in addition to the above for this purpose? Spreadsheets can read it in with no trouble at all. We've had C

Re: [HACKERS] Patch set under development to add usage reporting.

Peter Eisentraut writes: > On lör, 2009-10-31 at 13:37 -0400, John Murtari wrote: >> ... We also had >> developed the "SHOW STATISTICS" syntax for DB version that don't >> support INFORMATION SCHEMA. > I don't really get the point of the SHOW STATISTICS command. There is > already a command wh

Re: [HACKERS] Patch set under development to add usage reporting.

On lör, 2009-10-31 at 13:37 -0400, John Murtari wrote: > I had taken a look at existing statistics reporting (at > least in the 7.4.x tree) and didn't see a good analog to what this > provides. The statistics collector detailed at

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

On Sat, Oct 31, 2009 at 12:25:22PM -0400, Andrew Dunstan wrote: > > > Roger Leigh wrote: >> >> Wouldn't it be much simpler all around to add a "csv" output format >> in addition to the above for this purpose? Spreadsheets can read >> it in with no trouble at all. > > We've had CSV output since ver

Re: [HACKERS] Patch set under development to add usage reporting.

Peter, > > The project web site has a lot of info, but here is a quick > > example of what it does: > > > > thebook=# show statistics * from db history; > >db|minutes | Questions | Connections | Com_delete > > -++---+-+-

Re: [HACKERS] \d+ for long view definitions?

> diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c > --- a/src/bin/psql/describe.c > +++ b/src/bin/psql/describe.c > @@ -1306,7 +1306,7 @@ describeOneTableDetails(const char *schemaname, > printTableAddHeader(&cont, headers[i], true, 'l'); > > /* Check if table is a view

Re: [HACKERS] Patch set under development to add usage reporting.

Peter, > The patch itself appears to be licensed under the GPL, which means we > can't even look at it. We can look at it all we want, we just can't copy it. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.pos

Re: [HACKERS] PL/Perl backed crashed during spi_exec_query

Alexey Klyukin writes: > One of our customers is running 8.2.14 and use a couple of pl/perl and > pl/perlu functions written by CMD. Everything worked normally until > they tried to call one particular pl/perl function from pl/perl via > spi. It appears that a die call inside the callee just

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

Roger Leigh wrote: Wouldn't it be much simpler all around to add a "csv" output format in addition to the above for this purpose? Spreadsheets can read it in with no trouble at all. We've had CSV output since version 8.0. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

On Sat, Oct 31, 2009 at 05:11:10AM -0700, Greg Stark wrote: > On Mon, Oct 26, 2009 at 11:43 PM, Peter Eisentraut wrote: > > On Mon, 2009-10-26 at 10:12 -0700, Greg Stark wrote: > >> While i agree this looks nicer I wonder what it does to things like > >> excel/gnumeric/ooffice auto-recognizing tab

Re: [HACKERS] Patch set under development to add usage reporting.

On fre, 2009-10-30 at 12:02 -0400, John Murtari wrote: > The project web site has a lot of info, but here is a quick > example of what it does: > > thebook=# show statistics * from db history; >db|minutes | Questions | Connections | Com_delete > -++--

Re: [HACKERS] some dead code in functioncmds.c

On fre, 2009-10-30 at 19:08 +0100, Pavel Stehule wrote: > 2009/10/30 Heikki Linnakangas : > > Pavel Stehule wrote: > >> 2009/10/30 Heikki Linnakangas : > >>> To keep the compiler quiet about using the variables uninitialized. The > >>> compiler doesn't know that ereport(ERROR) never returns. > >> >

Re: [HACKERS] Patch set under development to add usage reporting.

Jaime, > > The project web site has a lot of info, but here is a quick > > example of what it does: > > thebook=# show statistics * from db history; db|minutes | Questions | Connections | Com_delete -++---+-+ thebook | 10

Re: [HACKERS] Patch set under development to add usage reporting.

Greg > > We now have a basic patch set that works and is basically stable (not > > recommended for production servers!). We've dedicated a page at our web > > site and it hopefully has answers to most of your questions, and also > > has the patch set for download. These are for 7.4.19 - t

[HACKERS] Segfault in PL/Python

I have discovered an obscure segfault condition in PL/Python. In PLy_output(), when the elog() call in the TRY branch throws an exception (this can happen when a statement timeout kicks in, for example), the PyErr_SetString() call in the CATCH branch can cause a segfault, because the Py_XDECREF(so

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

On Mon, Oct 26, 2009 at 11:43 PM, Peter Eisentraut wrote: > On Mon, 2009-10-26 at 10:12 -0700, Greg Stark wrote: >> While i agree this looks nicer I wonder what it does to things like >> excel/gnumeric/ooffice auto-recognizing table layouts and importing >> files. I'm not sure our old format was s

Re: [HACKERS] Unicode UTF-8 table formatting for psql text output

On Mon, Oct 26, 2009 at 01:33:19PM -0400, Tom Lane wrote: > Greg Stark writes: > > While i agree this looks nicer I wonder what it does to things like > > excel/gnumeric/ooffice auto-recognizing table layouts and importing > > files. I'm not sure our old format was so great for this so maybe this

Re: [HACKERS] \du quite ugly in 8.4

On ons, 2009-10-21 at 10:28 -0300, Alvaro Herrera wrote: > Peter Eisentraut wrote: > > Could someone clarify why this (from PG 8.4) > > > > # \du > > List of roles > >Role name | Attributes | Member of > > ---+-+ > > admin | Create

Re: [pgsql-www] [HACKERS] FTP/GIT/WWW server move

On Sat, Oct 31, 2009 at 09:54, Peter Eisentraut wrote: > On fre, 2009-10-30 at 13:28 +, Dave Page wrote: > > On Thu, Oct 29, 2009 at 9:35 AM, Dave Page wrote: > > > On Friday 30 November at 1200 GMT, the server that hosts our primary > > > FTP server, GIT server and one of the website mirror

Re: [HACKERS] Weird PL/Python elog output

On fre, 2009-10-30 at 17:13 +0200, Marko Kreen wrote: > On 10/30/09, Peter Eisentraut wrote: > > Calling PL/Python's elog functions exposes some curious behavior. For > > example, calling plpy.error('foo') prints > > > > ERROR: ('foo',) > > > > (instead of the > > > > ERROR: foo > > > > th

Re: [HACKERS] FTP/GIT/WWW server move

On fre, 2009-10-30 at 13:28 +, Dave Page wrote: > On Thu, Oct 29, 2009 at 9:35 AM, Dave Page wrote: > > On Friday 30 November at 1200 GMT, the server that hosts our primary > > FTP server, GIT server and one of the website mirrors will be moved to > > a new data center. Downtime is expected to