On Mon, Jan 28, 2019 at 03:17:47PM +0100, Laurenz Albe wrote:
> > Now, I would have thought that the "IF NOT EXISTS" part of
> > the CREATE EXTENSION would have allowed the subsequent CREATE
> > INDEX to succeed.
> >
> > I am wrong ?
>
> No, you are right.
>
> The "pg_trgm" extension does *not*
Karsten Hilbert wrote:
> the Orthanc DICOM server tries to create a trigram index using this code:
>
> db->Execute(
> "CREATE EXTENSION IF NOT EXISTS pg_trgm; "
> "CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers
> USING gin(value gin_trgm_ops);");
>
Hello all,
the Orthanc DICOM server tries to create a trigram index using this code:
db->Execute(
"CREATE EXTENSION IF NOT EXISTS pg_trgm; "
"CREATE INDEX DicomIdentifiersIndexValues2 ON DicomIdentifiers
USING gin(value gin_trgm_ops);");
which results in this s