On Tue, Aug 18, 2015 at 11:23:32PM -0400, Tom Lane wrote:
> Craig Ringer writes:
> > On 18 August 2015 at 01:18, David Fetter wrote:
> >> FETCH [in WITH]
>
> > I'd be a huge fan of this one. I'd love to see FETCH in
> > subqueries, too. Currently doing
On Wed, Aug 19, 2015 at 04:30:39PM +0900, Amit Langote wrote:
> On 2015-08-18 PM 10:43, David Fetter wrote:
> >>
> >> After the first command is done, the second command would take exclusive
> >> lock on table_name, scan the table to check if it contains any valu
On Tue, Aug 18, 2015 at 04:54:07PM +0100, Greg Stark wrote:
> On Tue, Aug 18, 2015 at 2:16 PM, David Fetter wrote:
> > I'm given to understand that this tight coupling is necessary for
> > performance. Are you saying that it could be unwound, or that
> > testing strateg
t;
> This removes partition_name as partition of partitioned_table. The table
> continues to exist with the same name or 'table_name', if specified.
> pg_class.relispartition is set to false for the table, so it behaves like
> a normal table.
Could this take anything sho
ut doing a complete planner
> run on a query.
I'm given to understand that this tight coupling is necessary for
performance. Are you saying that it could be unwound, or that testing
strategies mostly need to take it into account, or...?
Cheers,
David.
--
David Fetter http://fetter.or
gh.
Among many other things, certainly :)
> > SHOW
>
> Not very useful, easy to work around (pg_settings).
This particular one is just about being consistent, or the way I look
at it, about avoiding surprising users with inconsistencies.
Cheers,
David.
--
David Fetter http://fetter.org
;t have all
the row-returning commands in WITH?
Cheers,
David.
--
David Fetter 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
l about which type of "half"
we are defining. For some financial calculations, a "month" is always
30 days, a "quarter," always three "months," i.e. 90 days, and a
"half" is six "months," or 180 days.
Yes, date math is crazy,
On Tue, Aug 11, 2015 at 05:13:03PM +0200, Daniel Verite wrote:
> David Fetter wrote:
>
> > That depends on what you mean by "dynamic columns." The approach
> > taken in the tablefunc extension is to use functions which return
> > SETOF RECORD, which
d.
That said, a thing in psql that could slice serialized output into
columns would be handy as a broad, general part of reporting in psql,
and would mesh quite nicely with a back-end PIVOT (SERIALIZATION FOO)
or whatever syntax we land on.
Cheers,
David.
--
David Fetter http://fetter.org/
P
On Mon, Aug 10, 2015 at 07:10:41PM +0200, Daniel Verite wrote:
> David Fetter wrote:
>
> > I'm working up a proposal to add (UN)PIVOT support to the back-end.
>
> I was under the impression that a server-side PIVOT *with dynamic
> columns* was just unworkable a
if you are using some particular piece of extra
software, in this case the psql client.
I'm working up a proposal to add (UN)PIVOT support to the back-end.
Would you like to join in on that?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yah
ls bar, it makes sense to me that
> `CREATE EXTENSION foo` would install bar if it was available, and
> complain if it wasn’t.
This is this baseline sane behavior. Getting the full dependency
tree, although it would be very handy, would require more
infrastructure than we have now.
Cheers
ssive predicate locking mechanism now?
> Can it be that because of the small table size it performs sequential scan
> and locks the entire table?
>
> Sorry if any of these questions are plain stupid.
Thanks for asking. These questions are quite reasonable.
Cheers,
David.
--
David Fe
s, in my opinion, essentially required to make PGXN
> > useful for anything other than a scratchpad.
>
> Most of the distributions on PGXN feature links to their source code
> repositories.
Should this just be made a hard requirement for PGXN? Lack of a
source code repo is a pretty goo
stification for the legal department for why we should install this
software," to cause things simply never to get installed.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
R
when it comes to temporal databases,
which modern storage systems has made a good bit less crazy than they
were when we got rid of time travel.
What say?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Thu, May 21, 2015 at 12:24:03PM -0400, Robert Haas wrote:
> On Thu, May 21, 2015 at 12:21 PM, Andrew Gierth
> wrote:
> >>>>>> "David" == David Fetter writes:
> >
> > David> How about a more sensible data structure as a PG-specific addon.
&
?
How about a more sensible data structure as a PG-specific addon.
GROUPING_JSON() seems like just the thing.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
C
reate something like GROUPING_JSON().
Cheers,
David.
--
David Fetter 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
--
Sen
Folks,
We are now three tzdata changes behind. There are bugs in pg_dump
which create real restore errors for people using PostGIS, one of our
most popular extensions.
Can we please wrap and ship 9.4.2, etc., and do it soon?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235
get to, and then post further to
> this list, if there is interest.
I suspect that you would get a lot further with a PoC patch including
the needed documentation. Remember to include how this would work at
all the transaction isolation levels and combinations of same that we
support. Recall a
On Tue, Apr 28, 2015 at 09:39:02PM +0900, Amit Langote wrote:
> On Tue, Apr 28, 2015 at 9:28 PM, David Fetter wrote:
> > On Tue, Apr 28, 2015 at 03:17:08PM +0900, Amit Langote wrote:
> >>
> >> An example,
> >> postgres=# alter foreign table fparent alter a
'm pretty sure this is a bug. The way I see it, foreign tables can
either fully participate in table inheritance, or not at all, because
any inconsistencies here will cause confusion at best.
How big a deal would it be to fix it?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone:
d, then partitions under it called foo_jp, foo_us,
etc., in one level, foo_us_ca, foo_us_pa, etc. in the next level, and
on down, each in general in a separate data center.
Is there something essential about having non-leaf nodes as foreign
tables that's a problem here?
Cheers,
David.
--
ook there. If
> we don't agree with this, then the duplication check shall also bump
> to runtime checks.
I don't think any of this is needed.
- Heikki
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP:
that promise always rather than
search case by case, at least up to bugs in the version-checking
software.
http://search.cpan.org/~rjbs/Test-MinimumVersion-0.101081/lib/Test/MinimumVersion.pm
What say?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yah
for the community.
One issue with this patch is that it is not localized. If someone
goes and changes the S_LOCK implementation for one of the platforms
below, or adds a new platform, etc., without changing this comment
too, this comment becomes confusingly obsolete.
How do you plan to addres
On Thu, Apr 02, 2015 at 11:46:53AM +0900, Michael Paquier wrote:
> On Thu, Apr 2, 2015 at 9:38 AM, Alvaro Herrera
> wrote:
> >
> > David Fetter wrote:
> > > On Wed, Apr 01, 2015 at 08:13:02PM -0300, Alvaro Herrera wrote:
> > > > I have pushed this af
ferent hosts might
work, but I'll see what I can do.
Cheers,
David.
--
David Fetter 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/
On Tue, Mar 31, 2015 at 12:22:39PM -0700, David Fetter wrote:
> On Tue, Mar 31, 2015 at 12:58:27PM -0400, Tom Lane wrote:
> > David Fetter writes:
> > > On Tue, Mar 31, 2015 at 10:34:45AM -0400, Adam Brightwell wrote:
> > >> Previously, zero was rejected, wh
On Tue, Mar 31, 2015 at 12:58:27PM -0400, Tom Lane wrote:
> David Fetter writes:
> > On Tue, Mar 31, 2015 at 10:34:45AM -0400, Adam Brightwell wrote:
> >> Previously, zero was rejected, what does it do now? I'm sure it
> >> represents 0 AD/CE, however, is that imp
There should
probably be tests for that. The issue here is that zero was
popularized a very long time after the beginning of the Common Era.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmai
ering depending on backend version.
So basically, extension writers get to win a Rube Goldberg if they use
it for actually building software :/
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david
On Mon, Mar 30, 2015 at 05:35:29PM -0500, Jim Nasby wrote:
> On 3/26/15 5:26 PM, David Fetter wrote:
> >+ * Note: Non-positive years are take to be BCE.
>
> s/take/taken/
Good point. Next patch attached.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 41
Folks,
For reasons unclear, dates before the Common Era are disallowed in
make_date(), even though about 2/3 of the underlying data type's range
up until the present time fits that description.
Please find attached a patch fixing same.
Cheers,
David.
--
David Fetter http://fetter.org/
xt,
> yadda yadda). So I'm not in favor of doing the latter without a much
> more solid case than has been made.
Would PG_VERSION_NUM in the Makefile actually help writers of
extensions to do numeric comparisons on the version of PostgreSQL in a
way that doesn't win a Rube Goldberg
zation on or
> off" could stand improvement; it really conveys zero information. Maybe
> something like "force data to disk when committing"?
>
> Also, whatever we do here should be reflected into the description strings
> in guc.c.
I don't suppose there's
On Fri, Feb 27, 2015 at 08:42:29AM -0800, David Fetter wrote:
> On Mon, Feb 23, 2015 at 05:56:12PM -0300, Alvaro Herrera wrote:
> >
> > David Fetter wrote:
> >
> > > My thinking behind this was that the patch is a bug fix and intended
> > > to be back-patc
Cheers,
David.
--
David Fetter 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
er state.
Would it be simpler to write a separate patch to add an int16 SQL type
so that this implication is correct?
> The worst part of writing this patch has always been naming functions and
> types. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: d
On Tue, Mar 03, 2015 at 09:52:55PM -0500, Robert Haas wrote:
> On Mon, Mar 2, 2015 at 5:05 PM, David Fetter wrote:
> > So just to clarify, are you against back-patching the behavior
> > change, or the addition to src/common?
>
> Mostly the latter.
So you're saying
statement.
>
> Ah, like
> https://www.postgresql.org/message-id/1402790204.65037.YahooMailNeo%40web122301.mail.ne1.yahoo.com
Yes, very much like that.
Kevin, might you be able to give some guidance on this?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM:
On Mon, Mar 02, 2015 at 04:52:37PM -0500, Robert Haas wrote:
> On Mon, Feb 23, 2015 at 3:56 PM, Alvaro Herrera
> wrote:
> > David Fetter wrote:
> >
> >> My thinking behind this was that the patch is a bug fix and intended
> >> to be back-patched, so I wanted t
On Fri, Feb 27, 2015 at 02:51:18PM -0300, Alvaro Herrera wrote:
> I don't understand. Why don't these patches move anything to
> src/common?
Because I misunderstood the scope. Hope to get to those this evening.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 4
check would be a good nice. The patch footprint is pretty low so we
> may be able to backport this patch easily.
+1 for backporting. It's a real bug, and real people get hit by it if
they're using PostGIS, one of our most popular add-ons.
Cheers,
David.
--
David Fetter http
On Mon, Feb 23, 2015 at 05:56:12PM -0300, Alvaro Herrera wrote:
>
> David Fetter wrote:
>
> > My thinking behind this was that the patch is a bug fix and intended
> > to be back-patched, so I wanted to mess with as little infrastructure
> > as possible. A new version
.postgresql.org/
Cheers,
David.
--
David Fetter 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-hack
On Fri, Feb 20, 2015 at 05:55:20PM -0300, Alvaro Herrera wrote:
> Pavel Stehule wrote:
> > 2015-02-20 8:22 GMT+01:00 David Fetter :
> >
> > > On Fri, Feb 20, 2015 at 07:10:29AM +0100, Pavel Stehule wrote:
> > > > Hi
> > > >
> > > > I am
I'll mark this patch as ready for commit.
Thanks for fixing the bug. Let's go with this.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
C
On Thu, Feb 19, 2015 at 09:32:29PM +0100, Pavel Stehule wrote:
> 2015-02-19 19:51 GMT+01:00 David Fetter :
>
> > On Sun, Feb 01, 2015 at 08:38:24AM +0100, Pavel Stehule wrote:
> >
> > I'm not sure how best to illustrate those. Are you thinking of one
> > ex
ing;
Changed. This is cleaner.
> I have not any other comments.
>
> Possible questions:
> 1. more examples in doc
I'm not sure how best to illustrate those. Are you thinking of one
example each for the URI and conninfo cases?
> 2. small change how to check keep_password
On Wed, Feb 18, 2015 at 08:31:09PM -0700, David G. Johnston wrote:
> On Wed, Feb 18, 2015 at 6:50 PM, Andrew Dunstan wrote:
> > On 02/18/2015 08:34 PM, David Fetter wrote:
> >
> >> On Tue, Feb 17, 2015 at 08:21:32PM -0500, Peter Eisentraut wrote:
> >>
> >
g the population variance.
Why population variance and not sample variance? In distributions
where the second moment about the mean exists, it's an unbiased
estimator of the variance. In this, it's different from the
population variance.
Cheers,
David.
--
David Fetter http://fetter.or
On Fri, Feb 13, 2015 at 03:13:11PM -0600, Jim Nasby wrote:
> On 2/10/15 2:04 PM, David Fetter wrote:
> >>>> >Yeah, but people expect to be able to partition on ranges that are not
> >>>> >all of equal width. I think any proposal that we shouldn't sup
cgi-bin/show_history.pl?nm=nudibranch&br=HEAD
That's super awesome!
Do you have access to put a z/OS animal there, too? The compilers
available for that OS, as well as the OS itself, should make for some
very interesting results.
Cheers,
David.
--
David Fetter http://fetter.org/
Phon
on is there.
In both cases, permission for a tuple to exist is based on another
other tuple's presence with some generalized equality criterion. In
the exclusion case, it's prevented. In the inclusion case, it's
required.
Cheers,
David.
--
David Fetter http://fetter.o
r that is an equivalence
relation, however it's denoted. In practical terms, you'd need to
have a quick way to enumerate the equivalence classes and another to
establish whether equivalence holds.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
page," for those using web browsers, would really
smooth off some burrs.
Cheers,
David.
--
David Fetter 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: htt
gt;the doc build that I wind up waiting for at the end.
>
> I realize this is slightly OT, but I wonder if it might be worth having
> targets that build and install everything but the docs.
That'd be great.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
On Sat, Jan 31, 2015 at 12:50:20AM +0900, Sawada Masahiko wrote:
> On Sat, Jan 31, 2015 at 12:24 AM, David Fetter wrote:
> > On Fri, Jan 30, 2015 at 09:38:10PM +0900, Sawada Masahiko wrote:
> >> On Tue, Jan 27, 2015 at 3:34 AM, Robert Haas wrote:
> >> > On Thu, Jan
; option :-(.
Given that this has been deprecated for years, maybe it's time we took
it out in 9.5. That the interested parties haven't bothered to put
buildfarm members in that use the option tells me that they're not all
that interested.
Cheers,
David.
--
David Fetter h
|
> sourcefile
> ++
> max_connections| 100|
> /home/masahiko/pgsql/master/3data/postgresql.conf
> shared_buffers | 128MB
On Wed, Jan 28, 2015 at 04:10:42PM -0500, Tom Lane wrote:
> David Fetter writes:
> > While investigating another project, namely adding pg_hba.conf support
> > to pgbouncer, I ran into a stumbling block others probably will, too:
> > the hba code is backend-only, which means
ergic to copypasta, so unless there are big objections, I'd
like to export those functions to make hba available to other code.
Objections?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...
Q21
> I see a speedup of ~100% when using IndexScan prefetching + Nested-Loops
> Look-Ahead (the outer loop!).
> (On SSD with 32 Pages Prefetch/Look-Ahead + Cold Page Cache / Small RAM)
Would you be so kind as to pass along any patches (ideally applicable
to git master), tests, and specif
t; >
>
> Wow. Thanks.
>
> Btw, for bug-fix patches like this, should the patch creator (me) also
> create patches for back branches?
As I understand it, back-patches are the committer's responsibility.
The submitter might make suggestions as to how this might be
approac
On Sat, Jan 10, 2015 at 04:41:16PM -0800, David Fetter wrote:
> On Sat, Jan 10, 2015 at 09:30:57AM +0100, Erik Rijkers wrote:
> > On Fri, January 9, 2015 20:15, David Fetter wrote:
> > > [psql_fix_uri_service_003.patch]
> >
> > Applies on master; the feature (switch
\dx+, but the + is already used to show the objects associated with the
> extensions. (Althought it seems like it would more in keeping with other
> usage if \dx+ only listed the objects if it was given a pattern, and did
> what I propose if given no pattern)
For what it's worth, of
in wrapper around PQconnectdbParams?
+1 for this. Having a single point of truth here would be a big win.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider don
On Sat, Jan 10, 2015 at 09:30:57AM +0100, Erik Rijkers wrote:
> On Fri, January 9, 2015 20:15, David Fetter wrote:
> > [psql_fix_uri_service_003.patch]
>
> Applies on master; the feature (switching services) works well but a \c
> without any parameters produces a segfault
On Thu, Jan 08, 2015 at 08:04:47PM -0800, David Fetter wrote:
> On Mon, Jan 05, 2015 at 02:26:59PM -0800, David Fetter wrote:
> > On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote:
> > > On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
> > >
On Mon, Jan 05, 2015 at 02:26:59PM -0800, David Fetter wrote:
> On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote:
> > On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
> > >
> > > Yeah, that's the correct solution. It should not be terr
On Wed, Jan 07, 2015 at 05:18:58PM -0800, Peter Geoghegan wrote:
> On Wed, Jan 7, 2015 at 5:16 PM, David Fetter wrote:
> > There's precedent. Unique constraints, for example.
>
> I don't see that as any kind of precedent.
In the part you sliced off, Stephen descri
ppens, of course, but I really don't like the idea that the
> exact same command, with the exact same policies, would succeed or fail,
> due to policies, based on the data in the database.
There's precedent. Unique constraints, for example.
Cheers,
David.
--
David Fetter ht
On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote:
> On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
> >
> > Yeah, that's the correct solution. It should not be terribly difficult to
> > create a test for a conninfo string in the dbname parame
llowed.';
>
> Quite apart from any other reason, the "Sir" does seem a bit sexist - we
> have no idea of the gender of the reader. Probably just 'sorry, no rewrite
> allowed' would suffice.
We should change it to, "I'm sorry. I can't do that.&q
On Sat, Jan 03, 2015 at 03:03:45PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
> >> The old and the new documentation are both wrong. The directory libpq
> >> consults is `pg_config --sysconfdir`, whi
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
> On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote:
> > On Wed, Dec 31, 2014 at 3:24 PM, David Fetter wrote:
> > > There was a slash missing, which I've added. Where is the default
> > > d
On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote:
> On Wed, Dec 31, 2014 at 3:24 PM, David Fetter wrote:
>
> > Folks,
> >
> > There was a slash missing, which I've added. Where is the default
> > directory on Windows, or is there one?
> >
Folks,
There was a slash missing, which I've added. Where is the default
directory on Windows, or is there one?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to
On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
>
> On 12/17/2014 04:11 AM, Heikki Linnakangas wrote:
> >On 12/17/2014 10:03 AM, Albe Laurenz wrote:
> >>David Fetter wrote:
> >>>I've noticed that psql's \c function handles serv
On Fri, Dec 19, 2014 at 07:03:36PM -0700, David Johnston wrote:
> On Wed, Dec 17, 2014 at 8:25 AM, David Fetter [via PostgreSQL] <
> ml-node+s1045698n5831124...@n5.nabble.com> wrote:
>
> > On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
> >
> &g
e included header that breakable stuff is being used
seems like an excellent way to proceed.
Cheers,
David.
--
David Fetter 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: htt
On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote:
>
> On 12/17/2014 04:11 AM, Heikki Linnakangas wrote:
> >On 12/17/2014 10:03 AM, Albe Laurenz wrote:
> >>David Fetter wrote:
> >>>I've noticed that psql's \c function handles serv
ion.
Is there another one I missed?
If not, which of the approaches seems reasonable?
Cheers,
David.
--
David Fetter 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
./configure doesn't work, or that the code doesn't compile:
elapsed time <= 5 minutes. Or you can keep moving until you have made
progress for the time you've allotted.
But the bigger issue, as others have pointed out, has never been a
technical one. It's motivating people w
ove it
deserves. Perhaps something along the lines of a 128-bit default
structure with a promotion/demotion scheme for larger representations.
Until then, those of us writing extensions are stuck with heaps of
extra instructions in it that could easily be trimmed away to good
effect.
Cheers,
D
as an opaque blob?
Cheers,
David.
--
David Fetter 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 m
hat will make it really hard to add
> later.
Indeed not :)
Cheers,
David.
--
David Fetter 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
ommand-line
> tools into src/bin/. If it should be there it'd be less code churn
> if it went into there in the first place.
+1 for putting it directly in src/bin.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidf
ndry references from the IRC documentation bot and
replaced them with references to github.
Marc,
Could you please remove the Orafce project from pgFoundry?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: da
On Fri, Dec 12, 2014 at 04:21:43PM +0100, Andres Freund wrote:
> On 2014-12-12 07:10:40 -0800, David Fetter wrote:
> > On Thu, Dec 11, 2014 at 05:55:56PM -0500, Tom Lane wrote:
> > > Josh Berkus writes:
> > > > How about *you* run the next one, Tom?
> > >
&
ect, Tom, you seem to carve off an enormous amount of
time to follow -bugs and -general. What say you unsubscribe to those
lists for the duration of your tenure as CFM?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
rent (cost=0.00..280.77 rows=25 width=10)
>On public.ft1
> Remote SQL: UPDATE public.mytable_1 SET a = $2 WHERE ctid = $1
^^
It occurs to me that the command generated by the FDW might well not
be SQL at all, as is the case with file_fdw and anything else that
talks to a N
, even if it has some rough edges. That
> way we can improve it later, rather than have it fall into oblivion.
> Any objections?
Not from me :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.f
On Wed, Dec 03, 2014 at 06:17:51PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote:
> >> What do you mean "reconstruct the enum"?
>
> > Capture its state at the time when IMPORT FOREIGN SCHEMA i
On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote:
> >> No. How would you know whether the remote side even has the enum,
> >> let alone whether it has an identical set of memb
On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote:
> David Fetter writes:
> > I've been trying out 9.5-to-be's PostgreSQL FDW, and I noticed
> > that it doesn't seem to handle enum types. Would this be a
> > trivial fix?
>
> No. How would you
le_name 'foo');
CONTEXT: importing foreign table "foo"
Cheers,
David.
--
David Fetter 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:
301 - 400 of 2082 matches
Mail list logo
