0

how can I add multiple setval statements(50 statements) inside the block.

 DO $$
 BEGIN

 SELECT setval(pg_get_serial_sequence('alerts.incident_log','incident_log_id'),coalesce(max(incident_log_id),0) +1, false) from alerts.incident_log;
 SELECT setval(pg_get_serial_sequence('alerts.nds_email_message','nds_email_message_id'),coalesce(max(nds_email_message_id),0) +1, false) from alerts.nds_email_message;
 SELECT setval(pg_get_serial_sequence('alerts.nds_fax_message','nds_fax_message_id'),coalesce(max(nds_fax_message_id),0) +1, false) from alerts.nds_fax_message;
---- 50 statements
end $$;

 Error occurred during SQL query execution

 Reason:
 SQL Error [42601]: ERROR: query has no destination for result data
   Hint: If you want to discard the results of a SELECT, use PERFORM instead.
   Where: PL/pgSQL function inline_code_block line 4 at SQL statement
Jagdish
  • 1
  • 1

0 Answers0