SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA 7.4.435 + Postgres 9.5 = table code error

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA 7.4.435 + Postgres 9.5 = table code error
Author Message
LonelyWalker



Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation

Post SA 7.4.435 + Postgres 9.5 = table code error Reply with quote
May be it's already solved, but now - from context menu on any table by clicking "Code" link error eccurs:

Code:

/*
Cannot find source code for "public"."report_data".
DDL utility returned error:
C:\Program Files (x86)\PostgreSQL\9.5\bin\pg_dump.exe: illegal option -- i
Try "pg_dump --help" for more information.
*/


Thank you for attention
Wed Feb 10, 2016 6:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I guess it copied something from the previous version settings.

Please open SQL Assistant's Options.
Click DB Options tab
Select PostgreSQL type on the left
Click DDL Extraction utility option on the right and enter ddl\PostgreSQL_ddl.bat


Save options. This should fix the issue
Wed Feb 10, 2016 10:14 am View user's profile Send private message
LonelyWalker



Joined: 16 Oct 2015
Posts: 18
Country: Russian Federation

Post Reply with quote
Now it said
Code:
/*
Cannot find source code for "public"."equipment".
DDL utility returned error:
pg_dump: server version: 9.5.0; pg_dump version: 9.4.1
pg_dump: aborting because of server version mismatch
*/


When i replace all files in folder ddl\pg_dump with actual from PG 9.5, previous eror occurs (illegal option -- i ).
Wed Feb 10, 2016 11:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
Quote:
When i replace all files


If you do that, you would also need to edit the PostgreSQL_DDL.bat batch file to make it compatible with your pg_dump version.
Wed Feb 10, 2016 11:58 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.