postgres procedure syntax error near »end«

Question

I am facing an issue when I try to run my procudere. I have a table where I have all values stored in text format and try to convert to int or timestamp

CREATE OR REPLACE PROCEDURE public.textnummerictest(
)
LANGUAGE 'sql'
AS $BODY$
create or replace procedure textnummerictest()
language plpgsql
as $$
begin
 insert into sensorhistory_test(
  datetime,
  sensorid     )
 select from sensorhistory_temp (
  cast(sensorid as integer),
  datetime::timestamp       )
 end; $$
$BODY$;

ALTER PROCEDURE public.textnummerictest()
OWNER TO postgres;

Always getting the error Syntaxerror near end.

Any help really appreciated

You have a create or replace inside another create or replace — user330315
– user330315, Commented Mar 4, 2022 at 7:47
well this is added by pgadmin for any reason. the original script is between $BODY$ — cyberoner1
– cyberoner1, Commented Mar 4, 2022 at 7:53
Then it's a pgAdmin bug. Remove everything before the first $BODY$ and then remove the final $BODY$ as well. — user330315
– user330315, Commented Mar 4, 2022 at 7:54
I did so, but now end;$$ is red underlined and I get the same error — cyberoner1
– cyberoner1, Commented Mar 4, 2022 at 7:56
Well there is so much wrong with that statement, that it's really hard to fix. You are missing a ; at the end of the INSERT. And your procedure doesn't have a variable or parameter named sensorid or datetime. And select from .. should be select * from ... as well. — user330315
– user330315, Commented Mar 4, 2022 at 8:00

cyberoner1 · Accepted Answer · 2022-03-04 08:00:03Z

1

I found the error....

there must be a ';' before end...

answered Mar 4, 2022 at 8:00

cyberoner1

491 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres procedure syntax error near »end«

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related