search

caiiiycuk / postgresql-to-sqlite

pg2sqlite is easy to use solution to create sqlite database from postgresql dump
MIT License
132 stars 11 forks source link

Error creating index #23

Open waldner opened 7 months ago

waldner commented 7 months ago

I have a failure converting from this statement:

CREATE INDEX hydra_oauth2_flow_multi_query_idx ON hydra_oauth2_flow USING btree (((consent_error)::character varying(2)), state, subject, client_id, consent_skip, consent_remember, nid);

The output is

Create Index - Exception:
    [SQLITE_ERROR] SQL error or missing database (unrecognized token: ":")
    [SQL] 'CREATE INDEX hydra_oauth2_flow_multi_query_idx ON hydra_oauth2_flow (((consent_error)::character,state,subject,client_id,consent_skip,consent_remember,nid)'
    [LINE #1023] CREATE INDEX hydra_oauth2_flow_multi_query_idx ON hydra_oauth2_flow USING btree (((consent_error)::character varying(2)), state, subject, client_id, consent_skip, consent_remember, nid);,