I was trying to create an attribute and got this error:
NOTICE: adding missing FROM-clause entry for table "acs_attribute_id_seq"
LINE 1: select acs_attribute_id_seq.nextval from dual
^
QUERY: select acs_attribute_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 28 at SQL statement
ERROR: insert or update on table "acs_attributes" violates foreign key constraint "acs_attrs_obj_type_tbl_name_fk"
SQL state: 23503
Detail: Key (object_type,table_name)=(my_address,my_addresses) is not present in table "acs_object_type_tables".
Context: SQL statement "INSERT INTO acs_attributes (attribute_id, object_type, table_name, column_name, attribute_name, pretty_name, pretty_plural, sort_order, datatype, default_value, min_n_values, max_n_values, storage, static_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 )"
PL/pgSQL function "acs_attribute__create_attribute" line 30 at SQL statement
I guess I need to add a value to the acs_object_type_tables? Or did I miss a step?
Thanks!
