Hello,

When I try to generate project for PostgreSQL with marked checkbox 'Generate stored procedure'
I get following error in project log:
Error: Stored procedures for test1 failed to create. Error message: System.ArgumentException: Keyword not supported: 'port'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at CodeComplete.Wizard40.GlobalClass.ExecuteDataEntryBatchQuery(DataSourceManager ds, String Sql, String ProjectName)
at CodeComplete.Wizard40.GlobalClass.GenerateStoredProcedures(DataSourceBase ds, ProviderType Provider, String Proj


Table I've used : test1 (id - integer, value - character varying 20)


Thanks in advance.
Michael

In the current version, the generation of stored procedures only works for SQL Server. The templates for generating stored procedures for all the other providers do not work. We are looking for collaborators who can help us write the templates for the next version of Code Complete. Would you be willing to do that for the case of PostgreSQL ?

Regards

Philip

Thank's for reply.
I'm looking for code generation solution for PostgreSQL, so cooperation could be on my way, please write me an email about details.

Best regards.
Michael