a thing
decades in, it's not clear to me that that would break less stuff or
break it worse than simply disallowing SRFs in the target list, which
has been rejected on bugward-compatibility grounds. I suspect it
would be even worse because disallowing SRFs in target lists would at
least be obvious and
On Mon, May 23, 2016 at 01:36:57PM -0400, Tom Lane wrote:
> David Fetter <da...@fetter.org> writes:
> > On Mon, May 23, 2016 at 01:10:29PM -0400, Tom Lane wrote:
> >> This seems a bridge too far to me. It's just way too common to do
> >> "select genera
ld be far
> more polite to do that for them.
How about making "TABLE generate_series(1,n)" work? It's even
shorter in exchange for some cognitive load.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skyp
t a gigantic amount of
work. Is it worth making ALTER AGGREGATE support the things CREATE
AGGREGATE does?
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
-place binary
upgrade as a strategy. It's always been fragile, and it's only ever
been justifiable on grounds of hardware economics that no longer
obtain.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: david
rid of this user-baffling wart.
Hear, hear!
Sadly, we're too late for 9.6, but we can start with 10.0 and finish
this silliness once and for good.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfett
On Mon, May 16, 2016 at 06:20:34PM -0700, Joshua D. Drake wrote:
> On 05/16/2016 05:52 PM, David Fetter wrote:
> > Folks,
>
> > This path would, of course, run either locally or across a
> > network, and be testable in both cases. There would be a
> > downgrade
ogical
replication that's already in large part built.
This path would, of course, run either locally or across a network,
and be testable in both cases. There would be a downgrade path,
namely switching origin nodes.
What say?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fet
we put
> in.
+1
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
-
ard feature that I have seen requested a few times.
[almost 17 months later]
It seems like now is getting close to the time to get this into
master. The patch might have suffered from some bit rot, but the
design so far seems sound.
What say?
Cheers,
David.
--
David Fetter <da...@fetter.
; now I
> think we're stuck with a decision by default.
This, on the other hand, is more persuasive to me. We now have a much
more public face than we did then.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfette
markably myopic, but I guess
> possible.
You might be astonished at the ubiquity of myopia out in the world.
That's not an argument against 10.0, by the way. Myopia of that type
tends to come with software quality so low that your best bet is never
to start using it, and your second-best
rting with
deprecation of the old name in 9.6, etc. hs_filter(), perhaps?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Po
realities with JSON is that there isn't a
> terribly good binary representation, afaik. As I understand it, BSON
> doesn't support all the JSON structures that we do; if it did, I'd
> suggest we provide a way to convert our structure into BSON.
How about MessagePack?
http://msgpack.
aking a more flexible serialization
infrastructure? What we have is mostly /ad hoc/, and has already
caused real pain to the PostGIS folks, this even after some pretty
significant and successful efforts were made in this direction.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fet
not sure
> which one to vote for yet.
There's space on the ballot for up to three, and it appears to be a
ranked choice or similar preference system.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
On Fri, Mar 18, 2016 at 06:12:12PM -0700, Jeff Janes wrote:
> On Tue, Mar 15, 2016 at 8:36 AM, David Fetter <da...@fetter.org> wrote:
> >
> > Please find attached a patch that uses the float8 version to cover the
> > numeric types.
>
> Is there a well-defined mea
On Fri, Apr 08, 2016 at 01:47:56PM -0700, David Fetter wrote:
> Sorry about the delay. This patch disallows negative weights,
> although it still has that odd difference Jeff found.
Difference corrected. It turned out that my reference was mistaken on
the calculation.
Cheers,
David.
--
On Sun, Mar 20, 2016 at 03:38:40PM -0700, David Fetter wrote:
> On Sat, Mar 19, 2016 at 05:04:08PM +0100, Tomas Vondra wrote:
> > Hi,
> >
> > On 03/19/2016 07:34 AM, David Fetter wrote:
> > >On Fri, Mar 18, 2016 at 06:12:12PM -0700, Jeff Janes wrote:
> > >
On Tue, Apr 05, 2016 at 07:10:56PM -0400, Robert Haas wrote:
> On Tue, Apr 5, 2016 at 6:50 PM, David Fetter <da...@fetter.org> wrote:
> > Is there a reason other than lack of tuits for this restriction?
>
> "this" lacks an antecedent.
Try to put a primary key on a
Folks,
Is there a reason other than lack of tuits for this restriction?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider do
On Mon, Mar 21, 2016 at 01:33:28PM +, Robert Haas wrote:
> Support parallel aggregation.
...and there was much rejoicing!
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP:
On Sat, Mar 19, 2016 at 05:04:08PM +0100, Tomas Vondra wrote:
> Hi,
>
> On 03/19/2016 07:34 AM, David Fetter wrote:
> >On Fri, Mar 18, 2016 at 06:12:12PM -0700, Jeff Janes wrote:
> >>On Tue, Mar 15, 2016 at 8:36 AM, David Fetter <da...@fetter.org> wrote:
> >
On Fri, Mar 18, 2016 at 06:12:12PM -0700, Jeff Janes wrote:
> On Tue, Mar 15, 2016 at 8:36 AM, David Fetter <da...@fetter.org> wrote:
> >
> > Please find attached a patch that uses the float8 version to cover the
> > numeric types.
>
> Is there a well-defined mea
On Fri, Jan 08, 2016 at 04:37:36PM +1100, Haribabu Kommi wrote:
> On Mon, Dec 21, 2015 at 1:50 PM, David Fetter <da...@fetter.org> wrote:
> > On Sun, Dec 20, 2015 at 06:13:33PM -0600, Jim Nasby wrote:
> >> On 11/2/15 5:46 PM, David Fetter wrote:
> >> >
On Wed, Mar 02, 2016 at 03:34:39PM +0900, Michael Paquier wrote:
> On Wed, Mar 2, 2016 at 2:53 PM, David Fetter <da...@fetter.org> wrote:
> > On Wed, Mar 02, 2016 at 10:49:01AM +0900, Michael Paquier wrote:
> >> On Wed, Mar 2, 2016 at 7:22 AM, Michael Paquier
> >>
the CF app? I
> > believe that he cannot change the CF status now. We should switch to
> > "In Progress". I can do that at least.
>
> I am planning to switch 2016-03 from "Open" to "Processing" in a
> couple of hours, at which stage nobody will
On Fri, Feb 26, 2016 at 04:55:23PM +0530, Robert Haas wrote:
> On Wed, Feb 24, 2016 at 4:01 AM, David Fetter <da...@fetter.org> wrote:
> > I'm thinking that both the GUC check and the configure one should
> > restrict it to [1024..65535].
>
> Doesn't sound like a good i
On Tue, Feb 23, 2016 at 04:09:00PM -0600, Jim Nasby wrote:
> On 2/23/16 9:37 AM, Alvaro Herrera wrote:
> >Jim Nasby wrote:
> >>On 2/5/16 10:08 AM, David Fetter wrote:
> >>>On Wed, Feb 03, 2016 at 06:02:57PM -0600, Jim Nasby wrote:
> >>>>I just di
oken. Any
> reason not to have configure or at least make puke if pgport isn't valid?
That seems like a good idea.
I've been getting rejection to happen with phrases like
--with-pgport=${PGPORT:?}
which while it looks a little odd, only adds 4 characters to each
shell variable.
Cheers,
Davi
bit of writing detailed
summaries and splitting patches into logical chunks. All errors in
the PostgreSQL Weekly News are mine, but a little organization like
theirs would go a very long way, and not just for me.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415
Kudos!
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-
also.
>
> Something like the patch attached would be fine? This wins a
> backpatch because the query continuously running eats memory, no?
+1 for back-patching. There's literally no case where an infinite
input could be correct as the start or end of an interval for
generate_series.
Ch
sure
> you will be able to come back with something far more advanced for the
> first CF of 9.6.
What's the latest on this patch?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP:
ese things come down in price, it'll start being more and more
reasonable to treat rotating media as exotic.
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
Remem
On Fri, Jan 08, 2016 at 04:37:36PM +1100, Haribabu Kommi wrote:
> On Mon, Dec 21, 2015 at 1:50 PM, David Fetter <da...@fetter.org> wrote:
> > On Sun, Dec 20, 2015 at 06:13:33PM -0600, Jim Nasby wrote:
> >> On 11/2/15 5:46 PM, David Fetter wrote:
> >> >
they might similar issues.
>
> Wonder if we should instead define a wildcard wrapper in
> Makefile.global.in that does the sorting, including an explanation?
That sounds like it will avert a lot of pain in the future, and the
sort overhead is negligible compared to the build time.
Cheer
y known ROLE with LOGIN--of MAPPING
before completing with MAPPING FOR? I confess to not knowing how the
new system works in enough detail to know that off the top of my head.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter
On Mon, Dec 28, 2015 at 03:01:07PM +, Grzegorz Sampolski wrote:
> Hi.
> New patch available.
Please attach the patch or patch set to your email just like else
does. :)
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfett
together in a widely distributed
archive.
While github may seem like it's gigantic and eternal today, it may not
seem so ten years hence.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.f
> > *but* you are not working on it, it would be nice to mark it as
> > returned with feedback in 2016-01.
>
> And the CF is no closed. Here is the final score:
> Committed: 30.
> Moved to next CF: 42.
> Rejected: 9.
> Returned with Feedback: 22.
> Total:
ason...
>
> Since BRIN indexes cannot be primary keys nor unique keys, it's hard to
> be convinced that the use case of a table with only BRIN indexes is
> terribly interesting.
If you've got high-frequency logs, timestamptz might not operate at
fine enough a grain to form a pri
On Sun, Dec 20, 2015 at 06:13:33PM -0600, Jim Nasby wrote:
> On 11/2/15 5:46 PM, David Fetter wrote:
> >I'd like to add weighted statistics to PostgreSQL
>
> Anything happen with this? If community isn't interested, ISTM it'd be good
> to put this in PGXN.
I think it
e don't have any way of
> > expressing or enforcing that just yet.
> >
> That does sound interesting, but it's important to remember that
> referenced tables are not updated in real time in that same way that
> indexes are.
Is getting them so even remotely possible, given the system
tly cleaner solution is to make public methods to send tuples
to the copy stream and have COPY call those.
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
Remem
e, the
dependency resolution stuff is a first step that appears to be worth
doing by itself even if the effort then pauses, possibly for some
time.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
is part.
> and it is even sadder to see a direct dependency with
> libpqxx :(
I suspect this part is a SMOP, but I'm not quite sure what S might
constitute in this case.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
, or the following is a truly astonishing coincidence:
https://github.com/anse1/sqlsmith
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consi
MatchAny) &&
> + !TailMatches1("CONSTRAINT|TO"))
>
> The regexp patch makes the negative checks somewhat easier to read
> (there are 19 positions in tab-complete.c doing that), still inventing
> a new langage and having a heavy refactoring just ta
teral dependencies could go in a
loop, i.e. is there a reason to put in checks for same in the
transitive closure construction?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.f
On Wed, Dec 09, 2015 at 03:49:20PM +, Greg Stark wrote:
> On Wed, Dec 9, 2015 at 2:27 PM, David Fetter <da...@fetter.org> wrote:
> > Agreed that the "whole new language" aspect seems like way too big a
> > hammer, given what it actually does.
>
> Which
r than emacs, except when my hand is steady enough
> for the magnetized needle approach.[1]
I figured you for more the butterfly type.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
infinitely? Because I wanna install that.
I don't know about infinitely, but at least with the -S (no wrap)
option, less lets you use left- and right-arrow, prefixed by
multipliers, if you like, to scroll horizontally
And now I have learned something new about a pager I've used every day
for
> The behavior I'd have expected is that if the data is narrower than
> the window, the lines only go to the right margin of the data. This
> is a trivial change to the logic in print_aligned_vertical, but before
> I go make it, does anyone want to argue that the current behavi
h do a mixture of workloads it is not
> so easy to micromanage their work_mem. Especially as there are no
> easy tools that let me as the DBA say "if you connect from this IP
> address, you get this work_mem".
That's certainly doable with pgbouncer, for example. What would you
have in
an code that
looks like it could be reused or slightly generalized for the
implementation?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to
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
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
CREATE ROL
but if you don't want to conflict with the name
> crosstab, perhaps "pivot" would be better?
As I mentioned earlier, I'm hoping we can keep PIVOT reserved for the
server side, where all our competitors except DB2 (and MySQL if you
count that) have it.
Cheers,
David.
--
David Fetter <
the rest of the numeric types and maybe others
as make sense.
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
Remember to vote!
Consider donating to Po
t; consider their fortnight to be 15 days!!!
>
> What, it's a "fortnight", not a "quinzaine".
>
> You have no idea how hard it was to resist updating the patch...
Well, if you won't do it, I will.
Please find attached.
Cheers,
David.
--
David Fetter <da...@fetter.o
On Sun, Nov 01, 2015 at 01:06:39PM -0500, Tom Lane wrote:
> David Fetter <da...@fetter.org> writes:
> > On Tue, Oct 27, 2015 at 07:30:13PM +, Nathan Wagner wrote:
> >> On Wed, Oct 28, 2015 at 08:17:25AM +1300, Gavin Flower wrote:
> >> What, it's a "fortnig
On Sat, Oct 31, 2015 at 12:16:31AM +0100, Robert Haas wrote:
> On Thu, Oct 29, 2015 at 10:31 PM, David Fetter <da...@fetter.org> wrote:
> > Had this been part of the original ALTER DEFAULT PRIVILEGES patch,
> > those privileges would simply have been applied. Since it wasn't,
e URIs. I'd think it fine for Postgres to
> support this via multiple "-d" options; that would be about as good.
Indeed. Is there any risk of losing ordering information in the
standard command line processing libraries?
> That can cover 100% of cases, and I don't see it needin
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hacker
community work.
It's great that you're doing what you want to do. I take it that
Crunchy's model involves more FOSS and less special sauce...
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
oesn't is, as far as I
know:
- Whole-instance dumping (its original purpose, as far as I can tell)
- Auth (roles/secrets)
- Tablespaces
I believe that a relatively short patch to pg_dump would allow us to
make better versions of at least the first two. By better, I mean,
- Not require that a whole-instan
ecifically, I am not quite understanding the distinction
between "all cluster" and "global objects."
What do you have in mind on the implementation side? Do you think
pg_dump is a suitable baseline, or were you thinking of something
different, and if so, what?
Cheers,
David.
--
D
?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-h
On Thu, Oct 29, 2015 at 02:25:14PM -0400, Tom Lane wrote:
> David Fetter <da...@fetter.org> writes:
> > Since it's not a green field project, I would like to propose the
> > following addition to the ALTER ... OWNER TO ... construct:
> > ALTER ... OWNER TO ... [{NE
back-patch all the way to 9.1, as the lack of
fortnight support is clearly 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
Remember to vote!
.) and periodicity (f(x) =
f(x+360*n) for integer n, f in (sin, cos, tan, cot, sec, csc), for
example).
I haven't yet found same in a PostgreSQL-compatible library, though.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!:
On Fri, Oct 23, 2015 at 02:09:43AM +0200, Andres Freund wrote:
> On 2015-10-22 16:26:10 -0700, David Fetter wrote:
> > To be affective negatively by libreadline's viral license, an entity
> > would need to fork the psql client in proprietary ways that they did
> > not wish
On Fri, Oct 23, 2015 at 12:15:01PM -0400, Robert Haas wrote:
> On Fri, Oct 23, 2015 at 11:16 AM, David Fetter <da...@fetter.org> wrote:
> > Proprietary, secret changes to the back end, sure, but the client?
> > The most recent example I recall of that is Netezza, and I suspe
hat accessible. There's a lack
> of cooperation on the readline side too: we'd need to be able to see the
> whole query buffer not just the current line.
This may be on point:
http://stackoverflow.com/questions/161495/is-there-a-nice-way-of-handling-multi-line-input-with-gnu-readline
I suspect w
On Thu, Oct 22, 2015 at 04:05:06PM -0700, Tom Lane wrote:
> David Fetter <da...@fetter.org> writes:
> > On Thu, Oct 22, 2015 at 02:36:53PM -0700, Tom Lane wrote:
> >> I have no very good idea how to do that, though. Bison does have a
> >> notion of which symbol
er and deserializer to jsonb.
> Maybe I should publish this code?
Please 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
Remember to vote!
Consider donat
On Tue, Oct 20, 2015 at 02:28:15PM +, Robert Haas wrote:
> Tab complete CREATE EXTENSION .. VERSION.
>
> Jeff Janes
Would this be worth back-patching to 9.5? It seems like a pretty
isolated change with a pretty helpful utility.
Cheers,
David.
--
David Fetter <da...@fett
On Tue, Oct 20, 2015 at 11:16:13AM -0400, Robert Haas wrote:
> On Tue, Oct 20, 2015 at 11:03 AM, David Fetter <da...@fetter.org> wrote:
> > On Tue, Oct 20, 2015 at 10:52:05AM -0400, Robert Haas wrote:
> >> On Mon, Oct 19, 2015 at 8:02 PM, Jim Nasby <jim.na...@
On Tue, Oct 20, 2015 at 10:52:05AM -0400, Robert Haas wrote:
> On Mon, Oct 19, 2015 at 8:02 PM, Jim Nasby <jim.na...@bluetreble.com> wrote:
> > On 10/19/15 1:07 PM, David Fetter wrote:
> >>
> >> What I'd like to do is lift the restriction on ROWS FROM
On Mon, Oct 19, 2015 at 10:24:37AM -0700, David Fetter wrote:
> Folks,
>
> As I was learning how best to add native weighted statistics, coming
> soon, I noticed that our ROWS FROM() constructor takes only
> set-returning functions, gluing the outputs together side by side
&
in our code, modulo horrible things
involving WITH ORDINALITY and FULL JOIN.
Did I miss something?
If not, would it make sense to allow every set-returning construct
inside ROWS FROM(), rather than just some of them?
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Pho
s as a source of subtle bugs in the absence of an
attacker seem more pertinent right now.
https://www.google.com/?q=parse%20tree%20differential%20attack
> So, the only question is whether reusing the existing parser will
> brings along some highly useful functionality beyond an AST and
>
ed-source forks of
PostgreSQL than of any other open source software, certainly if you
normalize to the number of contributors. We fully intend to continue
spawning those proprietary closed-source forks.
What we're not fine with is depending on a proprietary system, no
matter what type of license, as in
On Mon, Sep 28, 2015 at 07:14:40PM +0300, YUriy Zhuravlev wrote:
> On Monday 28 September 2015 08:23:46 David Fetter wrote:
> > They may well be, but until we decide it's worth the switching
> > costs to move to a totally different way of doing things, that
> > system will s
re are a good many decisions I would make differently if I were
waving a magic wand over a green field project. Neither magic wands
nor a green field project are in operation here.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
ry important sense, it does not matter what features a
system has if it isn't one we can control. At a minimum, this means
we need to run it in its entirety on resources we control, and we need
to be able to patch any piece of it on our own say-so.
Cheers,
David.
--
David Fetter <da...@fetter.org>
Folks,
While doing some research for the upcoming (UN)PIVOT proposal, I
noticed that there were some hairy and no-longer-needed bits in the
regression tests for tablefunc, which I have shaved off with the
attached patch.
What say?
Cheers,
David.
--
David Fetter <da...@fetter.org>
that being the number of times I recall offhand having
written the function.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to
t; But I suspect I'm in the minority here, so feel free to ignore me.
> (I certainly do agree that use strict and use warnings are a good
> thing to use everywhere. It's just perlcritic I dislike.)
I believe there are ways to get perlcritic to keep quiet about things
we don't find relevant. May
g it
in template1 by default. Even that's a questionable decision, as
merely having the software in place does not credibly increase the
attack surface, and does up the installation procedures by a fallible
step.
Cheers,
David.
--
David Fetter <da...@fetter.org> http://fetter.org/
Pho
Folks,
In a failed attempt to send the output of \pset to a pipe, I noticed
that for reasons I find difficult to explain, not every output gets
redirected with \o.
At first blush, I'd consider this inconsistency as a bug.
What have I missed?
Cheers,
David.
--
David Fetter <da...@fetter.
On Mon, Aug 31, 2015 at 07:18:02PM +, Kevin Grittner wrote:
> David Fetter <da...@fetter.org> wrote:
>
> > In a failed attempt to send the output of \pset to a pipe, I
> > noticed that for reasons I find difficult to explain, not every
> > output gets redire
On Mon, Aug 31, 2015 at 07:18:02PM +, Kevin Grittner wrote:
> David Fetter <da...@fetter.org> wrote:
>
> > In a failed attempt to send the output of \pset to a pipe, I
> > noticed that for reasons I find difficult to explain, not every
> > output gets redire
:)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers
where we might consider
supporting them, but those would need to be zero-based plans, i.e. the
starting point would be that we don't support them, and arguments
would have to be made affirmatively to support them for some specific,
demonstrable use case.
Cheers,
David.
--
David Fetter da
today; there's some additional stuff in format_type.c there that is
probably useful to share between these two patches.
Should that stuff be its own stand-alone patch?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
On Thu, Aug 20, 2015 at 06:58:24PM +0900, Amit Langote wrote:
On 2015-08-19 PM 09:52, David Fetter wrote:
On Wed, Aug 19, 2015 at 04:30:39PM +0900, Amit Langote wrote:
There are use cases where we need to warn people that their assertions
need to be true, and if those assertions
,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql-hackers mailing list
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 values
outside the boundaries defined
On Tue, Aug 18, 2015 at 11:23:32PM -0400, Tom Lane wrote:
Craig Ringer cr...@2ndquadrant.com writes:
On 18 August 2015 at 01:18, David Fetter da...@fetter.org wrote:
FETCH [in WITH]
I'd be a huge fan of this one. I'd love to see FETCH in
subqueries, too. Currently doing anything like
201 - 300 of 2065 matches
Mail list logo
