Postgres Pro
Downloads
Home   >   mailing lists

Re: Function PostgreSQL 9.2 - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Function PostgreSQL 9.2
Date
Msg-id CANu8FiwSrjQs0XZPiMGnGL02q7rFjNADXUtN7rSiJgHQmW8=Dg@mail.gmail.com
Whole thread Raw
In response to Re: Function PostgreSQL 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view


On Thu, May 5, 2016 at 6:17 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

If I change that to company_id, I get the error:  column "company_id" does not exist, because that column is inside USERS and not COMPANIES.


​change that .... what is "that"

​Provide the actual code you ran that resulted in "column "company_id" does not exist"​  Your attempts at brevity are making this harder that it has to be.

David J.


​
 


Drum,
I strongly suggest you learn how to debug your own code.
The best way to do that is to temporarily use RAISE NOTICE ... at various points in your TRIGGER function so that YOU can determine the exact source of the problem.
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Function PostgreSQL 9.2
Next
From: Berend Tober
Date:
Subject: Re: Function PostgreSQL 9.2