"Cyril B." writes:
> On 07/19/2016 03:51 PM, Jim Nasby wrote:
>> In this example, you should be able to avoid that by setting
>> constraint_exclusion=off.
> Sorry I forgot to mention I had already tried that, to no avail.
Yeah, constraint_exclusion won't help, because this function isn't
in a CH
On 07/19/2016 03:51 PM, Jim Nasby wrote:
In this example, you should be able to avoid that by setting
constraint_exclusion=off.
Sorry I forgot to mention I had already tried that, to no avail.
--
Cyril B.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On 7/19/16 7:43 AM, Cyril B. wrote:
Hello,
Is there a way to execute a SELECT on a table having a constraint that
uses a non-working SQL function?
...
ALTER TABLE ONLY t1 ADD CONSTRAINT c EXCLUDE (id WITH =) WHERE ((f(id)
IS NOT TRUE));
...
ERROR: relation "rename_me.t2" does not exist
...
Hello,
Is there a way to execute a SELECT on a table having a constraint that
uses a non-working SQL function?
I know the easiest way would be to fix the function, but I'm the
database administrator, not the owner, and I need to do a COUNT(*) on
each table.
Here's a minimal use case:
CREA
