Updated on 2025-06-07 GMT+08:00

U0530005: TaurusDB for PostgreSQL does not support temporary stored procedures

Description

Database Type and Version

  • Source database type and version: all SQL Server versions
  • Target database type and version: TaurusDB for PostgreSQL 16.4 and later

Syntax Example

Although TaurusDB for PostgreSQL supports syntax for temporary stored procedures, it does not support the temporary stored procedures. They are stored as common stored procedures.

SQL Server syntax:

create procedure #temp_proc
as
  print 'xxx';
go

Suggestion

Adjust related functions.