search

FreiMarkt / Database

Database Scripts
1 stars 0 forks source link

Problems with DB indexes #7

Open dainiusjocas opened 10 years ago

dainiusjocas commented 10 years ago

When executing SQL from file 

Step 3/ Scripts To Create Index
, e.g .

CREATE INDEX "fki_ApproveOrderFK"
  ON "ApproveOrder"
  USING btree
  ("ProductID" COLLATE pg_catalog."default");

I receive an error that:

ERROR:  collations are not supported by type uuid

********** Error **********

ERROR: collations are not supported by type uuid
SQL state: 42804
yongzhou1314 commented 10 years ago

the index can be created automatically, you don't have to create it by your self.

On Sat, May 3, 2014 at 10:45 PM, Dainius Jocas notifications@github.comwrote:

When executing SQL from file

Step 3/ Scripts To Create Index

, e.g .

CREATE INDEX "fki_ApproveOrderFK" ON "ApproveOrder" USING btree ("ProductID" COLLATE pg_catalog."default");

I receive an error that:

ERROR: collations are not supported by type uuid

\ Error **

ERROR: collations are not supported by type uuid SQL state: 42804

— Reply to this email directly or view it on GitHubhttps://github.com/FreiMarkt/Database/issues/7 .