On 2011-09-28 15:25, Joachim Wieland wrote:
Yes, that's the desired behaviour, the patch add this paragraph to the
documentation already:
I can't believe I missed that. My apologies.
On 2011-09-29 05:16, Joachim Wieland wrote:
The attached patch addresses the reported issues.
Thanks, this
On 29.09.2011 14:31, Fujii Masao wrote:
On Tue, Sep 27, 2011 at 8:06 PM, Florian Pflugf...@phlo.org wrote:
Actually, why don't we use that machinery to implement this? There's currently
no rm_safe_restartpoint callback for RM_XLOG_ID, so we'd just need to create
one that checks whether
On Mon, Oct 3, 2011 at 8:21 AM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
On 29.09.2011 14:31, Fujii Masao wrote:
On Tue, Sep 27, 2011 at 8:06 PM, Florian Pflugf...@phlo.org wrote:
Actually, why don't we use that machinery to implement this? There's
currently no
On Mon, Oct 3, 2011 at 6:23 AM, Fujii Masao masao.fu...@gmail.com wrote:
So I think that the idea should be implemented separately from
the patch I've posted.
Agreed. I'll do a final review and commit today.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL
Hanada-san,
I applied your patch and run a few test cases. while this test, I
noticed a few points.
At first, I tried to use file_fdw, however, it was crashed of course.
It seems to me this logic should be modified to confirm whether the target FDW
support join push down, or not.
+ if
Tom Lane t...@sss.pgh.pa.us writes:
Simon Riggs si...@2ndquadrant.com writes:
On Sun, Oct 2, 2011 at 10:05 PM, Tom Lane t...@sss.pgh.pa.us wrote:
So at this point I'd vote for just dropping it and always allowing
custom (that is, qualified) GUC names to be set, whether the prefix
corresponds
BTW, I remember that I was suggested the object-access-hooks to acquire
controls around changes of system catalogs are also useful to implement
clustering features, not only enhanced security features, when I had a talk
at PGcon2001.
It might be my mistake that I categorized this patch at the
On Sun, Oct 2, 2011 at 23:05, Tom Lane t...@sss.pgh.pa.us wrote:
During the discussion of Alexey Klyukin's rewrite of ParseConfigFile,
considerable unhappiness was expressed by various people about the
complexity and relative uselessness of the custom_variable_classes GUC.
While working over
On Oct2, 2011, at 23:15 , Joe Abbate wrote:
I'm
somewhat surprised there appears to be no ability to lock a database
exclusively for something like pg_dump/pg_restore, so you're not
surprised by concurrent activity against the catalogs. I'm guessing the
assumption is that MVCC will take care
On Sun, Oct 2, 2011 at 8:19 PM, Robert Haas robertmh...@gmail.com wrote:
It occurs to me that pgstat_report_xact_end_timestamp doesn't really
need to follow the protocol of bumping the change count before and
after bumping the timestamp. We elsewhere assume that four-byte reads
and writes are
On Fri, Sep 30, 2011 at 4:18 PM, Simon Riggs si...@2ndquadrant.com wrote:
If we want to measure times, we can easily send regular messages into
WAL to provide this function. Using checkpoint records would seem
frequent enough to me. We don't always send checkpoint records but we
can send an
On 12 February 2011 14:48, Alex Hunsaker bada...@gmail.com wrote:
On Sun, Feb 6, 2011 at 15:31, Andrew Dunstan and...@dunslane.net wrote:
Force strings passed to and from plperl to be in UTF8 encoding.
String are converted to UTF8 on the way into perl and to the
database encoding on the way
Whether this feature is available in version 9.1.0. ??
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tracking-latest-timeline-in-standby-mode-tp3238829p4863900.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
--
Sent via pgsql-hackers
I tried adding a not-null column in one step and got a collation
error for a different column. Adding the column in several steps
works:
itd= alter table livedata add column pricechanged timestamp not null default
current_timestamp;
ERROR: no collation was derived for column whois_b with
On 28/09/2011, at 11:17 AM, Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Royce Ausburn's message of mar sep 27 21:28:26 -0300 2011:
Tom's suggestion looks like it's less trivial that I can do just yet, but
I'll take a look and ask for help if I need it.
On Sun, Oct 2, 2011 at 4:08 PM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote:
Ok I needed `git apply' to apply the patches, now that I used that I can
confirm that the 3 patches apply, compile, pass tests, and that I could
play with them a little. I think I'm going to mark that ready for
How can i get record by data block not by sql?
I want to read and write lots of data by data blocks and write a record to a
appointed data blocks,so i can form a disk-resident tree by recording the block
address. But i don't know how to implement in postgresql.
Is there system function can
Magnus Hagander mag...@hagander.net writes:
Don't forget that there are usecases for variables under
custom_variable_classes that aren't actually associated with
extensions (as general session-shared-variables). Though I guess if it
was somehow restricted to extensions, those who needed that
On 10/03/2011 10:17 AM, Tom Lane wrote:
Magnus Hagandermag...@hagander.net writes:
Don't forget that there are usecases for variables under
custom_variable_classes that aren't actually associated with
extensions (as general session-shared-variables). Though I guess if it
was somehow
Hello
is there some possibility to get a processed rows from COPY statement
from PL/pgSQL?
I searched any ways, but there are no command tag.
Regards
Pavel Stehule
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 10/03/2011 10:34 AM, Pavel Stehule wrote:
Hello
is there some possibility to get a processed rows from COPY statement
from PL/pgSQL?
I searched any ways, but there are no command tag.
You mean something like a RETURNING clause?
My worry would be about possible speed effects, although
Andrew Dunstan and...@dunslane.net writes:
On 10/03/2011 10:17 AM, Tom Lane wrote:
Right. Getting rid of custom_variable_classes should actually make
those use-cases easier, since it will eliminate a required setup step.
So are we going to sanction using this as a poor man's session variable
Robert Haas robertmh...@gmail.com writes:
I think that new versions of patch can handle unified diffs without a
problem, but older versions choke on them. My Mac has 2.5.8 and
handles unidiffs no problem.
Even containing git headers?
Here's what I'm talking about here:
On Mon, Oct 03, 2011 at 10:41:48AM -0400, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
On 10/03/2011 10:17 AM, Tom Lane wrote:
Right. Getting rid of custom_variable_classes should actually
make those use-cases easier, since it will eliminate a required
setup step.
So
On Sat, Oct 1, 2011 at 9:46 PM, Andrew Dunstan and...@dunslane.net wrote:
How would that help? This isn't a lock failure.
It is, rather, a failure to lock. Currently, LOCK TABLE only works on
tables, and pg_dump only applies it to tables. If the offending
object had been a table rather than a
On Mon, Oct 3, 2011 at 10:55 AM, David Fetter da...@fetter.org wrote:
Perhaps it's best to document this usage and include the warning for
those less bright, as you term them. I'd be less tempted to call
them not bright and more tempted to think they might assume
PostgreSQL already takes
On Mon, Oct 3, 2011 at 10:54 AM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
I think that new versions of patch can handle unified diffs without a
problem, but older versions choke on them. My Mac has 2.5.8 and
handles unidiffs no problem.
Even
Robert Haas robertmh...@gmail.com writes:
Yeah. custom_variable_classes is a pretty annoying wart, but if it's
set to the default value (namely, empty) then it actually does prevent
people from setting bajillions of completely pointless settings, which
seems like it has some merit. I'm not
Robert Haas robertmh...@gmail.com writes:
On Sat, Oct 1, 2011 at 9:46 PM, Andrew Dunstan and...@dunslane.net wrote:
How would that help? This isn't a lock failure.
It is, rather, a failure to lock. Currently, LOCK TABLE only works on
tables, and pg_dump only applies it to tables. If the
Fujii Masao wrote:
On Sun, Oct 2, 2011 at 7:54 AM, Bruce Momjian br...@momjian.us wrote:
What exactly is your question? ?You are not using a config-only
directory but the real data directory, so it should work fine.
No. He is using PGDATA (= /etc/postgresql-9.0) as a config-only
Jamie Fox wrote:
I regret that as a part-timer recently brought back on here I didn't
get an opportunity to test this earlier. The upgrade with the patch
worked fine on my first attempt.
Great. Thanks for the report, and sorry for the bug.
Robert Haas robertmh...@gmail.com writes:
On Mon, Oct 3, 2011 at 10:54 AM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
I think that new versions of patch can handle unified diffs without a
problem, but older versions choke on them. My Mac has
Excerpts from Dimitri Fontaine's message of lun oct 03 11:54:36 -0300 2011:
Robert Haas robertmh...@gmail.com writes:
I think that new versions of patch can handle unified diffs without a
problem, but older versions choke on them. My Mac has 2.5.8 and
handles unidiffs no problem.
Even
Bruce Momjian br...@momjian.us writes:
I am starting to question the value of config-only directories if pg_ctl
stop doesn't work, or you have to specify a different directory for
start and stop.
Yup.
Did we not think of these things when we designed config-only
directories? I don't even
Excerpts from Tom Lane's message of lun oct 03 01:47:18 -0300 2011:
(Without cassert, it looks like LockReassignCurrentOwner is the next
biggest time sink; I'm wondering if there's some sort of O(N^2) behavior
in there.)
That seems fishy. Even if there weren't quadratic behavior, should
On 10/03/2011 12:47 AM, Tom Lane wrote:
Andrew Dunstanand...@dunslane.net writes:
While investigating a client problem I just observed that pg_dump takes
a surprisingly large amount of time to dump a schema with a large number
of views. The client's hardware is quite spiffy, and yet pg_dump
Robert Haas robertmh...@gmail.com writes:
Yeah, it just skips right over them. I've never had even a minor
problem on that account, which is why I was surprised to see it giving
you so much trouble.
Ok then, I'll try some more next time. Been trying not to spend too
much time here… on the
Excerpts from Tom Lane's message of lun oct 03 12:34:22 -0300 2011:
Bruce Momjian br...@momjian.us writes:
I am starting to question the value of config-only directories if pg_ctl
stop doesn't work, or you have to specify a different directory for
start and stop.
Yup.
Did we not
Please don't cross-post. Responding on -hackers because it seems a
better fit here than on -performance.
姜头 104186...@qq.com wrote:
How can i get record by data block not by sql?
I want to read and write lots of data by data blocks and write
record to a appointed data block and read it.
Alvaro Herrera alvhe...@commandprompt.com writes:
Excerpts from Tom Lane's message of lun oct 03 01:47:18 -0300 2011:
(Without cassert, it looks like LockReassignCurrentOwner is the next
biggest time sink; I'm wondering if there's some sort of O(N^2) behavior
in there.)
That seems fishy.
On Mon, Oct 3, 2011 at 11:16 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Yeah. custom_variable_classes is a pretty annoying wart, but if it's
set to the default value (namely, empty) then it actually does prevent
people from setting bajillions of
On Mon, Oct 3, 2011 at 11:28 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Mon, Oct 3, 2011 at 10:54 AM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
I think that new versions of patch can handle unified diffs
Robert Haas robertmh...@gmail.com writes:
On Mon, Oct 3, 2011 at 11:16 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Yeah. custom_variable_classes is a pretty annoying wart, but if it's
set to the default value (namely, empty) then it actually does prevent
Alvaro Herrera wrote:
Excerpts from Tom Lane's message of lun oct 03 12:34:22 -0300 2011:
Bruce Momjian br...@momjian.us writes:
I am starting to question the value of config-only directories if pg_ctl
stop doesn't work, or you have to specify a different directory for
start and
Christian Ullrich ch...@chrullrich.net writes:
I tried adding a not-null column in one step and got a collation
error for a different column.
itd= alter table livedata add column pricechanged timestamp not null default
current_timestamp;
ERROR: no collation was derived for column whois_b
On Mon, Oct 3, 2011 at 12:25 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Mon, Oct 3, 2011 at 11:16 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Yeah. custom_variable_classes is a pretty annoying wart, but if it's
set
Bruce Momjian br...@momjian.us writes:
Config-only directories seem to be only adding confusion. All possible
solutions seem to be adding more code and user requirements, which the
creation of symlinks avoids.
Is it time for me to ask on 'general' if removal of this feature is
warranted?
On Mon, Oct 3, 2011 at 04:20, Amit Khandekar
amit.khande...@enterprisedb.com wrote:
Is there a plan to commit this issue? I am still seeing this issue on
PG 9.1 STABLE branch. Attached is a small patch that targets only the
specific issue in the described testcase :
create or replace
On mån, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required to use pg_ctl, and for the longest time, it was
pg_ctl that was considered to be broken (for various other reasons) and
avoided in packaged
On Mon, Oct 3, 2011 at 7:07 PM, Peter Eisentraut pete...@gmx.net wrote:
On mån, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required to use pg_ctl,
You are if you wish to run as a service on
On Thu, Sep 29, 2011 at 6:24 AM, Kyotaro HORIGUCHI
horiguchi.kyot...@oss.ntt.co.jp wrote:
This is new version of make_greater_string patch.
According to the comments in the original source code, the purpose of
savelastchar is to avoid confusing pg_mbcliplen(). You've preserved
savelastchar only
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the person to opine on whether we
could get away with removing it.
The horse has well and truly bolted. We'd have a
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the person to opine on whether we
could get away with removing it.
The horse has well and
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Config-only directories seem to be only adding confusion. All possible
solutions seem to be adding more code and user requirements, which the
creation of symlinks avoids.
Is it time for me to ask on 'general' if removal of this
On 10/03/2011 02:15 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the person to opine on whether we
could get away with removing it.
Peter Eisentraut wrote:
On m?n, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required to use pg_ctl, and for the longest time, it was
pg_ctl that was considered to be broken (for various other
On Mon, Oct 3, 2011 at 7:15 PM, Bruce Momjian br...@momjian.us wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the person to opine on whether we
could get away
Andrew Dunstan wrote:
On 10/03/2011 02:15 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the person to opine on whether we
could get
On 10/03/2011 02:25 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 02:15 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start with, so I'm probably not the
* Tom Lane wrote:
Christian Ullrichch...@chrullrich.net writes:
I tried adding a not-null column in one step and got a collation
error for a different column.
itd= alter table livedata add column pricechanged timestamp not null default
current_timestamp;
ERROR: no collation was
Andrew Dunstan wrote:
On 10/03/2011 02:25 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 02:15 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the separate-config-directory design
to start
On Mon, Oct 3, 2011 at 20:39, Andrew Dunstan and...@dunslane.net wrote:
On 10/03/2011 02:25 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 02:15 PM, Bruce Momjian wrote:
Andrew Dunstan wrote:
On 10/03/2011 12:54 PM, Tom Lane wrote:
I was never exactly thrilled with the
On 22.09.2011 13:51, MUHAMMAD ASIF wrote:
You are right, _xpg_ socket functionality is not available in older systems, it
is available in hp-ux 11.23 version through patch HCO_35744 . HPUX 10.20 is
very old machine (1996). I am using latest HPUX B.11.31 machine, I don't have
access to older
Excerpts from Bruce Momjian's message of lun oct 03 15:23:47 -0300 2011:
Peter Eisentraut wrote:
On m?n, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required to use pg_ctl, and for the
Magnus Hagander wrote:
So, you are saying that people who want config-only directories are just
not people who normally use pg_ctl, because if they were, they would
have reported the bug? ?That seems unlikely. ?I will admit the Gentoo
case is exactly that.
As Dave has pointed out there
On Sun, Oct 2, 2011 at 8:21 AM, Simon Riggs si...@2ndquadrant.com wrote:
The problem is to find the replication delay, even when the system is quiet.
What I have proposed finds the replication delay more accurately even
than looking at the last commit, since often there are writes but no
Excerpts from Bruce Momjian's message of lun oct 03 16:03:47 -0300 2011:
I'm not sure how big the overlap is - would it be easier if you moved
the required functionality into pg_upgrade itself, as you mentioned at
some point? As in, would it be easier to fix the config-only directory
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 15:23:47 -0300 2011:
Peter Eisentraut wrote:
On m?n, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 16:03:47 -0300 2011:
I'm not sure how big the overlap is - would it be easier if you moved
the required functionality into pg_upgrade itself, as you mentioned at
some point? As in, would it be easier to fix the
David Fetter da...@fetter.org writes:
Perhaps it's best to document this usage and include the warning for
those less bright, as you term them. I'd be less tempted to call
them not bright and more tempted to think they might assume
PostgreSQL already takes care of cleaning this up, but
On Mon, Oct 3, 2011 at 3:09 PM, Bruce Momjian br...@momjian.us wrote:
Well, we are unlikely to backpatch that parse-and-report option so it
would be +2 years before it could be expected to work for even
single-major-version upgrades. That just seems unworkable. Yeah. :-(
I'd like to see the
Excerpts from Bruce Momjian's message of lun oct 03 16:09:08 -0300 2011:
Alvaro Herrera wrote:
My guess is that we could fix the simple case (the one that doesn't
involve a -o datadir option) with the parse-and-report option that has
been mentioned, and dictate that the other one doesn't
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 16:09:08 -0300 2011:
Alvaro Herrera wrote:
My guess is that we could fix the simple case (the one that doesn't
involve a -o datadir option) with the parse-and-report option that has
been mentioned, and
On Mon, Oct 3, 2011 at 21:55, Bruce Momjian br...@momjian.us wrote:
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 16:09:08 -0300 2011:
Alvaro Herrera wrote:
My guess is that we could fix the simple case (the one that doesn't
involve a -o datadir option)
Robert Haas wrote:
On Mon, Oct 3, 2011 at 3:09 PM, Bruce Momjian br...@momjian.us wrote:
Well, we are unlikely to backpatch that parse-and-report option so it
would be +2 years before it could be expected to work for even
single-major-version upgrades. ?That just seems unworkable. ?Yeah.
Magnus Hagander wrote:
Well, how does the server get from the config file to where the state
file is? Can we do it the same way, or even expose it to the tools
using a commandline parameter or something?
In that case (the Gentoo example), they use --data-directory
su -l postgres \
Excerpts from Bruce Momjian's message of lun oct 03 16:55:54 -0300 2011:
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 16:09:08 -0300 2011:
Alvaro Herrera wrote:
My guess is that we could fix the simple case (the one that doesn't
involve a -o
Alvaro Herrera wrote:
The problem is pg_ctl has to read server _state_ which cannot be put
in a configuration directory, and we don't even require the real data
directory to be recorded in the config file.
How so? It certainly is in postgresql.conf.
See my other email, e.g. -o
Excerpts from Bruce Momjian's message of lun oct 03 17:06:16 -0300 2011:
Magnus Hagander wrote:
Well, how does the server get from the config file to where the state
file is? Can we do it the same way, or even expose it to the tools
using a commandline parameter or something?
In that
On Mon, Oct 3, 2011 at 8:07 PM, Robert Haas robertmh...@gmail.com wrote:
Sorry, but I still don't really think it's fair to say that you've
proposed a solution to this problem. Or if you have, neither I nor
Fujii Masao understand that proposal well enough to decide whether we
like it.
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 17:06:16 -0300 2011:
Magnus Hagander wrote:
Well, how does the server get from the config file to where the state
file is? Can we do it the same way, or even expose it to the tools
using a commandline
On mån, 2011-10-03 at 19:11 +0100, Dave Page wrote:
On Mon, Oct 3, 2011 at 7:07 PM, Peter Eisentraut pete...@gmx.net wrote:
On mån, 2011-10-03 at 11:27 -0400, Bruce Momjian wrote:
Frankly, I am confused how this breakage has gone unreported for so
long.
Well, nobody is required to use
On Mon, Oct 3, 2011 at 3:59 PM, Bruce Momjian br...@momjian.us wrote:
pg_ctl would have to do some detective work to see if PG_VERSION existed
in that directory and adjust its behavior --- the pg_upgrade patch I
posted does this kind of detection. The goal is the change would happen
only for
Excerpts from Bruce Momjian's message of lun oct 03 17:28:53 -0300 2011:
Alvaro Herrera wrote:
Well, we have the Gentoo developer in this very thread. I'm sure they
would fix their command line if we gave them a pg_ctl that worked.
Surely the package that contains the init script also
On Mon, Oct 3, 2011 at 4:25 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Mon, Oct 3, 2011 at 8:07 PM, Robert Haas robertmh...@gmail.com wrote:
Sorry, but I still don't really think it's fair to say that you've
proposed a solution to this problem. Or if you have, neither I nor
Fujii Masao
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
Another compromise might be to allow for defining variable in any class
from the configuration files but restrict that to existing classes from
the SET command. Wait, that's exactly what happens as soon as there's
no explicit
On mån, 2011-10-03 at 15:09 -0400, Bruce Momjian wrote:
Why were people not using pg_ctl? Because of the limitations which
were fixed in PG 9.1? As Dave already said, windows already has to
use pg_ctl.
Historically, pg_ctl has had a lot of limitations. Just off the top of
my head,
Tom Lane t...@sss.pgh.pa.us writes:
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
Another compromise might be to allow for defining variable in any class
from the configuration files but restrict that to existing classes from
the SET command. Wait, that's exactly what happens as soon as
On 10/03/2011 04:41 PM, Peter Eisentraut wrote:
On mån, 2011-10-03 at 15:09 -0400, Bruce Momjian wrote:
Why were people not using pg_ctl? Because of the limitations which
were fixed in PG 9.1? As Dave already said, windows already has to
use pg_ctl.
Historically, pg_ctl has had a lot of
Dimitri Fontaine dimi...@2ndquadrant.fr writes:
Tom Lane t...@sss.pgh.pa.us writes:
No, because there are people who do intentionally use placeholder
variables as session-local storage, and that would be taking away
that capability.
Or do you want to open SET typo.wrogn TO 'foobar' to just
Andrew Dunstan wrote:
On 10/03/2011 04:41 PM, Peter Eisentraut wrote:
On m?n, 2011-10-03 at 15:09 -0400, Bruce Momjian wrote:
Why were people not using pg_ctl? Because of the limitations which
were fixed in PG 9.1? As Dave already said, windows already has to
use pg_ctl.
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 17:28:53 -0300 2011:
Alvaro Herrera wrote:
Well, we have the Gentoo developer in this very thread. I'm sure they
would fix their command line if we gave them a pg_ctl that worked.
Surely the package that
On Mon, Oct 3, 2011 at 7:10 PM, Andrew Dunstan and...@dunslane.net wrote:
Agreed. If you remove that, the logical problem goes away and it
becomes a simple problem of dumping the contents of postgresql.conf and
having pg_ctl (and pg_upgrade) use that. Let me look at how much code
that would
Andrew Dunstan wrote:
On 10/03/2011 06:45 PM, Bruce Momjian wrote:
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 17:28:53 -0300 2011:
Alvaro Herrera wrote:
Well, we have the Gentoo developer in this very thread. I'm sure they
would fix their command line
2011/10/3 Simon Riggs si...@2ndquadrant.com:
On Sun, Oct 2, 2011 at 11:45 PM, Dickson S. Guedes lis...@guedesoft.net
wrote:
I'm trying your patch, it was applied cleanly to master and compiled
ok. But since I started postgres I'm seeing a 99% of CPU usage:
Oh, thanks. I see what happened.
This is a subject that has come up recently, and I can think of a number
of use cases for it.
However, there are lots of wrinkles. For example, the names of objects
appear in LOTS of places, and making sure we caught them all might be
quite tricky. Say you have a table x that inherits a,b,
On 10/03/2011 06:45 PM, Bruce Momjian wrote:
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 17:28:53 -0300 2011:
Alvaro Herrera wrote:
Well, we have the Gentoo developer in this very thread. I'm sure they
would fix their command line if we gave them a pg_ctl that
On Mon, Oct 3, 2011 at 2:13 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Sep 29, 2011 at 6:24 AM, Kyotaro HORIGUCHI
horiguchi.kyot...@oss.ntt.co.jp wrote:
This is new version of make_greater_string patch.
According to the comments in the original source code, the purpose of
Bruce Momjian wrote:
Alvaro Herrera wrote:
Excerpts from Bruce Momjian's message of lun oct 03 17:28:53 -0300 2011:
Alvaro Herrera wrote:
Well, we have the Gentoo developer in this very thread. I'm sure they
would fix their command line if we gave them a pg_ctl that
On Mon, Oct 3, 2011 at 3:18 PM, senthilnathan senthilnatha...@gmail.com wrote:
Whether this feature is available in version 9.1.0. ??
Yes, it's available in 9.1.x.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Sent via pgsql-hackers
1 - 100 of 101 matches
Mail list logo