INSERT INTO does not return until canceled

Question

i am using sqldevlepoer and trying to execute an statement like below,

INSERT INTO users
(first_name, last_name)
VALUES
('john', 'smith');

but nothing is returned until i stop the operation manually .... it just hangs, Any ideas?

Answer 1

I'm guessing, just that, because we need more info on your question, but maybe you have another session with a begin transaction and it was never commited or rollbacked.