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

2010-08-11 Thread David Fetter
On Wed, Aug 11, 2010 at 07:39:37PM -0400, Andrew Dunstan wrote: On 08/11/2010 07:33 PM, David Fetter wrote: I would be curious to the benefit of putting it in core. I have no problem with the type but in core? If it's not in core, the vast majority of users will not have it installed

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

2010-08-12 Thread David Fetter
unbelievably illegible -u format patches are?). I have every confidence that you, of all people, can arrange to use 'filterdiff --format=context' on attached patches automatically, saving you some time and us some boredom :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

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

2010-08-12 Thread David Fetter
On Thu, Aug 12, 2010 at 09:53:54AM -0700, Joshua D. Drake wrote: On Thu, 2010-08-12 at 09:44 -0700, David Fetter wrote: On Thu, Aug 12, 2010 at 12:27:45PM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: Here's an updated patch, with the invalidation changes merged

Re: [HACKERS] patch: General purpose utility functions used by the JSON data type

2010-08-13 Thread David Fetter
frequently just there. As we're improving enums (allowing them to be altered easily after creation, etc.), it seems reasonable to provide ways to return them from all kinds of PLs, including making this easier in C. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] patch: General purpose utility functions used by the JSON data type

2010-08-13 Thread David Fetter
On Fri, Aug 13, 2010 at 01:33:06PM -0400, Robert Haas wrote: On Fri, Aug 13, 2010 at 1:05 PM, David Fetter da...@fetter.org wrote: On Fri, Aug 13, 2010 at 12:59:48PM -0400, Robert Haas wrote: On Fri, Aug 13, 2010 at 12:55 PM, Joseph Adams joeyadams3.14...@gmail.com wrote: Indeed, a built

Re: [HACKERS] Proposal / proof of concept: Triggers on VIEWs

2010-08-16 Thread David Fetter
to be added to VIEWs: http://archives.postgresql.org/pgsql-hackers/2010-08/msg01030.php Comments welcome. Please add this to the next commitfest :) https://commitfest.postgresql.org/action/commitfest_view?id=7 Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread David Fetter
On Mon, Aug 16, 2010 at 02:25:50PM -0400, Robert Haas wrote: On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada umi.tan...@gmail.com wrote: We (Marko, David Fetter and I) discussed on IRC about design of writeable CTEs. It does and will contain not only syntax but also miscellaneous

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread David Fetter
On Mon, Aug 16, 2010 at 04:34:07PM -0400, Robert Haas wrote: On Mon, Aug 16, 2010 at 3:00 PM, David Fetter da...@fetter.org wrote: There has been previous talk of allowing WITH (COPY ...) and I am personally of the opinion that it would be nice to be able to do WITH (EXPLAIN ...).  DDL

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-18 Thread David Fetter
several different medians, each with distinguishing names? 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] proposal: tuplestore, tuplesort aggregate functions

2010-08-18 Thread David Fetter
On Wed, Aug 18, 2010 at 04:10:18PM +0200, Pavel Stehule wrote: 2010/8/18 David Fetter da...@fetter.org: Which median do you plan to implement?  Or do you plan to implement several different medians, each with distinguishing names? my proposal enabled implementation of any median like

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-18 Thread David Fetter
On Wed, Aug 18, 2010 at 10:39:33AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: Apart from the medians, which median-like aggregates do you have in mind to start with? If you can provide examples of median-like aggregates that people might need to implement as user-defined

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-18 Thread David Fetter
On Wed, Aug 18, 2010 at 04:46:57PM +0200, Pavel Stehule wrote: 2010/8/18 Tom Lane t...@sss.pgh.pa.us: David Fetter da...@fetter.org writes: Apart from the medians, which median-like aggregates do you have in mind to start with?  If you can provide examples of median-like aggregates

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-19 Thread David Fetter
, as there is no single, authoritative median. 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] Fw: patch for pg_ctl.c to add windows service start-type

2010-08-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

Re: [HACKERS] wip: functions median and percentile

2010-08-19 Thread David Fetter
, but the perfect is the enemy of the good. Percentile is already there as NTILE, a windowing function. Median may be useful, but we pretty much can't just call it median. Instead, we need to call it something like left_median or arithmetic_median. Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] wip: functions median and percentile

2010-08-19 Thread David Fetter
On Thu, Aug 19, 2010 at 12:12:12PM -0500, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: Median may be useful, but we pretty much can't just call it median. Instead, we need to call it something like left_median or arithmetic_median. I think it would be reasonable

Re: [HACKERS] wip: functions median and percentile

2010-08-19 Thread David Fetter
On Thu, Aug 19, 2010 at 01:25:36PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Thu, Aug 19, 2010 at 12:12:12PM -0500, Kevin Grittner wrote: http://www.merriam-webster.com/dictionary/median If you do a google search for median and poke around, you'll find many places

Re: [HACKERS] Fw: patch for pg_ctl.c to add windows service start-type

2010-08-19 Thread David Fetter
, the a and d values seem to be accepted but not documented. D'oh! Changed patch enclosed. Now in context format :) 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

Re: [HACKERS] Fw: patch for pg_ctl.c to add windows service start-type

2010-08-19 Thread David Fetter
thing -- why is there an enum at all? Seems it'd be simpler to assign the right value to the variable in the getopt() code to start with. That's a question for the patch author. I was just cleaning up the docs :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-19 Thread David Fetter
being the case above. We could just go with whatever Oracle, DB2 and MS-SQL Server have, assuming it's the same thing, until something appears in the SQL standard. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] proposal: tuplestore, tuplesort aggregate functions

2010-08-19 Thread David Fetter
On Thu, Aug 19, 2010 at 06:03:57PM -0400, Robert Haas wrote: On Thu, Aug 19, 2010 at 5:53 PM, David Fetter da...@fetter.org wrote: On Thu, Aug 19, 2010 at 05:40:46PM -0400, Tom Lane wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: Robert Haas robertmh...@gmail.com wrote: I

Re: [HACKERS] Version Numbering

2010-08-20 Thread David Fetter
Frobozz 3.1.4.1.5.2.6, not 3.1.4.1.5.2.5!). -- 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] Version Numbering

2010-08-20 Thread David Fetter
On Fri, Aug 20, 2010 at 11:36:55AM -0700, David Wheeler wrote: On Aug 20, 2010, at 11:34 AM, David Fetter wrote: +1 for three-number versions...well, until we really see the light and go to two-number versions. 8.3 and 8.4 are different enough that they shouldn't even mildly appear

Re: [HACKERS] Version Numbering

2010-08-20 Thread David Fetter
On Fri, Aug 20, 2010 at 07:59:55PM +0100, Greg Stark wrote: On Fri, Aug 20, 2010 at 7:34 PM, David Fetter da...@fetter.org wrote: +1 for three-number versions...well, until we really see the light and go to two-number versions.  8.3 and 8.4 are different enough that they shouldn't even

Re: [HACKERS] Version Numbering

2010-08-20 Thread David Fetter
On Fri, Aug 20, 2010 at 11:48:12AM -0700, David Wheeler wrote: On Aug 20, 2010, at 11:47 AM, David Fetter wrote: No idea what you mean by that, but generally it's a bad idea to switch from dotted-integer version numbers and numeric version numbers. See Perl (Quel désastre!). I'm

Re: [HACKERS] Version Numbering

2010-08-20 Thread David Fetter
On Fri, Aug 20, 2010 at 04:41:20PM -0500, Jaime Casanova wrote: On Fri, Aug 20, 2010 at 1:48 PM, David E. Wheeler da...@kineticode.com wrote: On Aug 20, 2010, at 11:47 AM, David Fetter wrote: The current system give people the completely false impression that 7.0 and 7.4 are somehow

Re: [HACKERS] Version Numbering

2010-08-21 Thread David Fetter
, and (of course ;) writeable CTEs, would qualify under that second. Open for discussion would be features like Can spit out, on demand, any subset of the dependency graph for an object. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Fw: patch for pg_ctl.c to add windows service start-type

2010-08-22 Thread David Fetter
On Sun, Aug 22, 2010 at 10:03:32PM +0800, Quan Zongliang wrote: Sure, I agree. New patch attached. How about this? Docs re-added. Please not to leave these out in future patches. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] WIP: extensible enums

2010-08-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] WIP: extensible enums

2010-08-23 Thread David Fetter
, which isn't that exciting, Not to you, maybe, but to users, it's really handy to have intuitive, rather than strictly orthogonal, ways to do things. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

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

Re: [HACKERS] [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-08-24 Thread David Fetter
be a good deal too sunny) -- 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] gSoC add MERGE command new patch -- merge_v104

2010-08-24 Thread David Fetter
of 2ndQuadrant's time on this. :) 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] 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] 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] 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

[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] 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

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread David Fetter
. I'd suggest e for external. M for management is a pretty useless mnemonic --- what's being managed? \def, \deu, etc. sound great :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] pre-MED

2008-12-14 Thread David Fetter
On Mon, Nov 17, 2008 at 10:37:41AM -0800, David Fetter wrote: On Tue, Nov 04, 2008 at 12:23:55PM -0500, Tom Lane wrote: Alex Hunsaker bada...@gmail.com writes: On Thu, Oct 30, 2008 at 05:16, Tom Lane t...@sss.pgh.pa.us wrote: which doesn't seem like it would amount to anything compared

Re: [HACKERS] pre-MED

2008-12-15 Thread David Fetter
On Mon, Dec 15, 2008 at 08:50:25AM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: Tom, I know you've been busy with lots of stuff, so here's a little reminder. I talked with a couple of people who know the back-end much better than I do. One said the above was way

Re: [HACKERS] Partitioning wiki page

2008-12-17 Thread David Fetter
be a good starting point for discussions and a way to move forward. Any word on moving partitions off-line and back on? This is a very common use case, so if it's not supported, it'd be good to document that this is so :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [HACKERS] Partitioning wiki page

2008-12-17 Thread David Fetter
to restore. 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers

Re: [HACKERS] Is Window really safe as a global typedef name?

2008-12-19 Thread David Fetter
it, but I'm not coming up with anything good; the best I can do after a long day is EvalWindow, and that doesn't seem particularly inspired. Any suggestions? QueryWindow? ResultSetWindow? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] about truncate

2008-12-21 Thread David Fetter
for table inheritance is in table partitioning, can we see about deprecating ONLY (in the table inheritance sense) for the next couple of development cycles and then removing it? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] about truncate

2008-12-21 Thread David Fetter
On Sun, Dec 21, 2008 at 11:06:09PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: Given that the main (and only sane, IMHO) use for table inheritance is in table partitioning, can we see about deprecating ONLY (in the table inheritance sense) for the next couple of development

Re: [HACKERS] uuids on freebsd

2008-12-25 Thread David Fetter
-freebsd module that uses the base system uuid functions rather than the ossp ones. I could put this on pgfoundry if there isn't likely to be a real fix in the near future.) +1 for putting it on pgFoundry. It's now on pgfoundry :) Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] TODO items for window functions

2008-12-30 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers

Re: [HACKERS] about truncate

2008-12-30 Thread David Fetter
note though that we have a lot of other non-recursive maintenance operations (CLUSTER, some variants of ALTER TABLE, etc) ... are we going to try to make them all recursive? We probably should. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] about truncate

2008-12-30 Thread David Fetter
On Tue, Dec 30, 2008 at 04:07:33PM -0500, Jaime Casanova wrote: On Tue, Dec 30, 2008 at 2:00 PM, David Fetter da...@fetter.org wrote: Here's one such use-case. Let's say a table has gotten large and you've decided to partition it. You add child tables, add one or more triggers

Re: [HACKERS] TODO items for window functions

2008-12-31 Thread David Fetter
, it seems kind of inconsistent to do this for window functions unless we also make \df start putting parens around the argument lists for regular functions. Comments? Would parens around all the argument lists really be so bad? I'm thinking not. Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] version() output vs. 32/64 bits

2008-12-31 Thread David Fetter
Alvaro's suggestion. +1 for broken-out fields in columns per Alvaro. 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 Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] SQL/MED compatible connection manager

2009-01-01 Thread David Fetter
, so +1 on the SRF option :) 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: [HACKERS] float8 strtod weirdness

2009-01-07 Thread David Fetter
- (0 rows) !? No !? at all. The = operation on floats has never been one to count on. If you need = not to give surprising results, you need to use some other data type such as numeric. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] about truncate

2009-01-07 Thread David Fetter
to GRANT/REVOKE :) 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

Re: [HACKERS] about truncate

2009-01-08 Thread David Fetter
On Thu, Jan 08, 2009 at 02:39:52PM +0200, Peter Eisentraut wrote: David Fetter wrote: +1 for adding recursion to GRANT/REVOKE :) This area is under SQL standard control, so we can't really invent our own behavior. Consider the following: CREATE TABLE persons (name, email); CREATE TABLE

Re: [HACKERS] Recovery Test Framework

2009-01-12 Thread David Fetter
git, as many hackers and committers have already started to do. This is the kind of situation where CVS just plain falls down because branching and merging are unmanageably difficult in it, where in git, they're many-times-a-day operations. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Recovery Test Framework

2009-01-12 Thread David Fetter
On Mon, Jan 12, 2009 at 11:33:43AM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: Two things to fix this, and several other problems: 1. Remove the messages size limits on -hackers. They serve no useful purpose, and they interfere with our development process. Agreed

Re: [HACKERS] Recovery Test Framework

2009-01-12 Thread David Fetter
move the main repo to git crowd, all you need for what you're suggesting here is a stable git mirror on git.postgresql.org. Agreed :) Cheers, David (happy to help by setting people up on git.postgresql.org). -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Recovery Test Framework

2009-01-12 Thread David Fetter
just need to enforce that 'git push' only ever did a fast-forward. We could do this using git's configuration: http://www.kernel.org/pub/software/scm/git/docs/git-config.html See receive.denyNonFastForwards, which is built for just this purpose :) Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] Recovery Test Framework

2009-01-12 Thread David Fetter
On Mon, Jan 12, 2009 at 08:12:46PM -0500, Tom Lane wrote: 250K ought to be enough. ...for anybody ;) 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 Remember

Re: FWD: Re: [HACKERS] Updated backslash consistency patch

2009-01-15 Thread David Fetter
is not. Neither is I need to see system objects by default, despite what some people whose day job is hacking on PostgreSQL may believe. 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] Updated backslash consistency patch

2009-01-15 Thread David Fetter
better than nothing, but it still doesn't help when I want to do: psql -c '\df' | grep bool psql -c '\dfS' |grep bool This is not a made-up use case. Nor is does this long overdue change impose an undue burden on it :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

[HACKERS] Re: [GENERAL] Question regarding new windowing functions in 8.4devel

2009-01-16 Thread David Fetter
by typ order by ts desc) WHERE typ 4; ERROR: syntax error at or near WHERE LINE 8: WHERE ^ 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 Remember

Re: [HACKERS] Re: [GENERAL] Question regarding new windowing functions in 8.4devel

2009-01-16 Thread David Fetter
On Fri, Jan 16, 2009 at 12:23:16PM -0500, Jaime Casanova wrote: On Fri, Jan 16, 2009 at 12:07 PM, David Fetter da...@fetter.org wrote: Now i want only 3 records for every typ: test=# select typ, ts, rank() over (partition by typ order by ts desc ) from foo where rank = 3; ERROR

Re: [HACKERS] [GENERAL] Question regarding new windowing functions in 8.4devel

2009-01-16 Thread David Fetter
On Fri, Jan 16, 2009 at 12:34:34PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: I tried this: SELECT typ, ts, rank() over w AS foo_rank FROM foo WINDOW w AS (partition by typ order by ts desc) WHERE foo_rank 4; ERROR: syntax

Re: [HACKERS] [GENERAL] Question regarding new windowing functions in 8.4devel

2009-01-16 Thread David Fetter
On Fri, Jan 16, 2009 at 12:41:59PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: We don't appear to be able to use the actual thing in the target list either. Would you translate that into English? Or at least an example without trivial syntax errors? This works: SELECT

Re: [HACKERS] Column-Level Privileges

2009-01-24 Thread David Fetter
: : joe=w/postgres : } (1 row) 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] problem with archive_command as suggested by documentation

2009-01-26 Thread David Fetter
with something, but it will take some time; an impending addition to the family currently has priority... You understand that this means you need to provide blue-elephant-themed photos, right? Congratulations! :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] 8.4 release planning

2009-01-27 Thread David Fetter
and ask when we'll have it. I've never seen anything like the interest in this for any database feature, including the fairies-and-unicorns multi-master replication people imagine will scale linearly in every dimension by plugging in nodes. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] 8.4 release planning

2009-01-27 Thread David Fetter
On Tue, Jan 27, 2009 at 11:36:02AM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: On Mon, Jan 26, 2009 at 03:12:02PM -0500, Tom Lane wrote: I don't think this is correct. I do. People literally grab my shoulder and ask when we'll have it. Do these people understand

Re: [HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-29 Thread David Fetter
On Thu, Jan 29, 2009 at 08:12:12PM -0500, Tom Lane wrote: David E. Wheeler da...@kineticode.com writes: Seems to me that IS DISTINCT FROM is just another operator, like =, Wishful thinking... What would it take to make this wish come true? Cheers, David. -- David Fetter da

Re: [HACKERS] adding stuff to parser, question

2009-01-31 Thread David Fetter
On Sat, Jan 31, 2009 at 04:46:26PM +, Grzegorz Jaskiewicz wrote: Hey folks, I am trying to add GRANT SELECT ON ALL TABLES to postgres, Is this part of the SQL:2008? If not, is there something else that is? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

Re: [HACKERS] adding stuff to parser, question

2009-01-31 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Updated backslash consistency patch

2009-02-01 Thread David Fetter
the rolcanlogin value. +1 for fixing that. was it that easy, or I got it wrong? :) I think Stephen meant that they should add a column to the output. Stephen? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] add_path optimization

2009-02-01 Thread David Fetter
that seem to help significantly: Are there any cases you've found where this change significantly impairs performance, and if so, how did you find them? If not, would you be up for trying to find some? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] [PATCH] Psql List Languages

2009-02-02 Thread David Fetter
fields and change spaces/tab to 4 spaces. :) +1 for adding this :) 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 Remember to vote! Consider donating to Postgres

Re: [HACKERS] Auto-updated fields

2009-02-04 Thread David Fetter
On Wed, Feb 04, 2009 at 01:23:04PM -0500, Bruce Momjian wrote: Robert Treat wrote: On Wednesday 21 January 2009 20:21:41 Bruce Momjian wrote: Alvaro Herrera wrote: Robert Treat wrote: On Thursday 08 May 2008 00:27:10 Tino Wildenhain wrote: David Fetter wrote: Ref: http

Re: [HACKERS] Is a plan for lmza commpression in pg_dump

2009-02-07 Thread David Fetter
are equivalent to that algorithm is no longer proprietary because any project could simply use PostgreSQL's version and have done. 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] UUIDs using e2fs library on Linux in 8.4

2009-02-07 Thread David Fetter
something else, or would you consider re-licensing it under BSDL-compatible terms? 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 Remember to vote! Consider donating

Re: [HACKERS] WIP: fix SET WITHOUT OIDS, add SET WITH OIDS

2009-02-08 Thread David Fetter
On Sun, Feb 08, 2009 at 11:51:22AM -0500, Tom Lane wrote: Now, if you want to argue that we should get rid of SET WITHOUT OIDS altogether, +1 for removing it altogether. Row OIDs are and ugly wart :P Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] WIP: fix SET WITHOUT OIDS, add SET WITH OIDS

2009-02-09 Thread David Fetter
this: You have explicit OIDs in this database, which have been deprecated since 8.1. If despite this, you would like to preserve them, use the --oids option for pg_dump. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Optimization rules for semi and anti joins

2009-02-11 Thread David Fetter
, under no circumstances would such a person paste that link in a public forum. Should we have a kick-off policy for this kind of misbehavior? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Optimization rules for semi and anti joins

2009-02-11 Thread David Fetter
On Wed, Feb 11, 2009 at 09:36:38AM -0500, Jonah H. Harris wrote: On Wed, Feb 11, 2009 at 8:05 AM, David Fetter da...@fetter.org wrote: As has been discussed here many, many times, the only kind of person who should be doing a patent search is a company's IP attorney, which you

Re: [HACKERS] pg_restore --multi-thread

2009-02-12 Thread David Fetter
? --num-bikeshed? ;) Cheers, David (purple!) -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: [HACKERS] SE-PostgreSQL and row level security

2009-02-13 Thread David Fetter
mobilizing them? 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

Re: [HACKERS] [GENERAL] Good Delimiter for copy command

2009-02-17 Thread David Fetter
: COPY delimiter must be a single character 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 Remember to vote! Consider donating to Postgres: http://www.postgresql.org

[HACKERS] SIMILAR TO bug?

2009-02-18 Thread David Fetter
...@davidfetter=# SELECT 'abc' ~ '^[a]'; ?column? -- t (1 row) Did I misunderstand what SIMILAR TO does, or...? 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

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