"Tom Lane" <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> When we checkpoint we write out all dirty buffers. But ISTM we don't really
>> need to write out buffers which are dirty but which have an LSN older than
>> the
>> previous checkpoint. Those represent buffers wh
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 pass out-of-line bytea
parameters as binary mode.
Tom Lane wrote:
> No, it's orthogonal to whether we want a "quit" command. (My opinion is
> not, because what the heck will we do with it in multiuser mode? And
> there is no good way to shoehorn it into just the single-user mode, it'd
> have to be a grammar entry.)
Hmm, I was thinking that we
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Sure, but those who do know how to SIGQUIT might reach for that before
>> they reach for control-D. There's hardly anyone out there who could
>> be called an experienced user of the standalone mode, I think, and so
>> we shouldn't ass
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> At least on my machine there doesn't seem to be a defined way to
> >> generate SIGTERM from the terminal; so I can see where if someone hasn't
> >> read the postgres man page carefully, their first instinct upon f
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> At least on my machine there doesn't seem to be a defined way to
>> generate SIGTERM from the terminal; so I can see where if someone hasn't
>> read the postgres man page carefully, their first instinct upon finding
>> that control-C d
Tom Lane wrote:
> "Leon Mergen" <[EMAIL PROTECTED]> writes:
> > On 7/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> It's actually not that easy to get out of the single-user mode without
> >> it doing a checkpoint. I suppose you must have either SIGQUIT or
> >> SIGKILL'd it. While there's nothing
Hi Tom,
I only have one remark really, which I first thought of after sending
the report.
If you were to use the result for subtracting from the first value,
instead of adding to the second, the conditions are reversed. It's
not really as obvious as I first thought whether there's 2 months
Pelle Johansson <[EMAIL PROTECTED]> writes:
> If you were to use the result for subtracting from the first value,
> instead of adding to the second, the conditions are reversed. It's
> not really as obvious as I first thought whether there's 2 months and
> 29 days or 2 months and 30 days betw
* Tom Lane ([EMAIL PROTECTED]) wrote:
> As of today there are two new functions exported by libpq.so since
> 8.2 (lo_truncate and PQconnectionUsedPassword). Currently,
> libpq/Makefile sets the major.minor shlib version to 5.1 as compared
> to 5.0 in PG 8.2. Should it be 6.0? I seem to recall pe
"Pelle Johansson" <[EMAIL PROTECTED]> writes:
> The age() function seem to work by first counting months until less than a
> month remains to to the second argument, then counting days left. This
> doesn't give the correct result, as shown by this example:
> # select column1, age(column1, '2006-11
As of today there are two new functions exported by libpq.so since
8.2 (lo_truncate and PQconnectionUsedPassword). Currently,
libpq/Makefile sets the major.minor shlib version to 5.1 as compared
to 5.0 in PG 8.2. Should it be 6.0? I seem to recall people
chastizing us for not bumping the major v
"Leon Mergen" <[EMAIL PROTECTED]> writes:
> On 7/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> It's actually not that easy to get out of the single-user mode without
>> it doing a checkpoint. I suppose you must have either SIGQUIT or
>> SIGKILL'd it. While there's nothing we can do about SIGKILL,
"Leon Mergen" <[EMAIL PROTECTED]> writes:
>> Perhaps you are not shutting down the standalone mode cleanly after
>> the vacuum?
> Okay, that was obviously it -- I didn't realize I needed to send a
> crtl+D signal to the server when in single user mode to shut it down,
> and figured that any uncomm
rupesh bajaj wrote:
I am mailing on behalf of the Database Systems Lab, Indian Institute of
Science(IISc), Bangalore, India. We have implemented three new operators
internal to the PostgreSQL 8.1.2 engine in order to support queries on
multilingual data(english and hindi as of now). It can be ext
15 matches
Mail list logo
