.
FWIW, given that there will probably always be corner cases. I can
see the attraction in Simon's suggestion of providing a way to
manually issue a system-wide forced plan flush.
Would that require a system-wide plan cache to implement?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
be in user space.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
--
Sent via pgsql
On Tue, Aug 19, 2008 at 09:50:53PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Tue, Aug 19, 2008 at 07:45:16PM -0400, Tom Lane wrote:
FWIW, given that there will probably always be corner cases. I can
see the attraction in Simon's suggestion of providing a way
| pg_prepared_statement | SETOF record |
pg_catalog | pg_prepared_xact | SETOF record |
pg_catalog | pg_show_all_settings | SETOF record |
(5 rows)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
links that are explicitly telling you,
Don't be stupid read the docs is a very good idea.
And we're back to man pages and CHM files.
How big a project would that latter be?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
= 'plperl.use_strict';
name | setting | unit | category | short_desc | extra_desc | context | vartype
| source | min_val | max_val
--+-+--+--+++-+-++-+-
(0 rows)
Is this a bug?
Cheers,
David.
--
David Fetter [EMAIL
small request. The font is really
small and I have pretty good eyesight.
Fixed :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating
On Wed, Aug 20, 2008 at 01:56:50PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
I've noticed that neither SHOW ALL nor SELECT ... FROM pg_settings
shows the value of custom GUCs, even though SHOW will do so for
any given one.
Yeah, that's intentional, because what
, now that we are into August, would Asaba-san and whomever else
like to try out the git repository? To do so, I just need a login
name and a public key.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
. It is linked from the
Commitfest page.
Also, now that we are into August, would Asaba-san and whomever else
like to try out the git repository? To do so, I just need a login
name and a public key.
I will send you later.
Thanks :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
check whether pg_xlog is a
directory and the only thing in $PGDATA. One way to do that is to add
a new return code to check_data_dir() and a new branch of the case
statement after it's called.
What say?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM
On Mon, Aug 25, 2008 at 11:48:29AM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
While initdb allows you to choose a directory for transaction
logs, it can't already exist, so it can't be in its usual place
under $PGDATA. I'd like to propose that this be allowed by having
On Mon, Aug 25, 2008 at 09:29:03AM -0700, Joshua D. Drake wrote:
On Mon, 25 Aug 2008 09:04:01 -0700
David Fetter [EMAIL PROTECTED] wrote:
When -X is set to existing, it would check whether pg_xlog
is a directory and the only thing in $PGDATA. One way to do
that is to add a new
On Mon, Aug 25, 2008 at 09:54:26AM -0700, Joshua D. Drake wrote:
On Mon, 25 Aug 2008 09:42:21 -0700
David Fetter [EMAIL PROTECTED] wrote:
We either need to provide a way to initialize it at initdb, allow
xlogs to be in table space or add a GUC for the location.
There's already a way
Folks,
It looks to me like there should be more links, maybe even
bidirectional ones, between the TODO wiki and commitfest pages. Does
mediawiki have a bidirectional link capability?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
On Tue, Aug 26, 2008 at 09:40:26PM -0400, Alvaro Herrera wrote:
David Fetter wrote:
Folks,
It looks to me like there should be more links, maybe even
bidirectional ones, between the TODO wiki and commitfest pages.
Does mediawiki have a bidirectional link capability?
Huh, what's
believe it would
make a great addition to the core product, but only in 8.4.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http
doing reviews faster. It just means not waiting until the patch is
in release-ready state. It's latency that's hurting us, not
bandwidth...
A DSCM can do a *lot* to get this latency down :)
Cheers,
David (not advocating any particular DSCM at the moment, just the
process of using one)
--
David
day with it.
http://repo.or.cz/w/PostgreSQL.git
There are git-cvsimport and git-cvsexport utilities which make
communication between the legacy SCM and the DSCM straight-forward.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
On Tue, Oct 23, 2007 at 06:19:42PM -0400, Andrew Dunstan wrote:
David Fetter wrote:
On Tue, Oct 23, 2007 at 04:59:51PM -0400, Chris Browne wrote:
[EMAIL PROTECTED] (Tom Lane) writes:
Simon Riggs [EMAIL PROTECTED] writes:
I'd suggest we have multiple checkpoints during the cycle
of preventing bit-rot on
large patches and keeping them in sync :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http
On Wed, Oct 24, 2007 at 02:18:42PM -0300, Alvaro Herrera wrote:
[EMAIL PROTECTED] wrote:
On Wed, Oct 24, 2007 at 02:32:13PM +0200, Martijn van Oosterhout wrote:
On Tue, Oct 23, 2007 at 02:39:43PM -0700, David Fetter wrote:
The one below is already available, so we don't have to do a flag
actually agreeing that autovac should not block DDL.
+1 here for having autovacuum not block DDL :)
Cheers,
David (for what it's worth)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember
our fe-be
protocol implementation bit-by-bit.
How do you mean?
The only way I've done multisets is by creating functions that return
multiple refcursors, either in a row or as SETOF. Is or was there
some other way?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1
On Sun, Oct 28, 2007 at 08:18:04PM -0500, Merlin Moncure wrote:
On 10/27/07, David Fetter [EMAIL PROTECTED] wrote:
The only way I've done multisets is by creating functions that
return multiple refcursors, either in a row or as SETOF. Is or
was there some other way?
ahem...arrays
;
END;
$$;
SELECT * FROM wtf('a','b');
FETCH all FROM a;
FETCH all FROM b;
ROLLBACK;
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating
On Tue, Oct 30, 2007 at 09:48:24AM +0100, Pavel Stehule wrote:
2007/10/30, David Fetter [EMAIL PROTECTED]:
Based on the example in TFM for PL/PgSQL:
BEGIN;
CREATE TABLE foo(foo_id SERIAL PRIMARY KEY, foo_text TEXT);
CREATE TABLE bar(bar_id SERIAL PRIMARY KEY, bar_text TEXT);
INSERT
On Tue, Oct 30, 2007 at 11:31:12AM -0300, Alvaro Herrera wrote:
David Fetter wrote:
AS $$
BEGIN
OPEN $1 FOR SELECT * FROM foo;
RETURN NEXT $1;
OPEN $2 FOR SELECT * FROM bar;
RETURN NEXT $2;
END;
$$;
I know it. It is ugly as all hell.
Agreed.
Cheers,
David
should be just a SMOP.
Having NEW and OLD views of per-statement triggers would be a Very
Nice Feature(TM) independent of stored procedures. For one thing, it
would make certain kinds of replication trivial.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778
with the assumption that you know at run time the
shape of all the rows and that that shape is uniform.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating
of existing PLs would be
required?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
...
Is this an insane idea, or would it be possible, practical and useful?
I don't know about the sanity, but I've done it a couple of places :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
you're using.
Yes, it violates the assumption that you can just swap DBMSs from
under your application code, but I've never seen that assumption
hold for applications that actually use the RDBMS anyway.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM
you think of the proposal to make text search work this way
and to document this more easily readable form?
+1 for adding this.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL
?
Actually anything other than a plain file, right? (Do we really
want to be able to psql -f a_pipe?)
Yes, I have seen people use just this technique.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter
was spread
checkpoint or time-extended checkpoint. Anybody have a better
idea?
balanced
gradual
extended (I see you mention time-extended but wouldn't time be implicit
based on the actual docs and thus we only need extended?)
How about smoothed?
Cheers,
David.
--
David Fetter [EMAIL
you were to the place
you want to be. With transactional DDL, you know absolutely for sure
that you've done either the whole change or none of it, i.e. not
half-way in between :)
Cheers,
David (a giant fan of transactional DDL)
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415
algorithms? Right now, there's a contest between SHA1 and
MD5 as to which one gets broken first, and SHA1 appears to be in the
lead. SHAn for n1 could preempt the awfulness of losing this race.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
Folks,
8.3's psql is ponderously unhelpful when getting the type description
of an enum, so I'd like to propose a new column in the \dT output
which can contain those values in an array format. Yes, I know it
looks like a new feature, but it's really a bug fix.
Cheers,
David.
--
David Fetter
On Sun, Jan 20, 2008 at 10:55:11PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
8.3's psql is ponderously unhelpful when getting the type
description of an enum, so I'd like to propose a new column in the
\dT output which can contain those values in an array format
data, but it's DDL nonetheless.
By that definition CLUSTER is DDL and TRUNCATE is DDL if you look at
the implementation rather than the user-visible effects.
I agree that both are more DDL-like than DML-like.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415
On Sat, Feb 02, 2008 at 02:23:40PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Thu, Jan 31, 2008 at 10:22:42AM +, Gregory Stark wrote:
There are plenty of DDL commands which modify data (CREATE INDEX,
ATLER TABLE ALTER COLUMN TYPE). The defining characteristic
On Sat, Feb 02, 2008 at 05:23:39PM -0500, Christopher Browne wrote:
On Feb 2, 2008 2:43 PM, David Fetter [EMAIL PROTECTED] wrote:
It still involves DDL-like operations in the sense of changing
(for the duration of the query) trigger behavior.
But that change of trigger behavior is still
looking for...
You could have a function get_attribute_as_text(NEW, 'id') or even
get_attribute_quoted(NEW, 'id')
It would be nice to have a more dynamic language built-in. I'm not
aware of any BSD-licensed dynamic languages though.
Perl is BSD-compatible.
Cheers,
David.
--
David Fetter
Folks,
Let's put PL/PgSQL in template1 by default, as some downstream
packagers are already doing. If someone really must remove it, they
can still do that.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
On Tue, Feb 19, 2008 at 12:11:05PM -0500, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
Let's put PL/PgSQL in template1 by default, as some downstream
packagers are already doing. If someone really must remove it,
they can still do that.
This has been proposed before
|
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating
, as (a) that prejudges what the
alternate forks might be used for, and (b) the name fails to be
inclusive of the data fork. Other suggestions anyone?
Segment? Section? Module?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
does.
Help, comments, brickbats, etc. appreciated :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http
On Wed, Mar 26, 2008 at 08:31:04AM -0400, Andrew Dunstan wrote:
David Fetter wrote:
Folks,
Neil Conway sent me a patch that sketched out a plan to make quals
visible to functions
er, what? Please explain what this means, why it might be useful.
Example(s) would help.
Right now, user
On Wed, Mar 26, 2008 at 01:21:14PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
What happens now with dblink is that the remote table (more generally,
the output of a fixed query) gets materialized into memory in its
entirety, and if it's bigger than what's available
it transparently with dblink :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
it could short of a time machine. We're stuck
with an backward convention. :(
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
pretty
sure is not currently used in our grammar.
We could use the Turkish
muvaffakiyetsizleştiricileştiriveremeyebileceklerimizdenmişsinizcesine,
which I'm pretty sure isn't either :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
was actually this way, could go a long way toward making
sure that PLs didn't regress into untrusted territory.
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
Folks,
Andrew Dunstan posted some instructions on his blog, and I'm thinking
they clarify things a great deal for people who want to learn how to
do VPATH builds.
Attached patch adds the description along with an index term. What
say?
Cheers,
David.
--
David Fetter da...@fetter.org http
On Thu, May 27, 2010 at 09:51:30PM -0400, Robert Haas wrote:
On Thu, May 27, 2010 at 7:10 PM, David Fetter da...@fetter.org wrote:
On Fri, May 28, 2010 at 01:03:15AM +0300, Peter Eisentraut wrote:
On fre, 2010-05-21 at 14:22 -0400, Robert Haas wrote:
On Fri, May 21, 2010 at 2:21 PM, Tom
before 9.1?
Because there's a fundamentally new way to use them now, namely with
exclusion constraints :)
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
On Thu, Jun 03, 2010 at 10:57:05PM -0400, Robert Haas wrote:
On Thu, Jun 3, 2010 at 8:47 PM, Jan Wieck janwi...@yahoo.com wrote:
What would be the use case for such a query?
Monitoring?
s/\?/!/;
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM
is happening. (If you think it means HS is
s/HS/any software, no matter how trivial/
bug-free, I have a nice bridge I'd like to interest you in.)
Is it the one from Lower Manhattan to Brooklyn? I've got all kinds of
cool ideas about what to do with it...
Cheers,
David.
--
David Fetter da
intent vs. effect.
Do you want some help with creating 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
;
EXCEPTION
WHEN invalid_xml_document THEN
RETURN false;
END;
$$;
While tracking this down, I didn't see a way to get SQLSTATE or the
corresponding condition name via psql. Is this an oversight? A bug,
perhaps?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone
to
the docs for this, as they get written.
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
On Sat, Jul 10, 2010 at 09:26:38AM -0700, David Fetter wrote:
On Sat, Jul 10, 2010 at 11:52:31AM +0200, Andres Freund wrote:
On Fri, Jul 09, 2010 at 11:33:04PM -0400, Robert Haas wrote:
On Fri, Jul 9, 2010 at 10:25 PM, Boxuan Zhai bxzhai2...@gmail.com wrote:
Dear All
already?
Oops.
Fixed that now in attached patch.
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
On Sat, Jul 10, 2010 at 10:39:02AM -0700, David Fetter wrote:
On Sat, Jul 10, 2010 at 01:18:49PM -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
Though, if the worst problem with this patch is the formatting, we're
doing *quite* well.
Well, the worst problem
On Sat, Jul 10, 2010 at 01:53:53PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
By the way, make check fails here with attached initdb.log:
creating system views ... FATAL: unrecognized token: false
Hm, I'd suspect something fouled up in keyword recognition. Did you
do
of all our competition, both free and proprietary.
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
!
In two words, HELL, YES!
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
;)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http
to remember or
guess.
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
this in the
backend?
Yes.
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
. Such backend stuff is in every RDBMS except ours.
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
of the beast. I don't
think it's as bad as is made out, however, as \d covers 99% of
everyday usage and certainly the show tables that started
this thread.
It covers 0% of cases where people are not using psql.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
into a JTable for Java Swing applications. If a client gets
back a series of result sets, the sky is the limit.
Ad astra per PostgreSQL!
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
in the context of the project as a whole:
* Is everything done in a way that fits together coherently with other
features/modules?
Yes.
* Are there interdependencies that can cause problems?
Not that I've found, except as noted above re: apps based on the
previous behavior.
--
David
is
complex, especially when the DML for that data source is different
from PostgreSQL's DML.
Do you have some ideas as to how to solve this problem in general? In
this case?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
. How much work would that part be?
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
/unserialize?
Because that's not what the function actually does.
FWIW, I'm for (im|ex)plode, as join()/split(), which I'd otherwise
like, would run into too many issues with JOIN.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
taken when the EXPLAIN started.
Did I misunderstand the code? And if I didn't, why do we do this
differently?
You mentioned in IRC that this was in aid of getting wCTEs going. How
are these things connected?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
by T2 to baz while in the regular execution scenario
it does.
Well that's gotta be a bug, but in what I'm not sure.
I've said it before, and I'll say it again. User-accessible RULEs are
themselves a bug :P
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
--
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://www.postgresql.org
-debug --enable-cassert
make
Log from that also enclosed.
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
in Postgres Wiki. I explain the
details of my implementation and a set of testing examples.
Can someone help Boxuan with how to write regression tests?
Happy to. I'll start this evening PDT or tomorrow :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778
for an overriding psql variable, drops through to look for
an environment variable, and then to a sane default, for some
reasonable value of sane. Perhaps this default could depend on OS
(Windows vs. Everything Else) to start with.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone
... er.. man
witch... warlock?
Witch.
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
an opinion on making
this change:
for: tgl, josh, badalex, mmoncure
against: rhaas, thom
Anybody else want to vote, or change their vote after seeing the patch?
+1 for removing the single-argument version.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
exclude builtin functions of language
SQL. Is there a reason for this inconsistency?
If I had to hazard a guess, it would be that the functionality was
written over time by different people, not all of whom were using the
same criteria for coherence.
Cheers,
David.
--
David Fetter da
/src/sgml
make
Then you can point a web browser at the doc/src/sgml/html/index.html
(and similar)
http://www.postgresql.org/docs/current/static/docguide.html
has information about the tools you will need for the above to work.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org
afraid, ...
using a variadic function isn't too much nice now
some xslt_process(xmlsrc, 'n1=v1','n2=v2','n3=v3'
This sounds like the perfect case for pulling hstore into core code. :)
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
be for temp
tables to not have persistent catalog entries in the first place.
For the upcoming global temp tables, which are visible in other
sessions, how would this work?
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
,
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
On Sun, Aug 08, 2010 at 03:25:06PM +0300, Peter Eisentraut wrote:
On tor, 2010-08-05 at 07:13 -0700, David Fetter wrote:
On Thu, Aug 05, 2010 at 04:58:32PM +0300, Peter Eisentraut wrote:
pg_stat_user_functions has an inconsistent notion of what user
is. Whereas the other pg_stat_user_
.
The cube contrib module was only ever meant to be replaced by the
real feature, which you're working on, so +1 for dropping everything
in it that you are not replacing with the one which complies with the
SQL standard.
Cheers,
David.
--
David Fetter da...@fetter.org http://fetter.org/
Phone: +1 415 235
the copyrights in the code
base to the standard we set.
I can even see this becoming a commit- or push- hook. :)
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
On Mon, Aug 09, 2010 at 02:23:55PM +0100, Greg Stark wrote:
On Mon, Aug 9, 2010 at 2:02 PM, David Fetter da...@fetter.org wrote:
I am working on Grouping Sets support. The first issue is cube
keyword. Contrib module cube define a few functions cube. So
if we want to continue in support
of the CFs. Unfortunately, I don't have
time for it ATM.
Do you have enough of it to send out as WIP?
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
.
--
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
JSON code should go into core is up
for discussion. Thoughts, anyone?
+1 for putting it in core in 9.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
iCal: webcal
On Wed, Aug 11, 2010 at 03:40:36PM -0700, Joshua D. Drake wrote:
On Wed, 2010-08-11 at 15:27 -0700, David Fetter wrote:
I've been developing it as a contrib module because:
* I'd imagine it's easier than developing it as a built-in
datatype right away (e.g. editing a .sql.in file
701 - 800 of 2065 matches
Mail list logo