Hi Guys,

 I've just noticed that when creating a new table that requires a serial column, the generation script starts with:

CREATE SEQUENCE public.http_config_http_cnfg_ref_seq

INCREMENT BY 1

MINVALUE 1

START 1

CACHE 1

NO CYCLE

OWNED BY http_config.http_cnfg_ref

;

The problem here, is the table doesn't exist yet, so this doesn't execute. Should it not create the sequence first then then the table with an int or bigint then assign the nextval of the sequence as the default value of the table int?

That sort of thing isn't really my forte, but i do know it's currently not working.

If I''m doing something silly, please let me know.

Cheers. Regards, TM 

Thanks for reporting this (and using the product!). We'll look into it. Sounds like an issue. In most other databases, sequences are not owned by tables, that's why, in general, ModelRight creates sequences before tables; however we might need to adjust this for PGSQL

---

ModelRight Evangelist

This problem is fixed in the next build. We will update when is available (within the next few days).

---

ModelRight Evangelist

Excellent. Thanks mate.

build 3517 is up... please let us know how it works.

---

ModelRight Evangelist

The bug is fixed. Thanks guys.