postgresql-to-sqlite icon indicating copy to clipboard operation
postgresql-to-sqlite copied to clipboard

Error creating index

Open waldner opened this issue 1 year ago • 2 comments

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);,

waldner avatar Mar 25 '24 15:03 waldner

I have the same problem. Have you found a workaround?

autoantwort avatar Nov 30 '24 11:11 autoantwort

No sorry, in the end the need to do the conversion went away so I didn't investigate further,

waldner avatar Nov 30 '24 18:11 waldner