| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>, Berend Tober <btober(at)computer(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Function PostgreSQL 9.2 |
| Date: | 2016-05-05 22:30:45 |
| Message-ID: | CANu8FiwSrjQs0XZPiMGnGL02q7rFjNADXUtN7rSiJgHQmW8=Dg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 5, 2016 at 6:17 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Berend Tober | 2016-05-05 23:32:28 | Re: Function PostgreSQL 9.2 |
| Previous Message | David G. Johnston | 2016-05-05 22:17:12 | Re: Function PostgreSQL 9.2 |