Обсуждение: An additional foreign key test for regression

The deferred trigger queue pushing to disk patch pointed out
that the regression tests for foreign keys didn't seem to test
a deferred constraint that was not satisified by a later
statement and was not made immediate by set constraints,
so here's a simple added test with a single invalid insert and
a commit.

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Stephan Szabo wrote:
>
> The deferred trigger queue pushing to disk patch pointed out
> that the regression tests for foreign keys didn't seem to test
> a deferred constraint that was not satisified by a later
> statement and was not made immediate by set constraints,
> so here's a simple added test with a single invalid insert and
> a commit.

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Stephan Szabo wrote:
>
> The deferred trigger queue pushing to disk patch pointed out
> that the regression tests for foreign keys didn't seem to test
> a deferred constraint that was not satisified by a later
> statement and was not made immediate by set constraints,
> so here's a simple added test with a single invalid insert and
> a commit.

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Patch applied.  Thanks.

I adjusted the patch to match the new elog output.

---------------------------------------------------------------------------


Stephan Szabo wrote:
>
> The deferred trigger queue pushing to disk patch pointed out
> that the regression tests for foreign keys didn't seem to test
> a deferred constraint that was not satisified by a later
> statement and was not made immediate by set constraints,
> so here's a simple added test with a single invalid insert and
> a commit.

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073