zilzila
zilzila
This problem occurs not only with jsonb, but also in a simpler case - if you try to index not by the [additional] tsvector field, but by the text field,...
In TDBConnection.GetDatatypeByNativeType() the citext type oid is obtained: ```pascal TypeOid := GetVar('SELECT '+EscapeString(Datatypes[i].Name.ToLower)+'::regtype::oid'); ``` If replace this query with ```delphi TypeOid := GetVar('SELECT oid FROM '+QuoteIdent('pg_type')+' WHERE '+QuoteIdent('typname')+' = '+EscapeString(Datatypes[i].Name.ToLower));...
Another demonstration of this bug, without opening the file: 1. Clear the default query tab 2. Open a new query tab, write something there 3. Close HeidiSQL 4. Start HeidiSQL...