ose doing so at the time --- and I'm
> > > pretty dubious that this code is sufficiently
> > > performance-critical to justify the work, either.
> >
> > OK, I'll put a spinlock around access to the head of the array.
>
> v2 patch attached
If you'v
.conf"?
+1. It's clear, and if an attacker can compromise pg_hba.conf,
there's nothing PostgreSQL can do to help.
I'd like to bring up the idea of an attacker who both has that access
and doesn't know about pg_hba.conf just to dismiss it. Such a person
might exist, but w
known-correct syntax
highlighting in text editors.
Cheers,
David.
--
David Fetter 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
grep pipes).
>
> Thoughts?
+1 for simplifying and consolidating.
Cheers,
David.
--
David Fetter 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
up with a directory
structure for the new parallel pg_dump seems like a much better idea.
Andrew, do you have some notes on this?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCa
hole set of records and in the outer select most of them
> discarded.
That sounds like the optimizer's falling down on the job. Would this
be difficult to fix?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
with the SGML,
> and it's really hard to check grammar and languge ... let alone compare
> stuff to the alphas ... in raw SGML.
While not a WYSIWYG, shelling out to "make" after each disk write
should do what you want. Which editor(s) do you like to use? Emacs
and vim both have
On Mon, Mar 22, 2010 at 04:04:16PM -0300, Alvaro Herrera wrote:
> David Fetter wrote:
>
> > diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
> > index 9881ff4..9313112 100644
> > --- a/doc/src/sgml/func.sgml
> > +++ b/doc/src/sgml/func.sgml
> &g
On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote:
> David Fetter writes:
> > I'm seeing a lot of places where this might be documented. Any ideas
> > as to which ones are appropriate?
>
> I would think "Geometric Functions and Operators" would be the
On Mon, Mar 22, 2010 at 04:47:37PM +, Simon Riggs wrote:
> On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote:
>
> > > Yes, for most people touching != overlap. So it just looks like a
> > > bug.
> >
> > I don't know which people you've surv
>
> Yes, for most people touching != overlap. So it just looks like a
> bug.
I don't know which people you've surveyed, but at least in my math
classes, one point in common was sufficient for an overlap. I'd be
happy to write up something that makes this clear.
Cheers,
Dav
e else. Anyone think
> this is sufficiently better to justify possible confusion?
Grouping these this way will help a lot more people, namely the future
ones, than it can possibly confuse :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter66
tgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html
Cheers,
David.
--
David Fetter 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/davi
great time to get into the second class status of domains. :P
Cheers,
David.
--
David Fetter 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
On Fri, Mar 12, 2010 at 07:35:41PM +0100, Pavel Stehule wrote:
> 2010/3/12 David Fetter :
> >
> > This is, by the way, an excellent argument for including hstore in
> > core in 9.1. :)
>
> I like it - but it looking little bit strange - I thinking we need
> only
hst || ('foo' => 'bar');
> NEW := populate_record(NEW,hst);
>return NEW;
>end;
>
>$function$;
>
> But this question probably belongs on -general rather than -hackers.
This is, by the way, an excellent argument for inclu
;ve found it easiest to ship all of PostgreSQL rather than deal with
this kind of stuff.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/fee
On Thu, Mar 11, 2010 at 03:27:23PM +0100, strk wrote:
> On Wed, Mar 10, 2010 at 07:50:16AM -0500, Andrew Dunstan wrote:
>
> > Using an hstore in 9.0 it's not too bad,
>
> Does it still have a limit of 65535 bytes per field ?
No. :)
Cheers,
David.
--
David Fetter http:
ogether from the configure script. I
> don't think we're going to contort our source code in order to make
> a marginal improvement in the ability to coexist with random other
> code that is also polluting the link-time namespace.
+1 for de-supporting this option.
Cheers,
Dav
On Mon, Mar 08, 2010 at 12:18:31PM -0500, Robert Haas wrote:
> On Mon, Mar 8, 2010 at 12:10 PM, David Fetter wrote:
> > On Mon, Mar 08, 2010 at 11:58:20AM -0500, Jaime Casanova wrote:
> >> On Mon, Mar 8, 2010 at 4:17 AM, Pierre C wrote:
> >> >
> >> >>
It results in lots of slow,
> > broken, insecure database designs.
>
> So, if php dev doesn't have time to learn to do things right then we
> have to find time to learn to do things wrong? seems like a nosense
> argument to me
Indeed.
Cheers,
David.
--
David Fetter http
On Fri, Mar 05, 2010 at 03:10:59PM -0500, Andrew Dunstan wrote:
>
>
> David Fetter wrote:
> >On Fri, Mar 05, 2010 at 02:56:23PM +0100, François Pérou wrote:
> >>Dear friends,
> >>
> >>As a reminder, I took part in the development of pgAdmin and I am
>
dress" the concerns of some, but by no means
all, developers of some little project by introducing massive bugs.
That is never going to happen, and you need to stop asking.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: david
explicitly that the label must go
> > before DECLARE.
>
> with the docs saying another thing, this couldn't be considered as a
> bug fix and therefore backpatchable
+1 for back-patching.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfe
On Thu, Feb 25, 2010 at 07:20:58PM -0500, Bruce Momjian wrote:
>
> Did we ever get tab completion support for these backslash commands?
Nope :/
Not sure if I'll be able to get to it this week, either.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM:
o fix xml2. I was afraid to do that back
> in May when the patch was committed, but by now we have enough field
> testing to suggest that 8.4 is no worse than 8.3 as far as the core
> xml operations go.
>
> Comments?
+1 for back-patching.
Cheers,
David.
--
David Fetter http:/
It passes strict, warnings, and
perlcritic -4
Cheers,
David.
--
David Fetter 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 don
RNING
> to something like 5 or 10 seconds. I think the main argument for
> the latter approach would be to avoid log-spam in normal operation.
> Although Greg is correct that a NOTICE wouldn't be logged at default
> log levels, lots of people don't use that default. Comme
lem in that behaviour. If somebody requests a
> backup then we should wait for it to complete. Kevin's suggestion of
> pg_fail_backup() is the only sensible conclusion there because it
> gives an explicit way out of deadlock.
>
> ISTM the problem is that you didn't test. Steps
On Thu, Feb 18, 2010 at 01:51:08PM -0800, David Fetter wrote:
> Folks,
>
> While hacking on PL/Parrot, I ran across an issue where when trying
> to load PL/pgsql, it's done unconditionally and fails. How do we
> fix pg_regress to be a little more subtle about this?
For now,
On Fri, Feb 19, 2010 at 01:34:46PM -0500, Robert Haas wrote:
> On Thu, Feb 18, 2010 at 11:38 PM, Tom Lane wrote:
> > Takahiro Itagaki writes:
> >> David Fetter wrote:
> >>> support both pre-9.0 and post-9.0 PostgreSQLs. David Wheeler has
> >>> sugge
On Fri, Feb 19, 2010 at 12:26:29AM -0200, Euler Taveira de Oliveira wrote:
> David Fetter escreveu:
> > OK, I know it's late, but having PL/pgsql on by default has caused
> > an unforeseen need: --require-language.
> >
> Why? IMHO pg_regress should be used with the s
On Thu, Feb 18, 2010 at 06:27:30PM -0500, Tom Lane wrote:
> David Fetter writes:
> > While hacking on PL/Parrot, I ran across an issue where when
> > trying to load PL/pgsql, it's done unconditionally and fails. How
> > do we fix pg_regress to be a little more subtle ab
Folks,
While hacking on PL/Parrot, I ran across an issue where when trying to
load PL/pgsql, it's done unconditionally and fails. How do we fix
pg_regress to be a little more subtle about this?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
On Tue, Feb 16, 2010 at 12:39:29PM -0500, Rayson Ho wrote:
> On Tue, Feb 16, 2010 at 11:22 AM, David Fetter wrote:
> > * Shell access from several accounts
> > * Git or cvs client
> > * Compiler tools
> > * Perl of a fairly recent vintage
> > * Outbo
On Tue, Feb 16, 2010 at 08:11:15AM -0500, Andrew Dunstan wrote:
>
>
> David Fetter wrote:
> >Folks,
> >
> >Would it be worthwhile to light up some buildfarm animals on OpenVMS?
> >
> >http://www.openvms.org/stories.php?story=10/02/09/2319162
> >
Folks,
Would it be worthwhile to light up some buildfarm animals on OpenVMS?
http://www.openvms.org/stories.php?story=10/02/09/2319162
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
On Fri, Feb 12, 2010 at 12:21:02AM -0200, Euler Taveira de Oliveira wrote:
> David Fetter escreveu:
> > It's consistent with how we do CREATE FUNCTION, where the order of
> > parameters after RETURNS is arbitrary.
> >
> If it is arbitrary the synopsis is wrong becau
ommand rather than at the end.
It's consistent with how we do CREATE FUNCTION, where the order of
parameters after RETURNS is arbitrary.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
On Fri, Feb 12, 2010 at 09:24:55AM +0900, Takahiro Itagaki wrote:
>
> David Fetter wrote:
>
> > > Syntax of DO command is:
> > > DO code [ LANGUAGE lang_name ]
> >
> > That's not the only syntax.
> > DO [LANGUAGE lang_name] code
&g
e
also works, e.g.:
CREATE LANGUAGE plperl;
CREATE TABLE foo(id SERIAL PRIMARY KEY, t TEXT);
DO LANGUAGE plperl $$spi_exec_query(q[INSERT INTO foo(t) VALUES('aaa')]);$$;
SELECT * FROM foo;
The DO LANGUAGE lang_name code syntax is much clearer, as far as I'm
concerned, than putti
pl and contrib.
>
> Thoughts?
+1 on both :)
Cheers,
David.
--
David Fetter 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!
Con
On Wed, Jan 27, 2010 at 12:41:28PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Wed, Jan 27, 2010 at 12:27:08PM -0500, Tom Lane wrote:
> >> The rule against tabs in SGML files is only a bit of anal
> >> retentivity anyway. I don't think that enforcing it
On Wed, Jan 27, 2010 at 12:27:08PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Wed, Jan 27, 2010 at 04:52:00PM +0200, Peter Eisentraut wrote:
> >> Better write a check in the makefile.
>
> > That assumes that everyone will always actually run the
> > a
On Wed, Jan 27, 2010 at 04:52:00PM +0200, Peter Eisentraut wrote:
> On tis, 2010-01-26 at 10:20 -0800, David Fetter wrote:
> > On Tue, Jan 26, 2010 at 02:21:29PM +, Bruce Momjian wrote:
> > > Log Message:
> > > ---
> > > Remove tabs in SGML.
>
On Tue, Jan 26, 2010 at 02:21:29PM +, Bruce Momjian wrote:
> Log Message:
> ---
> Remove tabs in SGML.
Can we see about making a commit hook for CVS that disallows \t in
SGML files? The process in git is pretty simple.
Cheers,
David.
--
David Fetter http://fetter.org/
nge CREATE FUNCTION's behavior.)
The whole default_to_language thing seems like a great way to have
spooky breakage at a distance, so +1 for removing it.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter X
127.0.0.1/32trust
> > >
> > > Sounds good to me.
> >
> > I can't see anyone objecting.
>
> Can we also change the "USER" column heading to "ROLE"?
Does pg_hba.conf actually control any roles other than ones with
login?
to commits,
which have been prefixed with just such a sentence of late.
Your PostgreSQL Weekly News Patch Summarizer,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal
ed to mess with for
> > 8.5. As Simon comments, getting it to work nicely in the face of corner
> > cases (like processes dying unexpectedly) could be a lot of work.
>
> Agreed, polling is good enough for 8.5.
Is this a TODO yet?
Cheers,
David.
--
David Fetter http://fetter.or
all ears if there's better
> > suggestions.
>
> Yeah, I saw. Seems like a reasonable solution for now.
We can always cvs mv...oh, wait! ;)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet
#x27;ll add a note to the commitfest.
A description here would help, too :)
Cheers,
David.
--
David Fetter 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/
a.sender,
a.has_attachments,
t."path" || a.uid,
FROM
t JOIN arc_messages a
ON (
a.mailbox = t.mailbox AND
t.uid = a.parent_uid
)
)
SELECT *
FROM t
ORDER BY "path";
Cheers,
David.
--
David Fetter http:/
On Mon, Jan 11, 2010 at 09:19:44PM -0500, Robert Haas wrote:
> I have not yet given up hope on April 1, but I wouldn't bet on it,
> either.
Let's *not* schedule anything for April 1. There's some history, not
to mention an internet-wide holiday, there.
Cheers,
David.
-
ren't
pertinent to this discussion.
If we're looking to other projects, the Linux kernel might be more
relevant. That has, for the nonce, decided to sacrifice stability for
time-based releases. People who help package the kernel for
distributions are better qualified than I to discuss t
please commit your patches for our new baby elephant!
w00t!
Cheers,
David
--
David Fetter 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
something like CVS...
Cheers,
David.
--
David Fetter 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 donatin
, but apart from that?
Cheers,
David (git! git! git! ;)
--
David Fetter 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!
Cons
mmitFest to free up more committer resources, particularly Tom, to
> work on Hot Standby and Streaming Replication and attempt to
> accelerate the process of getting 8.5 out the door. This proposal
> needs input from the community. The affected patches are:
I don't see any need to thu
replication, which would
> justify tagging this release 9.0. With only one of them, it's 8.5.
> I understand that there are power users who would find HS alone to
> be tremendously useful, but in terms of what the average user sees,
> there's a quantum difference.
By, "
entation that
> builds on the existing PostgreSQL tools and the examples of the
> [CPAN][] and [JSAN][]. My hope is that it's full of [JFDI][]! I
> would be very grateful for feedback and suggestions.
+1 for a modest PGAN to start. :)
Cheers,
David.
--
David Fetter http://
eers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/a
Cheers,
David.
P.S. Please do trim, as I just did, and don't top post.
--
David Fetter 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
a January
> table and so on. Basically following the examples given on the 8.4
> web site.
>
> I'm thinking it would be nice if there was a way to automatically
> add the next month without having to script it all out.
There's no good reason you can't add 5 years&#x
27;t.
I'm not sure how relevant this could be, as existing apps can't use
future functionality. We have precedents with RULEs, which can make
the arguments pretty meaningless.
In some future version, we may want to redo the infrastructure to
support "modified" values for multiple stat
?
There was a use case for supporting non-working int64, but reality has
changed.
> Is it worth expending any energy on?
Not IMHO.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
i
On Sat, Jan 02, 2010 at 05:10:08PM -0500, Tom Lane wrote:
> David Fetter writes:
> >> It doesn't actually work, because the query isn't paying attention to
> >> the current partial word. Try do language pl, or just compare
> >> source to the original Qu
On Sat, Jan 02, 2010 at 04:53:45PM -0500, Tom Lane wrote:
> David Fetter writes:
> > On Sat, Jan 02, 2010 at 04:22:38PM -0500, Tom Lane wrote:
> >> (b) wrong in detail.
>
> > How?
>
> It doesn't actually work, because the query isn't paying atten
On Sat, Jan 02, 2010 at 04:22:38PM -0500, Tom Lane wrote:
> David Fetter writes:
> > Please find enclosed a patch which adds tab completion for DO
> > blocks.
>
> Seems (a) rather pointless and
I don't find it so.
> (b) wrong in detail.
How? That it can'
Folks,
Please find enclosed a patch which adds tab completion for DO blocks.
Thanks to Andrew Gierth and Stefan Kaltenbrunner for help putting it
together :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
it!
Done! :)
Cheers,
David.
--
David Fetter 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://ww
same thought. Though it would also be nice to allow
> something like:
>
> COPY (type1, type2, type3, type4) FROM STDIN CSV
>
> ...which is obviously going to create a horrible parser problem if
> you actually tried to use that syntax.
How about using the CTE syntax?
Cheers,
shouldn't be there. Applied.
>
> Does this count as catch-22?
Patch-22, perhaps?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/fee
e implementation, it's a bad idea. Probably best as an
optional module of some kind.
Cheers,
David.
--
David Fetter 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/peopl
to treat timestamps as
continuous in all cases.
Cheers,
David.
--
David Fetter 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!
Conside
> > but always better to fix them before committing, IMO).
>
> +1 in general, not particularly for this patch (haven't checked that
> in this patch).
>
> Actually, how about we add that to the page at
> http://wiki.postgresql.org/wiki/Submitting_a_Patch?
Done.
Cheers,
he buildfarm?
> >
> Hackers,
>
> Any nominations?
Do they have anything running z/OS? It has a truly amazing compiler
called c89 which implements exactly that spec and nothing else.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Ya
On Mon, Dec 07, 2009 at 07:11:56PM -0500, Tom Lane wrote:
> David Fetter writes:
> > We have a very unfortunate naming situation with Jeff Davis's new
> > feature, namely the shorter name, which is one permutation away
> > from an existing and entirely unrelated feature
ng it, which I believe we should do Really Soon(TM), to Operator
[Exclusion] Constraints would fix this problem.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com
dition of the git documentation and the update of the CVS
> documentation. So we get this info out there. We don't normally
> backpatch things like this though, so comments on that?
+1 for back-patching.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: df
ULL.
>
> Congratulations!
>
> --
> Dave Page
> PostgreSQL Core Team
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
--
David Fetter http://f
ied to the opclass/index machinery
> too.
>
> Unless there's loud squawks I'm going to exercise committer's
> prerogative and make all the docs and messages just say "exclusion
> constraint".
We have "constraint exclusion" already, wh
retty well guarantee some
kind of catastrophic failure. Could we create some way to get an
estimate of space needed, given that the system needs to stay up while
that's happening?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davi
one or more large, long-term
deals.
PostgreSQL doesn't have this motive, although some of the proprietary
forks may well.
Can we see about Andrew Sullivan's point 4? Or is it more important
to address the "do we want to" question first?
Whatever order we take them in,
N is not a source of records, it's a source of
> > bytes; and likewise for STDOUT.
>
> Hmm. I can just imagine wanting to do that as a way of running COPY over
> dblink. Are there other use cases?
It'd be nice to make this available to the next revision of DBI-Link
a
recision?
> >
>
> To today I though so float4 is more practical :).
Floats have never been safe with respect to operations like =, and
won't become so.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: da
if the operator is <> instead of =, a violation is actually the
opposite of a UNIQUE violation.
Cheers,
David.
--
David Fetter 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/i
so many reviewers that such triaging becomes unnecessary,
> then it may automatically *not* be a problem.
In the PostgreSQL Weekly News, I track patches, and apparently at
least one person reads that section. Would it be helpful to track
reviews somehow during commitfests with the reviewers&#
On Mon, Nov 16, 2009 at 06:56:54AM +0200, Peter Eisentraut wrote:
> On sön, 2009-11-15 at 17:09 -0500, Tom Lane wrote:
> > David Fetter writes:
> > > On Sun, Nov 15, 2009 at 10:09:14AM -0500, Andrew Dunstan wrote:
> > >> Peter Eisentraut wrote:
> > >&g
Folks,
Shouldn't this work and produce a "true?"
SELECT NULL IS NOT DISTINCT FROM ANY(ARRAY['a',NULL]);
ERROR: syntax error at or near "ANY"
LINE 1: SELECT NULL IS NOT DISTINCT FROM ANY(ARRAY['a',NULL]);
Cheers,
David.
--
David Fetter h
On Thu, Nov 12, 2009 at 11:46:54AM -0800, David Wheeler wrote:
> On Nov 12, 2009, at 10:46 AM, David Fetter wrote:
>
> > My question boils down to, "why is this string concatenation
> > different from all other string concatenations?"
>
> Does it have som
w, the answer can be, "it behaves differently with respect to
NULLs," and we just document this. We can later decide whether this
behavior should change.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMP
On Thu, Nov 12, 2009 at 11:20:26AM -0500, Tom Lane wrote:
> David Fetter writes:
> > The next one is just plain unexpected.
>
> array_to_string ignores null elements. What do you think it should
> do with them?
It should concatenate them, i.e. return a NULL if the array
davidfet...@postgres=# SELECT array_to_string(array(values(1),(null)),'');
array_to_string
─
1
(1 row)
I would have expected it to come out as NULL.
What say?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfette
; or (my preference) change to an active construction like:
EXECUTE changes the output of GET
DIAGNOSTICS, but does not change the state of
FOUND.
Cheers,
David (Strunk and White ftw! ;)
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: da
On Mon, Nov 09, 2009 at 11:20:39PM +0900, Hitoshi Harada wrote:
> 2009/11/9 David Fetter :
> > On Mon, Nov 09, 2009 at 06:39:54PM +0900, Hitoshi Harada wrote:
> >> I'm not sure if it can be finished until the start of the next CF,
> >> but I've been working on
ostgreSQL project to start with a
slow(ish) and correct implementation, then make it faster. NTFs or
other speed boosts, while nice to have, would not be needed for a
first production implementation. After all, the alternatives without
the native ones are usually slow, buggy, unstable, or combina
ither
using OLD to specify old rows, or both NEW and OLD if we want to break
current behavior. Would this make that easier to do? Harder? Is it
orthogonal?
Cheers,
David (who thinks that both NEW and OLD are object names so poor we
should force quoting them just on aesthetic princi
columns in different formats, although that is possible in the
> underlying protocol. So I made this possible.)
How?
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://
-
> {"name":"Tom","age":"29"}
> (1 row)
>
> There are still too many TODOs such like type conversion between JS
> and SQL, build system, and memory allocation. If you want I'll send
> you my code.
Please sen
1101 - 1200 of 2082 matches
Mail list logo
