Re: [Chasers-general] Trying to create tbl_income

[Jessi B. <jbe...@de...>]

Hi Mike,
It looks like the create.tbl_income.sql file first creates tbl_income, 
then some indexes, and lastly the trigger verify_income_record, which 
relies on the function income_verify(). Like you noted, this trigger 
cannot be created before the function is created, but the function 
cannot be created before the table.

If you break up create.tbl_income.sql, you can first create tbl_income, 
then create the function, and lastly the trigger. Storing the trigger in 
the same file as the table's create statement seems like an error here 
(and probably in other places too.)

Does that make sense?

take care,
jessi


Michael James wrote:
> We’re trying to create tbl_income.  When we run create.tbl_income.sql we 
> get this error:
> 
>  
> 
> ERROR:  function income_verify() does not exist
> 
> ********** Error **********
> 
> ERROR: function income_verify() does not exist
> SQL state: 42883
> 
>  
> 
> Then we run create.functions_income.sql and get this error:
> 
>  
> 
> ABORT;
> 
> ERROR:  relation "tbl_income" does not exist
> 
> ********** Error **********
> 
> ERROR: relation "tbl_income" does not exist
> SQL state: 42P01
> 
>  
> 
> This looks circular to me.  Any ideas?
> 
>  
> 
> Thanks,
> 
>  
> 
> Mike James
> 
> Plymouth Housing Group
> 
> mj...@pl... <mailto:mj...@pl...>
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> ------------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Chasers-general mailing list
> Cha...@li...
> https://lists.sourceforge.net/lists/listinfo/chasers-general

-- 
Jessi Berkelhammer
Downtown Emergency Service Center
Computer Programming Specialist