:
http://git.postgresql.org/git/~davidfetter/postgresql/.git
Is there some git repository I can pull from to make this a little
less manual?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
On Tue, Jul 08, 2008 at 09:28:34PM -0400, Alvaro Herrera wrote:
David Fetter wrote:
On Tue, Jul 08, 2008 at 06:01:05PM +0900, Tatsuo Ishii wrote:
Here is the patches he made against CVS HEAD (as of today).
The git repository should now match this :)
http://git.postgresql.org/?p
On Wed, Jul 09, 2008 at 04:43:27PM -0400, Aidan Van Dyk wrote:
* David Fetter [EMAIL PROTECTED] [080709 14:45]:
On Tue, Jul 08, 2008 at 09:28:34PM -0400, Alvaro Herrera wrote:
In fact, I fail to see the point of you providing the repo if
the upstream guys are apparently not using
together a
standard procedure for new patches. Would you be willing to write it
up?
That way I could pull from the repository and run e.g.
git-log --stat origin/master..with-recursive or similar.
Excellent :)
Hope this helps.
It does indeed.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED
On Thu, Jul 10, 2008 at 11:31:00AM -0400, Alvaro Herrera wrote:
Aidan Van Dyk wrote:
* David Fetter [EMAIL PROTECTED] [080710 10:19]:
2. Allow people who are not currently committers on CVS HEAD to
make needed changes.
Uh, the point of git is it's distributed, so you don't need
://git.postgresql.org/ ?
In case you are wondering: I've got married
Congratulations!
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 Mon, Jul 14, 2008 at 05:35:28PM -0400, Alvaro Herrera wrote:
David Fetter wrote:
On Mon, Jul 14, 2008 at 05:42:21PM +0200, Markus Wanner wrote:
Would you mind if I were to make a git branch for it on
http://git.postgresql.org/ ?
That's very likely wasted effort, since obviously
functions that return them in
nodeToString() or other formats.
I'll try to write up a more complete proposal until end of next week.
Yay!
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
Not yet fixed:
- detect certain queries those are not valid acroding to the standard
- sort query names acording to the dependency
Is there something in the standard on how to do this? How to sort the
nodes other ways?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org
On Mon, Jul 14, 2008 at 04:22:47PM -0700, Joshua D. Drake wrote:
On Mon, 2008-07-14 at 14:41 -0700, David Fetter wrote:
On Mon, Jul 14, 2008 at 05:35:28PM -0400, Alvaro Herrera wrote:
David Fetter wrote:
On Mon, Jul 14, 2008 at 05:42:21PM +0200, Markus Wanner wrote:
Would you
allow only one query name at the
moment.
I'm not sure I understand what that has to do with sorting.
Please find attached a place where I've found some problems sorting by
tree by array as Asaba-san suggested.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235
repository or how to write an interesting WITH RECURSIVE
applications.
Don't get me wrong. I believe git is a great tool. But we have
limited time and need to think about the priority.
Fair enough :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778
On Wed, Jul 16, 2008 at 09:35:28PM +0200, Markus Schiltknecht wrote:
Hi,
David Fetter wrote:
Would you mind if I were to make a git branch for it on
http://git.postgresql.org/ ?
I've set up a git-daemon with the Postgres-R patch here:
git://postgres-r.org/repo
Since it's a distributed
.
I am so happy with any kind of comments, reviews or critiques.
Regards,
Many people have been waiting for years for this functionality.
Thanks so much for doing this.
When will you have another patch that applies against CVS HEAD?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http
!
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-hackers
mean.
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-hackers
the
spike?
Just generally, reducing the number of connections to the DB will help
in reducing resource consumption.
When you first get a chance, use or set up a test environment where
you can test the upgrade to 8.3.latest.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1
distinguishable
from a non-partial UNIQUE NOT NULL constraint.
While I'm a chicken rather than a pig on this project
http://en.wikipedia.org/wiki/The_Chicken_and_the_Pig, I believe that
covering the more general case right from the start would be a much
better plan.
Cheers,
David.
--
David Fetter [EMAIL
this would be to JOIN the k-deep part of the path
enumeration to the parts greater than k deep.
What would need to be fixed in order to make the above things work?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype
On Fri, Jul 18, 2008 at 07:56:09AM -0700, David Fetter wrote:
On Fri, Jul 18, 2008 at 10:41:20AM +0900, Tatsuo Ishii wrote:
Here is the lastest WITH RECURSIVE patches against CVS HEAD created by
Yoshiyuki Asaba and minor corrections by Tatsuo Ishii.
I tried this patch vs. CVS HEAD
,
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-hackers mailing list
#17 0x0820a4e0 in PostmasterMain (argc=3, argv=0xa0ced50) at postmaster.c:1023
#18 0x081b69d6 in main (argc=3, argv=0xa0ced50) at main.c:188
What other information could help track down this problem?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM
(t1.path,1) = 2
AND
array_upper(t2.path,1) 2
)
GROUP BY t1.id;
ERROR: unrecognized node type: 203
Please apply the attached patch to help out with tab
completion in psql.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo
Folks,
This subject keeps coming up, then back down, etc.
What would a libpgdump API look like?
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
=~davidfetter/window_functions/.git;a=summary
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
On Tue, Jul 29, 2008 at 02:21:18PM -0400, Robert Haas wrote:
+1 for CREATE OR REPLACE
...Robert
+1 for CREATE OR REPLACE from me, too :)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
.
Any ideas how to approach this?
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
On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:
2008/7/29 David Fetter [EMAIL PROTECTED]:
On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:
I happily announce that the first design of window function was
finished and the patch against HEAD is released online. See
On Thu, Jul 31, 2008 at 02:46:29PM +0900, Hitoshi Harada wrote:
2008/7/31 David Fetter [EMAIL PROTECTED]:
On Thu, Jul 31, 2008 at 02:12:26PM +0900, Hitoshi Harada wrote:
2008/7/29 David Fetter [EMAIL PROTECTED]:
On Mon, Jul 28, 2008 at 07:25:55PM +0900, H.Harada wrote:
I happily
On Thu, Jul 31, 2008 at 11:00:15PM +0900, Hitoshi Harada wrote:
2008/7/31 David Fetter [EMAIL PROTECTED]:
Sorry about that. Apparently, at least the way things are set up,
there's a *lot* of history you can rewind. Further changes should
move pretty quickly :)
Thankfully, I succeeded
/pgsql-hackers/2008-07/msg01277.php
Harada-san has been working on. Could these use the same machinery?
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
On Fri, Aug 01, 2008 at 02:13:52AM +0900, Hitoshi Harada wrote:
2008/8/1 David Fetter [EMAIL PROTECTED]:
You will be as soon as I can arrange it. I may move or re-create
that repository. Please send me a username and an RSA public key
so I can give you git-shell access.
Thank you
On Thu, Jul 31, 2008 at 03:10:35PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
It seems to me that DISTINCT ON is just a special case of the more
general windowing functions
http://archives.postgresql.org/pgsql-hackers/2008-07/msg01277.php
Harada-san has been working
?
You do understand you've just kicked off a discussion of shipping
PL/LOLCODE by default.
Oops, I mean, when does it ship? ;-P
Christmas ;)
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP
, and at the
moment, it appears we're taking each of these as a totally separate
project.
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
that they won't see things erroring out? It doesn't add new syntax,
as far as I can tell.
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
for the next jump up from where varlena is
now, to 8 bytes? Would we want to use the bit-stuffing model that the
current varvarlena uses?
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL
On Mon, Aug 18, 2008 at 04:22:56PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
What would need to happen for the next jump up from where varlena
is now, to 8 bytes?
Dealing with upwards-of-4GB blobs as single Datums isn't remotely
sane, and won't become so in the near
On Mon, Aug 18, 2008 at 06:09:13PM -0400, Andrew Chernow wrote:
David Fetter wrote:
Folks,
As the things stored in databases grow, we're going to start
needing to think about database objects that 4 bytes of size can't
describe. People are already storing video in lo and bytea fields
On Mon, Aug 18, 2008 at 07:31:04PM -0400, Tom Lane wrote:
David Fetter [EMAIL PROTECTED] writes:
On Mon, Aug 18, 2008 at 04:22:56PM -0400, Tom Lane wrote:
The main things I think we'd need to consider besides just the
access API are
- permissions features (more than none anyway
should work and
the error appears to stem from the parser's looking at the innermost
UNION ALL instead of the outermost.
Cheers,
David.
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED
, too :)
What do we do about man pages on Windows?
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
.
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
701 - 800 of 2065 matches
Mail list logo