Re: [HACKERS] UNNEST ... WITH ORDINALITY (AND POSSIBLY OTHER STUFF)

2010-11-19 Thread David Fetter
(AND POSSIBLY OTHER STUFF) On Fri, Nov 19, 2010 at 11:40:05AM +0900, Itagaki Takahiro wrote: On Fri, Nov 19, 2010 at 08:33, David Fetter da...@fetter.orgmailto:da...@fetter.org wrote: In order to get WITH ORDINALITY, would it be better to change gram.y to account for both WITH ORDINALITY

Re: [HACKERS] UNNEST ... WITH ORDINALITY (AND POSSIBLY OTHER STUFF)

2010-11-19 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

[HACKERS] UNNEST ... WITH ORDINALITY (AND POSSIBLY OTHER STUFF)

2010-11-18 Thread David Fetter
and without, or just for the WITH ORDINALITY case? Also, there's been some enthusiasm for a different kind of enhancement of UNNEST, which would go something like this: UNNEST(anyarray, number_of_dimensions_to_unnest) That'd probably be a separate patch, though. Cheers, David. -- David Fetter da

Re: [HACKERS] UNNEST ... WITH ORDINALITY (AND POSSIBLY OTHER STUFF)

2010-11-18 Thread David Fetter
On Fri, Nov 19, 2010 at 11:40:05AM +0900, Itagaki Takahiro wrote: On Fri, Nov 19, 2010 at 08:33, David Fetter da...@fetter.org wrote: In order to get WITH ORDINALITY, would it be better to change gram.y to account for both WITH ORDINALITY and without, or just for the WITH ORDINALITY case

Re: [HACKERS] Indent authentication overloading

2010-11-17 Thread David Fetter
it would've been much better to do it years ago. That doesn't mean we shouldn't at least *consider* doing it at some point. The sooner, the better, IMHO. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] unlogged tables

2010-11-17 Thread David Fetter
VOLATILE for UNSYNCED? Not sure about UNLOGGED. +1 for describing the end-user-visible behavior. 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

Re: [HACKERS] unlogged tables

2010-11-17 Thread David Fetter
THAT EXPLAIN THE DETAILS GO HERE; How about something like: OPTIONS (SYNC=no, LOG=no, ... ) 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] unlogged tables

2010-11-16 Thread David Fetter
--omit-unlogged-data. Are you sure we don't want to default the other way? +1 for defaulting the other way. 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] unlogged tables

2010-11-16 Thread David Fetter
On Tue, Nov 16, 2010 at 02:07:35PM -0800, David Fetter wrote: On Tue, Nov 16, 2010 at 02:00:33PM -0800, Josh Berkus wrote: Yeah, you'd have to allow a flag to control the behavior. And in that case I'd rather the flag have a single default rather than different defaults depending

Re: [HACKERS] MULTISET and additional functions for ARRAY

2010-11-15 Thread David Fetter
of optimizing at all. Could we maybe see about optimizing the 99% case, which those two bits cover? 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] wCTE behaviour

2010-11-14 Thread David Fetter
once. So: WITH t AS (INSERT INTO foo VALUES (0) RETURNING *) SELECT 1 FROM t t1, t t2; would only insert one row in any case. Right :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] wCTE behaviour

2010-11-14 Thread David Fetter
)); runs the cte two times, hence two new rows in foo. I think we can worry about that if we ever have run-time functions done as WITH, but I think they'd be a *much* better fit for DO. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] SSI update

2010-11-14 Thread David Fetter
list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- 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] wCTE behaviour

2010-11-13 Thread David Fetter
On Sat, Nov 13, 2010 at 02:28:35PM +0100, Yeb Havinga wrote: On 2010-11-12 16:51, David Fetter wrote: On Fri, Nov 12, 2010 at 10:25:51AM -0500, Tom Lane wrote: Yeah, that's another interesting question: should we somehow force unreferenced CTEs to be evaluated anyhow? Yes. After a night's

Re: [HACKERS] wCTE behaviour

2010-11-13 Thread David Fetter
FROM foo RETURNING *) SELECT 1 WHERE false; WITH t AS (DELETE FROM foo RETURNING *) SELECT 1 FROM t LIMIT 0; No. 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

Re: [HACKERS] wCTE behaviour

2010-11-13 Thread David Fetter
On Sat, Nov 13, 2010 at 03:23:42PM +0100, Yeb Havinga wrote: On 2010-11-13 14:41, David Fetter wrote: On Sat, Nov 13, 2010 at 02:28:35PM +0100, Yeb Havinga wrote: 1) the name Common Table Expression suggests that t must be regarded as an expression, hence syntactically / proof theoretic

Re: [HACKERS] wCTE behaviour

2010-11-12 Thread David Fetter
that as an implementation detail, not as part of the specification. Right :) 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] wCTE behaviour

2010-11-12 Thread David Fetter
to be really confusing, I fear. Yes, and as we add more things--COPY is the first but probably not the last--to CTEs, this no action-at-a-distance behavior will become even more important. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] MULTISET and additional functions for ARRAY

2010-11-12 Thread David Fetter
, and I've started a separate thread on this along with a page on the wiki. 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

[HACKERS] Refactoring the Type System

2010-11-12 Thread David Fetter
. To that end, I've put up a page on the wiki that includes a list of issues to be addressed. It's intended to be changed, possibly completely. http://wiki.postgresql.org/wiki/Refactor_Type_System What might the next version of the type system look like? Cheers, David. -- David Fetter da

Re: [HACKERS] wCTE behaviour

2010-11-12 Thread David Fetter
and forward-reference issue, we can just forbid them in DML CTE at first. Sounds good :) 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

Re: [HACKERS] wCTE behaviour

2010-11-11 Thread David Fetter
of previous CTEs, just as current non-writeable ones do. A lot of the useful cases for this feature depend on this visibility. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] wCTE behaviour

2010-11-11 Thread David Fetter
way that different data modifications made in a single INSERT/UPDATE/DELETE command are considered to be made simultaneously. +1 -1. When people want to see what has gone before, they can use RETURNING clauses. With the indeterminate order proposal, they cannot. Cheers, David. -- David

Re: [HACKERS] wCTE behaviour

2010-11-11 Thread David Fetter
table, so as less-rolled data get deleted, they get aggregated into an INSERT into that table. Think of RRDtool, only with a real data store. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] multi-platform, multi-locale regression tests

2010-11-10 Thread David Fetter
you wanted, was clearly the right choice. Hopefully we can have the build farm animals run the dcheck target once SSI is committed. Does Perl have some kind of concurrency-controlled test framework? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] W3C Specs: Web SQL

2010-11-08 Thread David Fetter
),generate_series(1,100),...; ... and that was *before* CTEs made SQL Turing-complete. 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

Re: [HACKERS] Query Plan Columns

2010-11-06 Thread David Fetter
best to separate the node descriptions from the adjacency list that links them together. 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

Re: [HACKERS] Tab completion for view triggers in psql

2010-10-29 Thread David Fetter
On Tue, Oct 26, 2010 at 11:55:07AM +0900, Itagaki Takahiro wrote: On Tue, Oct 26, 2010 at 11:34 AM, David Fetter da...@fetter.org wrote: Do we need to 'add' it? Possibly.  My understanding is that it couldn't really replace it. Ah, I see. I was wrong. We can have modification privileges

Re: [HACKERS] Tab completion for view triggers in psql

2010-10-26 Thread David Fetter
On Tue, Oct 26, 2010 at 12:35:13PM +0100, Dean Rasheed wrote: On 25 October 2010 21:01, David Fetter da...@fetter.org wrote: Folks, Please find attached patch for $subject :) Thanks for looking at this. I forgot about tab completion. I think that the change to ALTER TRIGGER

[HACKERS] EOCF

2010-10-26 Thread David Fetter
Folks, I just realized I hadn't closed out the commitfest earlier. Have done so. 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

Re: [HACKERS] Range Types, discrete and/or continuous

2010-10-25 Thread David Fetter
range types, we can do the basic research that would involve, etc., later. 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] Range Types, discrete and/or continuous

2010-10-25 Thread David Fetter
On Mon, Oct 25, 2010 at 10:21:49AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Sun, Oct 24, 2010 at 06:59:34PM -0400, Tom Lane wrote: Put me in the camp that says you need both. I really seriously dislike the idea of representing [1, 2) as [1, 2-epsilon], mainly

[HACKERS] Tab completion for view triggers in psql

2010-10-25 Thread David Fetter
Folks, Please find attached patch for $subject :) 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] Tab completion for view triggers in psql

2010-10-25 Thread David Fetter
On Tue, Oct 26, 2010 at 10:30:49AM +0900, Itagaki Takahiro wrote: On Tue, Oct 26, 2010 at 5:01 AM, David Fetter da...@fetter.org wrote: Please find attached patch for $subject :) Thank you for maintaining psql tab completion, but I'm not sure whether tgtype is the best column

Re: [HACKERS] Tab completion for view triggers in psql

2010-10-25 Thread David Fetter
On Tue, Oct 26, 2010 at 11:10:53AM +0900, Itagaki Takahiro wrote: On Tue, Oct 26, 2010 at 10:53 AM, David Fetter da...@fetter.org wrote: How about has_table_privilege() to filter candidate relations That's orthogonal to tgtype (snip) Shall I send a new patch with that added? Do we need

Re: [HACKERS] xlog.c: WALInsertLock vs. WALWriteLock

2010-10-23 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] Custom aggragation function that creates an array

2010-10-22 Thread David Fetter
looked over what's in contrib/intarray ? 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] PostgreSQL and HugePage

2010-10-21 Thread David Fetter
the aforementioned largish machine to test it on :) 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] WIP: extensible enums

2010-10-20 Thread David Fetter
from EDB have mentioned that slimming down the on-disk representation was one such target. What other ones would you see as needing such attention? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] How to determine failed connection attempt due to invalid authorization (libpq)?

2010-10-19 Thread David Fetter
On Mon, Oct 18, 2010 at 07:26:32AM -0700, David Fetter wrote: On Mon, Oct 18, 2010 at 10:18:25AM -0400, Robert Haas wrote: On Mon, Oct 18, 2010 at 10:05 AM, David Fetter da...@fetter.org wrote: On Mon, Oct 18, 2010 at 10:03:55AM -0400, Robert Haas wrote: On Sun, Oct 17, 2010 at 2:03 AM

Re: [HACKERS] knngist - 0.8

2010-10-19 Thread David Fetter
On Mon, Oct 18, 2010 at 04:13:04PM +0100, Mark Cave-Ayland wrote: David Fetter wrote: For my vote, I'd prefer either the Oid of a custom type or an array of Oid, Datum pairs - i.e. something we can extend in the future if required. This sounds a lot like a foreign key to another table

Re: [HACKERS] knngist - 0.8

2010-10-18 Thread David Fetter
either the Oid of a custom type or an array of Oid, Datum pairs - i.e. something we can extend in the future if required. This sounds a lot like a foreign key to another table. Are you not proposing doing that because of performance considerations? Cheers, David. -- David Fetter da

Re: [HACKERS] How to determine failed connection attempt due to invalid authorization (libpq)?

2010-10-18 Thread David Fetter
it. A quick glance at the code reveals that a PGresult can store individual error fields but a PGconn can store only a message. :-( Does this seem worth patching for 9.1? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] How to determine failed connection attempt due to invalid authorization (libpq)?

2010-10-18 Thread David Fetter
On Mon, Oct 18, 2010 at 10:18:25AM -0400, Robert Haas wrote: On Mon, Oct 18, 2010 at 10:05 AM, David Fetter da...@fetter.org wrote: On Mon, Oct 18, 2010 at 10:03:55AM -0400, Robert Haas wrote: On Sun, Oct 17, 2010 at 2:03 AM, Dmitriy Igrishin dmit...@gmail.com wrote: I've asked pgsql

Re: [HACKERS] Fate of the old cvs repository

2010-10-17 Thread David Fetter
else? +1 for dropping a tarball on the FTP mirrors. That way it's distributed and hard to lose. :) 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] Extensions, this time with a patch

2010-10-17 Thread David Fetter
not clear enough from context. 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] Timeline in the light of Synchronous replication

2010-10-17 Thread David Fetter
, forcing to create a new standby from scratch because of time lines might not be very desirable if the database is huge. One way to get them in sync without starting from scratch is to use rsync from A to B. This works in the asynchronous case, too. :) Cheers, David. -- David Fetter da

Re: [HACKERS] [GENERAL] pg_filedump binary for CentOS

2010-10-15 Thread David Fetter
On Thu, Oct 14, 2010 at 05:53:30PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Should we consider moving pg_filedump into our /contrib? Can't: it's GPL. Depends on whether we can get it relicensed. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] [JDBC] Support for JDBC setQueryTimeout, et al.

2010-10-14 Thread David Fetter
like to see this submitted. Perhaps they'd like to participate :) 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] How to reliably detect if it's a promoting standby

2010-10-14 Thread David Fetter
://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Extensions, this time with a patch

2010-10-13 Thread David Fetter
might find necessary to run. As people will want to up- or downgrade extensions to a particular version, this should probably be something more like ALTER EXTENSION ... SET VERSION [version number | LATEST | PREVIOUS ]... or something like that. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Extensions, this time with a patch

2010-10-13 Thread David Fetter
and test downgrade code are much less likely to have their upgrades cause such failures in the first place, but there's not much to do about that. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] [JDBC] Support for JDBC setQueryTimeout, et al.

2010-10-12 Thread David Fetter
On Tue, Oct 12, 2010 at 04:04:56AM -0500, Radosław Smogura wrote: On Mon, 11 Oct 2010 08:29:16 -0500, Kevin Grittner kevin.gritt...@wicourts.gov wrote: David Fetter da...@fetter.org wrote: Please find enclosed a WIP patch from one of my co-workers intended to support JDBC's

Re: [HACKERS] [JDBC] Support for JDBC setQueryTimeout, et al.

2010-10-12 Thread David Fetter
On Tue, Oct 12, 2010 at 10:37:00AM -0500, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: Is there something incomplete about the ones I sent, and if so, what? Well, I'm still curious why it was necessary to modify the server side to implement an interface feature for which

Re: [HACKERS] Debugging initdb breakage

2010-10-12 Thread David Fetter
helped a few times that there has been no PANIC but just a FATAL or ERROR, for example. It's easy to attach GDB to such a backend. Nice tip, thanks! Where should we preserve this, other than the mailing list archives? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

[HACKERS] Support for JDBC setQueryTimeout, et al.

2010-10-11 Thread David Fetter
/todo.html 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

Re: [HACKERS] Which file does the SELECT?

2010-10-11 Thread David Fetter
On Mon, Oct 11, 2010 at 04:14:04PM +0530, Vaibhav Kaushal wrote: Is there something like that in Kdevelop? I dont use CLI editors much. KDevelop is listed as one of the editors that support ctags. http://en.wikipedia.org/wiki/Ctags Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] is sync rep stalled?

2010-10-01 Thread David Fetter
, it's gotten a little trite. The cool kids are keeping things pretty public these days when they plan to go public. -- 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: SQL/MED(FDW) DDL

2010-10-01 Thread David Fetter
to be PostgreSQL. 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] patch: SQL/MED(FDW) DDL

2010-10-01 Thread David Fetter
On Fri, Oct 01, 2010 at 10:54:47AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Thu, Sep 30, 2010 at 10:29:56PM -0400, Robert Haas wrote: Yeah, that might be better. Is it reasonable to assume we always want to push down as much as possible, or do we need to think about

Re: [HACKERS] is sync rep stalled?

2010-09-30 Thread David Fetter
SR in 9.1, and you among others will be very unhappy. So yes, it is stalled, and yes, there's a real urgency to actually getting a baseline something in there in the next couple of weeks. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] is sync rep stalled?

2010-09-30 Thread David Fetter
On Thu, Sep 30, 2010 at 09:52:46AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Thu, Sep 30, 2010 at 09:14:42AM +0100, Simon Riggs wrote: I don't see anything has stalled. I do. We're half way through this commitfest, so if no one's actually ready to commit one

[HACKERS] Commitfest: The Good, The Bad, and the Ugly

2010-09-28 Thread David Fetter
step 5 is not doable, let me know. If you think it is, this is your chance to help make it happen. Write back either way. Cheers, David. [1] If you do have them, help out with step 6, too. [2] If you are one, help out with step 6, too. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] trailing whitespace in psql table output

2010-09-27 Thread David Fetter
care about changing the expected output, we can just trim the whitespace as Peter suggested originally. I must be missing something pretty crucial here as far as the complexity of changing all the regression tests. Wouldn't trimming all trailing whitespace do the trick? Cheers, David. -- David

Re: [HACKERS] trailing whitespace in psql table output

2010-09-27 Thread David Fetter
On Mon, Sep 27, 2010 at 03:11:07PM -0400, Robert Haas wrote: On Mon, Sep 27, 2010 at 2:09 PM, David Fetter da...@fetter.org wrote: On Mon, Sep 27, 2010 at 01:53:45PM -0400, Robert Haas wrote: On Mon, Sep 27, 2010 at 1:34 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread David Fetter
. You probably could. I'm very doubtful it's worth it... Back to a question you asked earlier, what exactly still depends on CVS right now, as in which buildfarm animals, what parts of the NLS processes? Also as you asked earlier, what else? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Git cvsserver serious issue

2010-09-23 Thread David Fetter
On Thu, Sep 23, 2010 at 11:17:35AM -0400, Andrew Dunstan wrote: On 09/23/2010 10:58 AM, David Fetter wrote: Back to a question you asked earlier, what exactly still depends on CVS right now, as in which buildfarm animals, what parts of the NLS processes? Also as you asked earlier, what

Re: [HACKERS] wip: functions median and percentile

2010-09-23 Thread David Fetter
way to do this using the same code in the windowing and non-windowing case, that would be much, much better from an architectural point of view. Single Point of Truth and all that. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

[HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread David Fetter
requirements. What say? 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] Another Modest Proposal: Platforms

2010-09-22 Thread David Fetter
On Wed, Sep 22, 2010 at 04:28:04PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: We can start by supporting only platforms git runs on, this being the first in what I'd picture as a set of base requirements. Sounds like allowing the tail to wag the dog. Runs git is actually

Re: [HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread David Fetter
On Wed, Sep 22, 2010 at 02:02:18PM -0700, Joshua D. Drake wrote: On Wed, 2010-09-22 at 13:58 -0700, David Fetter wrote: On Wed, Sep 22, 2010 at 04:28:04PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: We can start by supporting only platforms git runs on, this being

Re: [HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread David Fetter
a buildfarm animal with your development environment on it isn't. 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] Shutting down server from a backend process, e.g. walrceiver

2010-09-21 Thread David Fetter
a message to it so it can take appropriate action on the node, starting with shutting it down? 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

Re: [HACKERS] trailing whitespace in psql table output

2010-09-21 Thread David Fetter
trailing whitespace in the table headers, I think removing trailing whitespace in headers itself is reasonable, but the change breaks almost all of regression tests. Will we adjust expected results for the change? On its face, this doesn't seem like a hard change to make. Cheers, David. -- David

Re: [HACKERS] Path question

2010-09-20 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

[HACKERS] Day 01/31

2010-09-16 Thread David Fetter
to be a great commitfest. Now, to work! At the time of this writing, 21 patches have Nobody reviewing them. That's 21 more than we need. I'll start assigning the ones unpicked tomorrow morning :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] can we publish a aset interface?

2010-09-16 Thread David Fetter
for Czech language. People who need fast processing just use a simple dictionary - and probably there are not any pg hacker from Poland or Slovakia. I know of at least one in Poland, and I'd be amazed if there were none from Slovakia. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] Re: [COMMITTERS] pgsql: Use a latch to make startup process wake up and replay

2010-09-15 Thread David Fetter
all work on anything you might chance to think about. It is quite simply never going to happen, so you need to back off. 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

[HACKERS] Last Call for 9/15

2010-09-15 Thread David Fetter
Folks, If you've got a patch you want to have as part of this commitfest and it's not already on the page, you have until 2200 PST8PDT to get it on there. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] pg_ctl emits strange warning message

2010-09-14 Thread David Fetter
, David (Commitfest Cat Herd of the Month). -- 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] Synchronous replication - patch status inquiry

2010-09-14 Thread David Fetter
in the backend, walsender, startup process and walreceiver. If a latch feature Heikki proposed will have been committed, I'll replace that with a latch. Now that the latch patch is in, when do you think you'll be able to use it instead of the poll loop? Cheers, David. -- David Fetter da

[HACKERS] Commitfest September 2010 Plans and Call for Reviewers

2010-09-12 Thread David Fetter
in the Reviewers column. https://commitfest.postgresql.org/action/commitfest_view?id=7 Let's make 5771[1] PostgreSQL's best year yet! Cheers, David. [1] That's the Jewish year just begun. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Synchronization levels in SR

2010-09-08 Thread David Fetter
mentioning cos its just the Byzantine Generals problem. For completeness, a reference to the aforementioned Byzantine Generals: http://en.wikipedia.org/wiki/Byzantine_fault_tolerance Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

[HACKERS] Freezing per-role settings

2010-09-07 Thread David Fetter
ROLE read_only FREEZE transaction_isolation; I'd think of the reverse of each of these as GRANT and ALTER ... THAW, respectively. Is anyone else interested in such a feature? If so, is it more DCL-ish, or more DDL-ish? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [HACKERS] Freezing per-role settings

2010-09-07 Thread David Fetter
On Tue, Sep 07, 2010 at 12:41:51PM -0700, Jeff Davis wrote: On Tue, 2010-09-07 at 11:39 -0700, David Fetter wrote: We'd like to create a role called read_only, with eponymous capability. Seems useful. Great to hear :) If so, is it more DCL-ish, or more DDL-ish? I don't like

Re: [HACKERS] Freezing per-role settings

2010-09-07 Thread David Fetter
On Tue, Sep 07, 2010 at 02:43:12PM -0700, Jeff Davis wrote: On Tue, 2010-09-07 at 13:30 -0700, David Fetter wrote: Offhand, I'm not thinking of past examples of mutating/disappearing GUC that people would want to freeze, nor of a new GUC that would negate or substantially alter

Re: [HACKERS] 9.1alpha1 bundled -- please verify

2010-09-06 Thread David Fetter
be here as with previous builds: http://www.enterprisedb.com/products/pgdevdownload.do I hate to mention this at this late date, but it just occurred to me that the ordering is Alpha, then Beta, then Release Candidates, then Release. Did I get that wrong? Cheers, David. -- David Fetter da

Re: [HACKERS] git: uh-oh

2010-09-06 Thread David Fetter
of recording ignorance (other than NULL, that is ;) 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] 9.1alpha1 bundled -- please verify

2010-09-06 Thread David Fetter
On Mon, Sep 06, 2010 at 01:11:03PM -0700, David Fetter wrote: On Mon, Sep 06, 2010 at 08:07:33PM +0100, Dave Page wrote: On Mon, Sep 6, 2010 at 7:41 PM, Peter Eisentraut pete...@gmx.net wrote: On mån, 2010-09-06 at 19:38 +0100, Dave Page wrote: On Mon, Sep 6, 2010 at 6:54 PM, Peter

Re: OT: OFF TOPIC: [HACKERS] returning multiple result sets from a stored procedure

2010-09-06 Thread David Fetter
if you decide to do the work to fix them, and by the time you've done that work, your youth will also be waning ;) 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

Re: [HACKERS] regclass without error?

2010-09-03 Thread David Fetter
* Detecting errors * Issuing ROLLBACKs to the aforementioned SAVEPOINT None of this works super well for a bulk load. 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

[HACKERS] Windows Tools

2010-09-03 Thread David Fetter
Hello, At work, I've been tasked with providing some Windows connection libraries, etc. Are people still using MinGW, or should I just recommend using a proprietary toolkit to do the builds? If so, which one(s)? Cheers, David (Windows n00b) -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] regclass without error?

2010-09-03 Thread David Fetter
; -- if it works RELEASE my_savepoint; -- if it fails ROLLBACK TO my_savepoint; RELEASE my_savepoint; Granted, it's not super-performant ... We have no mechanism to do this, or any other check, during a bulk load. It'd be a great feature to have :) Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] Windows Tools

2010-09-03 Thread David Fetter
On Fri, Sep 03, 2010 at 06:24:06PM +0200, Magnus Hagander wrote: On Fri, Sep 3, 2010 at 17:18, Dave Page dp...@pgadmin.org wrote: On Fri, Sep 3, 2010 at 4:11 PM, David Fetter da...@fetter.org wrote: Hello, At work, I've been tasked with providing some Windows connection libraries, etc

Re: [HACKERS] array_agg() NULL Handling

2010-09-01 Thread David Fetter
for removing the NULLs. WHERE clause :P 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] Synchronous replication - patch status inquiry

2010-08-31 Thread David Fetter
, but things still seem unclear. Do we have a final agreed upon patch that I can use? Any links for that? No. That was a mite brusque and not super informative. There are patches, and the latest from Fujii Masao is probably worth looking at :) Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] string function - format function proposal

2010-08-31 Thread David Fetter
On Tue, Aug 31, 2010 at 11:07:40PM +0200, Pavel Stehule wrote: Hello attached WIP patch. I don't see it attached. Is it just me? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Synchronous replication - patch status inquiry

2010-08-31 Thread David Fetter
On Tue, Aug 31, 2010 at 08:34:31PM -0400, Robert Haas wrote: On Tue, Aug 31, 2010 at 6:24 PM, David Fetter da...@fetter.org wrote: On Tue, Aug 31, 2010 at 05:44:15PM -0400, Bruce Momjian wrote: fazool mein wrote: Hello everyone, I'm interested in benchmarking synchronous replication

Re: [HACKERS] EXPLAIN doesn't show the actual function expression for FunctionScan

2010-08-24 Thread David Fetter
On Tue, Aug 24, 2010 at 10:40:30AM -0400, Tom Lane wrote: So I got annoyed by $SUBJECT just now while chasing Wheeler's bug report. Seems like this would be a good thing to print. Should it appear always, or just with VERBOSE, or ??? +1 for always. Cheers, David. -- David Fetter da

Re: [HACKERS] EXPLAIN doesn't show the actual function expression for FunctionScan

2010-08-24 Thread David Fetter
), ROW('1.2.23', '=', '1.2.23')]) (3 rows) Look reasonable? This would have helped me a good deal a couple of times this week :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

<    5   6   7   8   9   10   11   12   13   14   >