Kris Jurka <[EMAIL PROTECTED]> writes:
> On Mon, 9 Jul 2007, Tom Lane wrote:
>> Today's puzzler for the curious:
> It turns out that this failure was caused by pulling in pg's own printf
> implementation to the resulting ECPG program.
Hah! Nice detective work, Kris.
> Calling printf("%.*f\n",
On Mon, 9 Jul 2007, Tom Lane wrote:
Today's puzzler for the curious:
Last night the buildfarm reported two ECPG-Check failures
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=salamander&dt=2007-07-08%2017:30:00
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canary&dt=2007-07-08%2017:30:
Hi
After struggling with understanding xlog.c and friends far enough to
be able to refactor StartupXLOG to suit the needs of concurrent recovery,
I think I've finally reached a workable (but still a bit hacky) solution.
My design is centered around the idea of a bgreplay process that
takes over
Florian G. Pflug wrote:
Please disregard - I was confusing xlogid with xlog segments, so
most of my mail was nonsense.
I've fixed my problem by storing not the EndRecPtr, but rather
the ReadRecPtr, in shmem and rereading the last already applied
record in my bgreplay process. Then I can just us
Hi
When ReadRecord encounters an XLOG_SWITCH record, it does
EndRecPtr.xrecoff += XLogSegSize - 1;
EndRecPtr.xrecoff -= EndRecPtr.xrecoff % XLogSegSize;
which seems to set xrecoff to either 0 (if it was 0)
or to XLogSegSize (if it was > 0).
Note that xrecoff == XLogSegSize is kind of "denormaliz
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> Do we want something like this which provides a PQescapeByteaParam for
>> escaping bytea strings before passing them as text-mode parameters in
>> PQexecParam?
>
> Seems a lot easier and more efficient to just pa
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Unless you're doing muti-line regex, what's the point of a $ anywhere
> but the end of the expression? Am I missing something? Likewise with ^.
Leaving out the backslashes, you can do things like (foo$|baz|qux)(baz|qux|)
to say that all 9 combinations
On Mon, Jul 09, 2007 at 07:04:27PM +0100, Gregory Stark wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > Now, because we surround the pattern with ^...$ anyway, I can't offhand
> > see a use-case for putting $ with its regexp meaning into the pattern.
>
> It's possible to still usefully use
Gregory Stark <[EMAIL PROTECTED]> writes:
> Incidentally, are these really regexps? I always thought they were globs.
They're regexps under the hood, but we treat . as a schema separator
and translate * to .*, which makes it look like mostly a glob scheme.
But you can make use of brackets, |, +,
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Now, because we surround the pattern with ^...$ anyway, I can't offhand
> see a use-case for putting $ with its regexp meaning into the pattern.
It's possible to still usefully use $ in the regexp, but it's existence at the
end means there should always be
>>> On Mon, Jul 9, 2007 at 11:36 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000=
>> C00DA" from archive
>> [2007-07-07 18:24:28.051 CDT] 5962 L
On Mon, 2007-07-09 at 12:36 -0400, Tom Lane wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
> > [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000=
> > C00DA" from archive
> > [2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file "0001000=
> > C00
An example being discussed on the jdbc list led me to try this:
regression=# create table a$b$c (f1 int);
CREATE TABLE
regression=# \d a$b$c
Did not find any relation named "a$b$c".
It works if you use quotes:
regression=# \d "a$b$c"
Table "public.a$b$c"
Column | Type | Modifiers
--
>>> On Mon, Jul 9, 2007 at 10:54 AM, in message
<[EMAIL PROTECTED]>, "Kevin Grittner"
<[EMAIL PROTECTED]> wrote:
> We're running a number of warm standby instances on one server. One of them
> stalled on Saturday. When I found that this morning, I confirmed that the
> files were in the directo
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> [2007-07-07 18:24:27.692 CDT] 5962 LOG: restored log file "0001000=
> C00DA" from archive
> [2007-07-07 18:24:28.051 CDT] 5962 LOG: restored log file "0001000=
> C00DB" from archive
> [2007-07-09 08:21:50.200 CDT] 5904 LOG: r
On Wed, Jul 04, 2007 at 01:03:20PM +0200, Dawid Kuroczko wrote:
> Hello.
>
> I think it could be a nice idea to put descriptions from
> http://www.postgresql.org/docs/8.2/static/catalogs.html
> into system catalogs itself. I.e., make a bunch of
>
> COMMENT ON COLUMN pg_class.relname
>IS 'Nam
We're running a number of warm standby instances on one server. One of them
stalled on Saturday. When I found that this morning, I confirmed that the
files were in the directory from which it should be pulling the WAL files. The
logs showed normal processing up to the stall, with no messages
Today's puzzler for the curious:
Last night the buildfarm reported two ECPG-Check failures
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=salamander&dt=2007-07-08%2017:30:00
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canary&dt=2007-07-08%2017:30:01
which promptly went away again. Judg
On Jul 9, 2007, at 12:24 PM, Marko Kreen wrote:
On 7/9/07, Hans-Juergen Schoenig <[EMAIL PROTECTED]> wrote:
does anybody remember why threaded python is not allowed on some
flavors of BSD?
AFAIR the problem is they use separate libc for threaded things,
and main postgres is (and will be) li
On 7/9/07, Hans-Juergen Schoenig <[EMAIL PROTECTED]> wrote:
does anybody remember why threaded python is not allowed on some flavors of BSD?
AFAIR the problem is they use separate libc for threaded things,
and main postgres is (and will be) linked with non-threaded libc.
--
marko
hello all ...
does anybody remember why threaded python is not allowed on some
flavors of BSD?
i was surprised to read this in the configure script ...
# threaded python is not supported on bsd's
echo "$as_me:$LINENO: checking whether Python is compiled with thread
support" >&5
echo $ECHO_N
rupesh bajaj wrote:
We are currently generating the patch and are ready to discuss about all
issues in the hackers list. Since this process will take some time, is it
permissible for us to release our version on our institute <
http://dsl.serc.iisc.ernet.in > website?
Yes, sure.
You should rea
Hi,
We are currently generating the patch and are ready to discuss about all
issues in the hackers list. Since this process will take some time, is it
permissible for us to release our version on our institute <
http://dsl.serc.iisc.ernet.in > website?
Thanks and Regards,
Rupesh & Sharat
On 7/8/
On Fri, 2007-07-06 at 15:43 +0900, Tatsuo Ishii wrote:
> I'm wondering if a tsearch's configuration is bound to a language or
> an encoding. If it's bound to a language, there's a serious design
> problem, I would think. An encoding or charset is not necessarily
> bound to single language. We can
On Fri, 2007-07-06 at 10:55 +0100, Heikki Linnakangas wrote:
> We need to get the requirements straight.
>
> One goal of bgwriter is clearly to keep just enough buffers clean in
> front of the clock hand so that backends don't need to do writes
> themselves until the next bgwriter iteration. Bu
On Thu, 2007-07-05 at 21:50 +0100, Heikki Linnakangas wrote:
> All test runs were also patched to count the # of buffer allocations,
> and # of buffer flushes performed by bgwriter and backends. Here's those
> results (I hope the intendation gets through properly):
>
> imo
26 matches
Mail list logo
