On Wed, Oct 13, 2010 at 2:43 AM, Heikki Linnakangas
wrote:
> On 13.10.2010 08:21, Fujii Masao wrote:
>>
>> On Sat, Oct 9, 2010 at 4:31 AM, Heikki Linnakangas
>> wrote:
>>>
>>> It shouldn't be too hard to fix. Walsender needs to be able to read WAL
>>> from
>>> preceding timelines, like recovery
On 13.10.2010 08:21, Fujii Masao wrote:
On Sat, Oct 9, 2010 at 4:31 AM, Heikki Linnakangas
wrote:
It shouldn't be too hard to fix. Walsender needs to be able to read WAL from
preceding timelines, like recovery does, and walreceiver needs to write the
incoming WAL to the right file.
And walse
2010/10/12 KaiGai Kohei :
> I noticed the previous patch has an obvious conflict to the latest
> git mater, and it does not have any documentation updates.
>
> So, I rebased the patch, and added descriptions about secure views.
> Rest of parts are unchanged.
It seems that we have rough agreement t
2010/8/24 KaiGai Kohei :
> I tried to revise the patch. It allows plugins to get control next to
> client authentication, but before returning the status to users.
>
> This change enables plugins which should be invoked on authentication
> failed to utilize this hook, not only assignment of session
On Fri, Oct 1, 2010 at 7:12 AM, Andrew Dunstan wrote:
> On 10/01/2010 04:35 AM, Dean Rasheed wrote:
>>
>> 2). In enum_ccmp(), when you cache the full list of elements, you're
>> not updating mycache->sort_list_length, so it will keep fetching the
>> full list each time. Also, I think that function
On Fri, Oct 8, 2010 at 12:51 PM, Alexander Korotkov
wrote:
> Sorry, I'm pretty unconversant in git. Now, it should be ok.
I spent some time hacking on this. It doesn't appear to be too easy
to get levenshtein_less_equal() working without slowing down plain old
levenshtein() by about 6%. The slo
>> wrote:
>> > Excerpts from Jim Nasby's message of jue jun 10 17:54:43 -0400 2010:
>> >> test...@workbook=# select has_table_privilege( 'public', 'test', 'SELECT'
>> >> );
>> >> ERROR: role "public" does not exist
>> >
>> > Here's a patch implementing this idea.
I applied it almost as-is, exce
On Sat, Oct 9, 2010 at 4:31 AM, Heikki Linnakangas
wrote:
>> Yes. But if there is no unsent WAL when the master goes down,
>> we can start new standby without new backup by copying the
>> timeline history file from new master to new standby and
>> setting recovery_target_timeline to 'latest'.
>
>
On Sat, Oct 9, 2010 at 1:41 AM, Josh Berkus wrote:
>
>> And, I'd like to know whether the master waits forever because of the
>> standby failure in other solutions such as Oracle DataGuard, MySQL
>> semi-synchronous replication.
>
> MySQL used to be fond of simiply failing sliently. Not sure what
On Sat, Oct 9, 2010 at 12:12 AM, Markus Wanner wrote:
> On 10/08/2010 04:48 PM, Fujii Masao wrote:
>> I believe many systems require write-availability.
>
> Sure. Make sure you have enough standbies to fail over to.
Unfortunately even enough standbys don't increase write-availability
unless you c
Robert Haas wrote:
> On Tue, Sep 28, 2010 at 3:57 AM, Shigeru HANADA
> wrote:
> > On Mon, 27 Sep 2010 21:07:33 -0400
> > Robert Haas wrote:
> >> I found and fixed a few more issues and committed this. ?The pg_dump
> >> support had a few escaping bugs, and I added tab completion support
> >> for p
Excerpts from Itagaki Takahiro's message of mar oct 12 23:05:36 -0300 2010:
> Hi,
>
> On Tue, Sep 7, 2010 at 6:16 AM, Alvaro Herrera
> wrote:
> > Excerpts from Jim Nasby's message of jue jun 10 17:54:43 -0400 2010:
> >> test...@workbook=# select has_table_privilege( 'public', 'test', 'SELECT'
>
On Tue, 2010-10-12 at 19:31 -0400, Tom Lane wrote:
> This seems much of a piece with the existing proposal to allow
> individual "words" of a URL to be reported separately:
> https://commitfest.postgresql.org/action/patch_view?id=378
>
> As I said in that thread, this could be done in a backwards
On Tue, Oct 12, 2010 at 10:05 PM, Itagaki Takahiro
wrote:
> BTW, does the patch need to be back-patched to older versions?
> Since they use get_roleid_checked() instead of get_role_oid(), the fix
> cannot be applied cleanly to them, though it will be similar codes.
I would interpret this a a feat
Hi,
On Tue, Sep 7, 2010 at 6:16 AM, Alvaro Herrera
wrote:
> Excerpts from Jim Nasby's message of jue jun 10 17:54:43 -0400 2010:
>> test...@workbook=# select has_table_privilege( 'public', 'test', 'SELECT' );
>> ERROR: role "public" does not exist
>
> Here's a patch implementing this idea.
It s
(2010/10/12 23:09), Robert Haas wrote:
> On Tue, Oct 12, 2010 at 9:20 AM, KaiGai Kohei wrote:
>> As I introduced before, the idea of two hooks makes obvious where
>> we should put the security hooks; it is next to the existing DAC
>> checking. It is the best guideline, even if we will touch the co
Richard Broersma wrote:
On Tue, Oct 12, 2010 at 3:54 PM, Josh Berkus wrote:
Oh. Now that's an interesting perspective ... you're suggesting that we
take the comments and apply them as COMMENTS on the specific pg_settings?
On a side note regarding comments, I'd like to make a request for a
mo
Josh Berkus wrote first:
Postgres has "COMMENT ON ..." SQL for various database objects and I
assumed that said comments would be stored in the system catalog.
Oh. Now that's an interesting perspective ... you're suggesting that we
take the comments and apply them as COMMENTS on the specific p
Marko Tiikkaja writes:
> On 2010-10-13 2:10 AM +0300, Tom Lane wrote:
>> BTW, this patch seems to be also the time to remove the AtStart_Cache()
>> call in CommandCounterIncrement, as foreseen in the comment there.
> Frankly, I have no idea what to do about this.
Just delete the call. The only
Josh Berkus writes:
>> Postgres has "COMMENT ON ..." SQL for various database objects and I
>> assumed that said comments would be stored in the system catalog.
> Oh. Now that's an interesting perspective ... you're suggesting that we
> take the comments and apply them as COMMENTS on the specifi
On 2010-10-13 2:10 AM +0300, Tom Lane wrote:
Marko Tiikkaja writes:
That's actually just my ignorance I forgot to mention. As I understand
it, our code currently first pushes one snapshot and then does multiple
PushActiveSnapshot (or PushUpdatedSnapshot)/PopActiveSnapshot rounds
before popping
Bruce Momjian writes:
> [ sent to hackers where it belongs ]
> Thom Brown wrote:
>> It could be me being picky, but I don't regard parameters or page
>> fragments as part of the URL path.
> Wow, that is a tough one. One the one hand, it seems nice to be able to
> split stuff out more, but on the
Marko Tiikkaja writes:
> On 2010-10-13 1:21 AM +0300, Tom Lane wrote:
>> I started looking at this patch, and I'm wondering why you inserted all
>> the Register/UnregisterSnapshot calls that weren't there before
> That's actually just my ignorance I forgot to mention. As I understand
> it, our
On Tue, Oct 12, 2010 at 3:54 PM, Josh Berkus wrote:
> Oh. Now that's an interesting perspective ... you're suggesting that we
> take the comments and apply them as COMMENTS on the specific pg_settings?
On a side note regarding comments, I'd like to make a request for a
more comprehensive commen
> Postgres has "COMMENT ON ..." SQL for various database objects and I
> assumed that said comments would be stored in the system catalog.
Oh. Now that's an interesting perspective ... you're suggesting that we
take the comments and apply them as COMMENTS on the specific pg_settings?
That would
On 2010-10-13 1:21 AM +0300, Tom Lane wrote:
Marko Tiikkaja writes:
Here's a new version of the patch, deprecating pg_parse_and_rewrite.
I started looking at this patch, and I'm wondering why you inserted all
the Register/UnregisterSnapshot calls that weren't there before (eg, why
did spi.c h
Josh Berkus wrote:
The fact that Postgres already
explicitly supports comment metadata in its system catalog means it must
already know something about this.
We support what?
Postgres has "COMMENT ON ..." SQL for various database objects and I assumed
that said comments would be stored in t
Marko Tiikkaja writes:
> Here's a new version of the patch, deprecating pg_parse_and_rewrite.
I started looking at this patch, and I'm wondering why you inserted all
the Register/UnregisterSnapshot calls that weren't there before (eg, why
did spi.c have to change at all?). ISTM either these are
[ sent to hackers where it belongs ]
Thom Brown wrote:
> Hi,
>
> I noticed that if I run this:
>
> SELECT alias, description, token FROM
> ts_debug('http://www.postgresql.org:2345/directory/page.html?version=9.1&build=alpha1#summary');
>
> I get:
>
> alias | description |
Darren, All,
> All you would need is for the file parser to retain the
> comments as metadata, include them in the relations that the SQL
> commands see where the latter can also edit them as data, and then write
> out the updated file with comments.
"All you need to do" in order to trisect and a
Darren Duncan wrote:
> why is it not possible to retain the single existing postgres.conf
> file format (human writable) *and* have it machine/SQL-editable
> *and* maintain the comments?
My recollection of the previous discussion wasn't that there was no
way to do it, but rather that each pers
Dimitri Fontaine wrote:
Andrew Dunstan writes:
On 10/12/2010 05:02 PM, Dimitri Fontaine wrote:
So, what you do is have a file per GUC, file name is the GUC name, first
line contains *ONLY* current value, the rest of the file is comments.
You're joking, right?
No. I just want both comments
Andrew Dunstan writes:
> On 10/12/2010 05:02 PM, Dimitri Fontaine wrote:
>> So, what you do is have a file per GUC, file name is the GUC name, first
>> line contains *ONLY* current value, the rest of the file is comments.
>
> You're joking, right?
No. I just want both comments and SQL commands.
On 10/12/2010 05:02 PM, Dimitri Fontaine wrote:
So, what you do is have a file per GUC, file name is the GUC name, first
line contains *ONLY* current value, the rest of the file is comments.
You're joking, right?
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgre
On 10/12/2010 03:57 PM, Magnus Hagander wrote:
There's a simpler solution which I have just tested. Instead of patching,
use the Pg driver instead of SQLite. Set the dbname to %m. If the database
doesn't exist the cvs checkout will fail. So we just set up databases for
the modules we want to ex
Peter Eisentraut writes:
>> Hopefully final patch, which addresses the above issues, adds some
>> documentation enhancements, and the possibility to quote host names (in
>> case someone wants to have a host named "samehost").
Oh, I had an idea for a small improvement to this. It doesn't seem
unl
Robert Haas writes:
> That's probably not going to happen until we have a way to update
> postgresql.conf via SQL. Which, I maintain, as I have maintained
> before, is not going to happen until we get rid of the comments,
> because otherwise absolutely any implementation anyone proposes will
> ge
On Tue, Oct 12, 2010 at 10:05:57PM +0200, Dimitri Fontaine wrote:
> Alvaro Herrera writes:
> > As a note, I've had luck finding bootstrap-time bugs by manually
> > feeding the bootstrapping commands into bootstrap mode, with a
> > leftover dir from "initdb --noclean". This has helped a few times
Peter Eisentraut writes:
> Hopefully final patch, which addresses the above issues, adds some
> documentation enhancements, and the possibility to quote host names (in
> case someone wants to have a host named "samehost").
A few minor gripes:
> + If a host name is specified (anything that
Alvaro Herrera writes:
> As a note, I've had luck finding bootstrap-time bugs by manually feeding
> the bootstrapping commands into bootstrap mode, with a leftover dir from
> "initdb --noclean". This has helped a few times that there has been no
> PANIC but just a FATAL or ERROR, for example. It
On Fri, Oct 8, 2010 at 08:09, Magnus Hagander wrote:
> On Fri, Oct 8, 2010 at 03:52, Andrew Dunstan wrote:
>>
>>
>> On 10/07/2010 03:37 PM, Magnus Hagander wrote:
>>>
>>> On Thu, Oct 7, 2010 at 21:31, Andrew Dunstan wrote:
On 10/07/2010 10:11 AM, Magnus Hagander wrote:
>><
>> O
David Fetter writes:
> On Mon, Oct 11, 2010 at 04:14:04PM +0530, Vaibhav Kaushal wrote:
>> Is there something like that in Kdevelop? I dont use CLI editors much.
>
> KDevelop is listed as one of the editors that support ctags.
I've just developed some code for the backend and used cscope (from
E
David Fetter writes:
> Let's imagine you have a connection pooler with two clients, A and B.
> A calls setQueryTimeout, then starts a query, which terminates in
> time, but dies before handling it. B connects to the pool, gets A's
> connection, and finds a statement_timeout that's not the default
I would like to hear what people think of my observations about the
design of contrib/isn. In particular, I'd like Jan Otto to contribute
- he probably has more domain knowledge than I do. I haven't heard
from Jan about the proposed regression test.
In producing this patch, did you work off the li
On Tue, Oct 12, 2010 at 17:55, David Fetter wrote:
> On Tue, Oct 12, 2010 at 10:37:00AM -0500, Kevin Grittner wrote:
>> David Fetter wrote:
>> > Is there something incomplete about the ones I sent, and if so,
>> > what?
>>
>> Well, I'm still curious why it was necessary to modify the server
>> si
On fre, 2010-10-08 at 11:19 -0400, Tom Lane wrote:
> Was this just a thinko in our transcription, or did they rename the
> view columns somewhere along the line?
I suppose you figured this out already, but in some of my older draft
copies, the column did indeed have a different name. The other co
On tis, 2010-10-12 at 10:11 +0900, KaiGai Kohei wrote:
> Is it really necessary to check reverse dns entries?
This has been extensively discussed in this thread.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On mån, 2010-10-11 at 21:34 +0300, Peter Eisentraut wrote:
> > * Why getnameinfo() in the fallback loop?
>
> I checked through my git history; this was actually a leftover from
> some
> debugging code. I'll remove it.
>
> > * Slash ('/') after the hostname
> >
> > At the parse_hba_line(), the p
David Fetter wrote:
> Let's imagine you have a connection pooler with two clients,
> A and B.
I'm with you so far.
> A calls setQueryTimeout, then starts a query, which terminates in
> time, but dies before handling it.
Here you lost me. I don't know what that means.
> B connects to the
On Tue, Oct 12, 2010 at 10:37:00AM -0500, Kevin Grittner wrote:
> David Fetter wrote:
> > Is there something incomplete about the ones I sent, and if so,
> > what?
>
> Well, I'm still curious why it was necessary to modify the server
> side to implement an interface feature for which everything
David Fetter wrote:
> Is there something incomplete about the ones I sent, and if so,
> what?
Well, I'm still curious why it was necessary to modify the server
side to implement an interface feature for which everything needed
seems to be present on the client side. Is this intended to be
use
Excerpts from Dimitri Fontaine's message of dom oct 10 17:38:01 -0300 2010:
> Hi,
>
> So I'm beginning to work on the extension support for dump and restore,
> and that begins with a new pg_extension catalog. I managed to break
> initdb already, of course, but I'm fighting my way out — no luck wit
On Tue, Oct 12, 2010 at 04:04:56AM -0500, Radosław Smogura wrote:
> On Mon, 11 Oct 2010 08:29:16 -0500, "Kevin Grittner"
> wrote:
> > David Fetter wrote:
> >
> >> Please find enclosed a WIP patch from one of my co-workers
> >> intended to support JDBC's setQueryTimeout, along with the patch
> >
On Tue, Oct 12, 2010 at 9:20 AM, KaiGai Kohei wrote:
> As I introduced before, the idea of two hooks makes obvious where
> we should put the security hooks; it is next to the existing DAC
> checking. It is the best guideline, even if we will touch the code
> around object creation in the future ve
On Tue, 2010-10-12 at 09:36 -0400, Tom Lane wrote:
>
> I think docdir is separate from the regular prefix. Try specifying
> --docdir to configure.
Thanks, I'll test (not now, but soon).
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repos
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes:
> On Mon, 2010-10-11 at 13:30 -0400, Tom Lane wrote:
>> What does "pg_config --docdir" report?
> $ /usr/pgsql-9.0/bin/pg_config --docdir
> /usr/share/doc/pgsql
> I was expecting it to be somewhere in /usr/pgsql-9.0, where it is the
> --prefix. Am I wron
On Sat, Oct 9, 2010 at 11:13 AM, Brendan Jurd wrote:
> I understand that 'replication' is a keyword as far as the database
> name is concerned, but I was surprised to find that it was treated as
> a keyword in the username field also. I had a look in
> src/backend/libpq/hba.c, and next_token() ap
(2010/10/12 20:59), Robert Haas wrote:
2010/10/11 KaiGai Kohei:
It enables us to put security hooks independent from MVCC visibility of
the new database object. If we pay attention for visibility of new database
object, it seems to me amount of things to understand and maintain will be
increased
On Sat, Oct 9, 2010 at 10:04 AM, Brendan Jurd wrote:
> Hi folks,
>
> I have just set up HS+SR for the first time, and for the most part,
> the docs were excellent. The one exception for me was the discussion
> of archive_cleanup_command. This is a pretty important part of
> constructing a health
2010/10/11 KaiGai Kohei :
> It enables us to put security hooks independent from MVCC visibility of
> the new database object. If we pay attention for visibility of new database
> object, it seems to me amount of things to understand and maintain will be
> increased, although MVCC visibility is fun
2010/10/12 Hitoshi Harada :
> 2010/10/12 Pavel Stehule :
>> Hello
>>
>> 2010/10/11 Greg Stark :
>>> On Sun, Oct 10, 2010 at 2:16 PM, Tom Lane wrote:
It was pointed out upthread that while median isn't presently
in the standard, Oracle defines it in terms of percentile_cont(0.5)
whic
On Mon, 11 Oct 2010 08:29:16 -0500, "Kevin Grittner"
wrote:
> David Fetter wrote:
>
>> Please find enclosed a WIP patch from one of my co-workers
>> intended to support JDBC's setQueryTimeout, along with the patch
>> for JDBC that uses it.
>
> I agree that it would be very nice to support thi
On Mon, 2010-10-11 at 13:30 -0400, Tom Lane wrote:
> What does "pg_config --docdir" report?
$ /usr/pgsql-9.0/bin/pg_config --docdir
/usr/share/doc/pgsql
I was expecting it to be somewhere in /usr/pgsql-9.0, where it is the
--prefix. Am I wrong?
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Con
63 matches
Mail list logo
