View Issue Details

IDProjectCategoryView StatusLast Update
0002102Database Workbench v6PostgreSQL Modulepublic2023-04-24 10:07
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeveritytweakReproducibilityhave not tried
Status closedResolutionopen 
Fixed in Version6.2.0 
Summary0002102: PostgreSQL Stored Procedure/Function template changed due to PostgreSQL v14 changes in DDL
DescriptionPostgreSQL Stored Procedure/Function template changed due to PostgreSQL v14 changes in DDL.

New syntax allows plain SQL, without AS 'definition'. Database Workbench was adding "AS $body$ (your source code) $body%", because v14 allows bodies as plain statements instead of " AS 'definition' ", the code for this has been removed and the items have been added to the template instead.

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2022-12-01 12:37 Martijn Tonies New Issue
2023-03-29 13:41 Martijn Tonies Assigned To => Martijn Tonies
2023-03-29 13:41 Martijn Tonies Status new => assigned
2023-04-05 14:04 Martijn Tonies Status assigned => resolved
2023-04-05 14:04 Martijn Tonies Fixed in Version => 6.2.0
2023-04-05 14:04 Martijn Tonies Summary PostgreSQL Stored Procedure/Function template changed due to PostgreSQL v14 changed in DDL => PostgreSQL Stored Procedure/Function template changed due to PostgreSQL v14 changes in DDL
2023-04-05 14:04 Martijn Tonies Description Updated
2023-04-24 10:07 Martijn Tonies Status resolved => closed