Mark Mielke wrote:
Where does the expectation come from? I don't recall ever reading it in
the documentation, and unless the session processes are contending over
the integers (using some sort of synchronization primitive) in memory
that represent the latest visible commit on every single
Heikki Linnakangas wrote:
Ned T. Crigler wrote:
It appears that the visibility map patch is causing pg_class.reltuples
to be
set improperly after a vacuum. For example, it is set to 0 if the map
indicated that no pages in the heap needed to be scanned.
Perhaps reltuples should not be updated
Hi All,
Following test returns error on 8.4 cvs head. it looks like an issue
Testcase: (8.4 CVS head)
CREATE OR REPLACE FUNCTION f007( a INTEGER,
b INTEGER DEFAULT 10 ) RETURNS INTEGER
AS $$
select 10;
$$ language sql;
CREATE OR REPLACE
Rushabh Lathia wrote:
Testcase: (8.4 CVS head)
CREATE OR REPLACE FUNCTION f007( a INTEGER,
b INTEGER DEFAULT 10 ) RETURNS INTEGER
AS $$
select 10;
$$ language sql;
CREATE OR REPLACE FUNCTION f007( a INTEGER DEFAULT 10,
b INTEGER
Hello
2008/12/15 Rushabh Lathia rushabh.lat...@gmail.com:
Hi All,
Following test returns error on 8.4 cvs head. it looks like an issue
Testcase: (8.4 CVS head)
CREATE OR REPLACE FUNCTION f007( a INTEGER,
b INTEGER DEFAULT 10 ) RETURNS INTEGER
AS $$
it's look well, but I still prefer some combination with =
name: = ''
name: = '''
:name = ''
$name = ..
$name = ..
I wonder about name := ''.
:= is used in Pascal/Ada to assign a value. Or would that again be an allowed
operator in pg ?
Andreas
--
Sent via pgsql-hackers mailing list
Hello, pgsql-hackers:
I want to debug one function in postgre backend.
for example, I want to debug the following function :
array_set(ArrayType *array,
int nSubscripts,
int *indx,
Datum dataValue,
bool isNull,
David Fetter da...@fetter.org writes:
Tom,
I know you've been busy with lots of stuff, so here's a little
reminder. I talked with a couple of people who know the back-end much
better than I do. One said the above was way under-specified, and the
other said he'd started work on it, but
Jaime Casanova jcasa...@systemguards.com.ec writes:
i'm seeing a fail in the rules regression, seems like it is not
ordering the results right even when the regression has an explicit
order by...
What locale is this running in?
regards, tom lane
--
Sent via
* Robert Haas robertmh...@gmail.com [081215 07:32]:
In fact, waiting for reply from standby server before acknowledging a commit
to the client is a bit pointless otherwise. It puts you in a strange
situation, where you're waiting for the commits in normal operation, but if
there's a
So you'd want all commits to wait until the transaction is safely replicated
in the standby. But if there's a network glitch, or the standby is
restarted, you're happy to reply to the client that it's committed if it's
only safely committed in the primary. Essentially, you wait for the reply
2008/12/15 Peter Eisentraut pete...@gmx.net:
Pavel Stehule wrote:
Because AS is signal for collecting column (or label) names.
I thing so we should use AS as Tom's proposal, together with SQL/XML
functionality.
Yes, please implement that.
I'll do it - it's better then nothing,
It's
On Sun, 2008-12-14 at 21:41 -0500, Robert Haas wrote:
If this is right, #2, #3, #4, and #6 feel similar except
that they're protecting against failures of different (but
still all incomplete) subsets of the hardware on the slave, right?
Right. Actually, the biggest difference with #6
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
i'm seeing a fail in the rules regression, seems like it is not
ordering the results right even when the regression has an explicit
order by...
What locale is this running
On Mon, Dec 15, 2008 at 7:24 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Here's an updated patch against head.
Thanks.
No problemo.
NOTE, it appears that this (and the previous) patch PANIC with
concurrent transaction log activity while database system is shutting
down on shutdown
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= j.urban...@students.mimuw.edu.pl writes:
Tom Lane wrote:
I came across this bit in ts_typanalyze.c:
/* We want statistic_target * 100 lexemes in the MCELEM array */
num_mcelem = stats-attr-attstattarget * 100;
I wonder whether the multiplier here
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What locale is this running in?
Seems this is Spanish_Spain.1252 and the encoding WIN1252
What it looks like is that the locale is intentionally sorting h after k
(or more
Jonah H. Harris wrote:
Alvaro, have you given up on the patch or are you just busy on
something else at the moment?
I've given up until we find a good way to handle hint bits. Various
schemes have been proposed but they all have more or less fatal flaws.
Agreed. Though, I don't want
On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What it looks like is that the locale is intentionally sorting h after k
(or more likely the rule is ch after ck). My Spanish is just about gone
... is that a sane behavior at all?
not at all... where can i check those
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What it looks like is that the locale is intentionally sorting h after k
(or more likely the rule is ch after ck). My Spanish is just about gone
... is that a sane behavior
David E. Wheeler wrote:
Perhaps not, but I have to say, looking at Robert's JSON example:
SELECT json(r.foo AS foo, r.bar AS bar, r.baz AS baz, r.bletch AS
quux) FROM rel r;
I would be pretty confused. It looks exactly like the proposed syntax
for named parameters. So while syntactically
Tom Lane wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What locale is this running in?
Seems this is Spanish_Spain.1252 and the encoding WIN1252
What it looks like is that the locale is intentionally
In fact, waiting for reply from standby server before acknowledging a commit
to the client is a bit pointless otherwise. It puts you in a strange
situation, where you're waiting for the commits in normal operation, but if
there's a network glitch or the standby goes down, you're willing to go
Zdenek Kotala zdenek.kot...@sun.com writes:
Following commit:
http://archives.postgresql.org/pgsql-committers/2008-12/msg00109.php
breaks several farms. Is it know issue?
Hmm. What I think is happening is that sometimes there's a pg_statistic
entry for a table that another process is in the
I wonder if we should switch to keeping reltuplesperpage instead. Then
a partial vacuum could update it by taking the average number of
tuples per page forbthe pages it saw. Perhaps adjusting it to the
weights average between the old value and the new value based on how
many pages were
On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Tom Lane wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What locale is this running in?
Seems this is Spanish_Spain.1252 and
On Sun, Dec 14, 2008 at 11:36:21AM -0500, Andrew Dunstan wrote:
See below
...
Thanks. The backtrace is kind of strange, but I might have found it. Could you
please update from CVS and re-run?
Thanks again.
Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes:
Greg Stark wrote:
I wonder if we should switch to keeping reltuplesperpage instead. Then a
partial vacuum could update it by taking the average number of tuples
per page forbthe pages it saw. Perhaps adjusting it to the weights
2008/12/15 Zeugswetter Andreas OSB sIT andreas.zeugswet...@s-itsolutions.at:
it's look well, but I still prefer some combination with =
name: = ''
name: = '''
:name = ''
$name = ..
$name = ..
I wonder about name := ''.
:= is used in Pascal/Ada to assign a value. Or would that again be
Jaime Casanova wrote:
On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
It was sane behavior a couple of decades ago -- dictionaries used to
sort like this (ch was considered an independent letter, and sorted
between c and d).
while 'ch' and 'll' are
Alvaro Herrera alvhe...@commandprompt.com writes:
Jaime Casanova wrote:
while 'ch' and 'll' are independent letters they sort as they were 'c'
and 'l'... that means that 'ch' should go before 'ck'
Interesting. So they are both wrong, glibc and teachers. We can file a
bug with glibc but I'm
On Mon, Dec 15, 2008 at 10:13 AM, Bruce Momjian br...@momjian.us wrote:
Jonah H. Harris wrote:
Alvaro, have you given up on the patch or are you just busy on
something else at the moment?
I've given up until we find a good way to handle hint bits. Various
schemes have been proposed but
Fujii-san,
Just repeating this in case you lost this comment:
On Mon, 2008-12-15 at 09:40 +, Simon Riggs wrote:
Fujii-san, please can we incorporate those two options, rather than just
one choice synchronous_replication = on. They look like two commonly
requested options.
I see the
Peter Eisentraut pete...@gmx.net writes:
Rushabh Lathia wrote:
I think this should not return error as the input args here is
timestamp... inputs?
In theory yes, but it's currently not that smart.
This is truly horrid. Was that patch *really* ready to commit?
I noticed some comments added
I wrote:
But I don't see this sorting behavior with glibc on Linux (Fedora 9 to
be exact, testing LC_COLLATE=es_ES.utf8).
BTW, I *do* see wieck wiech in es_ES locale on HPUX 10.20, released
~1996. So I think we have correctly identified the core issue, and the
only interesting question is why
On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, one thing you should try is
select 'wieck'::text 'wiech'::text;
select 'wieck'::text 'wiech'::text;
administra...@casanova10 ~/pg.build/8.4dev
$ bin/psql -a -f test.sql postgres
select 'wieck'::text
Jonah H. Harris jonah.har...@gmail.com writes:
On Mon, Dec 15, 2008 at 10:13 AM, Bruce Momjian br...@momjian.us wrote:
Feature freeze is not the time to be looking for new ideas. I suggest
we save this for 8.5.
Well, we may not need a new idea.
We don't really have an acceptable solution
Jonah H. Harris escribió:
Well, we may not need a new idea. Currently, the problem I see with
the checkpoint-at-shutdown looks like it could possibly be easily
solved. Though, there may be other issues I'm not familiar with. Has
anyone reviewed this yet?
I didn't investigate the shutdown
I wrote:
... But this type of problem has come
up before. I wonder if we shouldn't do what was previously discussed:
make has_table_privilege and related functions silently return FALSE,
instead of throwing error, when given a nonexistent OID.
On checking the archives, it seems most of the
On Mon, Dec 15, 2008 at 11:29 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Jonah H. Harris jonah.har...@gmail.com writes:
On Mon, Dec 15, 2008 at 10:13 AM, Bruce Momjian br...@momjian.us wrote:
Feature freeze is not the time to be looking for new ideas. I suggest
we save this for 8.5.
Well, we
On Sun, 2008-12-14 at 12:57 -0500, Mark Mielke wrote:
I'm curious about your suggestion to direct queries that need the
latest
snapshot to the 'primary'. I might have misunderstood it - but it
seems
that the expectation from some is that *all* sessions see the latest
snapshot, so would
Jonah H. Harris escribió:
On Mon, Dec 15, 2008 at 11:29 AM, Tom Lane t...@sss.pgh.pa.us wrote:
We don't really have an acceptable solution for the conflict with hint
bit behavior. The shutdown issue is minor, agreed, but that's not the
stumbling block.
Agreed on the shutdown issue.
On Dec 15, 2008, at 11:05 AM, Peter Eisentraut wrote:
In my mind, you just have to think about it hard enough to come to
realize that, when viewed from the right angle, the semantic
conflict might not exist after all. It's a bit tricky, but I think
it's possible.
Better for users not to
The attached patch contains a couple of fixes in the existing probes and
includes a few new ones.
- Fixed compilation errors on OS X for probes that use typedefs
- Fixed a number of probes to pass ForkNumber per the relation forks patch
- The new probes are those that were taken out from the
Simon Riggs wrote:
I am truly lost to understand why the *name* synchronous replication
causes so much discussion, yet nobody has discussed what they would
actually like the software to *do*
It's the color of the bikeshed ...
We can make the reply to a commit message when any of the
Robert Haas wrote:
In fact, waiting for reply from standby server before acknowledging a commit
to the client is a bit pointless otherwise. It puts you in a strange
situation, where you're waiting for the commits in normal operation, but if
there's a network glitch or the standby goes down,
It's a real promise. The reason you're getting hand-wavy answers is
because it's such a basic requirement that I'm trying to point out
just how fundamental a requirement it is.
If you want to see the actual code which guarantees this take a look
around the code for procarray - in
Hi,
i'm seeing a fail in the rules regression, seems like it is not
ordering the results right even when the regression has an explicit
order by...
i'm in a mingw32 5.1 on xp sp2 using msys 1.0.10 and gcc 3.4.2
attached the regression.diffs
please make me know if i can provide more info
--
Jonah H. Harris escribió:
On Sun, Dec 14, 2008 at 4:51 PM, Josh Berkus j...@agliodbs.com wrote:
v11 doesn't apply to cvs head anymore
I'm not currently working on this patch, sorry.
Should we pull it from 8.4, then?
Here's an updated patch against head.
Thanks.
NOTE, it appears
Greg Stark wrote:
I wonder if we should switch to keeping reltuplesperpage instead. Then a
partial vacuum could update it by taking the average number of tuples
per page forbthe pages it saw. Perhaps adjusting it to the weights
average between the old value and the new value based on how many
Pavel Stehule wrote:
Because AS is signal for collecting column (or label) names.
I thing so we should use AS as Tom's proposal, together with SQL/XML
functionality.
Yes, please implement that.
It's only idea: default behave is using as for param name specification,
seconf with flag maybe
On Mon, Dec 15, 2008 at 11:50 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
That only does heap hint bits, but it does nothing about pd_flags, the
btree flags (btpo_cycleid I think), and something else I don't recall at
the moment. This was all solvable however. The big problem with it
On Mon, Dec 15, 2008 at 11:38 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I wrote:
... But this type of problem has come
up before. I wonder if we shouldn't do what was previously discussed:
make has_table_privilege and related functions silently return FALSE,
instead of throwing error, when
On Mon, Dec 15, 2008 at 08:50:25AM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Tom,
I know you've been busy with lots of stuff, so here's a little
reminder. I talked with a couple of people who know the back-end
much better than I do. One said the above was way
Jonah H. Harris escribió:
It is pretty late in the process to continue with this design-related
discussion, but I really wanted to see it in 8.4.
Well, it's hard to blame anyone but me, because I started working on
this barely two weeks before the final commitfest IIRC.
--
Alvaro Herrera
On Monday 28 January 2008 05:37:03 Florian Weimer wrote:
* Robert Treat:
Note we've been using Theo's plperl bytea patch on one of our
production servers for some time; if anyone wants access to that
lmk.
I'm interested. Could you post a pointer to this code, please?
I had to do some
Alvaro Herrera alvhe...@commandprompt.com writes:
Jonah H. Harris escribió:
Now, in the case where hint bits have been updated and a WAL record is
required because the buffer is being flushed, requiring the WAL to be
flushed up to that point may be a killer on performance. Has anyone
tested
On Mon, 2008-12-15 at 10:13 -0500, Bruce Momjian wrote:
Jonah H. Harris wrote:
Alvaro, have you given up on the patch or are you just busy on
something else at the moment?
I've given up until we find a good way to handle hint bits. Various
schemes have been proposed but they all
On Mon, 15 Dec 2008, Greg Stark wrote:
I wonder if we should switch to keeping reltuplesperpage instead.
It would be preferrable to not touch the user side of reltuples if
possible, since it's the only instant way to get a good estimate of the
number of rows in a table right now. That's
Robert Haas robertmh...@gmail.com writes:
On Mon, Dec 15, 2008 at 11:38 AM, Tom Lane t...@sss.pgh.pa.us wrote:
So my proposal is to change the OID-accepting variants of
has_table_privilege and friends, as well as pg_table_is_visible and
friends, to silently return FALSE instead of failing when
Joshua D. Drake escribió:
If we can't fix the issue, then yeah let's rip it out but as it sits we
have a hurdle that needs to be overcome not a new feature that needs to
be implemented.
Ideas for solving the hurdle are welcome.
Agreed, shall we remove the replication and se postgres patches
Gregory Stark escribió:
Alvaro Herrera alvhe...@commandprompt.com writes:
Jonah H. Harris escribió:
Now, in the case where hint bits have been updated and a WAL record is
required because the buffer is being flushed, requiring the WAL to be
flushed up to that point may be a killer on
On Mon, 2008-12-15 at 14:29 -0300, Alvaro Herrera wrote:
Joshua D. Drake escribió:
If we can't fix the issue, then yeah let's rip it out but as it sits we
have a hurdle that needs to be overcome not a new feature that needs to
be implemented.
Ideas for solving the hurdle are welcome.
On Mon, Dec 15, 2008 at 12:30 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
How hard would it be to just take an exclusive lock on the page when setting
all these hint bits?
I guess it will be intolerably slow then. If we were to say we have
CRC now, but if you enable it you have 1%
Hackers,
We don't yet seem to have a clear specification for this feature, and
the Other Open Source DB has shown us how problematic it is to get
auto-partitioning wrong.
Should we defer auto-partitioning to 8.5?
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
On Mon, 2008-12-15 at 09:12 -0800, David Fetter wrote:
On Mon, Dec 15, 2008 at 08:50:25AM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Tom,
Since you're the one who brought this up, I think it's on you to
flesh it out at least a little bit, or at least to describe it
David Fetter da...@fetter.org writes:
On Mon, Dec 15, 2008 at 08:50:25AM -0500, Tom Lane wrote:
I'm sorry, but I have far too much work in front of me reviewing
patches that have a chance of getting into 8.4. I do not have time
to do pre-implementation research for a patch that doesn't.
You
Josh Berkus j...@agliodbs.com writes:
Hackers,
We don't yet seem to have a clear specification for this feature, and the
Other
Open Source DB has shown us how problematic it is to get auto-partitioning
wrong.
Should we defer auto-partitioning to 8.5?
If we're serious about having a next
On Mon, Dec 15, 2008 at 1:46 PM, Gregory Stark st...@enterprisedb.com wrote:
Josh Berkus j...@agliodbs.com writes:
Hackers,
We don't yet seem to have a clear specification for this feature, and the
Other
Open Source DB has shown us how problematic it is to get auto-partitioning
wrong.
Joshua D. Drake escribió:
On Mon, 2008-12-15 at 14:29 -0300, Alvaro Herrera wrote:
Joshua D. Drake escribió:
If we can't fix the issue, then yeah let's rip it out but as it sits we
have a hurdle that needs to be overcome not a new feature that needs to
be implemented.
Ideas for
Kurt Harriman harri...@acm.org wrote:
That's why I have instead offered some patches to enable C++
for new extensions and add-on development with minimal
impact to the C core.
I've been a bit confused by this thread. We wrote a couple PostgreSQL
functions (pdftotext and pdfisok) which use
Hello,
I ran into this problem recently:
https://projects.commandprompt.com/public/replicator/pastebin?show=f1288d4d8%0D
Of the functions the only one that will use constraint_exclusion is the
one that explicitly passes the date value. I kind of get why except for
the one that uses EXECUTE. As
Joshua D. Drake j...@commandprompt.com writes:
Of the functions the only one that will use constraint_exclusion is the
one that explicitly passes the date value.
Since you haven't shown us the constraints you're talking about, or the
resulting plans, it's difficult for anyone to guess what's
[ just realized that I set this message aside to reply to later, and
then forgot about it --- apologies ]
Kurt Harriman harri...@acm.org writes:
Tom Lane wrote:
There is no such option, and won't be.
Yours is the first comment anyone has posted to the list
regarding my proposed
On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
Of the functions the only one that will use constraint_exclusion is the
one that explicitly passes the date value.
Since you haven't shown us the constraints you're talking about, or the
On Mon, 2008-12-15 at 09:19 -0500, Robert Haas wrote:
I understand you're point, but I think there's still a use case. The
idea is that declaring the secondary dead is a rare event, and there's
some mechanism by which you're enabled to page your network staff, and
they hightail it into the
On Fri, Dec 12, 2008 at 7:55 AM, Peter Eisentraut pete...@gmx.net wrote:
Now I have a question about the FDW C interface. The way I understand it,
an SQL/MED-enabled server and a FDW each have a specific API by which they
communicate. Supposedly, each database vendor should be able to ship a
On Monday 15 December 2008 15:43:00 Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
Rushabh Lathia wrote:
I think this should not return error as the input args here is
timestamp... inputs?
In theory yes, but it's currently not that smart.
This is truly horrid. Was that
On Monday 15 December 2008 22:30:19 Jonah H. Harris wrote:
On Fri, Dec 12, 2008 at 7:55 AM, Peter Eisentraut pete...@gmx.net wrote:
Now I have a question about the FDW C interface. The way I understand
it, an SQL/MED-enabled server and a FDW each have a specific API by which
they
* Joshua D. Drake (j...@commandprompt.com) wrote:
On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
Of the functions the only one that will use constraint_exclusion is the
one that explicitly passes the date value.
Since you haven't
Peter Eisentraut wrote:
Simon Riggs wrote:
I am truly lost to understand why the *name* synchronous replication
causes so much discussion, yet nobody has discussed what they would
actually like the software to *do*
It's the color of the bikeshed ...
Hmmm. I thought this was pretty clear.
Martin Zaun wrote:
4. Issue: missing break in switch, silent override of '-l' argument?
This behaviour has been in there before and is not addresses by the
patch: The user-selected Win32 mklink command mode is never applied
due to a missing 'break' in CustomizableInitialize():
switch
Josh Berkus wrote:
Hmmm. I thought this was pretty clear. There's three levels of synch
which are useful features:
1) synchronus standby which is really asynchronous, but only has a gap
of 100ms.
2) Synchronous standby which guarentees that all committed transactions
are on the
Isn't the queryable read-only feature totally orthogonal with
how synchronous the replication is?
Yes. However, it introduces specific difficult issues which an
unreadable synchronous slave does not have.
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To
Tom Lane wrote:
I am, btw, still waiting for an actually plausible use-case for this.
AFAICS the setjmp-vs-exceptions thing puts a very serious crimp in
what you could hope to accomplish by importing a pile of C++ code.
The one use-case I can think of that imports a pile of C++ code
is the
Ron Mayer wrote:
Tom Lane wrote:
I am, btw, still waiting for an actually plausible use-case for this.
AFAICS the setjmp-vs-exceptions thing puts a very serious crimp in
what you could hope to accomplish by importing a pile of C++ code.
The one use-case I can think of that imports a pile of
On Mon, 2008-12-15 at 13:43 -0800, Josh Berkus wrote:
Isn't the queryable read-only feature totally orthogonal with
how synchronous the replication is?
Yes. However, it introduces specific difficult issues which an
unreadable synchronous slave does not have.
Don't think it's hugely
Simon,
I've explained this twice now on different parts of this thread. Could I
politely direct your attention to those posts?
Chill. I was just explaining that the *goal* of sync standby was not
complicated or really something to be argued about. It's pretty clear.
--Josh
--
Sent via
Bruce Momjian wrote:
Martin Zaun wrote:
4. Issue: missing break in switch, silent override of '-l' argument?
This behaviour has been in there before and is not addresses by the
patch: The user-selected Win32 mklink command mode is never applied
due to a missing 'break' in
Since this patch was rejected, I have added the attached documentation
to pg_standby to mention the sleep() we do.
---
Martin Zaun wrote:
Below my comments on the CommitFest patch:
pg_standby minor changes for
Forgive me if this is clear to everyone else, but regarding the new
replication options in 8.4:
Will existing PITR backup techniques work without modification?
Will existing techniques for warm standby with a custom script (not
using pg_standby) work without modification?
We will want to
On Mon, 2008-12-15 at 13:06 -0800, Josh Berkus wrote:
Peter Eisentraut wrote:
Simon Riggs wrote:
I am truly lost to understand why the *name* synchronous replication
causes so much discussion, yet nobody has discussed what they would
actually like the software to *do*
It's the color
Magnus Hagander wrote:
Bruce Momjian wrote:
Martin Zaun wrote:
4. Issue: missing break in switch, silent override of '-l' argument?
This behaviour has been in there before and is not addresses by the
patch: The user-selected Win32 mklink command mode is never applied
due to a missing
Tom Lane wrote:
Heikki Linnakangas hei...@enterprisedb.com writes:
Martin Zaun wrote:
With these avenues to be explored, can the pg_standby patch on the
CommitFest wiki be moved to the Returned with Feedback section?
Yes, I think we can conclude that we don't want this patch as it is.
Tom Lane wrote:
Hiroshi Inoue in...@tpf.co.jp writes:
Upper(), lower() or initcap() function truncates the result
under Japanese Windows with e.g. the server encoding=UTF-8
and the LC_CTYPE setting Japanese_japan.932 .
Hmm, I guess that makes sense, since the LC_CTYPE implies an encoding
On Mon, 2008-12-15 at 17:10 -0500, Bruce Momjian wrote:
Why no backpatch to 8.3? Seems like a clear bugfix to me.
I knew that was going to be asked.
8.3 is really where this is needed. 8.4 has almost no need of this.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training,
I have added this TODO item:
Rationalize the discrepancy between settings that use values in bytes
and SHOW that returns the object count
* http://archives.postgresql.org/pgsql-docs/2008-07/msg7.php
Sorry for the delay on this.
What I did was to mark the simple TODO items as done and add an
additional TODO item to list all sequence settings:
D o Have psql show current values for a sequence
o Have psql \ds show all sequences and their settings
*
laser wrote:
hi all,
I read the code that it seems easy for the cursor in plpgsql to return
ROW_COUNT after
MOVE LAST etc. The SPI_processed variable already there, but didn't put
it into estate
structure, any reason for that?
[ Sorry for the delay.]
Would some tests how Oracle
Would someone who understand pgcrypto please review this?
http://archives.postgresql.org/message-id/1216335149.11208.9.ca...@bloodnok.com
---
Marc Munro wrote:
-- Start of PGP signed section.
I am attaching a patch to
1 - 100 of 123 matches
Mail list logo