Hitoshi Harada wrote:
2008/9/2 Heikki Linnakangas <[EMAIL PROTECTED]>:
Hitoshi Harada wrote:
2008/9/2 Heikki Linnakangas <[EMAIL PROTECTED]>:
In my understanding, the "Window Frame" is defined
by clauses such like "ROWS BETWEEN ... ", "RANGE BETWEEN ... " or so,
contrast to "Window Partition" d
On Wed, 2008-09-03 at 09:51 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > On Tue, 2008-09-02 at 15:51 +0300, Heikki Linnakangas wrote:
> >
> >> The needs of access to the rows are so different that it seems best to
> >> me to delegate the buffering to the window function.
> >
> > Tha
Marko Kreen wrote:
On 9/2/08, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Marko Kreen wrote:
In the meantime, here is simple patch for case-insensivity.
You might be able to talk me into accepting various unambiguous, common
alternative spellings of various units. But for instance allowing M
On Wed, Sep 3, 2008 at 9:17 AM, daveg <[EMAIL PROTECTED]> wrote:
> On Thu, Aug 14, 2008 at 06:50:09PM +0100, Simon Riggs wrote:
> >
> > On Fri, 2008-08-08 at 16:23 -0400, Tom Lane wrote:
> >
> > > NOT IN is a lot trickier,
> > > condition: you must also assume that the comparison operator involved
On Wed, Sep 3, 2008 at 11:20 AM, Heikki Linnakangas <
[EMAIL PROTECTED]> wrote:
> Marko Kreen wrote:
>
>> On 9/2/08, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>>
>>> Marko Kreen wrote:
>>>
In the meantime, here is simple patch for case-insensivity.
>>> You might be able to talk me int
On 9/3/08, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> Marko Kreen wrote:
> > On 9/2/08, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > > Marko Kreen wrote:
> > > > In the meantime, here is simple patch for case-insensivity.
> > > >
> > > You might be able to talk me into accepting various un
On Tue, 2008-09-02 at 16:50 +0300, Peter Eisentraut wrote:
> Gregory Stark wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >
> >> Marko Kreen wrote:
> >>> In the meantime, here is simple patch for case-insensivity.
> >> You might be able to talk me into accepting various unambiguous, com
Tom Lane <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> Tom Lane <[EMAIL PROTECTED]> writes:
>>> BTW, there are at least two copies of that code to be changed. I'd
>>> suggest grepping for assignments to t_hoff to be sure there aren't more.
>
>> I did send in a patch a
2008/9/3 Heikki Linnakangas <[EMAIL PROTECTED]>:
> Hitoshi Harada wrote:
>>
>>> I'd suggest:
>>>
>>> 1. Implement Window node, with the capability to invoke an aggregate
>>> function, using the above API. Implement required parser/planner changes.
>>> Implement a few simple ranking aggregates using
Is there a knowable order in which functions are called within a query in
PostgreSQL?
For example I'll use the Oracle "contains" function, though this is not
exactly what I'm doing, it just illustrates the issue clearly.
select *, score(1) from mytable where contains(mytable.title, 'Winding
Road'
Alvaro Herrera wrote:
There's one thing that seems a bit baroque, which is the
PG_COPYRES_USE_ATTRS stuff in PQcopyResult. I think that flag
introduces different enough behavior that it should be a routine of its
own, say PQcopyResultAttrs. That way you would leave out the two extra
params in
Hannu Krosing wrote:
On Tue, 2008-09-02 at 16:50 +0300, Peter Eisentraut wrote:
Gregory Stark wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Are you really afraid that someone would want to use mb to mean
millibits ?
As SQL is generally case insensitive, it is quite surprising to most
[EMAIL PROTECTED] writes:
> For example I'll use the Oracle "contains" function, though this is not
> exactly what I'm doing, it just illustrates the issue clearly.
> select *, score(1) from mytable where contains(mytable.title, 'Winding
> Road', 1) order by score(1);
> The "contains" function do
[EMAIL PROTECTED] wrote:
>Would it be something like: "where" clause first, left to right, followed
>by select terms, left to right, and lastly the "order by" clause?
I don't know what ANSI says, nor do I know what PostgreSQL exactly does
at the moment, but, the only thing you can reasonably count
Greg Stark wrote:
I don't think worrying about the message we send to users is reasonable.
We can take responsibilty for the messages we output but punishing our
users to teach them a lesson is being actively user-hostile
There is no arguing that MB != Mb; nor is there anything user-hostile
b
Gregory Stark <[EMAIL PROTECTED]> writes:
> I could do the janitorial work again if we're interested.
I think it'd make more sense to do it incrementally rather than in one
big-bang patch ...
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgre
Dear Hitoshi,
I noticed the folowing typo in the doc sgml:
'rownumber()', instead of 'row_number()' ( 2x )
hth
Erik Rijkers
*** doc/src/sgml/func.sgml.orig 2008-09-03 17:20:28.130229027 +0200
--- doc/src/sgml/func.sgml 2008-09-03 17:21:01.331907454 +0200
***
*** 10092,1010
On Wed, 2008-09-03 at 07:52 -0700, Joshua D. Drake wrote:
> Hannu Krosing wrote:
> > On Tue, 2008-09-02 at 16:50 +0300, Peter Eisentraut wrote:
> >> Gregory Stark wrote:
> >>> Peter Eisentraut <[EMAIL PROTECTED]> writes:
>
> > Are you really afraid that someone would want to use mb to mean
> > mil
On Wed, 2008-09-03 at 08:20 -0700, Joshua D. Drake wrote:
> Greg Stark wrote:
> > I don't think worrying about the message we send to users is reasonable.
> > We can take responsibilty for the messages we output but punishing our
> > users to teach them a lesson is being actively user-hostile
>
2008/9/4 Erikj <[EMAIL PROTECTED]>:
> Dear Hitoshi,
>
> I noticed the folowing typo in the doc sgml:
>
> 'rownumber()', instead of 'row_number()' ( 2x )
>
> hth
>
> Erik Rijkers
>
>
>
> *** doc/src/sgml/func.sgml.orig 2008-09-03 17:20:28.130229027 +0200
> --- doc/src/sgml/func.sgml 2008-09-03
On Wed, 03 Sep 2008 18:32:16 +0300
Hannu Krosing <[EMAIL PROTECTED]> wrote:
> > We have had this discussion before, I even submitted a patch to
> > make them case insensitive. In retrospect I was wrong to submit
> > that patch. SQL may be case insensitive but units are not. MB !=
> > Mb != mb ,
>
> [EMAIL PROTECTED] writes:
>> For example I'll use the Oracle "contains" function, though this is not
>> exactly what I'm doing, it just illustrates the issue clearly.
>
>> select *, score(1) from mytable where contains(mytable.title, 'Winding
>> Road', 1) order by score(1);
>
>> The "contains" fu
> I was kind of afraid of that. So, how could one implement such a function
> set?
Write a function (say, score_contains) that returns NULL whenever
contains would return false, and the score otherwise.
SELECT * FROM (
SELECT *, score_contains(mytable.title, 'Winding Road', 1) AS
score FROM m
Andrew Chernow escribió:
> Alvaro Herrera wrote:
>> (I also removed PQresultAlloc.)
>
> Nooo ... removing PQresultAlloc breaks libpqtypes! It also removes
> some of the use cases provided by PQsetvalue, which allows one to add to
> a result (in our case from scratch).
I don't really see th
> [EMAIL PROTECTED] writes:
>> For example I'll use the Oracle "contains" function, though this is not
>> exactly what I'm doing, it just illustrates the issue clearly.
>
>> select *, score(1) from mytable where contains(mytable.title, 'Winding
>> Road', 1) order by score(1);
>
>> The "contains" fu
On Wed, Sep 03, 2008 at 06:37:29PM +0300, Hannu Krosing wrote:
> On Wed, 2008-09-03 at 08:20 -0700, Joshua D. Drake wrote:
> > There is no arguing that MB != Mb;
>
> The whole point of this discussion is, that mostly people expect
> MB == Mb = mb == mB, especially if they see weird constructs li
Alvaro Herrera wrote:
Andrew Chernow escribió:
Alvaro Herrera wrote:
(I also removed PQresultAlloc.)
Nooo ... removing PQresultAlloc breaks libpqtypes! It also removes
some of the use cases provided by PQsetvalue, which allows one to add to
a result (in our case from scratch).
I don'
[EMAIL PROTECTED] writes:
> I need to perform an operation during query time and there are multiple
> results based on the outcome. For instance: (Lets try this)
> select myrank(t1.column1, t2.column2, 1) as rank,
> myscore(t1.column1,t2.column2, 1) as score from t1, t2 where
> myrank(t1.column1,t
>> I was kind of afraid of that. So, how could one implement such a
>> function
>> set?
>
> Write a function (say, score_contains) that returns NULL whenever
> contains would return false, and the score otherwise.
>
> SELECT * FROM (
> SELECT *, score_contains(mytable.title, 'Winding Road', 1)
On Wed, 2008-09-03 at 09:10 -0700, Joshua Drake wrote:
> If someone doesn't know the difference between Mb and MB on a
> production system, I would not want them anywhere near any instance of
> a production system.
I for one can make the difference, once I can zen that we are in a
domain, where M
Folks,
If you hadn't noticed, the CommitFest started this week. I'm currently
assigning patches to reviewers, but if there's a patch you especially
want to tackle, please put your name down right away.
If you can't actually review the patch *this week*, please don't put
your name down.
Th
> [EMAIL PROTECTED] writes:
>> I need to perform an operation during query time and there are multiple
>> results based on the outcome. For instance: (Lets try this)
>
>> select myrank(t1.column1, t2.column2, 1) as rank,
>> myscore(t1.column1,t2.column2, 1) as score from t1, t2 where
>> myrank(t1.c
Hannu Krosing escribió:
> On Wed, 2008-09-03 at 09:10 -0700, Joshua Drake wrote:
> > If we are going to make sweeping statements (anyone on this thread)
> > about user-hostile and most people, then we better define what those
> > mean.
>
> Not user-hostile but rather hostile to an overworked DBA
On Wed, Sep 03, 2008 at 01:48:18PM -0400, Alvaro Herrera wrote:
> I think the energy wasted in this discussion would be better spent in
> working a the check-the-config-file feature. That would equally solve
> this problem, as well as many others.
This seems like a good idea to me.
A
--
Andre
On Tue, 2 Sep 2008, Tom Lane wrote:
How about having two new columns "reset value" and "boot value"?
Like it better than "default value" ...
It's being a bit pedantic at the expense of the user, but I don't really
care that much here. I exposed the boot_val and described it in the
documen
Hi,
If you are a Fedora-9 or RHEL/CentOS 5 user and want to test new
features of PostgreSQL 8.4 and help development team, you may use the
packages that I have just released, based on today's CVS snapshot. I am
planning to push new packages each weekend during commitfest.
Please note that these p
I don't think worrying about the message we send to users is
reasonable. We can take responsibilty for the messages we output but
punishing our users to teach them a lesson is being actively user-
hostile
greg
On 3 Sep 2008, at 15:52, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
Hannu Kro
Sure if people want to do it the right way more power to them. What
you're talking about is punishing people when they don't live up to
your standards.
greg
On 3 Sep 2008, at 16:20, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
Greg Stark wrote:
I don't think worrying about the message we s
On Wed, 3 Sep 2008 19:36:19 +0100
Greg Stark <[EMAIL PROTECTED]> wrote:
> Sure if people want to do it the right way more power to them. What
> you're talking about is punishing people when they don't live up to
> your standards.
I think I will defer to Andrew and Alvaro's opinion on the matt
Greg Smith <[EMAIL PROTECTED]> writes:
> On Tue, 2 Sep 2008, Tom Lane wrote:
>>> How about having two new columns "reset value" and "boot value"?
>>
>> Like it better than "default value" ...
> It's being a bit pedantic at the expense of the user, but I don't really
> care that much here. I exp
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> You do realize that misspelling unit name can cause downtime of several
> minutes instead of couple seconds? We can easily do restart in couple of
> seconds but the restart, look logs, launch editor, find value, change,
> save, restart cycle
=?ISO-8859-1?Q?Benedek_L=E1szl=F3?= <[EMAIL PROTECTED]> writes:
> pg_dumpall now just passes the --role option to pg_dump. What do you
> think, is it enough
> or it should issue the SET ROLE TO ... command in its own session too?
I think it would have to, in the general case. Consider the possib
On Wed, 3 Sep 2008, Tom Lane wrote:
"Default value if the parameter is not explicitly set"
If that statement were the truth, the whole truth, and nothing but the
truth, and if it didn't ignore the point about "explicitly set WHERE?",
I'd be fine with it.
First question--how about if I changed
On Wed, 3 Sep 2008 16:04:12 -0400 (EDT)
Greg Smith <[EMAIL PROTECTED]> wrote:
> Section question: with those changes, would it then be reasonable to
> you to keep that column named "default" instead of giving it a less
> common name?
>
> > You are adopting a very narrow mindset, which seems to
On Wed, 2008-09-03 at 13:48 -0400, Alvaro Herrera wrote:
> Hannu Krosing escribió:
> > On Wed, 2008-09-03 at 09:10 -0700, Joshua Drake wrote:
>
> > > If we are going to make sweeping statements (anyone on this thread)
> > > about user-hostile and most people, then we better define what those
> > >
On Wed, 03 Sep 2008 23:10:24 +0300
Hannu Krosing <[EMAIL PROTECTED]> wrote:
> > That would equally solve
> > this problem, as well as many others.
>
> AFAIK the config file is checked now, and if the check fails, the
> database won't start.
Like apachectl configcheck ... E.g; we have the ability
Hannu Krosing escribió:
> On Wed, 2008-09-03 at 13:48 -0400, Alvaro Herrera wrote:
> > I think the energy wasted in this discussion would be better spent in
> > working a the check-the-config-file feature.
>
> What kind of checks do you have in mind. Would this be something that
> works at restar
>>> Tom Lane <[EMAIL PROTECTED]> wrote:
> If you're still interested in testing CVS HEAD's handling of EXISTS,
> I've about finished what I wanted to do with it.
It's been hectic here, but I've managed to let some stuff run in the
background using an old test case from here:
http://archives.po
On Wed, 2008-09-03 at 11:45 -0700, Joshua Drake wrote:
> On Wed, 3 Sep 2008 19:36:19 +0100
> Greg Stark <[EMAIL PROTECTED]> wrote:
>
> > Sure if people want to do it the right way more power to them. What
> > you're talking about is punishing people when they don't live up to
> > your standard
Marko Kreen <[EMAIL PROTECTED]> writes:
> In case module and server magic blocks do not match
> report exact parameters that differ.
Applied with revisions --- your patch produced a message that wasn't
localizable and didn't follow the style guidelines. Also it assumed
that all the fields would b
On Thu, 04 Sep 2008 01:26:44 +0300
Hannu Krosing <[EMAIL PROTECTED]> wrote:
> So Andrews opinion was that Mb (meaning Mbit) is different from MB
> (for megabyte) and that if someone thinks that we define shared
> buffers in megabits can get confused and order wrong kind of network
> card ?
I was
Joshua Drake <[EMAIL PROTECTED]> writes:
> I guess I would ask, "Who else would we be targeting this for?". DBAs
> seem to be the only logical choice.
Regular users look at pg_settings too, you know. Maybe *you* only
get questions from DBAs...
regards, tom lane
--
Sent
Greg Smith <[EMAIL PROTECTED]> writes:
> First question--how about if I changed that description to read:
> "Default value used at server startup if the parameter is not explicitly
> set"?
"... not otherwise set" would probably be an accurate phrasing.
(I'm thinking of corner cases like stuff ab
Gregory Stark <[EMAIL PROTECTED]> writes:
> There are a couple problems with this:
> a) We need some way to decide *when* to do a sort and when to do an index
> scan. The planner has all this machinery but we don't really have all the
> pieces handy to use it in a utility statement.
Why not? You
Hello,
My basic question is: in multimaster replication, if each site goes
ahead and does the modifications issued by the transaction and then
sends the writeset to others in the group, how the ACID properties be
maintained?
Details:
Suppose there are two sites in the group, lets say, A and B and
Hi Srinivas,
Multi-master replication in Postgres-R is handled using a process called
certification that ensures there are no serializability violations. Look at
the paper by Kemme and Alonzo entitled "Don't be Lazy, Be Consistent..."
(http://www.cs.mcgill.ca/~kemme/papers/vldb00.html). In th
Hannu Krosing escribió:
> I mean, there is no known written standard, which says that Mb is
> megabit, not megabyte or that you can (or can't) write kilo as K, but
> some people just believe that kB is "the Way" and allowing people to
> write kilobytes as KB or kb is evil and should be punished.
Stephen Frost <[EMAIL PROTECTED]> writes:
> * Jaime Casanova ([EMAIL PROTECTED]) wrote:
>> updating the patch with one that only extends inserts. though, i
>> haven't look at the col level privs patch yet.
> At least initially I wasn't planning to support column-level privileges
> for sequences, s
* Tom Lane ([EMAIL PROTECTED]) wrote:
> =?ISO-8859-1?Q?Benedek_L=E1szl=F3?= <[EMAIL PROTECTED]> writes:
> > pg_dumpall now just passes the --role option to pg_dump. What do you
> > think, is it enough
> > or it should issue the SET ROLE TO ... command in its own session too?
>
> I think it would
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > * Jaime Casanova ([EMAIL PROTECTED]) wrote:
> >> updating the patch with one that only extends inserts. though, i
> >> haven't look at the col level privs patch yet.
>
> > At least initially I wasn't planning to
Before I respond to Tom's comments, let me step back a second and add the
intro the deadline didn't leave me time for. There are two specific
things the bit I added to this GUC patch is aimed at:
1) Somebody has a postgresql.conf from a random source (saw it on the
Internet and pasted dubious
On Wed, 3 Sep 2008, Tom Lane wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
First question--how about if I changed that description to read:
"Default value used at server startup if the parameter is not explicitly
set"?
"... not otherwise set" would probably be an accurate phrasing.
(I'm th
On Fri, 2008-08-29 at 10:47 +0300, Heikki Linnakangas wrote:
> Here's an updated FSM patch.
Can I check some aspects of this related to Hot Standby? Some of them
sound obvious, but worth double checking.
* There will be no need to read FSM by any normal operation of a
read-only transaction, so
On Mon, 2008-09-01 at 00:25 +0100, Gregory Stark wrote:
> One thing that's been annoying me for a while is that our CLUSTER
> implementation is really very slow. When I say very slow I mean it's really
> very very very slow.
Does this implementation work towards being able to do
CREATE INDEX .
On Wednesday 03 September 2008 16:12:29 Joshua Drake wrote:
> On Wed, 03 Sep 2008 23:10:24 +0300
>
> Hannu Krosing <[EMAIL PROTECTED]> wrote:
> > > That would equally solve
> > > this problem, as well as many others.
> >
> > AFAIK the config file is checked now, and if the check fails, the
> > data
On Wed, 2008-09-03 at 20:01 -0400, Alvaro Herrera wrote:
> Hannu Krosing escribió:
>
> > I mean, there is no known written standard, which says that Mb is
> > megabit, not megabyte or that you can (or can't) write kilo as K, but
> > some people just believe that kB is "the Way" and allowing people
66 matches
Mail list logo