Simon Riggs escribió:
> Looks like that really is a deficiency in my tool chain on OSX, rather than
> some bug/user error. Even at the very latest, very shiny version.
>
> Latest versions of gcc trap the error, so I'll have to investigate an
> alternative.
Funnily enough, on Debian Wheezy with g
On 24 June 2013 22:17, Simon Riggs wrote:
> On 24 June 2013 21:42, Jeff Janes wrote:
>
>> On Sun, Jun 23, 2013 at 8:58 PM, Abhijit Menon-Sen
>> wrote:
>>
>>> At 2013-06-08 21:45:24 +0100, si...@2ndquadrant.com wrote:
>>> >
>>> > ALTER TABLE foo
>>> >ALTER CONSTRAINT fktable_fk_fkey DEFERRED
On 24 June 2013 21:42, Jeff Janes wrote:
> On Sun, Jun 23, 2013 at 8:58 PM, Abhijit Menon-Sen
> wrote:
>
>> At 2013-06-08 21:45:24 +0100, si...@2ndquadrant.com wrote:
>> >
>> > ALTER TABLE foo
>> >ALTER CONSTRAINT fktable_fk_fkey DEFERRED INITIALLY IMMEDIATE;
>>
>> I read the patch (looks go
On Sun, Jun 23, 2013 at 8:58 PM, Abhijit Menon-Sen wrote:
> At 2013-06-08 21:45:24 +0100, si...@2ndquadrant.com wrote:
> >
> > ALTER TABLE foo
> >ALTER CONSTRAINT fktable_fk_fkey DEFERRED INITIALLY IMMEDIATE;
>
> I read the patch (looks good), applied it on HEAD (fine), ran make check
> (fine)
At 2013-06-08 21:45:24 +0100, si...@2ndquadrant.com wrote:
>
> ALTER TABLE foo
>ALTER CONSTRAINT fktable_fk_fkey DEFERRED INITIALLY IMMEDIATE;
I read the patch (looks good), applied it on HEAD (fine), ran make check
(fine), and played with it in a test database. It looks great, and from
previo
On Mon, Jun 10, 2013 at 11:06 PM, Dimitri Fontaine
wrote:
> Andres Freund writes:
> > I haven't looked at the patch in detail, but I am very, very much in
> > favor of the feature in general… I have wished for this more than once,
>
> +1
>
+1. It will be useful.
--
Michael
Andres Freund writes:
> I haven't looked at the patch in detail, but I am very, very much in
> favor of the feature in general… I have wished for this more than once,
+1
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-hackers maili
Andres Freund wrote:
> On 2013-06-08 21:45:24 +0100, Simon Riggs wrote:
>> ALTER TABLE foo
>> ALTER CONSTRAINT fktable_fk_fkey DEFERRED INITIALLY IMMEDIATE;
> I haven't looked at the patch in detail, but I am very, very much in
> favor of the feature in general… I have wished for this more t
On 2013-06-08 21:45:24 +0100, Simon Riggs wrote:
> While fiddling with FK tuning, it was useful to be able to enable and
> disable the DEFERRED mode of constraints.
>
> That is not currently possible in SQL, so I wrote this patch. Without
> this you have to drop and then re-add a constraint, which
While fiddling with FK tuning, it was useful to be able to enable and
disable the DEFERRED mode of constraints.
That is not currently possible in SQL, so I wrote this patch. Without
this you have to drop and then re-add a constraint, which is
impractical for large tables.
e.g.
CREATE TABLE fktabl
10 matches
Mail list logo
