2010/8/8 David E. Wheeler da...@kineticode.com:
On Aug 7, 2010, at 12:24 AM, Pavel Stehule wrote:
try=# create or replace function try(bool) returns text language plperl AS
'shift';
CREATE FUNCTION
Time: 121.403 ms
try=# select try(true);
try
-
t
(1 row)
I wish this wasn't so.
On 7 August 2010 10:56, Marko Tiikkaja marko.tiikk...@cs.helsinki.fi wrote:
The problem is that this isn't even nearly sufficient. I gave this some
more thought while I was away, and it seems that I missed at least one more
important thing: the WHERE clause. Imagine this query:
DELETE FROM
On 8/8/2010 12:49 PM, Dean Rasheed wrote:
On 7 August 2010 10:56, Marko Tiikkajamarko.tiikk...@cs.helsinki.fi wrote:
The problem is that this isn't even nearly sufficient. I gave this some
more thought while I was away, and it seems that I missed at least one more
important thing: the WHERE
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_* views filter out non-user objects
by schema, pg_stat_user_functions
Gordon Shannon wrote:
If it was HOT prune, can anyone summarize what that does?
Get a copy of the PostgreSQL source, and read this file:
src/backend/access/heap/README.HOT
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On 06/08/10 17:50, Pavel Stehule wrote:
attached updated patch with regression test
Bravely ignoring the quotation/varidic/favourite_scheme_here
conversations, I've taken a look at the patch as is. Thanks to Tom's
input I can now correctly drive the function. I can also report that
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_*
Robert Haas robertmh...@gmail.com writes:
Do we have a projected data for the next 9.0 wrap, and will it be
beta5 or rc1?
No, and don't know ;-). It won't be till after the 15th because
assorted people are on vacation. Perhaps a reasonable plan is to
wrap on the 19th (week from Thursday), and
Peter Eisentraut pete...@gmx.net writes:
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_* views filter out non-user
On Aug 7, 2010, at 11:05 PM, Pavel Stehule wrote:
COLLECTION?
yes, sorry - simply - class where fields can be accessed via specified
index - unique or not unique.
Like in Oracle? From:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/collections.htm
A collection is an
2010/8/8 David E. Wheeler da...@kineticode.com:
On Aug 7, 2010, at 11:05 PM, Pavel Stehule wrote:
COLLECTION?
yes, sorry - simply - class where fields can be accessed via specified
index - unique or not unique.
Like in Oracle? From:
Itagaki Takahiro itagaki.takah...@gmail.com writes:
Accessor functions to get so far collected statistics for the current
transaction
https://commitfest.postgresql.org/action/patch_view?id=301
The only issue in the patch is too long view and function names:
-
Pavel Stehule wrote:
I didn't use a correct name - so indexed set is better.
How would such a thing differ from a RAM-based local temporary table?
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Pavel Stehule pavel.steh...@gmail.com writes:
updated patch attached
What exactly is the point of the \sf command? It seems like quite a lot
of added code for a feature that nobody has requested, and whose
definition is about as ad-hoc as could be. Personally I'd much sooner
use \ef for
On Aug 8, 2010, at 9:10 AM, Pavel Stehule wrote:
There are no keys.
ok - I didn't use a correct name - so indexed set is better.
Hash?
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Peter Eisentraut pete...@gmx.net writes:
On lör, 2010-07-31 at 13:40 -0400, Robert Haas wrote:
I think the point of this function is to determine whether a cast to
xml will throw an error. The behavior should probably match exactly
whatever test would be applied there.
Maybe there should
2010/8/8 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com writes:
updated patch attached
What exactly is the point of the \sf command? It seems like quite a lot
of added code for a feature that nobody has requested, and whose
definition is about as ad-hoc as could be.
2010/8/8 Kevin Grittner kevin.gritt...@wicourts.gov:
Pavel Stehule wrote:
I didn't use a correct name - so indexed set is better.
How would such a thing differ from a RAM-based local temporary table?
temporary tables are too heavy for this purposes. In SQL environment I
expecting a
2010/8/8 David E. Wheeler da...@kineticode.com:
On Aug 8, 2010, at 9:10 AM, Pavel Stehule wrote:
There are no keys.
ok - I didn't use a correct name - so indexed set is better.
Hash?
Just only hash isn't good model, because I sometimes we would prefer a
ordered set
Regards
Pavel
David
Mike Fowler m...@mlfowler.com writes:
On 06/08/10 20:55, Peter Eisentraut wrote:
On fre, 2010-08-06 at 09:04 +0100, Mike Fowler wrote:
If the patch is to be committed, does it make sense for me to refine
it such that it uses the new xpath internal function you extracted in
the xmlexists
On sön, 2010-08-08 at 11:59 -0400, Tom Lane wrote:
The reason for the inconsistency is that the underlying behavior is
different: fmgr automatically doesn't collect stats for internal
functions.
Sure it does: When they are defined in language SQL.
--
Sent via pgsql-hackers mailing list
For the next review cycle, here is a patch that adds some ALTER TYPE
subcommands for composite types:
ALTER TYPE ... ADD ATTRIBUTE
ALTER TYPE ... DROP ATTRIBUTE
ALTER TYPE ... ALTER ATTRIBUTE ... SET DATA TYPE
ALTER TYPE ... RENAME ATTRIBUTE
These work similarly to the analogous ALTER TABLE /
On Sun, Aug 8, 2010 at 1:45 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Peter Eisentraut pete...@gmx.net writes:
On lör, 2010-07-31 at 13:40 -0400, Robert Haas wrote:
I think the point of this function is to determine whether a cast to
xml will throw an error. The behavior should probably match
Hi everyone,
I've been playing around with a process based parallel quicksort
(http://github.com/markwkm/quicksort) and I tried to shoehorn it into
postgres because I wanted to see if I could sort more than integers.
I've attached a patch that creates a new GUC to control the degree of
On Sun, Aug 8, 2010 at 1:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Pavel Stehule pavel.steh...@gmail.com writes:
updated patch attached
What exactly is the point of the \sf command? It seems like quite a lot
of added code for a feature that nobody has requested, and whose
definition is
On Sun, Aug 8, 2010 at 11:36 AM, Mike Fowler m...@mlfowler.com wrote:
On 06/08/10 17:50, Pavel Stehule wrote:
attached updated patch with regression test
Bravely ignoring the quotation/varidic/favourite_scheme_here
conversations,
Thank you!
I've taken a look at the patch as is.
Excellent.
Peter Eisentraut pete...@gmx.net writes:
On sön, 2010-08-08 at 11:59 -0400, Tom Lane wrote:
The reason for the inconsistency is that the underlying behavior is
different: fmgr automatically doesn't collect stats for internal
functions.
Sure it does: When they are defined in language SQL.
On 8/8/10 8:40 AM, David Fetter wrote:
Would anyone object to changing it to make it more consistent with
other others? And since we're jollily making catalog changes in 9.0
still, could this also be backpatched?
I'd object. It's not a bug (arguable spec, maybe, but working as
spec'd), and
David Fetter da...@fetter.org writes:
I'd like to mark this as Ready for Committer :)
Applied with corrections. The main noncosmetic change was that the
estate field has to be saved and restored, not just arbitrarily reset to
null after running a handler. Otherwise nested exception handlers
Robert Haas robertmh...@gmail.com writes:
On Sun, Aug 8, 2010 at 11:36 AM, Mike Fowler m...@mlfowler.com wrote:
1) XML2 is largely undocumented, giving rise to the problems encountered.
Since the module is deprecated anyways, does it make more sense to get xslt
handling moved into core and get
Robert Haas robertmh...@gmail.com writes:
On Sun, Aug 8, 2010 at 1:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
What exactly is the point of the \sf command?
I rather like \sf, actually; in fact, I think there's a decent
argument to be made that it's more useful than the line-numbering
stuff
Hi,
A few months ago Bruce was doing a hunting of personal Copyrights
notices, but i still found a lot of files copyrighted to: Regents of
the University of California and other files copyrighted to
individuals (ej: almost everything inside src/backend/regex is
copyrighted to Henry Spencer)
A few months ago Bruce was doing a hunting of personal Copyrights
notices, but i still found a lot of files copyrighted to: Regents of
the University of California and other files copyrighted to
individuals (ej: almost everything inside src/backend/regex is
copyrighted to Henry Spencer)
33 matches
Mail list logo
