postgresql timestamp

[musternet]

Hello all, The timestamp with timezone column from postgresql is not being generated in the current version. It used to be generated in the old version of sequelize-auto 0.8.3. Best Regards

[steveschmitt]

Hmm, I wonder what changed. Can you provide a CREATE TABLE script that I can use to test?

[musternet]

here is an example of the CREATE TABLE SCRIPT.

` -- public.mail definition

-- Drop table

-- DROP TABLE public.mail;

CREATE TABLE public.mail ( id bigserial NOT NULL, created_at timestamptz NOT NULL, ip bpchar(45) NOT NULL, status int2 NOT NULL, account_id int8 NOT NULL, code varchar(40) NULL, reset_code varchar(40) NULL, CONSTRAINT feedback_pkey PRIMARY KEY (id) ); CREATE INDEX feedback_status_idx ON public.mail USING btree (status); CREATE INDEX index_account_id2 ON public.mail USING btree (account_id); CREATE INDEX index_code ON public.mail USING btree (code); CREATE INDEX mail_reset_code_idx ON public.mail USING btree (reset_code);

-- public.mail foreign keys

ALTER TABLE public.mail ADD CONSTRAINT mail_fk FOREIGN KEY (account_id) REFERENCES public.account(id); ` N.B. Its happening on all the tables that contains timestamp with timezone columns when migrating from db to sequelize