如何将带有返回状态的存储过程从SQL Server/Sybase迁移到PostgreSQL？

0

【以下的问题经过翻译处理】在从SQL Server或Sybase数据库迁移到PostgreSQL时，如何转换具有返回状态的存储过程, 并检查过程调用是否成功。

比如以下存储过程例子： EXEC @return_status = sample_proc

Topics

Tags

Microsoft SQL Server PostgreSQL Aurora PostgreSQL

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 9 months ago49 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】如果没有事务级别的提交或回滚语句的需求，那么可以选择在PostgreSQL中将其作为“函数”并根据执行逻辑返回状态码。与商用数据库引擎中的“存储过程”相比，PostgreSQL中的“函数”可以适应大多数情况。

EXPERT

rePost Polyglot

answered 9 months ago

Relevant content

The AWS Lambda program sometimes fails to trigger, while other times it works correctly.
Accepted Answer
HaydenLuo
asked 7 months ago
如何讓 IAM 使用者只看的到自己建立的資源 ( How to allow IAM users to only see resources they have created.)
Accepted Answer
kerokero
asked 2 months ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
How can I download the full SQL text from Performance Insight for my Aurora PostgreSQL-Compatible instance?
AWS OFFICIALUpdated a year ago
How do I upgrade or downgrade the SQL Server engine edition in RDS for SQL Server?
AWS OFFICIALUpdated 2 years ago
How do I read server-side traces in Amazon RDS for SQL Server?
AWS OFFICIALUpdated a month ago
How do I create a linked server in RDS for SQL Server with the source as RDS?
AWS OFFICIALUpdated a year ago
Announcement: Amazon RDS for SQL Server is ending support for Microsoft SQL Server 2014
EXPERT
appadman
published a year ago
Migrating Microsoft SQL Server workloads to the AWS Cloud
EXPERT
Gayathri Krishnamoorthy
published 9 months ago