Re: [HACKERS] [COMMITTERS] pgsql: Remove more SGML tabs.

On Thu, Feb 10, 2011 at 09:16:09PM +0200, Peter Eisentraut wrote: On tor, 2011-02-10 at 10:40 -0800, David Fetter wrote: I think all such checks belong in .git/hooks/pre-commit, and need to be as cross-platform as needed for committers. Would a *n*x-based version do for a start? I think

Re: [HACKERS] [COMMITTERS] pgsql: Remove more SGML tabs.

the number of times they come up and the ease of checking them mechanically. 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

Re: [HACKERS] SSI patch version 14

memory model is a piece of garbage. What other model(s) might work better? 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] [COMMITTERS] pgsql: Remove more SGML tabs.

that our build system already requires Perl, there should be, but I'm not quite sure how this would be accomplished. 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] postponing some large patches to 9.2

. I'm all for doing this eventually, and meanwhile getting what's already done in. - The PL/python extravaganza. I'm not really clear where we stand with this. There are a lot of patches here. Many of these are already a go. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] postponing some large patches to 9.2

On Tue, Feb 08, 2011 at 02:04:04PM -0500, Robert Haas wrote: On Tue, Feb 8, 2011 at 1:02 PM, David Fetter da...@fetter.org wrote: Given how things worked, i.e. that people were not clear that 9.1 development had actually started, etc., I am again proposing that we have one more CF starting

Re: [HACKERS] WIP: RangeTypes

, interface, funcationality, grammar, etc. are welcome. Regards, Jeff Davis I'd offer to help, but personal matters press this weekend :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Seeking Mentors for Funded Reviewers

to do things they might not otherwise have done, but you'll also make people wonder whether they should be volunteering at all. Offhand, I'd say this is a really bad idea. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

it. 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] Extensions support for pg_dump, patch v27

of pg_catalog so we don't have an exception to the rule. 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] a regression

. Maybe someone would like to set up a buildfarm member that tests a whole slew of locales. We've had the capability for a couple of years now. Is it just a matter of setting a flock of environment variables as part of the setup? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] REVIEW: EXPLAIN and nfiltered

doubt it matters. +1 for this. It says what happened. :) 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] pl/python refactoring

, and it's been that way before. Also, the CF is already closed in theory... If you're fixing things in PL/PythonU, such a change would certainly be in scope as an update to your patch, i.e. don't let the fact that the CF has started stop you from fixing it. Cheers, David. -- David Fetter da

Re: [HACKERS] pg_filedump moved to pgfoundry

there's a Policy® at Red Hat that software made on its dime be GPL (v2, I'd guess), and that getting an exception would involve convening its board or similarly drastic action. Is that about right? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] psql: Add \dL to show languages

or PostgreSQL, 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...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] SSI patch version 12

you tell the system an untruth about the state of the world, such as alleging immutability when it's not actually there, it will get its revenge in ways more drastic than this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.

suggesting that the command tags become an array? This has all kinds of interesting possibilities, but would of course break all kinds of stuff in the process. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] WIP: RangeTypes

, however, have been causing me a little frustration. [Explanation and illustrations]. In that case, let's leave them out for this cut. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] pg_filedump moved to pgfoundry

is GPL, per Red Hat company policy, and that's not going to change.) Who's the copyright holder(s)? If it's all individual contributors, Red Hat policy is not in play. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

[HACKERS] kill -KILL: What happens?

of the mechanism(s) whereby the damage occurs? 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] kill -KILL: What happens?

On Thu, Jan 13, 2011 at 10:41:28AM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: I've noticed over the years that we give people dire warnings never to send a KILL signal to the postmaster, but I'm unsure as to what are potential consequences of this, as in just exactly how

Re: [HACKERS] pg_depend explained

Please put a self-contained example on the snippets page, and please also to check that it actually runs before doing so. You'd mangled some aliases in the query you sent, which leads me to believe you hadn't actually tried running it. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] kill -KILL: What happens?

, and that people should shut it off, but it *is* our problem if we let the postmaster start (or continue) when it's set that 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

Re: [HACKERS] kill -KILL: What happens?

into whatever nrmal poll/select event handlign it uses to notice when the parent's pipe is closed. I just started to experiment with that idea, and wrote a small test program to check if that'd work. I'll post the results when I'm done. Great! :) Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] kill -KILL: What happens?

On Thu, Jan 13, 2011 at 02:21:44PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: I get that we can't prevent all pilot error, but I was hoping we could bullet-proof this a little more, especially in light of a certain extremely popular server OS's OOM killer's default

Re: [HACKERS] kill -KILL: What happens?

On Thu, Jan 13, 2011 at 03:29:13PM -0800, Jeff Davis wrote: On Thu, 2011-01-13 at 11:14 -0800, David Fetter wrote: I get that we can't prevent all pilot error, but I was hoping we could bullet-proof this a little more, especially in light of a certain extremely popular server OS's OOM

Re: [HACKERS] Allowing multiple concurrent base backups

backups less dependent on CPU, among them: - Making the on-disk representation smaller - Making COPY more efficient As far as I know, none of this work is public yet. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Allowing multiple concurrent base backups

On Wed, Jan 12, 2011 at 05:17:38PM +0200, Heikki Linnakangas wrote: On 12.01.2011 17:15, David Fetter wrote: On Wed, Jan 12, 2011 at 10:26:05AM +0100, marcin mank wrote: Considering that parallell base backups would be io-bound (or network-bound), there is little need to actually run them

Re: [HACKERS] Allowing multiple concurrent base backups

On Wed, Jan 12, 2011 at 10:24:31AM -0500, Tom Lane wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: On 12.01.2011 17:15, David Fetter wrote: On Wed, Jan 12, 2011 at 10:26:05AM +0100, marcin mank wrote: Considering that parallell base backups would be io-bound

Re: [HACKERS] arrays as pl/perl input arguments [PATCH]

release. (And even then some major things in minor releases, for example the removal of Safe.pm) ] +1 for changing the behavior to something sane with loud, specific warnings in the release notes about what will break and how. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] pg_depend explained

pg_depend_before To what does pg_depend_before refer? 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: RangeTypes

the code a little. Thoughts? Probably not worth complicating the code at this stage. KISS again :) 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] Allowing multiple concurrent base backups

the chips were down. I hope this assessment proves to be incorrect, because like Magnus and Heikki, I think this will be a major usability improvement. It takes us from there's a way to do that to it just works. (It just works)++ :) Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] SSI and 2PC

it's available ASAP to a wide range of people via the next alpha (or beta, if that's where we're going next). 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] SSI and 2PC

On Mon, Jan 10, 2011 at 08:59:45AM -0600, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: Could people fix it after the patch? ISTM that a great way to test it is to make very sure it's available ASAP to a wide range of people via the next alpha (or beta, if that's where we're

Re: [HACKERS] SSI patch version 8

On Mon, Jan 10, 2011 at 10:03:18AM -0600, Kevin Grittner wrote: Due to popular request (Hey, David's popular, right?), Well, I'm a person, and popular originally refers to something like that ;) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Compatibility GUC for serializable

-- if set, SERIALIZABLE would fall back to working the same as REPEATABLE READ. In an off-list exchange with me, David Fetter expressed opposition to this, as a foot-gun. I'm not sure where anyone else stands on this. Personally, I don't care a whole lot because it's trivial to add, so

Re: [HACKERS] hstore ? operator versus mathematics

-compatible with this behavior. Barring objections, I'm going to fix it. +1 for fixing it. 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] LOCK for non-tables

. This is Generally Not A Good Thing™, and we removed that some time back. 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] LOCK for non-tables

On Fri, Jan 07, 2011 at 10:58:41AM -0500, Robert Haas wrote: On Fri, Jan 7, 2011 at 10:52 AM, David Fetter da...@fetter.org wrote: I'm not sure I understand this.  Does it mean I'd have to say    LOCK TABLE my_view; No. +1 for #4, then :) Cheers, David. -- David Fetter da

Re: [HACKERS] Remove pg_am.amindexnulls?

of am that *couldn't* index nulls out of the gate. Might their be such AMs on the horizon? 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] We need to log aborted autovacuums

you are here X marking where they have inadvertently wandered onto. Actually, that'd make a great flow chart on a T-shirt :) 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] making an unlogged table logged

. So you'd change a logged table into an unlogged table to cut down on I/O, and take the risk of losing the data if the server went down? BLACKHOLE is a storage engine that's equivalent to /dev/null, so it wasn't a risk /per se/. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] ALTER EXTENSION UPGRADE patch v1

On Wed, Jan 05, 2011 at 10:19:23AM +0100, Dimitri Fontaine wrote: David Fetter da...@fetter.org writes: One could imagine that an extension was updated more quickly than PostgreSQL major versions come out, or at least not at the exact same time. Sure, but I don't see what your proposed

Re: [HACKERS] WIP: Range Types

? 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] Re: new patch of MERGE (merge_204) a question about duplicated ctid

for the simpler cases and a way to relax consistency guarantees for those who would like to do 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

Re: [HACKERS] Implementing pg_dump_sort.c topological sorting in sql/plpgsql/plperl?

. 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] ALTER EXTENSION UPGRADE patch v1

not be a 9.1 feature, but it's sure to be one people who need to deploy software want. A lot. 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] Re: new patch of MERGE (merge_204) a question about duplicated ctid

On Tue, Jan 04, 2011 at 07:02:54PM +0200, Marko Tiikkaja wrote: On 2011-01-04 6:27 PM, David Fetter wrote: On Tue, Jan 04, 2011 at 04:44:32AM -0500, Greg Smith wrote: Heikki Linnakangas wrote: You can of course LOCK TABLE as a work-around, if that's what you want. Presuming the code quality

Re: [HACKERS] system views for walsender activity

be breaking a decades-old tradition of terrible 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

Re: [HACKERS] ALTER EXTENSION UPGRADE patch v1

On Tue, Jan 04, 2011 at 08:31:19PM +0100, Dimitri Fontaine wrote: David Fetter da...@fetter.org writes: Do you plan to have ALTER EXTENSION ... UPGRADE TO VERSION ... , or the more general, ALTER EXTENSION ... ALTER VERSION TO ... ? Well why not, but I'm not sure I understand

Re: [HACKERS] Re: new patch of MERGE (merge_204) a question about duplicated ctid

On Tue, Jan 04, 2011 at 09:27:10PM -0500, Greg Smith wrote: David Fetter wrote: How about implementing an UPSERT command as take the lock, do the merge? That way, we'd have both the simplicity for the simpler cases and a way to relax consistency guarantees for those who would like to do so

Re: [HACKERS] pg_streamrecv for 9.1?

On Wed, Dec 29, 2010 at 11:47:53AM +0100, Magnus Hagander wrote: Would people be interested in putting pg_streamrecv (http://github.com/mhagander/pg_streamrecv) in bin/ or contrib/ for 9.1? I think it would make sense to do so. +1 for bin/ Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Avoiding rewrite in ALTER TABLE ALTER TYPE

than simply mention that they exist. Saying, in effect, search the archives with our not-super-great search technology using keywords you didn't think of, comes off as pretty dismissive if not downright hostile. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] writable CTEs

, 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] and it's not a bunny rabbit, either

reality. With predicate locks, etc., it may become untrue later, though :) 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

Re: [HACKERS] writable CTEs

. 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] C++ keywords in headers (was Re: [GENERAL] #include funcapi.h)

of stuff. This sounds like an excellent early candidate for the bitrot farm. 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

Re: [HACKERS] writable CTEs

the phrase, 'POST-interactive GRaphics REtrieval System.' ;) 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] writable CTEs

in correcting this, by putting CTEs or Common table expressions in parenthesis after WITH queries in the docs at certain select places? I could write a documentation patch. +1 :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] writable CTEs

On Mon, Dec 27, 2010 at 09:51:01PM -0500, Robert Haas wrote: On Mon, Dec 27, 2010 at 9:28 PM, David Fetter da...@fetter.org wrote: On Tue, Dec 28, 2010 at 12:19:47AM +, Peter Geoghegan wrote: It's worth noting that officially (i.e. in the docs), we don't even call CTEs CTEs at any point

Re: [HACKERS] writable CTEs

, plus a main query. Or are they? They are. :) 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] and it's not a bunny rabbit, either

, though - not sure. Or we can just stick with the way we've been doing it, if I'm the only one who thinks it's icky. You're not the only one. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] WIP patch for parallel pg_dump

archive (I tend to keep going back to gmane's search) It's deja vu all over again. See mailing list archives for details. LOL! 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] SQL/MED - core functionality

, we can't even guarantee 1NF. Still many unanswered. Will try these later today :) 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] SQL/MED - core functionality

of another case. 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] SQL/MED - core functionality

systems do. this would seem rather pointless ... Surely the FDW must be able to limit the resultset somehow. Using LIMIT. :) 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] How much do the hint bits help?

an important option to be offering to our users. For what version of PostgreSQL are you proposing that we provide this protection? Let's assume that it's before 10.0 so we can get some idea of how this will arise :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] writable CTEs

based on a catalog query) or DDL (partition management), and I did. We could call them, Expanded CTEs, but that only freezes the prior norm making them read-only, so I think Writeable CTEs captures it pretty well. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] wCTE behaviour

the SQL2001/DB2 syntax instead of our own? Yes, and it's a good deal more limited and less intuitive than ours. This is one place where we got it right and the standard just got pushed into doing whatever IBM did. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] Extensions, patch v20 (bitrot fixes)

, ISO-2022-JP-2 and EUC-TW are such encodings. 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] plperlu problem with utf8

the 333 causes perl store it internally as utf8. Well with SQL_ASCII anything goes, no? Anything except a byte that's all 0s :( 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] Tab completion for view triggers in psql

On Thu, Dec 16, 2010 at 07:40:31AM -0500, Greg Smith wrote: David Fetter wrote: That we're in the position of having prevN_wd for N = 1..5 as the current code exists is a sign that we need to refactor the whole thing, as you've suggested before. I'll work up a design and prototype

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

On Mon, Dec 13, 2010 at 10:48:54PM -0500, Robert Haas wrote: On Tue, Nov 30, 2010 at 9:15 AM, David Fetter da...@fetter.org wrote: Patch attached. If you think my changes are ok, please change the patch status to Ready for Committer. Done :) I have committed part of this patch. Great

Re: [HACKERS] SQL/MED - core functionality

, I still think RULE and TRIGGER are useful, for example, logging purpose. Please start with TRIGGER, and we can then discuss the whether and possibly the how of RULEs later. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED

is a problem, the user can go ahead and write their own query, like Robert suggested. Perhaps the errhint could suggest a query. All the information needed for it would be available :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] CommitFest wrap-up

, and even if we're releasing 9.1 in July, three months plus is plenty of time to shake things out. 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, patch v16

, 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] wCTE behaviour

On Wed, Dec 08, 2010 at 01:23:59PM +0200, Marko Tiikkaja wrote: On 2010-12-08 10:19 AM +0200, David Fetter wrote: On Sun, Dec 05, 2010 at 01:33:39PM -0500, Greg Smith wrote: So this patch was marked Ready for Committer, but a) no committer has picked it up yet and b) Marko has made changes

Re: [HACKERS] wCTE behaviour

. If there is a committer intending to work on this as-is, they haven't identified themselves. I've tested this one and not managed to break it. One thing it could use is support for EXPLAIN ANALYZE. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] new patch of MERGE (merge_204) a question about duplicated ctid

On Sat, Dec 04, 2010 at 09:27:52PM +0800, Boxuan Zhai wrote: Dear Greg, I have updated the MERGE patch for two main problems. Please attach the actual patch :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] FK's to refer to rows in inheritance child

and bar columns are guaranteed never to overlap among the partitions, it should be possible make uniqueness guarantees over sets of partitions without using a common index. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] Proposal: First step towards Intelligent,integrated database

On Wed, Dec 01, 2010 at 03:19:32PM +0500, ghatpa...@vsnl.net wrote: Hello, Here is the proposal: My 1st step towards Intelligent, Integrated database. You're implying that databases are stupid and incoherent. This is *not* a great way to start. Cheers, David. -- David Fetter da

Re: [HACKERS] Proposal: First step towards Intelligent, integrateddatabase

My point exactly. You started off with high negativity, and you should not expect good results from same. Cheers, David. On Wed, Dec 01, 2010 at 08:15:25PM +0500, ghatpa...@vsnl.net wrote: Be positive ... Negative thoughts are not good... - Original Message - From: David Fetter da

Re: [HACKERS] Improved JDBC driver part 2

easier to review. That said, such a process would also be a lot easier if the JDBC driver wasn't in cvs ;) This brings up an excellent point. Would the people now developing the JDBC driver object to switching to git? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] Improved JDBC driver part 2

On Wed, Dec 01, 2010 at 10:15:38AM -0600, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: Would the people now developing the JDBC driver object to switching to git? If we move to git, don't forget that there is not one repository which has the entire history for PostgreSQL

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

On Tue, Nov 30, 2010 at 05:48:04PM +0900, Itagaki Takahiro wrote: On Wed, Nov 24, 2010 at 12:21, David Fetter da...@fetter.org wrote: Please find attached a patch changing both this and updateable to updatable, also per the very handy git grep I just learned about :) I think the patch has

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

On Tue, Nov 30, 2010 at 08:13:37PM +0900, Itagaki Takahiro wrote: On Tue, Nov 30, 2010 at 18:18, David Fetter da...@fetter.org wrote: It expands all tables (and views) in tab-completion after INSERT, UPDATE, and DELETE FROM.  Is it an intended change? I found it was a simple bug; we need

Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove outdated comments from the regression test files.

-10 03:06:38 + I think it's quite foolish to depend on abbreviated hashes to be unique forever. Good point. While a full-hash collision is of course possible, we have much more likely things that can mess us up than that :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] Patch to add a primary key using an existing index

. I'm going to mark this as ready for a committer. I think we need more discussions about the syntax:  ALTER TABLE table_name ADD PRIMARY KEY (...) WITH (INDEX='index_name') Why not: ALTER TABLE table_name ADD PRIMARY KEY (...) INDEX index_name; +1 :) Cheers, David. -- David Fetter da

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

On Wed, Nov 24, 2010 at 11:01:28PM -0500, Josh Kupershmidt wrote: On Tue, Nov 23, 2010 at 10:21 PM, David Fetter da...@fetter.org wrote: Please find attached a patch changing both this and updateable to updatable, also per the very handy git grep I just learned about :) I looked a little

Re: [HACKERS] SQL/MED - file_fdw

which original SQL/MED item is in? Or should I add them to CF 2011-01? The original. 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

On Tue, Nov 23, 2010 at 09:37:57PM -0500, Josh Kupershmidt wrote: On Fri, Oct 29, 2010 at 10:33 AM, David Fetter da...@fetter.org wrote: That seems like a matter for a separate patch.  Looking this over, I found I'd created a query that can never get used, so please find enclosed the next

Re: [HACKERS] final patch - plpgsql: for-in-array

spent my time with this. What you can actually do that's productive is stop all current development and concentrate on reviewing patches. If the language gap is an issue, please feel free to mail me your reviews in Czech, and I will get them translated. Cheers, David. -- David Fetter da

Re: [HACKERS] ALTER OBJECT any_name SET SCHEMA name

types also to avoid code duplication. Should this really error out? It's just a NOOP, so perhaps a NOTICE would be more appropriate. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

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

On Fri, Oct 29, 2010 at 08:33:00AM -0700, David Fetter wrote: 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

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

On Sun, Nov 21, 2010 at 03:36:58PM -0500, Robert Haas wrote: On Sun, Nov 21, 2010 at 1:07 PM, David Fetter da...@fetter.org wrote: On Fri, Oct 29, 2010 at 08:33:00AM -0700, David Fetter wrote: On Tue, Oct 26, 2010 at 11:55:07AM +0900, Itagaki Takahiro wrote: On Tue, Oct 26, 2010 at 11:34

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

On Sun, Nov 21, 2010 at 07:09:08PM -0500, Robert Haas wrote: On Sun, Nov 21, 2010 at 4:05 PM, David Fetter da...@fetter.org wrote: Could someone please commit this? :) Eh... was there some reason you didn't add it to the CommitFest app? I forgot. A fair excuse. :-) Because

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

On Sun, Nov 21, 2010 at 08:27:34PM -0500, Robert Haas wrote: On Sun, Nov 21, 2010 at 7:17 PM, David Fetter da...@fetter.org wrote: On Sun, Nov 21, 2010 at 07:09:08PM -0500, Robert Haas wrote: On Sun, Nov 21, 2010 at 4:05 PM, David Fetter da...@fetter.org wrote: Could someone please commit

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

| Here 2 | 2 | is| is 3 | 4 | some | yet 4 | 8 | odd | more 5 | | text | text 6 | | of| 7 | | a | 8 | | different | 9 | | length| (9 rows) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

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