Re: [HACKERS] pg_dump --pretty-print-views

of future versions that could have different operator precedences?) Under what circumstances do pretty-printed views not reload? It seems to me that such circumstances would be pretty_print() bugs by definition. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] Cascading replication: should we detect/prevent cycles?

a bunch of infrastructure? I'm pretty sure the logical change stuff Andres et al. are working on will be able to include the originating node, which makes cycle detection dead simple. Other restrictions on the graph like, must be a tree might be more complicated. Cheers, David. -- David Fetter da

Re: [HACKERS] Review of Row Level Security

. -- 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] Review of Row Level Security

On Wed, Jan 02, 2013 at 05:31:42PM +, Simon Riggs wrote: On 2 January 2013 17:19, David Fetter da...@fetter.org wrote: Would COPY be covered separately? How about TRUNCATE? COPY == INSERT Makes sense. The reason I mentioned it is that COPY is supposed to be a very fast bulk loading

Re: [HACKERS] Parser Cruft in gram.y

/software/peg/ More angles: http://wwwiti.cs.uni-magdeburg.de/~rosenmue/publications/SKS+08.pdf Might anyone here wish to investigate this, given some kind of resources for the initial study? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] [v9.3] Row-Level Security

internal access controls might be required on it, too. 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] [v9.3] Row-Level Security

On Mon, Dec 03, 2012 at 03:41:47PM +, Simon Riggs wrote: On 3 December 2012 15:36, Kohei KaiGai kai...@kaigai.gr.jp wrote: 2012/12/3 David Fetter da...@fetter.org: On Sun, Nov 25, 2012 at 03:20:28PM +0100, Kohei KaiGai wrote: However, UPDATE / DELETE support is not perfect right now

Re: [HACKERS] Materialized views WIP patch

as an optional piece of the grammar, with more REFRESH options to come. 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] Materialized views WIP patch

On Mon, Nov 26, 2012 at 04:02:17PM +, Peter Geoghegan wrote: On 26 November 2012 15:24, David Fetter da...@fetter.org wrote: I hate to add to the bike-shedding, but we should probably add REFRESH SNAPSHOT as an optional piece of the grammar, with more REFRESH options to come. I don't

Re: [HACKERS] Materialized views WIP patch

On Mon, Nov 26, 2012 at 04:34:36PM -0500, Kevin Grittner wrote: David Fetter wrote: On Mon, Nov 26, 2012 at 09:46:33AM -0500, Peter Eisentraut wrote: So, the way I understand it, in Oracle terms, this feature is a snapshot, not a materialized view. Maybe that's what it should be called

Re: [HACKERS] Proof of concept: auto updatable views [Review of Patch]

On Wed, Nov 07, 2012 at 05:55:32PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: On Wed, Nov 07, 2012 at 05:04:48PM -0500, Tom Lane wrote: Should we be doing something about such cases, or is playing dumb correct? The SQL standard handles deciding the behavior based

Re: [HACKERS] Proof of concept: auto updatable views [Review of Patch]

On Thu, Nov 08, 2012 at 11:33:47AM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: There are three different WITH CHECK OPTION options: WITH CHECK OPTION WITH CASCADED CHECK OPTION WITH LOCAL CHECK OPTION No, there are four: the fourth case being if you leave off

Re: [HACKERS] Tweaking ResolveNew's API

to doing it. Actually, it occurs to me that there's a really easy way to get the result: let's just rename the function. ResolveNew isn't an amazingly mnemonic name anyway. How about ReplaceVarsFromTargetList? +1 for descriptive names :) Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Proof of concept: auto updatable views [Review of Patch]

is included in the view DDL. See the section 2 of the SQL standard (Foundation) for details. 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] RFC: New log_destination 'fifo'

the underlying capability. 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

[HACKERS] MDCC

...not MVCC. Could we use this for geographically separated replication? http://muratbuffalo.blogspot.com/2012/11/mdcc-multi-data-center-consistency.html h/t Neil Conway. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] Synchronous commit not... synchronous?

in progress ROLLBACK d5r5fdj6u5ieml= -- Peter van Hardenberg San Francisco, California Everything was beautiful, and nothing hurt. -- Kurt Vonnegut -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Synchronous commit not... synchronous?

On Thu, Nov 01, 2012 at 01:31:34PM +0900, Michael Paquier wrote: On Thu, Nov 1, 2012 at 1:03 PM, David Fetter da...@fetter.org wrote: On Wed, Oct 31, 2012 at 06:39:20PM -0700, Peter van Hardenberg wrote: This was rather surprising - my synchronous commit was... not cancelled

Re: [HACKERS] Synchronous commit not... synchronous?

On Thu, Nov 01, 2012 at 02:10:46PM +0900, Michael Paquier wrote: On Thu, Nov 1, 2012 at 1:48 PM, David Fetter da...@fetter.org wrote: I guess my disk subsystem (it's a consumer-grade DAS SSD) doesn't have enough latency for my reflexes to hit ^C fast enough. Any way to inject this fault

Re: [HACKERS] [GENERAL] Estimated rows question

:-(. Does anyone? If so, who? 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] MySQL search query is not executing in Postgres DB

that incentive is reduced. 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] [v9.3] writable foreign tables

, 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] [v9.3] writable foreign tables

On Tue, Aug 28, 2012 at 05:18:34PM +0200, Kohei KaiGai wrote: 2012/8/28 David Fetter da...@fetter.org: On Tue, Aug 28, 2012 at 10:58:25AM -0400, Tom Lane wrote: Kohei KaiGai kai...@kaigai.gr.jp writes: It seems to me TargetEntry of the parse tree can inform us which column should

Re: [HACKERS] [v9.3] writable foreign tables

On Tue, Aug 28, 2012 at 06:08:59PM +0200, Kohei KaiGai wrote: 2012/8/28 David Fetter da...@fetter.org: On Tue, Aug 28, 2012 at 05:18:34PM +0200, Kohei KaiGai wrote: 2012/8/28 David Fetter da...@fetter.org: On Tue, Aug 28, 2012 at 10:58:25AM -0400, Tom Lane wrote: Kohei KaiGai kai

[HACKERS] default deny for roles

Folks, There are situations where a default deny policy is the best fit. To that end, I have a modest proposal: REVOKE PUBLIC FROM role; Thenceforth, the role in question would only have access to things it was specifically granted. What say? Cheers, David. -- David Fetter da

Re: [HACKERS] multi-master pgbench?

on independent nodes. Is there some other distinction to draw? 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] temporal support patch

? What if the transaction aborts after having written some data, does the audit log still get updated? There are definitely use cases for this, but until we have autonomous transactions, a totally separate project, I don't think we should attempt them in the first version. Cheers, David. -- David

Re: [HACKERS] multi-master pgbench?

of the writes? Such a thing would be quite useful, but it seems at first glance like a large project. 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] multi-master pgbench?

to the other nodes. In some sense, those write operations are incomplete until they have happened on all nodes, even in the asynchronous 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

Re: [HACKERS] [PATCH] Make psql -1 file.sql work as with -f

you've done here -- we should make psql -1 error out if reading from a terminal. +1 for this. Because accepting options that are intended to cause important behavior changes and then ignoring those options is Bad. Yes, It Is. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] WIP: pg_pretty_query

and not privilege one? 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] Docs: Make notes on sequences and rollback more obvious

an email, etc., it can't be rolled back. Might it be useful to find those irreversible operations we document and mark same? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] proposal - assign result of query to psql variable

On Sat, Jul 28, 2012 at 06:11:21PM +0200, Pavel Stehule wrote: Hello 2012/7/27 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: 2012/7/26 David Fetter da...@fetter.org: How about \gset var1,,,var2,var3... I don't like this - you can use fake variable

[HACKERS] tzdata2012d

Folks, I just noticed that there's yet another change to time zones: http://www.iana.org/time-zones Can we slide this into the upcoming point release? When would that be? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] proposal - assign result of query to psql variable

skip assigning variables in the target list, which one might want to do. 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] proposal - assign result of query to psql variable

On Thu, Jul 26, 2012 at 08:31:13AM +0200, Pavel Stehule wrote: 2012/7/26 David Fetter da...@fetter.org: On Thu, Jul 26, 2012 at 01:36:17AM -0400, Tom Lane wrote: Pavel Stehule pavel.steh...@gmail.com writes: \eset variable [, variable [..]] query -- it raise exception when more than

Re: [HACKERS] Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

On Mon, Jul 23, 2012 at 08:29:16AM -0400, Andrew Dunstan wrote: On 07/23/2012 12:37 AM, David Fetter wrote: On Tue, Jul 17, 2012 at 06:56:50PM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Jul 16, 2012 at 3:18 PM, Tom Lane t...@sss.pgh.pa.us wrote: BTW, while we

Re: [HACKERS] Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

hogwash. This is not giving me a warm feeling about our testing practices. Is there any part of this that the buildfarm, or some other automation framework, might be able to handle? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] CHECK NO INHERIT syntax

a bug. 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] psql \n shortcut for set search_path =

to 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] [PATCH] psql \n shortcut for set search_path =

On Tue, Jul 10, 2012 at 06:26:22PM +0200, Colin 't Hart wrote: On 10 July 2012 18:24, David Fetter da...@fetter.org wrote: On Tue, Jul 10, 2012 at 12:00:06PM -0400, Tom Lane wrote: Josh Kupershmidt schmi...@gmail.com writes: On Tue, Jul 10, 2012 at 2:09 AM, Colin 't Hart co

Re: [HACKERS] [COMMITTERS] pgsql: Make walsender more responsive.

of contented locks.) I say we leave it in there ;) 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] proof concept - access to session variables on client side

something an attacker could somehow use, 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 iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] Catalog/Metadata consistency during changeset extraction from wal

with NULLs? 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] Catalog/Metadata consistency during changeset extraction from wal

On Tue, Jun 26, 2012 at 05:05:27PM -0500, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: On Mon, Jun 25, 2012 at 01:50:54PM -0500, Kevin Grittner wrote: One fine point regarding before and after images -- if a value doesn't change in an UPDATE, there's no reason to include

[HACKERS] Nasty, propagating POLA violation in COPY CSV HEADER

. 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 donating

Re: [HACKERS] Nasty, propagating POLA violation in COPY CSV HEADER

On Wed, Jun 20, 2012 at 11:47:14AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: Rather than being totally ignored in the COPY OUT (CSV HEADER) case, the header line in should be parsed to establish which columns are where and rearranging the output if needed

Re: [HACKERS] Nasty, propagating POLA violation in COPY CSV HEADER

On Wed, Jun 20, 2012 at 12:18:45PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: OK, new proposal: COPY FROM (Thanks, Andrew! Must not post while asleep...) should have an option which requires that HEADER be enabled and mandates that the column names in the header match

Re: [HACKERS] initdb and fsync

starts postgres with fsync off. This is good, and I don't want to have more overhead in the tests. It's not like we already have awesome test coverage for OS interaction. What sorts of coverage would we want? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

Re: [HACKERS] 9.2 final

beta. They're a big chunk of why it might well be OK to step toward this major release :) 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] New Postgres committer: Kevin Grittner

@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://www.tripit.com/feed

Re: [HACKERS] hash index concurrency

/ EXCLUDE will create implicit index foo_i_excl for table foo CREATE TABLE dfetter@dfetter:5492=# insert into foo VALUES (1),(1); ERROR: conflicting key value violates exclusion constraint foo_i_excl DETAIL: Key (i)=(1) conflicts with existing key (i)=(1). Cheers, David. -- David Fetter da

Re: [HACKERS] How could we make it simple to access the log as a table?

? The trick, as I see it, is to make those on-disk log files be partitions of a table. Stephen Frost's point is well-taken, but I'm not sure we need to make it a blocker for this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] Remove readline notice from psql --version?

On Sun, May 20, 2012 at 01:24:21AM +0300, Peter Eisentraut wrote: Currently, psql --version prints something like psql (PostgreSQL) 9.2beta1 contains support for command-line editing I think this should be replaced with a notice about the actual library used. Cheers, David. -- David Fetter

Re: [HACKERS] WIP Patch: Selective binary conversion of CSV file foreign tables

On Tue, May 08, 2012 at 08:26:02PM +0900, Etsuro Fujita wrote: I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], Is the patch they used against 9.0 published somewhere? Cheers, David. -- David Fetter da

Re: [HACKERS] Feature proposal: list role members in psql

(or tree, if you're structured like that) for \du+ 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] Uppercase tab completion keywords in psql?

key). Any chance of reverting this change? Should it be governed by a setting? Something like (upper|lower|preserve) ? 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] Uppercase tab completion keywords in psql?

, 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] CREATE FOREGIN TABLE LACUNA

On Thu, Mar 15, 2012 at 11:23:43AM -0300, Alvaro Herrera wrote: Excerpts from David Fetter's message of jue mar 15 02:28:28 -0300 2012: On Wed, Mar 14, 2012 at 12:06:20PM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 10:22 AM, David Fetter da...@fetter.org wrote: I think that instead

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Fri, Mar 23, 2012 at 11:38:56AM -0700, David Fetter wrote: On Thu, Mar 15, 2012 at 11:23:43AM -0300, Alvaro Herrera wrote: Excerpts from David Fetter's message of jue mar 15 02:28:28 -0300 2012: On Wed, Mar 14, 2012 at 12:06:20PM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 10:22

Re: [HACKERS] Proposal: Create index on foreign table

the information for the lifetime of the session. Of course, a mere few GB of information queried each time couldn't possibly cause intolerable overheads... Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Thu, Mar 15, 2012 at 11:23:43AM -0300, Alvaro Herrera wrote: Excerpts from David Fetter's message of jue mar 15 02:28:28 -0300 2012: On Wed, Mar 14, 2012 at 12:06:20PM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 10:22 AM, David Fetter da...@fetter.org wrote: I think that instead

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Thu, Mar 15, 2012 at 11:23:43AM -0300, Alvaro Herrera wrote: Excerpts from David Fetter's message of jue mar 15 02:28:28 -0300 2012: On Wed, Mar 14, 2012 at 12:06:20PM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 10:22 AM, David Fetter da...@fetter.org wrote: I think that instead

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Tue, Mar 13, 2012 at 08:24:47AM -0700, David Fetter wrote: Folks, This is for 9.3, of course. I noticed that CREATE FOREIGN TABLE (LIKE some_table) doesn't work. I believe it should, as it would: - Remove a POLA violation - Make data loading into an extant table even easier

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Wed, Mar 14, 2012 at 08:53:17AM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 8:28 AM, David Fetter da...@fetter.org wrote: On Tue, Mar 13, 2012 at 08:24:47AM -0700, David Fetter wrote: Folks, This is for 9.3, of course. I noticed that CREATE FOREIGN TABLE (LIKE some_table

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Wed, Mar 14, 2012 at 10:27:28AM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Wed, Mar 14, 2012 at 8:28 AM, David Fetter da...@fetter.org wrote: Here's a WIP patch (lots of cut/paste, no docs, no tests), but it does work. �Still to do in addition: decide whether

Re: [HACKERS] VALID UNTIL

. 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] CREATE FOREGIN TABLE LACUNA

On Wed, Mar 14, 2012 at 11:29:14AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Wed, Mar 14, 2012 at 10:27:28AM -0400, Tom Lane wrote: Hm. That opinion seems to me to connect to the recently-posted patch to make contrib/file_fdw enforce NOT NULL constraints. Should we

Re: [HACKERS] CREATE FOREGIN TABLE LACUNA

On Wed, Mar 14, 2012 at 12:06:20PM -0400, Robert Haas wrote: On Wed, Mar 14, 2012 at 10:22 AM, David Fetter da...@fetter.org wrote: I think that instead of inventing new grammar productions and a new node type for this, you should just reuse the existing productions for LIKE clauses

[HACKERS] CREATE FOREGIN TABLE LACUNA

to think of it, which CREATE TABLE options are inappropriate to CREATE FOREIGN TABLE? 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] 16-bit page checksums for 9.2

factors between 10 and 100? For the former, I'm looking for whether those changes are within ordinary variation, and in the latter, some better idea of what the curve looks like. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] semi-PoC: kNN-gist for cubes

On Mon, Feb 06, 2012 at 06:25:33PM -0500, Jay Levitt wrote: I have a rough proof-of-concept for getting nearest-neighbor searches working with cubes. Please attach such patches to the email when posting them :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

Re: [HACKERS] semi-PoC: kNN-gist for cubes

On Tue, Feb 07, 2012 at 05:56:52AM -0800, David Fetter wrote: On Mon, Feb 06, 2012 at 06:25:33PM -0500, Jay Levitt wrote: I have a rough proof-of-concept for getting nearest-neighbor searches working with cubes. Please attach such patches to the email when posting them :) And here's

Re: [HACKERS] WIP(!) Double Writes

On Wed, Jan 04, 2012 at 10:19:16PM -0800, David Fetter wrote: Folks, Please find attached two patches, each under the PostgreSQL license, one which implements page checksums vs. REL9_0_STABLE, the other which depends on the first (i.e. requires that it be applied first) and implements

[HACKERS] Page Checksums + Double Writes

to do this would be to have an optional field at the end of the special space based on the new bit. Rows from pg_upgrade would have the bit clear, and would have the shorter special structure without the checksum. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [HACKERS] Page Checksums + Double Writes

On Wed, Dec 21, 2011 at 04:18:33PM -0800, Rob Wultsch wrote: On Wed, Dec 21, 2011 at 1:59 PM, David Fetter da...@fetter.org wrote: One of the things VMware is working on is double writes, per previous discussions of how, for example, InnoDB does things. The world is moving to flash

Re: [HACKERS] Page Checksums

and not complain in that case, but complain if there's a CRC failure and it *doesn't* look like a torn page? No. Would you be so kind as to elucidate this a bit? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Page Checksums

On Sun, Dec 18, 2011 at 10:14:38AM +0200, Heikki Linnakangas wrote: On 17.12.2011 23:33, David Fetter wrote: What: Please find attached a patch for 9.2-to-be which implements page checksums. It changes the page format, so it's an initdb-forcing change. How: In order

Re: [HACKERS] Page Checksums

On Sun, Dec 18, 2011 at 12:19:32PM +0200, Heikki Linnakangas wrote: On 18.12.2011 10:54, David Fetter wrote: On Sun, Dec 18, 2011 at 10:14:38AM +0200, Heikki Linnakangas wrote: On 17.12.2011 23:33, David Fetter wrote: If this introduces new failure modes, please detail, and preferably

[HACKERS] Page Checksums

this as dealing with a previously un-dealt-with failure rather than causing one. Questions, comments and bug fixes are, of course, welcome. Let the flames begin! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Large C files

On Fri, Oct 14, 2011 at 07:36:32PM +0100, Peter Geoghegan wrote: This evening, David Fetter described a problem to me that he was having building the Twitter FDW. It transpired that it was down to its dependence on an #include that was recently judged to be redundant.This seems like another

Re: [HACKERS] Range Types - typo + NULL string constructor

to left-closed, right-open. The use case for that one is so compelling that I'm OK with making it the default from which deviations need to be specified. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] Range Types - typo + NULL string constructor

On Tue, Oct 11, 2011 at 03:20:05PM +0200, Florian Pflug wrote: On Oct11, 2011, at 14:43 , David Fetter wrote: I'd recoil at not having ranges default to left-closed, right-open. The use case for that one is so compelling that I'm OK with making it the default from which deviations need

Re: [HACKERS] Range Types - typo + NULL string constructor

On Tue, Oct 11, 2011 at 12:09:01PM -0400, Robert Haas wrote: On Tue, Oct 11, 2011 at 12:03 PM, Jeff Davis pg...@j-davis.com wrote: On Tue, 2011-10-11 at 06:28 -0700, David Fetter wrote: Certainly not the end of the world, but is the convenience of being able to write somerange(a, b

Re: [HACKERS] Range Types - typo + NULL string constructor

On Tue, Oct 11, 2011 at 12:18:18PM -0400, Robert Haas wrote: On Tue, Oct 11, 2011 at 12:12 PM, David Fetter da...@fetter.org wrote: Nothing's bad about '[]' per se.  What's better, but possibly out of the reach of our current lexing and parsing system, would be things like: [1::int, 10

Re: [HACKERS] Extend file_fdw wrapper

the coarser, so in this case, the setting for the table should take precedence over the setting for the server. Also I think documents and regression tests would be required for this kind of change. +1 :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Extend file_fdw wrapper

options at that level. All the options being supplied seem much saner left as just foreign table options. You raise an excellent point, which is that there probably should be options at that level which override the (settable) generic file_fdw options. Cheers, David. -- David Fetter da

Re: [HACKERS] WIP: Collecting statistics on CSV file data

information. If you know anything, please tell me.) Look into the virtual index interface from Informix. We might want to start a wiki page on this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Should we get rid of custom_variable_classes altogether?

term them. I'd be less tempted to call them not bright and more tempted to think they might assume PostgreSQL already takes care of cleaning this up, but whatever. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Feature proposal: www_fdw

be hand-tooling it all? 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] feature request: auto savepoint for interactive psql when in transaction.

unnecessarily if we changed this default. 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] TABLE tab completion

it also (eventually) do SRFs? 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] Is there really no interest in SQL Standard?

it on the public internet. I'd like to be on this list, and believe I qualify. 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] WIP: Collecting statistics on CSV file data

network, and these two tables in Oracle. 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] Generating a query that never returns

to refer to the CTE on the right side of the UNION [ALL] (or the INTERSECT [ALL] per the SQL standard). Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] Is there really no interest in SQL Standard?

guys and their IP claims. That's probably not a bad idea. The down side is that it'll be the work of decades, not years, to get this thing going. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] Sponsored development

. Unless there's something really clever whereby you would use the same syntax in the DDL that you would for non-array FKs, there's still work to be done, possibly via a wrapper around the things you mentioned. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] Rough impl of IGNORE NULLS for window functions

on bitbucket, could you please send a patch vs. git master to the list? Cheers, David (pretty excited about this feature). -- 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] Re: [BUGS] BUG #6189: libpq: sslmode=require verifies server certificate if root.crt is present

. Anybody want to tackle same? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] Re: [BUGS] BUG #6189: libpq: sslmode=require verifies server certificate if root.crt is present

On Mon, Sep 12, 2011 at 07:37:23PM +0200, Magnus Hagander wrote: On Mon, Sep 12, 2011 at 19:21, David Fetter da...@fetter.org wrote: On Wed, Aug 31, 2011 at 09:59:18AM +, Srinivas Aji wrote: The following bug has been logged online: Bug reference:      6189 Logged

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