is probably to get the code from approximately the date of the
patch. As far as I know it hasn't been touched in a while, and didn't work
well back when it was being actively developed.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
pgpeMKakIJ2SX.pgp
Description: PGP signature
CONSTRAINT might be surprised.
Comments?
So you'd manually create an index, attach it to a constraint, drop the
constraint, and find that the index had disappeared? ISTM since you created
the index explicitly, you should have to drop it explicitly as well.
--
Joshua Tolley / eggyknap
End Point
On Sun, Jan 23, 2011 at 07:48:04PM -0600, Kevin Grittner wrote:
http://www.xtranormal.com/watch/8285377/?listid=20642536
I foresee a whole new set of animated postgres tutorials...
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
that can already happen (as opposed to adding an entirely new type of problem
to the mix).
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
symmetrical.
+1, but I think query is also a noise word here.
Why not just pg_execute_file and pg_execute_string?
regards, tom lane
While we're bikeshedding, and since I started the thread that has become this
topic, +1 for Tom's naming.
--
Joshua Tolley / eggyknap
End
On Thu, Nov 25, 2010 at 10:24:51PM +0100, Dimitri Fontaine wrote:
Joshua Tolley eggyk...@gmail.com writes:
I've just looked at pg_execute_from_file[1]. The idea here is to execute all
the SQL commands in a given file. My comments:
Thanks for your review. Please find attached a revised
.
* In the snippet below, it seems best just to use palloc0():
query_string = (char *)palloc((fsize+1)*sizeof(char));
memset(query_string, 0, fsize+1);
* Shouldn't it include SPI_push() and SPI_pop()?
[1] http://archives.postgresql.org/message-id/m262wf6fnz@2ndquadrant.fr
--
Joshua Tolley
provides this, among other possible configurations; perhaps that's why
it came up earlier.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
version much, but I'll poke through this
instead. I have a few days of family business coming up, and might be
unrespondive during that time.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
(or no one has figured out how
to do it)?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Thu, Aug 05, 2010 at 04:46:51PM +0200, Pavel Stehule wrote:
So Joshua, can you look on code?
Sure... thanks :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
in the foreseeable future, there's not
much point in my doing that.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
comments/docs :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
on
a patch anyway, so perhaps my updating the old one isn't all that worthwhile.
Pavel, is your code somewhere that we can get to it?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
/msg00700.php
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/src/backend/parser/Makefile b/src/backend/parser/Makefile
index a8f4c07..fb248a6 100644
*** a/src/backend/parser/Makefile
--- b/src/backend/parser/Makefile
*** override CPPFLAGS := -I. -I
On Tue, Jul 27, 2010 at 01:41:10PM +0900, Fujii Masao wrote:
On Tue, Jul 27, 2010 at 12:36 PM, Joshua Tolley eggyk...@gmail.com wrote:
Perhaps I'm hijacking the wrong thread for this, but I wonder if the quorum
idea is really the best thing for us. I've been thinking about Oracle's way
On Tue, Jul 27, 2010 at 10:53:45PM +0900, Fujii Masao wrote:
On Tue, Jul 27, 2010 at 10:12 PM, Joshua Tolley eggyk...@gmail.com wrote:
My concern is that in a quorum system, if the quorum number is less than the
total number of replicas, there's no way to know *which* replicas composed
is asynchronous. I'm not
sure this method is perfect, but it might be simpler than the quorum behavior
that has been considered, and adequate for actual use cases.
[1]
http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/protection.htm#SBYDB02000
alternatively, http://is.gd/dLkq4
--
Joshua
to know how this is one in oracle or
db2?
Neither appear to handle multi-column statistics in any form.
[1] http://download.oracle.com/docs/cd/B13789_01/appdev.101/b10802/d_stats.htm
[2]
http://www.ibm.com/developerworks/data/library/techarticle/dm-0606fechner/index.html
--
Joshua Tolley / eggyknap
(more
unresolved questions get in the way there), but it's a start.
[1] http://en.wikipedia.org/wiki/Copula_(statistics)
[2] http://git.postgresql.org/gitweb?p=users/eggyknap/postgres.git
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
consider expanding it to joined
relations.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
, instead of a ReadBufferMode argument, this only
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Tue, Jun 08, 2010 at 04:18:08PM -0400, Robert Haas wrote:
On Wed, May 26, 2010 at 11:24 PM, Joshua Tolley eggyk...@gmail.com wrote:
On Wed, May 26, 2010 at 03:47:25PM -0400, Robert Haas wrote:
On Tue, May 25, 2010 at 4:34 AM, Jonathan Leto jal...@gmail.com wrote:
This tiny doc patch
, incidentally, tested successfully on my
box, because I've managed to achieve doc building nirvana through blindly
flailing about until it worked...)?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/doc/src/sgml/plhandler.sgml b/doc/src/sgml/plhandler.sgml
index
it, but there's no reason an
untrusted language shouldn't be able to say SELECT
launch_missiles().
--
Joshua Tolley / eggyknap
End Point Corporation
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On Fri, May 21, 2010 at 2:04 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Joshua Tolley eggyk...@gmail.com writes:
Agreed. As long as a trusted language can do things outside the
database only by going through a database and calling some function to
which the user has rights, in an untrusted
not contain enough information for archive recovery.
ISTM wal_archive should make an appearance where the docs bring up
archive_mode and archive_command, to say wal_level must be set to 'archive'
or 'hot_standby', so all required configuration changes are mentioned close
together.
--
Joshua Tolley
, or by something else entirely. As long as the message isn't clearly
wrong in the reject case, as it is now.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
me, FWIW.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
of software without
any real need. The four lines of PL/LOLCODE that inspired this thought aren't
themselves a great burden, but when combined with everyone else using
SearchSysCache already...
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description
? In particular it's
useful to be able to find $libdir without requiring pg_config, as some
packagers tend not to include it in anything put the -dev packages, but all
those settings seem useful to have on hand, and in at least most cases
shouldn't be tough to expose via SQL. Comments?
--
Joshua Tolley
On Wed, Feb 03, 2010 at 02:32:47PM -0500, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
I'd really like to see the data from pg_config and pg_controldata available
through SQL, such as by adding output to pg_show_all_settings(), or adding
new
SRFs named something like
) where you
*will* need it.
Not just debug information (the --enable-debug flag to the configure script),
but also --enable-cassert, --enable-depend, and/or others you're likely to
want to use during development.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
was similarly surprised to learn the same thing recently, but
admit I didn't take the time see how easily it could be changed.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
-availability.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
:
For whatever it's worth, I get it too, on Ubuntu 9.04... ~4s without TZ vs.
~1.8s with TZ.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
examples.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Fri, Nov 20, 2009 at 12:00:24AM +0200, Peter Eisentraut wrote:
On fre, 2009-11-13 at 18:46 +0300, Teodor Sigaev wrote:
CREATE OR REPLACE FUNCTION incr(stuff int[]) RETURNS int[] AS $$
for x in stuff:
yield x+1
$$
LANGUAGE 'plpythonu';
# select incr(ARRAY[1,2,3]);
ERROR:
();
return_arr
-
{1,2,3,4,5}
(1 row)
5432 j...@josh*# select * from return_set();
return_set
1
2
3
4
5
(5 rows)
Perhaps that's overkill, though.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
On Sat, Nov 28, 2009 at 10:15:40PM -0500, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
Makes sense on both counts. Thanks for the help. How does the attached look?
Applied with minor corrections, mainly around the state save/restore
logic. I also put in some code to fix
, but if it did, I expect it would be
because whatever the connection was being used for in the past differs
substantially from whatever I plan to use it for in the future, which seems a
suitable time also to change application_name. I vote against
GUC_NO_RESET_ALL.
--
Joshua Tolley / eggyknap
End
the attached look?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml
index 49631f2..ebcb608 100644
*** a/doc/src/sgml/plperl.sgml
--- b/doc/src/sgml/plperl.sgml
*** CREATE FUNCTION replaceablefuncname/r
On Wed, Nov 18, 2009 at 09:35:35AM +1100, Brendan Jurd wrote:
2009/11/17 Joshua Tolley eggyk...@gmail.com:
On Sun, Nov 15, 2009 at 12:10:33PM +1100, Brendan Jurd wrote:
I noticed that there was a fairly large amount of bogus/inconsistent
whitespace
...
Thanks -- I tend to forget
) plperl_call_perl_func(desc, fake_fcinfo);
Right.
I don't get the warning either, and didn't realize it could produce one.
Thanks -- that change is also in the attached version.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/doc/src/sgml/plperl.sgml b/doc
the documentation, and
fixes another inconsistency I found.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml
index 49631f2..ebcb608 100644
*** a/doc/src/sgml/plperl.sgml
--- b/doc/src/sgml/plperl.sgml
On Fri, Nov 06, 2009 at 09:53:20PM -0500, Andrew Dunstan wrote:
Joshua Tolley wrote:
I looked through the
regression tests and didn't find any that used plperl -- should we add one
for
this (or for this and all kinds of other stuff)? Is there some way to make
running the regression test
On Fri, Nov 06, 2009 at 09:53:20PM -0500, Andrew Dunstan wrote:
Joshua Tolley wrote:
I looked through the
regression tests and didn't find any that used plperl -- should we add one
for
this (or for this and all kinds of other stuff)? Is there some way to make
running the regression test
interpreter initialization works, and have simply copied what looked like
important stuff from the original plperl call handler. I tested with this to
prove it:
DO $$ qx{touch test.txt}; $$ language plperl;
This works both with plperl and plperlu. Hints, anyone? Comments?
--
Joshua Tolley
On Thu, Nov 05, 2009 at 05:51:45PM -0500, Andrew Dunstan wrote:
Joshua Tolley wrote:
I've been trying to make pl/perl support 8.5's inline functions, with the
attached patch.
Wow, this is the second time this week that people have produced patches
for stuff I was about to do. Cool!
Well
on how we built PL/LOLCODE that
could prove useful.
Said slides are available here:
http://www.pgcon.org/2009/schedule/events/159.en.html
I hope they can be useful.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Wed, Oct 07, 2009 at 11:29:15AM -0400, Alvaro Herrera wrote:
Joshua Tolley escribió:
On Wed, Oct 07, 2009 at 10:22:02AM -0400, Alvaro Herrera wrote:
Kiswono Prayogo escribió:
by using latest v8 engine from google, is it possible to build PL/Js
just like other PL in Postgre
It doesn't have anything linking to it right now, which might be a bad thing.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
not necessarily contain the same information.
Loads of people seem to want to be able to have separate per-database log
files, which something like this could also allow.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
messages it gets (rather than just having
an opaque string), and route messages various places, accordingly.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Fri, Sep 25, 2009 at 05:04:45PM -0400, Robert Haas wrote:
On Fri, Sep 25, 2009 at 4:58 PM, Joshua Tolley eggyk...@gmail.com wrote:
On Fri, Sep 25, 2009 at 03:19:36PM -0400, Tom Lane wrote:
However, I don't think I actually believe the premise of this patch,
which is that sending log
On Fri, Sep 25, 2009 at 05:04:45PM -0400, Robert Haas wrote:
On Fri, Sep 25, 2009 at 4:58 PM, Joshua Tolley eggyk...@gmail.com wrote:
On Fri, Sep 25, 2009 at 03:19:36PM -0400, Tom Lane wrote:
However, I don't think I actually believe the premise of this patch,
which is that sending log
.
Presumably this couldn't easily be an upper bound on the time spent moving
tuples, rather than an upper bound on the number of tuples moved?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
), (4);
ERROR: duplicate key value violates unique constraint a_unique
DETAIL: Key (a)=(3) already exists.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
had all along. Perhaps indexed operator constraints?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Sun, Sep 13, 2009 at 10:54:21PM +0300, Peter Eisentraut wrote:
On fre, 2009-09-11 at 07:39 -0600, Joshua Tolley wrote:
While your discovery is accurate and the change makes it consistent with
other similar parameters, note that the previous wording is also
completely correct. This while
only be set at server start.
/para
/listitem
/varlistentry
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
us know you're not working on it. That
way Pavel, if he finds he has time and interest, or someone else, can work on
it without fear of conflicting with what you're doing. Thanks for your work;
please don't get discouraged!
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
interesting ways depends on a separate process, any logging before then will
be abnormal, and any logs we create will probably show up in a relatively
unexpected place. The Principle of Least Surprise suggests we minimize that
possibility.
--
Joshua Tolley / eggyknap
End Point Corporation
http
. Hot means it just takes over
when needed.
After all this, perhaps we can at least conclude that calling it cold,
warm, or hot anything is confusing, because no one can agree on what that
means. I propose we leave off finding a naming that includes temperature.
--
Joshua Tolley / eggyknap
End
be over-engineering. Those particular section
headers might not be applicable to someone else's review.
I've just added a link to this email to the Reviewing a Patch wiki page
(http://wiki.postgresql.org/wiki/Reviewing_a_Patch). Do with it as you see fit
:)
--
Joshua Tolley / eggyknap
End Point
On Tue, Aug 04, 2009 at 01:28:00PM -0400, Stephen Frost wrote:
Thanks to Joshua, there weren't really many changes I found for the
docs. Here they are anyway:
Yay, I was useful! :)
How about:
Replaces current privileges with the default privileges, as set using
xref
?
I don't want to add a new keyword, but SET STATISTICS DISTINCT would
be an easy change. Comments?
+1
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Sat, Jul 25, 2009 at 11:14:19AM +0200, Petr Jelinek wrote:
Joshua Tolley wrote:
Am I the only one that gets this on make check, with this version (from
src/test/regress/log/initdb.log):
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1
On Sat, Jul 25, 2009 at 03:50:06PM -0400, Andrew Dunstan wrote:
Joshua Tolley wrote:
I figured as much. I can't seem to get past this, despite a make distclean.
Suggestions, anyone?
try a fresh checkout and reapply the patch?
[ a couple git clean, git reset, make clean, etc. commands later
at the docs. I've made a few changes based solely
on my opinions of what sounds better and what's more consistent with the
existing documentation. Do with them as you see fit. :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
with them as you see fit. :)
Did you intend to attach something to this email?
...Robert
Well, yes, now that you mention it :) Trying again...
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 34679d8
):
This is per SQL standard. IS NULL is true if *all* the record's
fields are null; IS NOT NULL is true if *none* of them are.
--
Joshua Tolley / eggyknap
End Point Corporation
http
: data directory
/home/josh/devel/pgsrc/pg85/src/test/regress/./tmp_check/data not removed at
user's request
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
Josh Tolley is still conducting a
more in-depth review. Josh?
Yes, I am, but if you've read this far you know that already :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
fixed it in my version, and it applied cleanly to
head (with some offset hunks in gram.y). I've not yet finished building and
testing; results to follow later.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
apply are likely
to be added or removed.
I don't know how patches that require catalog version changes are generally
handled; should the patch include that change?
More testing to follow.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
you've brought
up is forthcoming.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
2
Indeed, src/include/nodes has no tidbitmap.h file (it shows up in
REL8_2_STABLE).
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Thu, Jul 09, 2009 at 02:35:04PM -0300, Dickson S. Guedes wrote:
This could help, maybe with a RSS in that (like in git).
+1 for the RSS feed, if only because I think it sounds neat :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description
this is a problem unique to GEQO.
Which in turn boils down to we need real world data to look at.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
for the titles. Oh, and in Patch.pm,
s/with/which in patches with have been Committed.
Finally, I ran Perl::Critic, and attached an (admittedly untested) patch to
clean up the things it whined about.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
diff --git a/perl-lib/PgCommitFest
again, if it would
be useful.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
at least two sets of
eyeballs on anything that we put into production for obvious reasons.
Is git://git.postgresql.org/git/pgcommitfest.git still the right place to get
the source?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
and an elephant are trying to sit on the same bench, the hamster does
not want the elephant to assert that he is a hamster; he wants the
elephant to announce his choice of seat prior to putting his bottom in
Thanks, Robert -- this made me giggle :)
--
Joshua Tolley / eggyknap
End Point Corporation
On Mon, Jun 29, 2009 at 02:07:23PM -0400, Tom Lane wrote:
Josh Berkus j...@agliodbs.com writes:
So, while an actual % completed indicator would be perfect, a query
steps completed, current step = would still be very useful and a large
improvement over what we have now.
I think this is
On Mon, Jun 29, 2009 at 10:22:15PM -0400, Robert Haas wrote:
I'm finding myself unable to follow all the terminology on this thead.
What's dimension reduction?
For instance, ask a bunch of people a bunch of survey questions, in hopes of
predicting some value (for instance, whether or not
The dtrace probes documentation [1] spells each probe name with dashes
(transaction-start, transaction-commit, etc.). Yet as far as I can see,
dtrace only works if you spell the probe names with double underscores
(transaction__start, transaction__commit, etc.). Why the discrepancy?
Obvious patch
On Thu, May 28, 2009 at 06:28:14PM -0400, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
The dtrace probes documentation [1] spells each probe name with dashes
(transaction-start, transaction-commit, etc.). Yet as far as I can see,
dtrace only works if you spell the probe names
On Thu, May 28, 2009 at 11:12:42PM -0400, Robert Haas wrote:
On Thu, May 28, 2009 at 11:00 PM, Euler Taveira de Oliveira
Don't you think is too strange having, for example, 6.67 rows?
No stranger than having it say 7 when it's really not. Actually mine
mostly come out 1 when the real value
On Tue, May 26, 2009 at 09:55:55AM -0400, Dave Page wrote:
from the pgAdmin perspective. We
already use libxml2, but JSON would introduce another dependency for
us.
...and using XML introduces a dependency for those that apps that don't already
use some XML parser. I realize that since the
On Mon, May 25, 2009 at 07:14:56AM -0400, Robert Haas wrote:
Many people who responded to this
thread were fine with the idea of some sort of options syntax, but we
had at least four different proposals for how to implement it:
Robert Haas: EXPLAIN (foo 'bar', baz 'bletch', ...) query
Pavel
On Mon, May 25, 2009 at 10:55:48AM -0400, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
The Oracle version, as it fills the table of explain results, gives
each number an id and the id of its parent row, which behavior we
could presumably copy. I'm definitely keen to keep
On Mon, May 25, 2009 at 11:22:24AM -0400, Tom Lane wrote:
Joshua Tolley eggyk...@gmail.com writes:
I'm not sure I see why it would be less flexible. I'm imagining we define
some
record type, and a function that returns a set of those records.
I'm unimpressed by the various proposals
On Sun, May 24, 2009 at 11:57:13AM -0400, Andrew Dunstan wrote:
Robert Haas wrote:
EXPLAIN ('hash_detail', 'on') query...
Oops, I should have written EXPLAIN (hash_detail 'on') query... can't
follow my own syntax.
I am sorry - this is really strange syntax . Who will use this
On Sun, May 24, 2009 at 06:53:29PM -0400, Tom Lane wrote:
Greg Smith gsm...@gregsmith.com writes:
On Sun, 24 May 2009, Pavel Stehule wrote:
we should have a secondary function explain_query(query_string,
option) that returns setof some.
+1. The incremental approach here should first be
On Wed, May 13, 2009 at 06:29:41AM +0200, Pavel Stehule wrote:
2009/5/13 Joshua Tolley eggyk...@gmail.com:
On Tue, May 12, 2009 at 11:20:14PM +0200, Pavel Stehule wrote:
this patch has some bugs but it is good prototype (it's more stable
than old patch):
I'm not sure if you're
On Tue, May 12, 2009 at 11:20:14PM +0200, Pavel Stehule wrote:
this patch has some bugs but it is good prototype (it's more stable
than old patch):
I'm not sure if you're at the point that you're interested in bug reports, but
here's something that didn't behave as expected:
5432 j...@josh*#
On Mon, May 04, 2009 at 10:13:31PM -0400, Robert Haas wrote:
nit
+ own analysis indicates otherwie). When set to a negative value, which
s/otherwie/otherwise
/nit
A question: why does attdistinct become entry #5 instead of going at the end?
I assume it's because the order here controls
I was browsing PL/pgSQL source, and saw this line (pl_comp.c:151):
function = (PLpgSQL_function *) fcinfo-flinfo-fn_extra
It then does some work to determine whether the result in function is
valid or not. So I got to wondering, what's the lifetime of the
FunctionCallInfoinfo object passed to
1 - 100 of 141 matches
Mail list logo
