Import using pgAdmin3 produces ERROR: duplicate key value violates unique constraint
The column default for daqa_report_id would have to be:

nextval('jira_tickets.daqa_id_seq'::regclass)


Not:

'jira_tickets.daqa_id_seq'::regclass

That would just fetch the OID for the sequence object from pg_class, which is converted to a meaningless, static bigint number.

pgAdmin has nothing to do with this.

But just use the pseudo data type bigserial instead. It does everything automatically. Here's how you would add a bigserial to an existing table:
Most efficient way to add a serial column to a huge table