Re: Function PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Function PostgreSQL 9.2
Дата
Msg-id CANu8FiwSrjQs0XZPiMGnGL02q7rFjNADXUtN7rSiJgHQmW8=Dg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Function PostgreSQL 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Function PostgreSQL 9.2
Следующее
От: Berend Tober
Дата:
Сообщение: Re: Function PostgreSQL 9.2