While building 9.2.3 on OS X 10.8.2 today:
checking ossp/uuid.h usability... no
checking ossp/uuid.h presence... yes
configure: WARNING: ossp/uuid.h: present but cannot be compiled
configure: WARNING: ossp/uuid.h: check for missing prerequisite headers?
configure: WARNING: ossp/uuid.h: see the
Hi all,
While testing a bit this feature, I noticed that use_remote_explain is
available in the list of options for FOREIGN TABLE and SERVER but this is
not specified in the docs:
http://www.postgresql.org/docs/devel/static/postgres-fdw.html
postgres=# CREATE FOREIGN TABLE foo (a int, b int) serv
On Thu, Feb 21, 2013 at 11:09 PM, Heikki Linnakangas <
hlinnakan...@vmware.com> wrote:
> On 15.02.2013 15:49, Heikki Linnakangas wrote:
>
>> Attached is a patch for git master. The basic idea is to split
>> InArchiveRecovery into two variables, InArchiveRecovery and
>> ArchiveRecoveryRequested. Ar
On 2013-02-21 14:11:10 -0800, Kevin Grittner wrote:
> Tom Lane wrote:
> > Kevin Grittner writes:
>
> >> What did you think of the idea of something like DISCARD
> >> MATERIALIZED VIEW DATA as a new statment? Or maybe RESET
> >> MATERIALIZED VIEW?
> >
> > I could live with either DISCARD or RESE
2013/2/22 Andrew Dunstan :
>
> On 02/21/2013 12:56 PM, Magnus Hagander wrote:
>>
>> On Thu, Feb 21, 2013 at 6:39 PM, Robert Haas
>> wrote:
>>>
>>> On Wed, Feb 20, 2013 at 11:58 AM, Ian Lawrence Barwick
>>> wrote:
I'm not sure if this is a documentation or hackers issue, but the
doc
On Tue, Feb 19, 2013 at 5:43 PM, Heikki Linnakangas wrote:
> On 19.02.2013 20:07, Fabrízio de Royes Mello wrote:
>
>> I would like to propose implement a way to track creation times to
>> database
>> objects. This was discussed before in this thread [1].
>>
>> This was discussed before in this th
Greg Stark wrote:
> Kevin Grittner wrote:
>> It doesn't. That was one of the more contentious points in the
>> earlier bikeshedding phases. Some felt that throwing away the
>> contents was a form of making the MV "out of date" and as such
>> didn't require any special handling. Others, includi
On Thu, Feb 21, 2013 at 2:38 PM, Kevin Grittner wrote:
> It doesn't. That was one of the more contentious points in the
> earlier bikeshedding phases. Some felt that throwing away the
> contents was a form of making the MV "out of date" and as such
> didn't require any special handling. Others,
Tom Lane wrote:
> Kevin Grittner writes:
>> What did you think of the idea of something like DISCARD
>> MATERIALIZED VIEW DATA as a new statment? Or maybe RESET
>> MATERIALIZED VIEW?
>
> I could live with either DISCARD or RESET.
I figured this was worth a pass through the keyword list to look
On 2/21/13 9:25 AM, Kevin Grittner wrote:
> Peter Eisentraut wrote:
>> On 2/20/13 11:14 PM, Greg Stark wrote:
>>> That's not entirely true. From the database's point of view,
>>> TRUNCATE is in many ways actually DDL.
>>
>> Whether something is DDL or DML or a read operation (query) is
>> not an i
2013/2/20 Josh Kupershmidt :
> On Wed, Jan 23, 2013 at 12:06 PM, Pavel Stehule
> wrote:
>> 2013/1/14 Tom Lane :
>>> Well, fine, but then it should fix both of them and remove
>>> minimal_error_message altogether. I would however suggest eyeballing
>>> what happens when you try "\ef nosuchfunctio
On Thu, Feb 21, 2013 at 11:02 AM, Robert Haas wrote:
> On Thu, Feb 21, 2013 at 10:51 AM, Merlin Moncure wrote:
>> Sure: but that's another straw man: abuse of + operator is case of
>> combining arbitrarily different behaviors (concatenation and
>> arithmetic aggregation) into uniform syntax. T
On 02/21/2013 12:56 PM, Magnus Hagander wrote:
On Thu, Feb 21, 2013 at 6:39 PM, Robert Haas wrote:
On Wed, Feb 20, 2013 at 11:58 AM, Ian Lawrence Barwick
wrote:
I'm not sure if this is a documentation or hackers issue, but the
documentation page for contrib module "xml2" refers to PostgreSQL
On Thu, Feb 21, 2013 at 6:39 PM, Robert Haas wrote:
> On Wed, Feb 20, 2013 at 11:58 AM, Ian Lawrence Barwick
> wrote:
>> I'm not sure if this is a documentation or hackers issue, but the
>> documentation page for contrib module "xml2" refers to PostgreSQL 8.4 in the
>> future tense:
>>
>>"It
Robert Haas escribió:
> On Thu, Feb 21, 2013 at 12:25 PM, Robert Haas wrote:
> >> There's also code to re-obtain the list of objects to drop after the
> >> event trigger functions have run; the second list is compared to the
> >> first one, and if they differ, an error is raised.
> >
> > This is d
Robert Haas escribió:
> On Wed, Feb 20, 2013 at 10:48 PM, Alvaro Herrera
> wrote:
> > I have added some protections so that these do not fire on undesirable
> > events (such as dropping an event trigger); also event triggers and
> > other object types are filtered out of pg_dropped_objects, in cas
On Wed, Feb 20, 2013 at 11:58 AM, Ian Lawrence Barwick
wrote:
> I'm not sure if this is a documentation or hackers issue, but the
> documentation page for contrib module "xml2" refers to PostgreSQL 8.4 in the
> future tense:
>
>"It is planned that this module will be removed in PostgreSQL 8.4
On Thu, Feb 21, 2013 at 12:25 PM, Robert Haas wrote:
>> There's also code to re-obtain the list of objects to drop after the
>> event trigger functions have run; the second list is compared to the
>> first one, and if they differ, an error is raised.
>
> This is definitely an improvement. I am no
Just a heads up: I intend to push this shortly, and after it has seen
some BF activity, pg_xlogdump as well.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
*** a/src/backend/Makefile
--- b/src/backend/Makefile
***
On Thu, Feb 21, 2013 at 12:16 PM, Jeff Janes wrote:
> Does the kernel really read a data block from disk into memory in
> order to immediately overwrite it? I would have thought it would
> optimize that away, at least if the writes are sized and aligned to
> 512 or 1024 bytes blocks (which WAL sh
On Wed, Feb 20, 2013 at 10:48 PM, Alvaro Herrera
wrote:
> I have added some protections so that these do not fire on undesirable
> events (such as dropping an event trigger); also event triggers and
> other object types are filtered out of pg_dropped_objects, in case
> something like DROP OWNED ha
On Thu, Feb 21, 2013 at 12:39 AM, Heikki Linnakangas
wrote:
>
> Are you talking about the patch to avoid restored WAL segments from being
> re-archived (commit 6f4b8a4f4f7a2d683ff79ab59d3693714b965e3d), or the bug
> that that unarchived WALs were deleted after crash (commit
> b5ec56f664fa20d80fe75
On Wed, Feb 20, 2013 at 7:54 AM, Robert Haas wrote:
> On Tue, Feb 19, 2013 at 5:48 PM, Simon Riggs wrote:
>> I agree with Merlin and Joachim - if we have the call in one place, we
>> should have it in both.
>
> We might want to assess whether we even want to have it one place.
> I've seen cases w
On Thu, Feb 21, 2013 at 10:51 AM, Merlin Moncure wrote:
> Sure: but that's another straw man: abuse of + operator is case of
> combining arbitrarily different behaviors (concatenation and
> arithmetic aggregation) into uniform syntax. This is bad, but a
> different thing. The right way to do
pink Peter as xml feature commiter.
Regards
Pavel
2013/2/21 Pavel Stehule :
> Hello
>
> here is patch
>
> where it should be pushed - 9.3 or 9.4 ?
>
> I vote 9.3 - I know a users, that should to do workarounds (he should
> not to use domains) now, so early is better. And this patch is one
> line
Hello
here is patch
where it should be pushed - 9.3 or 9.4 ?
I vote 9.3 - I know a users, that should to do workarounds (he should
not to use domains) now, so early is better. And this patch is one
line size patch
Regards
Pavel
2013/2/16 Pavel Stehule :
> 2013/2/16 Noah Misch :
>> On Sun, Ja
On Wed, Feb 20, 2013 at 9:42 AM, Robert Haas wrote:
> On Tue, Feb 19, 2013 at 10:00 AM, Merlin Moncure wrote:
>> Anyways, as to overloading in general, well, SQL is heavily
>> overloaded. We don't have int_max, float_max, etc. and it would be
>> usability reduction if we did.
>
> That's true, bu
Kevin Grittner writes:
> Tom Lane wrote:
>> Peter claimed upthread that REFRESH is a subcommand of ALTER
>> MATERIALIZE VIEW
> It's not, nor do I think it should be.
Oh, never mind then.
>> and that this operation should be another one. That sounds
>> pretty reasonable from here.
> That feel
Tom Lane wrote:
>> I think that the question what to push down is a different question
>> from checking column data types, because there we can rely on the
>> type input functions to reject bad values.
>
> Unfortunately, that's a very myopic view of the situation: there
> are many cases where data
Andres Freund wrote:
> I assume that at some point matviews will get (auto-)updateable,
> just as normal views recently got.
I'm dubious about that. Every use case I've seen for MVs involves
aggregation, although they are a generalized feature, so that won't
always be true. But if you have a v
Andres Freund writes:
> Sure, it might fail if you use READ ONLY explicitly. Or the code might
> check it. The point is that one might not have choice about the READ
> ONLY state of the local transaction if its a HS standby as all
> transactions are READ ONLY there.
[ shrug... ] If you want to u
On 2013-02-21 10:21:34 -0500, Tom Lane wrote:
> Andres Freund writes:
> > On 2013-02-21 09:58:57 -0500, Tom Lane wrote:
> >> How exactly would it do that via an FDW? Surely if the user tries to
> >> execute INSERT/UPDATE/DELETE against a foreign table, the command would
> >> get rejected in a rea
Tom Lane wrote:
> Kevin Grittner writes:
>> Tom Lane wrote:
>>> That being the case, lumping them as being the "same"
>>> operation feels like the wrong thing, and so we should choose a
>>> different name for the MV operation.
>>
>> There is currently no truncation of MV data without rendering
>
Andres Freund writes:
> On 2013-02-21 09:58:57 -0500, Tom Lane wrote:
>> How exactly would it do that via an FDW? Surely if the user tries to
>> execute INSERT/UPDATE/DELETE against a foreign table, the command would
>> get rejected in a read-only transaction, long before we even figure out
>> th
On 2013-02-21 07:10:09 -0800, Kevin Grittner wrote:
> Andres Freund wrote:
> > giving an error so its an easy to find distinction to a normal
> > table seems like a good idea.
>
> I'm not sure I understood your concerns entirely, but wonder
> whether this helps?:
To explain it a bit:
I assume t
Heikki Linnakangas wrote:
> On 21.02.2013 16:38, Kevin Grittner wrote:
>> Tom Lane wrote:
>>> Greg Stark writes:
The way I was thinking about it, whatever the command is named, you
might be able to tell the database to drop the storage associated with
the view but that would make
Kevin Grittner writes:
> Tom Lane wrote:
>> That being the case, lumping them as being the "same" operation
>> feels like the wrong thing, and so we should choose a different
>> name for the MV operation.
> There is currently no truncation of MV data without rendering the
> MV unscannable. Do y
Andres Freund wrote:
> giving an error so its an easy to find distinction to a normal
> table seems like a good idea.
I'm not sure I understood your concerns entirely, but wonder
whether this helps?:
test=# \d
List of relations
Schema | Name | Type | Owner
On 21.02.2013 16:38, Kevin Grittner wrote:
Tom Lane wrote:
Greg Stark writes:
The way I was thinking about it, whatever the command is named, you
might be able to tell the database to drop the storage associated with
the view but that would make the view invalid until it was refreshed.
It wou
Peter Eisentraut wrote:
I'll need more time to ponder your other points, but...
> You don't need a new command or key word for this. How about
> ALTER MATERIALIZED VIEW DISCARD?
I don't like this because we don't have ALTER TABLE REINDEX. But
the fact that DISCARD is a keyword does open up so
On 2013-02-21 09:58:57 -0500, Tom Lane wrote:
> Andres Freund writes:
> > On 2013-02-21 14:23:35 +, Albe Laurenz wrote:
> >> Tom Lane wrote:
> >>> Another thing I was wondering about, but did not change, is that if we're
> >>> having the remote transaction inherit the local transaction's isola
Andres Freund writes:
> On 2013-02-21 14:23:35 +, Albe Laurenz wrote:
>> Tom Lane wrote:
>>> Another thing I was wondering about, but did not change, is that if we're
>>> having the remote transaction inherit the local transaction's isolation
>>> level, shouldn't it inherit the READ ONLY prope
Albe Laurenz writes:
> Tom Lane wrote:
>> As I mentioned earlier, I think it would be better to force the remote
>> session's search_path setting to just "pg_catalog" and then reduce the
>> amount of explicit schema naming in the queries --- any opinions about
>> that?
> I think that that would m
Greg Stark wrote:
> I actually don't really dislike using "TRUNCATE" for this
> command. I was more asking about whether this meant people were
> thinking of the view as a thing where you could control the data
> in it by hand and could have the view be "empty" rather than just
> "not valid".
Y
Tom Lane wrote:
> Greg Stark writes:
>> The way I was thinking about it, whatever the command is named, you
>> might be able to tell the database to drop the storage associated with
>> the view but that would make the view invalid until it was refreshed.
>> It wouldn't make it appear to be empty.
On 2013-02-21 14:23:35 +, Albe Laurenz wrote:
> Tom Lane wrote:
> > Another thing I was wondering about, but did not change, is that if we're
> > having the remote transaction inherit the local transaction's isolation
> > level, shouldn't it inherit the READ ONLY property as well?
>
> That see
Peter Eisentraut wrote:
> On 2/20/13 11:14 PM, Greg Stark wrote:
>> That's not entirely true. From the database's point of view,
>> TRUNCATE is in many ways actually DDL.
>
> Whether something is DDL or DML or a read operation (query) is
> not an implementation detail, it's a user-exposed category
Tom Lane wrote:
> Applied with a lot of revisions.
I am thrilled.
> As I mentioned earlier, I think it would be better to force the remote
> session's search_path setting to just "pg_catalog" and then reduce the
> amount of explicit schema naming in the queries --- any opinions about
> that?
I t
On Thursday, February 21, 2013 12:46 AM Heikki Linnakangas wrote:
> On 20.02.2013 11:42, Amit Kapila wrote:
> > The patch for providing connection string for pg_basebackup,
> > pg_receivexlog, pg_dump and pg_dumpall is attached with this mail.
>
> Thanks. Now that I look at this patch, I realize t
On 15.02.2013 15:49, Heikki Linnakangas wrote:
Attached is a patch for git master. The basic idea is to split
InArchiveRecovery into two variables, InArchiveRecovery and
ArchiveRecoveryRequested. ArchiveRecoveryRequested is set when
recovery.conf exists. But if we don't know how far we need to re
On 2/20/13 11:14 PM, Greg Stark wrote:
> That's not entirely true. From the database's point of view, TRUNCATE
> is in many ways actually DDL.
Whether something is DDL or DML or a read operation (query) is not an
implementation detail, it's a user-exposed category. Since TRUNCATE is
logically equ
On 2/20/13 5:03 PM, Kevin Grittner wrote:
> Peter Eisentraut wrote:
>> On 2/20/13 2:30 PM, Kevin Grittner wrote:
Are there TRUNCATE triggers on materialized views?
>>> No. Nor SELECT, INSERT, UPDATE, or DELETE triggers. You can't
>>> create a trigger of any type on a materialized view. I d
On Wed, Feb 20, 2013 at 11:14 PM, Greg Stark wrote:
> On Wed, Feb 20, 2013 at 9:25 PM, Peter Eisentraut wrote:
>> More generally, I would consider the invalidation of a materialized view
>> a DDL command, whereas truncating a table is a DML command.
>
> That's not entirely true. From the database
On Wed, Feb 20, 2013 at 9:49 PM, Joachim Wieland wrote:
> So given the above, I think it's possible to come up with benchmarks
> that prove whatever you want to prove :-)
Yeah. :-(
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-h
Shigeru Hanada writes:
> [ postgres_fdw.v5.patch ]
Applied with a lot of revisions.
There are still a number of loose ends and things that need to be
discussed:
I'm not at all happy with the planner support functions --- as designed,
that code is basically incapable of thinking about more than
On 2013-02-21 04:14:09 +, Greg Stark wrote:
> On Wed, Feb 20, 2013 at 9:25 PM, Peter Eisentraut wrote:
> > More generally, I would consider the invalidation of a materialized view
> > a DDL command, whereas truncating a table is a DML command.
>
> That's not entirely true. From the database's
On Thu, Feb 21, 2013 at 12:39 AM, Heikki Linnakangas
wrote:
> On 21.02.2013 02:59, Daniel Farina wrote:
>>
>> On Fri, Feb 15, 2013 at 9:29 AM, Simon Riggs
>> wrote:
>>>
>>> On 15 February 2013 17:07, Heikki Linnakangas
>>> wrote:
>>>
> Unfortunately in HEAD, xxx.done file is not created when r
On 21.02.2013 02:59, Daniel Farina wrote:
On Fri, Feb 15, 2013 at 9:29 AM, Simon Riggs wrote:
On 15 February 2013 17:07, Heikki Linnakangas wrote:
Unfortunately in HEAD, xxx.done file is not created when restoring
archived
file because of absence of the patch. We need to implement that first
Greg Stark writes:
> The way I was thinking about it, whatever the command is named, you
> might be able to tell the database to drop the storage associated with
> the view but that would make the view invalid until it was refreshed.
> It wouldn't make it appear to be empty.
Actually, that seems
On 20.02.2013 13:39, pierpaolo.cincilla wrote:
Thank you Heikki for your reply. As you suggest, I will explain better what
I'm trying to accomplish.
What I'm writing a ditributed two-phase-commit termination protocol that
work in this manner:
1) Each site has a replica of the database. A site A
60 matches
Mail list logo