Re: ISSTRICT behavior - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: ISSTRICT behavior
Date
Msg-id 20060504063427.GA4752@svana.org
Whole thread Raw
In response to ISSTRICT behavior  (Don Y <pgsql@DakotaCom.Net>)
Responses Re: ISSTRICT behavior  (Don Y <pgsql@DakotaCom.Net>)
List pgsql-general
On Wed, May 03, 2006 at 11:02:26PM -0700, Don Y wrote:
> (sigh)  Sorry to be picking nits.  I'm just trying to
> sort out how to protect against folks making careless
> mistakes in the future (e.g., forgetting STRICT in
> the function declarations when adding a function to
> a database, etc)

Unfortunatly there is no way to ensure the user declares the function
in SQL in the way your code expects. I remember a discussion once about
allowing you to declare the essential function details in the C file so
that Postgres could complain if the user got it wrong, but nothing ever
came of it.

In short, give them an INSTALL.sql and tell them to use it.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From:
Date:
Subject: RES: pg_dumpall error
Next
From: Don Y
Date:
Subject: Re: ISSTRICT behavior