Re: [HACKERS] Patch: plan invalidation vs stored procedures

2008-08-19 Thread David Fetter
. FWIW, given that there will probably always be corner cases. I can see the attraction in Simon's suggestion of providing a way to manually issue a system-wide forced plan flush. Would that require a system-wide plan cache to implement? Cheers, David. -- David Fetter [EMAIL PROTECTED] http

Re: [HACKERS] Adjusting debug_print_plan to be more useful by default

2008-08-19 Thread David Fetter
be in user space. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql

Re: [HACKERS] Patch: plan invalidation vs stored procedures

2008-08-19 Thread David Fetter
On Tue, Aug 19, 2008 at 09:50:53PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Tue, Aug 19, 2008 at 07:45:16PM -0400, Tom Lane wrote: FWIW, given that there will probably always be corner cases. I can see the attraction in Simon's suggestion of providing a way

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF

2008-08-19 Thread David Fetter
| pg_prepared_statement | SETOF record | pg_catalog | pg_prepared_xact | SETOF record | pg_catalog | pg_show_all_settings | SETOF record | (5 rows) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] A smaller default postgresql.conf

2008-08-20 Thread David Fetter
links that are explicitly telling you, Don't be stupid read the docs is a very good idea. And we're back to man pages and CHM files. How big a project would that latter be? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

[HACKERS] SHOW ALL doesn't actually SHOW ALL

2008-08-20 Thread David Fetter
= 'plperl.use_strict'; name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val --+-+--+--+++-+-++-+- (0 rows) Is this a bug? Cheers, David. -- David Fetter [EMAIL

Re: [HACKERS] [pgsql-www] [FINALLY] the TODO list has migrated to Wiki

2008-08-20 Thread David Fetter
small request. The font is really small and I have pretty good eyesight. Fixed :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating

Re: [HACKERS] SHOW ALL doesn't actually SHOW ALL

2008-08-20 Thread David Fetter
On Wed, Aug 20, 2008 at 01:56:50PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I've noticed that neither SHOW ALL nor SELECT ... FROM pg_settings shows the value of custom GUCs, even though SHOW will do so for any given one. Yeah, that's intentional, because what

Re: [HACKERS] WITH RECURSIVE patches 0818

2008-08-23 Thread David Fetter
, now that we are into August, would Asaba-san and whomever else like to try out the git repository? To do so, I just need a login name and a public key. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] WITH RECURSIVE patches 0818

2008-08-23 Thread David Fetter
. It is linked from the Commitfest page. Also, now that we are into August, would Asaba-san and whomever else like to try out the git repository? To do so, I just need a login name and a public key. I will send you later. Thanks :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http

[HACKERS] initdb change

2008-08-25 Thread David Fetter
check whether pg_xlog is a directory and the only thing in $PGDATA. One way to do that is to add a new return code to check_data_dir() and a new branch of the case statement after it's called. What say? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] initdb change

2008-08-25 Thread David Fetter
On Mon, Aug 25, 2008 at 11:48:29AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: While initdb allows you to choose a directory for transaction logs, it can't already exist, so it can't be in its usual place under $PGDATA. I'd like to propose that this be allowed by having

Re: [HACKERS] initdb change

2008-08-25 Thread David Fetter
On Mon, Aug 25, 2008 at 09:29:03AM -0700, Joshua D. Drake wrote: On Mon, 25 Aug 2008 09:04:01 -0700 David Fetter [EMAIL PROTECTED] wrote: When -X is set to existing, it would check whether pg_xlog is a directory and the only thing in $PGDATA. One way to do that is to add a new

Re: [HACKERS] initdb change

2008-08-25 Thread David Fetter
On Mon, Aug 25, 2008 at 09:54:26AM -0700, Joshua D. Drake wrote: On Mon, 25 Aug 2008 09:42:21 -0700 David Fetter [EMAIL PROTECTED] wrote: We either need to provide a way to initialize it at initdb, allow xlogs to be in table space or add a GUC for the location. There's already a way

[HACKERS] TODO - Commitfest

2008-08-26 Thread David Fetter
Folks, It looks to me like there should be more links, maybe even bidirectional ones, between the TODO wiki and commitfest pages. Does mediawiki have a bidirectional link capability? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] TODO - Commitfest

2008-08-26 Thread David Fetter
On Tue, Aug 26, 2008 at 09:40:26PM -0400, Alvaro Herrera wrote: David Fetter wrote: Folks, It looks to me like there should be more links, maybe even bidirectional ones, between the TODO wiki and commitfest pages. Does mediawiki have a bidirectional link capability? Huh, what's

Re: [HACKERS] Skytools committed without hackers discussion/review

2007-10-09 Thread David Fetter
believe it would make a great addition to the core product, but only in 8.4. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-23 Thread David Fetter
doing reviews faster. It just means not waiting until the patch is in release-ready state. It's latency that's hurting us, not bandwidth... A DSCM can do a *lot* to get this latency down :) Cheers, David (not advocating any particular DSCM at the moment, just the process of using one) -- David

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-23 Thread David Fetter
day with it. http://repo.or.cz/w/PostgreSQL.git There are git-cvsimport and git-cvsexport utilities which make communication between the legacy SCM and the DSCM straight-forward. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-23 Thread David Fetter
On Tue, Oct 23, 2007 at 06:19:42PM -0400, Andrew Dunstan wrote: David Fetter wrote: On Tue, Oct 23, 2007 at 04:59:51PM -0400, Chris Browne wrote: [EMAIL PROTECTED] (Tom Lane) writes: Simon Riggs [EMAIL PROTECTED] writes: I'd suggest we have multiple checkpoints during the cycle

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-24 Thread David Fetter
of preventing bit-rot on large patches and keeping them in sync :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Feature Freeze date for 8.4

2007-10-24 Thread David Fetter
On Wed, Oct 24, 2007 at 02:18:42PM -0300, Alvaro Herrera wrote: [EMAIL PROTECTED] wrote: On Wed, Oct 24, 2007 at 02:32:13PM +0200, Martijn van Oosterhout wrote: On Tue, Oct 23, 2007 at 02:39:43PM -0700, David Fetter wrote: The one below is already available, so we don't have to do a flag

Re: [HACKERS] Re: [COMMITTERS] pgsql: Extract catalog info for error reporting before an error actually

2007-10-25 Thread David Fetter
actually agreeing that autovac should not block DDL. +1 here for having autovacuum not block DDL :) Cheers, David (for what it's worth) -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember

Re: [HACKERS] Proposal: real procedures again (8.4)

2007-10-27 Thread David Fetter
our fe-be protocol implementation bit-by-bit. How do you mean? The only way I've done multisets is by creating functions that return multiple refcursors, either in a row or as SETOF. Is or was there some other way? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1

Re: [HACKERS] Proposal: real procedures again (8.4)

2007-10-28 Thread David Fetter
On Sun, Oct 28, 2007 at 08:18:04PM -0500, Merlin Moncure wrote: On 10/27/07, David Fetter [EMAIL PROTECTED] wrote: The only way I've done multisets is by creating functions that return multiple refcursors, either in a row or as SETOF. Is or was there some other way? ahem...arrays

Re: [HACKERS] Proposal: real procedures again (8.4)

2007-10-29 Thread David Fetter
; END; $$; SELECT * FROM wtf('a','b'); FETCH all FROM a; FETCH all FROM b; ROLLBACK; Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating

Re: [HACKERS] Proposal: real procedures again (8.4)

2007-10-30 Thread David Fetter
On Tue, Oct 30, 2007 at 09:48:24AM +0100, Pavel Stehule wrote: 2007/10/30, David Fetter [EMAIL PROTECTED]: Based on the example in TFM for PL/PgSQL: BEGIN; CREATE TABLE foo(foo_id SERIAL PRIMARY KEY, foo_text TEXT); CREATE TABLE bar(bar_id SERIAL PRIMARY KEY, bar_text TEXT); INSERT

Re: [HACKERS] Proposal: real procedures again (8.4)

2007-10-30 Thread David Fetter
On Tue, Oct 30, 2007 at 11:31:12AM -0300, Alvaro Herrera wrote: David Fetter wrote: AS $$ BEGIN OPEN $1 FOR SELECT * FROM foo; RETURN NEXT $1; OPEN $2 FOR SELECT * FROM bar; RETURN NEXT $2; END; $$; I know it. It is ugly as all hell. Agreed. Cheers, David

Per-statement Triggers (was Re: [HACKERS] Proposal: real procedures again (8.4))

2007-10-30 Thread David Fetter
should be just a SMOP. Having NEW and OLD views of per-statement triggers would be a Very Nice Feature(TM) independent of stored procedures. For one thing, it would make certain kinds of replication trivial. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778

Jagged Rows (was Re: [HACKERS] Proposal: real procedures again (8.4))

2007-10-30 Thread David Fetter
with the assumption that you know at run time the shape of all the rows and that that shape is uniform. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating

Re: [HACKERS] Proposal TODO Item: SQL-language reference parameters by name

2007-10-30 Thread David Fetter
of existing PLs would be required? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: [HACKERS] minimal update

2007-11-02 Thread David Fetter
... Is this an insane idea, or would it be possible, practical and useful? I don't know about the sanity, but I've done it a couple of places :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] [hibernate-team] PostgreSQLDialect

2007-11-11 Thread David Fetter
you're using. Yes, it violates the assumption that you can just swap DBMSs from under your application code, but I've never seen that assumption hold for applications that actually use the RDBMS anyway. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Simplifying Text Search

2007-11-12 Thread David Fetter
you think of the proposal to make text search work this way and to document this more easily readable form? +1 for adding this. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL

Re: [HACKERS] psql -f doesn't complain about directories

2007-11-14 Thread David Fetter
? Actually anything other than a plain file, right? (Do we really want to be able to psql -f a_pipe?) Yes, I have seen people use just this technique. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] [DOCS] distributed checkpoint

2007-12-06 Thread David Fetter
was spread checkpoint or time-extended checkpoint. Anybody have a better idea? balanced gradual extended (I see you mention time-extended but wouldn't time be implicit based on the actual docs and thus we only need extended?) How about smoothed? Cheers, David. -- David Fetter [EMAIL

Re: [HACKERS] Table rewrites vs. pending AFTER triggers

2008-01-03 Thread David Fetter
you were to the place you want to be. With transactional DDL, you know absolutely for sure that you've done either the whole change or none of it, i.e. not half-way in between :) Cheers, David (a giant fan of transactional DDL) -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415

Re: [HACKERS] [GENERAL] SHA1 on postgres 8.3

2008-01-20 Thread David Fetter
algorithms? Right now, there's a contest between SHA1 and MD5 as to which one gets broken first, and SHA1 appears to be in the lead. SHAn for n1 could preempt the awfulness of losing this race. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

[HACKERS] Bug in psql/enum

2008-01-20 Thread David Fetter
Folks, 8.3's psql is ponderously unhelpful when getting the type description of an enum, so I'd like to propose a new column in the \dT output which can contain those values in an array format. Yes, I know it looks like a new feature, but it's really a bug fix. Cheers, David. -- David Fetter

Re: [HACKERS] Bug in psql/enum

2008-01-21 Thread David Fetter
On Sun, Jan 20, 2008 at 10:55:11PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: 8.3's psql is ponderously unhelpful when getting the type description of an enum, so I'd like to propose a new column in the \dT output which can contain those values in an array format

Re: [HACKERS] Truncate Triggers

2008-02-02 Thread David Fetter
data, but it's DDL nonetheless. By that definition CLUSTER is DDL and TRUNCATE is DDL if you look at the implementation rather than the user-visible effects. I agree that both are more DDL-like than DML-like. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415

Re: [HACKERS] Truncate Triggers

2008-02-02 Thread David Fetter
On Sat, Feb 02, 2008 at 02:23:40PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Thu, Jan 31, 2008 at 10:22:42AM +, Gregory Stark wrote: There are plenty of DDL commands which modify data (CREATE INDEX, ATLER TABLE ALTER COLUMN TYPE). The defining characteristic

Re: [HACKERS] Truncate Triggers

2008-02-02 Thread David Fetter
On Sat, Feb 02, 2008 at 05:23:39PM -0500, Christopher Browne wrote: On Feb 2, 2008 2:43 PM, David Fetter [EMAIL PROTECTED] wrote: It still involves DDL-like operations in the sense of changing (for the duration of the query) trigger behavior. But that change of trigger behavior is still

Re: [HACKERS] wishlist for 8.4

2008-02-15 Thread David Fetter
looking for... You could have a function get_attribute_as_text(NEW, 'id') or even get_attribute_quoted(NEW, 'id') It would be nice to have a more dynamic language built-in. I'm not aware of any BSD-licensed dynamic languages though. Perl is BSD-compatible. Cheers, David. -- David Fetter

[HACKERS] Including PL/PgSQL by default

2008-02-19 Thread David Fetter
Folks, Let's put PL/PgSQL in template1 by default, as some downstream packagers are already doing. If someone really must remove it, they can still do that. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Including PL/PgSQL by default

2008-02-19 Thread David Fetter
On Tue, Feb 19, 2008 at 12:11:05PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: Let's put PL/PgSQL in template1 by default, as some downstream packagers are already doing. If someone really must remove it, they can still do that. This has been proposed before

Re: [HACKERS] minimal update trigger

2008-02-20 Thread David Fetter
| ---(end of broadcast)--- TIP 6: explain analyze is your friend -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating

Re: [HACKERS] Rewriting Free Space Map

2008-03-17 Thread David Fetter
, as (a) that prejudges what the alternate forks might be used for, and (b) the name fails to be inclusive of the data fork. Other suggestions anyone? Segment? Section? Module? Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

[HACKERS] Surfacing qualifiers

2008-03-26 Thread David Fetter
does. Help, comments, brickbats, etc. appreciated :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Surfacing qualifiers

2008-03-26 Thread David Fetter
On Wed, Mar 26, 2008 at 08:31:04AM -0400, Andrew Dunstan wrote: David Fetter wrote: Folks, Neil Conway sent me a patch that sketched out a plan to make quals visible to functions er, what? Please explain what this means, why it might be useful. Example(s) would help. Right now, user

Re: [HACKERS] Surfacing qualifiers

2008-03-26 Thread David Fetter
On Wed, Mar 26, 2008 at 01:21:14PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: What happens now with dblink is that the remote table (more generally, the output of a fixed query) gets materialized into memory in its entirety, and if it's bigger than what's available

Re: [HACKERS] Surfacing qualifiers

2008-03-26 Thread David Fetter
it transparently with dblink :) Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: [HACKERS] Specification for Trusted PLs?

2010-05-27 Thread David Fetter
it could short of a time machine. We're stuck with an backward convention. :( Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical

Re: [HACKERS] functional call named notation clashes with SQL feature

2010-05-27 Thread David Fetter
pretty sure is not currently used in our grammar. We could use the Turkish muvaffakiyetsizleştiricileştiriveremeyebileceklerimizdenmişsinizcesine, which I'm pretty sure isn't either :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Specification for Trusted PLs?

2010-05-27 Thread David Fetter
was actually this way, could go a long way toward making sure that PLs didn't regress into untrusted territory. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

[HACKERS] VPATH docs

2010-05-27 Thread David Fetter
Folks, Andrew Dunstan posted some instructions on his blog, and I'm thinking they clarify things a great deal for people who want to learn how to do VPATH builds. Attached patch adds the description along with an index term. What say? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Specification for Trusted PLs?

2010-05-27 Thread David Fetter
On Thu, May 27, 2010 at 09:51:30PM -0400, Robert Haas wrote: On Thu, May 27, 2010 at 7:10 PM, David Fetter da...@fetter.org wrote: On Fri, May 28, 2010 at 01:03:15AM +0300, Peter Eisentraut wrote: On fre, 2010-05-21 at 14:22 -0400, Robert Haas wrote: On Fri, May 21, 2010 at 2:21 PM, Tom

Re: [HACKERS] small exclusion constraints patch

2010-05-29 Thread David Fetter
before 9.1? Because there's a fundamentally new way to use them now, namely with exclusion constraints :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] Synchronization levels in SR

2010-06-04 Thread David Fetter
On Thu, Jun 03, 2010 at 10:57:05PM -0400, Robert Haas wrote: On Thu, Jun 3, 2010 at 8:47 PM, Jan Wieck janwi...@yahoo.com wrote: What would be the use case for such a query? Monitoring? s/\?/!/; Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] How about closing some Open Items?

2010-06-08 Thread David Fetter
is happening. (If you think it means HS is s/HS/any software, no matter how trivial/ bug-free, I have a nice bridge I'd like to interest you in.) Is it the one from Lower Manhattan to Brooklyn? I've got all kinds of cool ideas about what to do with it... Cheers, David. -- David Fetter da

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-27 Thread David Fetter
intent vs. effect. Do you want some help with creating same? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] Issue: Deprecation of the XML2 module 'xml_is_well_formed' function

2010-06-28 Thread David Fetter
; EXCEPTION WHEN invalid_xml_document THEN RETURN false; END; $$; While tracking this down, I didn't see a way to get SQLSTATE or the corresponding condition name via psql. Is this an oversight? A bug, perhaps? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-10 Thread David Fetter
to the docs for this, as they get written. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-10 Thread David Fetter
On Sat, Jul 10, 2010 at 09:26:38AM -0700, David Fetter wrote: On Sat, Jul 10, 2010 at 11:52:31AM +0200, Andres Freund wrote: On Fri, Jul 09, 2010 at 11:33:04PM -0400, Robert Haas wrote: On Fri, Jul 9, 2010 at 10:25 PM, Boxuan Zhai bxzhai2...@gmail.com wrote: Dear All

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-10 Thread David Fetter
already? Oops. Fixed that now in attached patch. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-10 Thread David Fetter
On Sat, Jul 10, 2010 at 10:39:02AM -0700, David Fetter wrote: On Sat, Jul 10, 2010 at 01:18:49PM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: Though, if the worst problem with this patch is the formatting, we're doing *quite* well. Well, the worst problem

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-10 Thread David Fetter
On Sat, Jul 10, 2010 at 01:53:53PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: By the way, make check fails here with attached initdb.log: creating system views ... FATAL: unrecognized token: false Hm, I'd suspect something fouled up in keyword recognition. Did you do

Re: [HACKERS] cross column correlation revisted

2010-07-15 Thread David Fetter
of all our competition, both free and proprietary. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread David Fetter
! In two words, HELL, YES! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread David Fetter
;) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread David Fetter
to remember or guess. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [HACKERS] SHOW TABLES

2010-07-16 Thread David Fetter
this in the backend? Yes. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [HACKERS] SHOW TABLES

2010-07-16 Thread David Fetter
. Such backend stuff is in every RDBMS except ours. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] SHOW TABLES

2010-07-19 Thread David Fetter
of the beast. I don't think it's as bad as is made out, however, as \d covers 99% of everyday usage and certainly the show tables that started this thread. It covers 0% of cases where people are not using psql. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] SHOW TABLES

2010-07-19 Thread David Fetter
into a JTable for Java Swing applications. If a client gets back a series of result sets, the sky is the limit. Ad astra per PostgreSQL! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

[HACKERS] Patch review: make RAISE without arguments work like Oracle

2010-07-19 Thread David Fetter
in the context of the project as a whole: * Is everything done in a way that fits together coherently with other features/modules? Yes. * Are there interdependencies that can cause problems? Not that I've found, except as noted above re: apps based on the previous behavior. -- David

Re: [HACKERS] sql/med review - problems with patching

2010-07-20 Thread David Fetter
is complex, especially when the DML for that data source is different from PostgreSQL's DML. Do you have some ideas as to how to solve this problem in general? In this case? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Status report on writeable CTEs

2010-07-20 Thread David Fetter
. How much work would that part be? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] patch: to_string, to_array functions

2010-07-22 Thread David Fetter
/unserialize? Because that's not what the function actually does. FWIW, I'm for (im|ex)plode, as join()/split(), which I'd otherwise like, would run into too many issues with JOIN. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Rewrite, normal execution vs. EXPLAIN ANALYZE

2010-07-23 Thread David Fetter
taken when the EXPLAIN started. Did I misunderstand the code? And if I didn't, why do we do this differently? You mentioned in IRC that this was in aid of getting wCTEs going. How are these things connected? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] Rewrite, normal execution vs. EXPLAIN ANALYZE

2010-07-23 Thread David Fetter
by T2 to baz while in the regular execution scenario it does. Well that's gotta be a bug, but in what I'm not sure. I've said it before, and I'll say it again. User-accessible RULEs are themselves a bug :P Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Review: Re: [PATCH] Re: [HACKERS] Adding xpath_exists function

2010-07-27 Thread David Fetter
-- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org

Re: [HACKERS] GROUPING SETS revisited

2010-08-03 Thread David Fetter
-debug --enable-cassert make Log from that also enclosed. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] merge command - GSoC progress

2010-08-03 Thread David Fetter
in Postgres Wiki. I explain the details of my implementation and a set of testing examples. Can someone help Boxuan with how to write regression tests? Happy to. I'll start this evening PDT or tomorrow :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] review: psql: edit function, show function commands patch

2010-08-04 Thread David Fetter
for an overriding psql variable, drops through to look for an environment variable, and then to a sane default, for some reasonable value of sane. Perhaps this default could depend on OS (Windows vs. Everything Else) to start with. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread David Fetter
... er.. man witch... warlock? Witch. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread David Fetter
an opinion on making this change: for: tgl, josh, badalex, mmoncure against: rhaas, thom Anybody else want to vote, or change their vote after seeing the patch? +1 for removing the single-argument version. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] pg_stat_user_functions' notion of user

2010-08-05 Thread David Fetter
exclude builtin functions of language SQL. Is there a reason for this inconsistency? If I had to hazard a guess, it would be that the functionality was written over time by different people, not all of whom were using the same criteria for coherence. Cheers, David. -- David Fetter da

Re: [HACKERS] MERGE Specification

2010-08-05 Thread David Fetter
/src/sgml make Then you can point a web browser at the doc/src/sgml/html/index.html (and similar) http://www.postgresql.org/docs/current/static/docguide.html has information about the tools you will need for the above to work. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] Initial review of xslt with no limits patch

2010-08-06 Thread David Fetter
afraid, ... using a variadic function isn't too much nice now some xslt_process(xmlsrc, 'n1=v1','n2=v2','n3=v3' This sounds like the perfect case for pulling hstore into core code. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] including backend ID in relpath of temp rels - updated patch

2010-08-06 Thread David Fetter
be for temp tables to not have persistent catalog entries in the first place. For the upcoming global temp tables, which are visible in other sessions, how would this work? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] Initial review of xslt with no limits patch

2010-08-06 Thread David Fetter
, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] pg_stat_user_functions' notion of user

2010-08-08 Thread David Fetter
On Sun, Aug 08, 2010 at 03:25:06PM +0300, Peter Eisentraut wrote: On tor, 2010-08-05 at 07:13 -0700, David Fetter wrote: On Thu, Aug 05, 2010 at 04:58:32PM +0300, Peter Eisentraut wrote: pg_stat_user_functions has an inconsistent notion of what user is. Whereas the other pg_stat_user_

Re: [HACKERS] is syntax columname(tablename) necessary still?

2010-08-09 Thread David Fetter
. The cube contrib module was only ever meant to be replaced by the real feature, which you're working on, so +1 for dropping everything in it that you are not replacing with the one which complies with the SQL standard. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] more personal copyrights

2010-08-09 Thread David Fetter
the copyrights in the code base to the standard we set. I can even see this becoming a commit- or push- hook. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] is syntax columname(tablename) necessary still?

2010-08-09 Thread David Fetter
On Mon, Aug 09, 2010 at 02:23:55PM +0100, Greg Stark wrote: On Mon, Aug 9, 2010 at 2:02 PM, David Fetter da...@fetter.org wrote: I am working on Grouping Sets support. The first issue is cube keyword. Contrib module cube define a few functions cube. So if we want to continue in support

Re: [HACKERS] knngist - 0.8

2010-08-09 Thread David Fetter
of the CFs. Unfortunately, I don't have time for it ATM. Do you have enough of it to send out as WIP? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] pg_restore should accept multiple -t switches?

2010-08-10 Thread David Fetter
. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] patch: Add JSON datatype to PostgreSQL (GSoC, WIP)

2010-08-11 Thread David Fetter
JSON code should go into core is up for discussion. Thoughts, anyone? +1 for putting it in core in 9.1 :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] patch: Add JSON datatype to PostgreSQL (GSoC, WIP)

2010-08-11 Thread David Fetter
On Wed, Aug 11, 2010 at 03:40:36PM -0700, Joshua D. Drake wrote: On Wed, 2010-08-11 at 15:27 -0700, David Fetter wrote: I've been developing it as a contrib module because: * I'd imagine it's easier than developing it as a built-in datatype right away (e.g. editing a .sql.in file

<    3   4   5   6   7   8   9   10   11   12   >