[web2py] Re: Unsupported referential constraint in extract_pgsql_models.py

[jm]

hello,

here is the table definition witch lead to the trouble :

CREATE TABLE aqu_gfcategcultureprec
(
  idculture integer NOT NULL,
  idcategorieculture integer NOT NULL,
  libelle_categorie character varying,
  code_libre character varying,
  CONSTRAINT aqu_gfcategcultureprec_pkey PRIMARY KEY (idculture,
idcategorieculture),
  CONSTRAINT fk_idculture_reference_tcultures FOREIGN KEY (idculture)
      REFERENCES tcultures (idculture) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH (
  OIDS=TRUE
);

thanks

JM

On 7 oct, 13:34, jm <jmgou...@gmail.com> wrote:
> Traceback (most recent call last):
>   File "D:\Dev\web2py\scripts\extract_pgsql_models.py", line 282, in
> <module>
>     define_db(cnn, db, host, port, user, passwd)
>   File "D:\Dev\web2py\scripts\extract_pgsql_models.py", line 266, in
> define_db
>     define_table(conn, table)
>   File "D:\Dev\web2py\scripts\extract_pgsql_models.py", line 244, in
> define_tabl
> e
>     fdef = define_field(conn, table, field, pks)
>   File "D:\Dev\web2py\scripts\extract_pgsql_models.py", line 94, in
> define_field
>
>     ref = references(conn, table, field['column_name'])
>   File "D:\Dev\web2py\scripts\extract_pgsql_models.py", line 234, in
> references
>     str(rows1))
> RuntimeError: Unsupported referential constraint: [{'update_rule':
> 'RESTRICT', '
> ordinal_position': 1, 'table_name': 'aqu_gfcategcultureprec',
> 'constraint_name':
>  'fk_idculture_reference_tcultures', 'delete_rule': 'RESTRICT',
> 'column_name': '
> idculture'}, {'update_rule': 'RESTRICT', 'ordinal_position': 1,
> 'table_name': 'a
> qu_gfcategcultureprec', 'constraint_name':
> 'fk_idculture_reference_tcultures', '
> delete_rule': 'RESTRICT', 'column_name': 'idculture'}, {'update_rule':
> 'RESTRICT
> ', 'ordinal_position': 1, 'table_name': 'aqu_gfcategcultureprec',
> 'constraint_na
> me': 'fk_idculture_reference_tcultures', 'delete_rule': 'RESTRICT',
> 'column_name
> ': 'idculture'}, {'update_rule': 'RESTRICT', 'ordinal_position': 1,
> 'table_name'
> : 'aqu_gfcategcultureprec', 'constraint_name':
> 'fk_idculture_reference_tcultures
> ', 'delete_rule': 'RESTRICT', 'column_name': 'idculture'}]