On Thu, May 27, 2010 at 1:58 PM, Mohammad Heykal Abdillah
heykal.abdil...@gmail.com wrote:
Now to the question, why my manualy constructed list was failed to
execute? I was pretty sure that my list node was identical with yacc.
Because you have a bug in your code.
--
Robert Haas
EnterpriseDB:
On 27/05/2010, at 20.00, Josh Berkus j...@agliodbs.com wrote:
Well, maybe I'm confused here, but arranging things so that we NEVER
have to visit the page after initially writing it seems like it's
setting the bar almost impossibly high.
That is the use case, though. What I've encountered
KaiGai,
* KaiGai Kohei (kai...@ak.jp.nec.com) wrote:
As we talked at the developer meeting on Ottawa, it needs to provide
a capability to assign a short text identifier on database objects
to support label based ESP (such as SELinux).
So, I'd like to propose a few approaches to support
Jesper Krogh jes...@krogh.cc wrote:
Couldn't pages that are totally filled by the same transaction, be
frozen on the initial write?
As far as I'm aware, that can only be done if:
(a) The tuples were written within the same transaction which
created or truncated the table.
*or*
(b)
On Thu, May 27, 2010 at 11:23:44AM -0400, Bruce Momjian wrote:
Tom Lane 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
There are functions pg_stat_get_backend_client_addr and
pg_stat_get_backend_client_port, which are exposed through the
pg_stat_activity view, but there is no straightforward way to get the
server-side address and port of a connection. This is obviously much
less commonly needed than the client
Joseph Adams joeyadams3.14...@gmail.com writes:
I tried making a function named json_type that has the same name as
the type json_type. However, this doesn't work as expected:
SELECT json_type('[1,2,3]');
Instead of calling json_type with '[1,2,3]' casted to JSON, it's
trying to cast
On Thu, May 27, 2010 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
If the function is a cast function (which it is),
I don't think it is.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-hackers mailing list
On tor, 2010-05-27 at 12:59 -0400, Tom Lane wrote:
I think we should fix it now. Quick thought: maybe we could use
FOR
instead of AS: select myfunc(7 for a, 6 for b);
I'm afraid FOR doesn't work either; it'll create a conflict with the
spec-defined SUBSTRING(x FOR y) syntax.
How about
Stephen Frost sfr...@snowman.net writes:
We also add a dependency between the labeled object and the security
label itself. It also enables to clean up orphan labels automatically,
without any new invention.
I agree that we need to address this. I am kind of curious how this is
handled for
On Thu, May 27, 2010 at 3:15 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Jesper Krogh jes...@krogh.cc wrote:
Couldn't pages that are totally filled by the same transaction, be
frozen on the initial write?
As far as I'm aware, that can only be done if:
(a) The tuples were
Peter Eisentraut pete...@gmx.net writes:
There are functions pg_stat_get_backend_client_addr and
pg_stat_get_backend_client_port, which are exposed through the
pg_stat_activity view, but there is no straightforward way to get the
server-side address and port of a connection. This is obviously
Robert Haas robertmh...@gmail.com writes:
On Thu, May 27, 2010 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
If the function is a cast function (which it is),
I don't think it is.
It certainly is --- he was actually declaring a cast with it in his
example, no?
Robert Haas robertmh...@gmail.com wrote:
On Thu, May 27, 2010 at 3:15 PM, Kevin Grittner
(a) The tuples were written within the same transaction which
created or truncated the table.
In case (a), you mess up visibility with respect to other
command-IDs within the transaction.
Surely
Simon Riggs wrote:
On Wed, 2010-05-26 at 18:52 +0900, Fujii Masao wrote:
I guess that dropping the support of #3 doesn't reduce complexity
since the code of #3 is almost the same as that of #2. Like
walreceiver sends the ACK after receiving the WAL in #2 case, it has
only to do the same
On Thu, May 27, 2010 at 3:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Thu, May 27, 2010 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
If the function is a cast function (which it is),
I don't think it is.
It certainly is --- he was actually
Peter Eisentraut pete...@gmx.net writes:
On tor, 2010-05-27 at 12:59 -0400, Tom Lane wrote:
I'm afraid FOR doesn't work either; it'll create a conflict with the
spec-defined SUBSTRING(x FOR y) syntax.
How about
select myfunc(a := 7, b := 6);
?
Hey, that's a thought. We couldn't have used
On Thu, May 27, 2010 at 3:52 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Robert Haas robertmh...@gmail.com wrote:
On Thu, May 27, 2010 at 3:15 PM, Kevin Grittner
(a) The tuples were written within the same transaction which
created or truncated the table.
In case (a), you mess up
Robert Haas robertmh...@gmail.com writes:
On Thu, May 27, 2010 at 3:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
It certainly is --- he was actually declaring a cast with it in his
example, no?
That was an attempt at a workaround to get it to do what he wanted.
Oh. If you don't want to think
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
I agree that we need to address this. I am kind of curious how this is
handled for comments? It appears to be, but I don't see an entry in
pg_depend when a comment is added to an object, yet the entry in
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Peter Eisentraut pete...@gmx.net writes:
select myfunc(a := 7, b := 6);
Kinda like it myself.
Question #1: is the SQL committee likely to standardize that out
from under us, too?
Couldn't say on that one.
Question #2: will ecpg have a problem with
Robert Haas robertmh...@gmail.com wrote:
I proposed an idea at PGCon, but I believe Tom and Heikki thought
it was far too grotty to consider.
Well, as an alternative -- don't we have some information about the
relation pinned which could hold the xid of its creator? If the
tuple is frozen
Stephen Frost sfr...@snowman.net writes:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I'm not real sure that you want a dependency for a security label anyway
--- wouldn't that mean each label could only be used for one object?
Err, your question comes across to me like if you added comments to
2010/5/27 Tom Lane t...@sss.pgh.pa.us:
Peter Eisentraut pete...@gmx.net writes:
On tor, 2010-05-27 at 12:59 -0400, Tom Lane wrote:
I'm afraid FOR doesn't work either; it'll create a conflict with the
spec-defined SUBSTRING(x FOR y) syntax.
How about
select myfunc(a := 7, b := 6);
?
Hey,
Josh Berkus j...@agliodbs.com writes:
On 5/27/10 8:38 AM, Greg Stark wrote:
Mot administration
questions are originally posed as general help questions. If you're
subscribed to these lists you get a random, fairly small, subset of
discussion related these topics.
Only someone who is a
On Thu, May 27, 2010 at 4:01 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Stephen Frost sfr...@snowman.net writes:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I'm not real sure that you want a dependency for a security label anyway
--- wouldn't that mean each label could only be used for one object?
Excerpts from Josh Berkus's message of jue may 27 14:11:51 -0400 2010:
Only someone who is a postgresql developer would consider 15-30
posts/day small. For most of our user base, the level of traffic on
-performance, -sql, and -general is already too high and many people
don't subscribe to
On 05/27/2010 12:39 PM, Robert Haas wrote:
On Thu, May 27, 2010 at 3:15 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Jesper Krogh jes...@krogh.cc wrote:
Couldn't pages that are totally filled by the same transaction, be
frozen on the initial write?
As far as I'm aware, that can
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
Err, your question comes across to me like if you added comments to
pg_depend, you'd only be able to use a given comment X for one object?.
Doesn't make alot of sense. :)
Well, one of us is confused. I
Heikki Linnakangas wrote:
BTW, I think we're going to need a separate config file for listing the
standbys anyway. There you can write per-server rules and options, but
explicitly knowing about all the standbys also allows the master to
recycle WAL as soon as it has been streamed to all the
Joe Conway m...@joeconway.com wrote:
(a) can work if it is all in one command, CREATE TABLE AS
SELECT...
Additionally we were discussing COPY in the FROM clause, which
means you could CREATE TABLE AS SELECT ... FROM (COPY ...). That
would allow bulk loading with hint bits already set (and
On 5/27/2010 12:01 PM, Jan Wieck wrote:
On 5/27/2010 9:59 AM, Greg Stark wrote:
This thread has been hard to follow for me. Were any of these
questions answered?
Yes.
The thing missing is any sort of answer to that problem description.
Jan
--
Anyone who trades liberty for security
Several buildfarm mingw members are getting failures like this, when
running initdb:
creating conversions ... FATAL: could not load library
On Thu, May 27, 2010 at 02:55:54PM -0400, Robert Haas wrote:
On Thu, May 27, 2010 at 1:27 PM, David E. Wheeler da...@kineticode.com
wrote:
On May 27, 2010, at 9:59 AM, Tom Lane wrote:
I think we should fix it now. Quick thought: maybe we could use FOR
instead of AS: select myfunc(7 for
On May 27, 2010, at 4:31 PM, Bruce Momjian br...@momjian.us wrote:
Heikki Linnakangas wrote:
BTW, I think we're going to need a separate config file for listing
the
standbys anyway. There you can write per-server rules and options,
but
explicitly knowing about all the standbys also allows
On Kam, 2010-05-27 at 15:02 -0400, Robert Haas wrote:
On Thu, May 27, 2010 at 1:58 PM, Mohammad Heykal Abdillah
heykal.abdil...@gmail.com wrote:
Now to the question, why my manualy constructed list was failed to
execute? I was pretty sure that my list node was identical with yacc.
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 Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
So... can we get back to coming up with a reasonable
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
I think the problem at hand has nothing at all to do with agglutination
or CJK-specific issues. You will get the same problem with other
languages *if* you set a locale that does not adequately support the
characters in use. E.g., Russian with locale C and encoding UTF8:
select
What I can't help wondering as I'm reading this discussion is -
Tatsuo-san said upthread that he has a problem with pg_trgm that he
does not have with full text search. So what is full text search
doing differently than pg_trgm?
Problem with pg_trgm is, it uses isascii() etc. to recognize a
Now to the question, why my manualy constructed list was failed to
execute? I was pretty sure that my list node was identical with yacc.
Because you have a bug in your code.
You can debug your code by comparing your hand made tree with the
original tree by using equal(). Search #ifdef
Tatsuo Ishii is...@postgresql.org writes:
Problem with pg_trgm is, it uses isascii() etc. to recognize a letter,
which will skip any non ASCII range character in C locale.
The only place I see that is in those ISPRINTABLE macros, which are only
used in show_trgm(), which is just a debugging
Problem with pg_trgm is, it uses isascii() etc. to recognize a letter,
which will skip any non ASCII range character in C locale.
The only place I see that is in those ISPRINTABLE macros, which are only
used in show_trgm(), which is just a debugging function. It could stand
to be
Josh Berkus j...@agliodbs.com writes:
We do not have a problem. The lists are fine the way they are.
+1 ... wasn't the point I thought you were trying to make, but I'm
good with not changing things.
regards, tom lane
--
Sent via pgsql-hackers mailing list
Tatsuo Ishii is...@postgresql.org writes:
similarity - generate_trgm - find_word - iswordchr - t_isalpha - isalpha
if locale is C and USE_WIDE_UPPER_LOWER defined which is the case in
most modern OSs.
Quite. And *if locale is C then only standard ASCII letters are letters*.
You may not like
Tatsuo Ishii is...@postgresql.org writes:
Or you could just #undef KEEPONLYALNUM in trgm.h. But I'm not sure
this is the right thing for you.
It's not a practical solution for people working with prebuilt Postgres
versions, which is most people. I don't object to finding a way to
provide a
Tatsuo Ishii is...@postgresql.org writes:
similarity - generate_trgm - find_word - iswordchr - t_isalpha -
isalpha
if locale is C and USE_WIDE_UPPER_LOWER defined which is the case in
most modern OSs.
Quite. And *if locale is C then only standard ASCII letters are letters*.
You
I think the problem at hand has nothing at all to do with agglutination
or CJK-specific issues. You will get the same problem with other
languages *if* you set a locale that does not adequately support the
characters in use. E.g., Russian with locale C and encoding UTF8:
select
Mike Fowler wrote:
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, May 25, 2010 at 1:09 PM, Mike Fowler m...@mlfowler.com wrote:
We're unlikely to accept this patch if it changes the minimum version
of libxml2 required to compile PostgreSQL
Why?
It's not a practical solution for people working with prebuilt Postgres
versions, which is most people. I don't object to finding a way to
provide a not-space behavior instead of an is-alnum behavior,
but as noted upthread a GUC isn't the right way. How do you feel
about a new set of
(2010/05/28 4:12), Stephen Frost wrote:
KaiGai,
* KaiGai Kohei (kai...@ak.jp.nec.com) wrote:
As we talked at the developer meeting on Ottawa, it needs to provide
a capability to assign a short text identifier on database objects
to support label based ESP (such as SELinux).
So, I'd like to
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 Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com
On Thu, May 27, 2010 at 6:56 PM, Mohammad Heykal Abdillah
heykal.abdil...@gmail.com wrote:
On Kam, 2010-05-27 at 15:02 -0400, Robert Haas wrote:
On Thu, May 27, 2010 at 1:58 PM, Mohammad Heykal Abdillah
heykal.abdil...@gmail.com wrote:
Now to the question, why my manualy constructed list was
(2010/05/28 5:11), Robert Haas wrote:
On Thu, May 27, 2010 at 4:01 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Stephen Frostsfr...@snowman.net writes:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I'm not real sure that you want a dependency for a security label anyway
--- wouldn't that mean each label
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
On Thu, May 27, 2010 at 11:13 PM, Robert Haas robertmh...@gmail.com wrote:
I guess this happens because the frequency of checkpoint on the standby is
too lower than that on the master. In the master, checkpoint occurs for every
consumption of three segments because of checkpoint_segments = 3.
(2010/05/28 5:25), Stephen Frost wrote:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frostsfr...@snowman.net writes:
Err, your question comes across to me like if you added comments to
pg_depend, you'd only be able to use a given comment X for one object?.
Doesn't make alot of sense. :)
On Fri, May 28, 2010 at 12:20 AM, Greg Stark gsst...@mit.edu wrote:
My suggestion is we should fold all the parameters into
postgresql.conf and treat recovery.conf as an additional
postgresql.conf to read. It would allow any GUC. The only difference
is that it would be moved out of the way
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= wulc...@wulczer.org writes:
On 19/05/10 21:01, Jesper Krogh wrote:
In practice, just cranking the statistics estimate up high enough seems
to solve the problem, but doesn't
there seem to be something wrong in how the statistics are collected?
The algorithm to
David Fetter da...@fetter.org writes:
I don't know about a *good* idea, but here's the one I've got.
1. Make a whitelist. This is what needs to work in order for a
language to be a fully functional trusted PL.
Well, I pretty much lose interest right here, because this is already
assuming
On Jum, 2010-05-28 at 08:55 +0900, Tatsuo Ishii wrote:
Now to the question, why my manualy constructed list was failed to
execute? I was pretty sure that my list node was identical with yacc.
Because you have a bug in your code.
You can debug your code by comparing your hand made
Peter Eisentraut wrote:
On tor, 2010-05-27 at 12:59 -0400, Tom Lane wrote:
I think we should fix it now. Quick thought: maybe we could use
FOR
instead of AS: select myfunc(7 for a, 6 for b);
I'm afraid FOR doesn't work either; it'll create a conflict with the
spec-defined
Andrew Dunstan and...@dunslane.net wrote:
Several buildfarm mingw members are getting failures like this, when
running initdb:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=dawn_batdt=2010-05-27%2019:45:18
Could it have been caused by the PGDLLIMPORT/PGDLLEXPORT changes?
Probably,
Bruce Momjian wrote:
Peter Eisentraut wrote:
On tor, 2010-05-27 at 12:59 -0400, Tom Lane wrote:
I think we should fix it now. Quick thought: maybe we could use
FOR
instead of AS: select myfunc(7 for a, 6 for b);
I'm afraid FOR doesn't work either; it'll
Andrew Dunstan and...@dunslane.net writes:
Bruce Momjian wrote:
One concern I have is that in PL/pgSQL, := and = behave the same, while
in SQL, they would not. That might cause confusion.
I doubt there will be much confusion.
I agree. Bruce is ignoring the fact that they are *not*
I encountered a situation while implementing JSON support where I
needed to return an enum value from a C function. To clarify, here's
the SQL:
CREATE TYPE json_type_t AS ENUM ('null', 'string', 'number', 'bool',
'object', 'array');
CREATE OR REPLACE FUNCTION json_type(json)
RETURNS json_type_t
Both nodes (active and standby) have the same configuration parameters.
The observed effect happens too if the checkpoint timeout is decreaased.
The problem seems to be that on standby no checkpoints are written and
only the chekpoint_timeout mechanism is active
Regards
Ingo
-Original
101 - 167 of 167 matches
Mail list logo