| Lists: | pgsql-patches |
|---|
| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | An additional foreign key test for regression |
| Date: | 2003-07-04 22:38:56 |
| Message-ID: | 20030704153518.Y26326-200000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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.
| Attachment | Content-Type | Size |
|---|---|---|
| fk_regress.patch | text/plain | 2.1 KB |
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: An additional foreign key test for regression |
| Date: | 2003-07-21 03:39:04 |
| Message-ID: | 200307210339.h6L3d4T19996@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: An additional foreign key test for regression |
| Date: | 2003-07-21 03:39:19 |
| Message-ID: | 200307210339.h6L3dJA20013@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: An additional foreign key test for regression |
| Date: | 2003-07-27 03:13:32 |
| Message-ID: | 200307270313.h6R3DWk03036@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073