Search Postgresql Archives

Re: What have I done!?!?!? :-)

Subject: Re: What have I done!?!?!? :-)
From: Jan Wieck <jan@xxxxxxxxxx>
Date: Fri, 8 Apr 2022 10:01:47 -0400
Cc: Nikolay Samokhvalov <samokhvalov@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <91e71bb4-6b6e-a4e1-1456-b9a9495f7e0d@wi3ck.info>
References: <E2D1EB02-6391-4698-B703-3B02E5271FBC@easesoftware.com> <70c17f9b-1e6e-5dc2-ec1b-a60f9000026c@wi3ck.info> <CANNMO+J-KZggPz4pX=KUOfRwpXm=Qo3eXz9=e2BtdnaBZbZRqg@mail.gmail.com> <0e4ea8e7-bfe2-b3ce-1edb-baa247bac0ca@wi3ck.info> <E62EA153-1EFD-411D-9553-5F890FC5139D@easesoftware.com> <CABUevEzXDH+D1kndL81bMFsNjX1as0Fi-hWt1OXy+1EcvJitxw@mail.gmail.com> <91e71bb4-6b6e-a4e1-1456-b9a9495f7e0d@wi3ck.info>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0

On 4/8/22 09:58, Jan Wieck wrote:

It only affects constraints that have been declared DEFERRABLE. Those
that are not are silently ignored (as per SQL standard).

I should have said "... silently ignored by this statement and stillfire IMMEDIATE".



Just to be clear, Jan

References:
- What have I done!?!?!? :-)
  - From: Perry Smith
- Re: What have I done!?!?!? :-)
  - From: Jan Wieck
- Re: What have I done!?!?!? :-)
  - From: Nikolay Samokhvalov
- Re: What have I done!?!?!? :-)
  - From: Jan Wieck
- Re: What have I done!?!?!? :-)
  - From: Perry Smith
- Re: What have I done!?!?!? :-)
  - From: Magnus Hagander
- Re: What have I done!?!?!? :-)
  - From: Jan Wieck