--On 7. Oktober 2015 02:33:59 -0700 Peter Geoghegan
wrote:
>
> At the risk of getting flamed: I think that this is a bug in
> PostgreSQL, not CentOS. I've said why I think that is at least once
> already [1]. Simply put, there is no justification for the belief that
> some people have that colla
The last day we've encountered an issue what i think is somewhat severe if
you want to do either OS upgrades with CentOS or even binary upgrades with
an existing PostgreSQL instance to a new machine with locale de_DE.UTF-8
and thus i'd like to share here.
Here are the details:
Originally a Postg
--On 29. Dezember 2014 12:55:11 -0500 Tom Lane wrote:
Given the lack of previous complaints, this probably isn't backpatching
material, but it sure seems like a bit of attention to consistency
would be warranted here.
Now that i read it i remember a client complaining about this some time
--On 4. November 2014 17:18:14 -0500 Tom Lane wrote:
Yeah, and I think that it's entirely reasonable for rewriting ALTER TABLEs
to update the xmin of the rewritten tuples; after all, the output data
could be arbitrarily different from what the previous transactions put
into the table. But th
--On 3. November 2014 18:15:04 +0100 Sven Wegener
wrote:
I've check git master and 9.x and all show the same behaviour. I came up
with the patch below, which is against curent git master. The patch
modifies the COPY TO code to create a new snapshot, after acquiring the
necessary locks on th
--On Dienstag, Juli 08, 2008 15:12:44 +0200 "Leif B. Kristensen"
<[EMAIL PROTECTED]> wrote:
Is this the case on both Windows and Linux? - that psql uses more for
paging, as opposed to doing it itself?
It uses "less" on Linux.
Seems to me that less is the default on cygwin, only. For others
--On Dienstag, Juli 08, 2008 21:46:53 +1000 Long Cui
<[EMAIL PROTECTED]> wrote:
I installed Postgresql 8.3.3 in windows XP, try to input some commands in
windows command prompt. The create, update and insert command work all
right, just select command.got the error message: "more" is not inte
--On Freitag, Juli 04, 2008 11:26:31 +0100 Richard Huxton
<[EMAIL PROTECTED]> wrote:
You ask for a particular index, it creates the index. Why complicate the
code checking for possible duplicate indexes if it's not a problem people
tend to encounter?
And what would characterize a "duplicate"
On Tue, 06 Feb 2007 21:28:49 +0100, Tomas Vondra <[EMAIL PROTECTED]> wrote:
>
> We're using sequence to generate the sessions(id) value, but that should
> not be a problem - with the structure / rules everything works fine (the
> current value in sessions_id_seq is about 870 so the values ar
On 30 Jan 2007 12:15:17 -0800, "Karen Hill" <[EMAIL PROTECTED]> wrote:
> On Jan 29, 11:06 pm, [EMAIL PROTECTED] ("Dawid Kuroczko") wrote:
>
>> * updatable views [ or am I missing something? ] -- it seems to me
>> they were close to be completed, but I don't remember if they were
>> completed an
On Sat, 20 Jan 2007 11:07:57 +0500, "Shoaib Mir" <[EMAIL PROTECTED]> wrote:
> I dont have the replication setup on my machine right now but I guess as
> far
> as I remember you can surely check for the master and slave nodes from a
> Slony schema table.
>
I think the notion of "master and slave
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
>
> Either way. I like to create sql files with all of the DDL for creating
> the view and rules.
> Overtime, if I need to change my view or reconfigure the rules, I can edit
> my sql file and then
> cal
On Tue, 19 Dec 2006 07:22:36 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
>> Once you update one side of the join with a
>> different join key value, the join row in question no longer exists in
>> the view ... so the second update doesn't find a row to update. This
>> has noth
On 19 Dec 2006 08:37:01 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
[...]
What would solve my problem is if there was a
> method to, at the end of
>> a begin/end block, I could rollback the changes made in that block
>> without having to raise an exception. Is it somehow possible to
>> explici
On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
> I understand that due to a lack of nested transaction support, it is
> not possible to use START TRANSACTION within a PL/PgSQL function. What
> I, however, do not understand is why I can't use SAVEPOINT either. I'm
> writing
On Tue, 5 Dec 2006 10:18:21 +, David Goodenough <[EMAIL PROTECTED]> wrote:
[...]
> The first bits of the sync are done without locking the source tables, and
> I do these until I find less than some suitable threshold of records
> needing
> to be updated. Then I lock the source tables and
On Thu, 30 Nov 2006 03:23:03 -0800 (PST), Ashish Karalkar <[EMAIL PROTECTED]>
wrote:
> Hello All,
>
> I am trying to add a new table to an running
> replication system.
>
Please stop posting Slony-I related questions to this list.
slony1-general is the more applicable list for this, see my
On Wed, 29 Nov 2006 18:38:22 +0530, "Merlin Moncure" <[EMAIL PROTECTED]> wrote:
> On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>> Hello friends,
>> I have a view defined as:-
>>
>> CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS
> name from users, vivek_test wh
--On Montag, Dezember 12, 2005 11:16:19 +0100 Martijn van Oosterhout
wrote:
On Sun, Dec 11, 2005 at 10:03:57PM -0600, Tony Caduto wrote:
Has there ever been any discussion on
using Free Pascal to create functions (C Style)?
I know pascal can be used to create user defined functions in other
--On Dienstag, November 16, 2004 17:39:12 +0100 "Alejandro D. Burne"
<[EMAIL PROTECTED]> wrote:
Sorry, but no reply on [EMAIL PROTECTED]
-- Forwarded message --
From: Alejandro D. Burne <[EMAIL PROTECTED]>
Date: Mon, 15 Nov 2004 15:00:58 +0100
Subject: Problem installing Postgresq
--On Dienstag, August 03, 2004 20:51:45 -0600 Scott Marlowe
<[EMAIL PROTECTED]> wrote:
On Tue, 2004-08-03 at 13:05, CSN wrote:
Just wondering, is updateable views slated for a
future version of Postgresql? In addition to using
rules that is.
It's on the todo list. Of course, the just means someo
Merrall, Graeme wrote:
I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider wh
Tom Lane wrote:
Bernd Helmle <[EMAIL PROTECTED]> writes:
But what means "enough tables"?
GEQO_THRESHOLD or more. You can set that anywhere you like (I think the
default is 11 or 12, which is about where the standard exhaustive-search
planner becomes painfully slow).
regards,
I am currently searching some resources, why and where the PostgreSQL
GEQO-Engine improves large join queries. The theoretical background is
clear, but i need some real life szenarios, where the GEQO-Engine beats
other solutions. Have anyone made such a comparison, or have experiences
which sze
This problem is discussed on erserver-general. There are some patches
available, that solves the problem and Andrew Sullivan posted workarounds
for those didn't get their
tables replicated. If you're not subscribed already, you can read the
archive here:
http://gborg.postgresql.org/pipermail/er
25 matches
Mail list logo
