On Thu, May 5, 2016 at 3:54 AM, Alban Hertroys <haram...@gmail.com> wrote:
> > > On 05 May 2016, at 8:42, drum.lu...@gmail.com wrote: > > > The final function code is: > > > > CREATE OR REPLACE FUNCTION users_code_seq() > > RETURNS "trigger" AS $$ > > DECLARE code character varying; > > BEGIN > > IF NEW.code IS NULL THEN > > SELECT client_code_increment INTO STRICT NEW.code FROM > public.companies WHERE id = NEW.id ORDER BY client_code_increment DESC; > > > ^^^^^^^ > There's your problem. I'm pretty sure the keyword STRICT isn't valid > there. It probably gets interpreted as a column name. > > No, its a sanity check/assertion. If that trips its because there is no company having a value of NEW.id on the public.companies table. If that is OK then remove the STRICT but if you are indeed expecting a record to be present and it is not it is correctly telling you that there is a problem in the data. Namely that said company needs to be added to the table. David J.
