Hello Team,

I am trying to insert a null guid directly to the DB. I use the following snippet

	QueryColumnExpression nullParameter =
					Column.Parameter(DBNull.Value, new GuidDataValueType(UserConnection.DataValueTypeManager));
				update.Set("ResponseDetailsId", nullParameter);

I get the following exception

System.NotSupportedException: The CLR type Terrasoft.Core.DB.QueryColumnExpression isn't supported by Npgsql or your PostgreSQL. If you wish to map it to a PostgreSQL composite type you need to register it before usage, please refer to the documentation.
 

If this is not a suitable way, which is the proper way to insert a null guid directly in a PostgreSQL db from C# code ?

Hi Community,

We decided to install a new Creatio Application instance on our linux based servers. We would like to know if we could use the lastest version of PostgreSQL (13 or 14)?

Thanks in Advance.

Best Regards,

Pedro Pinheiro

Team,

Trying to look for the "Indexing for full-text Search" option for a custom section in 7.17.2.1728_SalesTeam_Softkey_PostgreSQL_ENU and 7.17.3.1377_SalesTeam_Softkey_PostgreSQL_ENU packages deployed on-site. Though I find "Indexing for full-text Search" option in 7.17.3.1377 cloud instance, I am not able to find the same options in the site locally hosted in my laptop. Is there a way by which we can enable it?

Screenshot attached.