| From: | Amul Sul <sulamul(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Allow NOT VALID foreign key constraints on partitioned tables. |
| Date: | 2025-01-24 10:50:00 |
| Message-ID: | CAAJ_b974U3Vvf-qGwFyZ73DFHqyFJP9TOmuiXR2Kp8KVcJtP6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jan 24, 2025 at 7:46 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > OK thanks, looks good, I have pushed it now with some trivial
> > amendments.
>
> Looks like some of the queries need ORDER BY for stability.
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=morepork&dt=2025-01-23%2023%3A35%3A57
>
Attached is the patch to fix this. Apologies for the sloppy work, and
thanks for pointing it out.
Regards,
Amul
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Fix-instability-in-foreign-key-tests.patch | application/octet-stream | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2025-01-24 11:31:58 | Re: XMLDocument (SQL/XML X030) |
| Previous Message | Bertrand Drouvot | 2025-01-24 10:47:36 | Re: doc: explain pgstatindex fragmentation |