When generating schema scripts, I have the ability to include or exclude the storage options for a table. However, when the primary key constraint is generated, it includes the storage clause. Is there a way that I can disable that? If not, please consider that feature in the future. I'm using MS Sql Server. Two tables from my schema are shown below.
I'm running a Postgres Database on Aqua Data Studio 6.5.12 (Yes, it is a really old system, but i like it very much :) ).
I've got a query running normally in the Query Analyzer, but when I try to save it as a view, I'm receiving 'ERROR: Syntax error near SELECT'.
Do someone know what could be wrong in it?
Thank you!
ZeldaElfZeldaElf
1 Answer
The CASE statement is malformed.
Try modifying the SELECT to be like this:
Note that I am basing this behavior off of Postgres 9.3, although I don't think this particular behavior has changed in quite some time. I assume that your version of Postgres that Aqua Data Studio 6 is using is quite old, as, while I'm not familiar with that product, it would appear the most recent version is 14, indicating that it's likely many years old.