This is me gnashing teeth... <odd noises>
I got tired of constantly rebuilding my server every time something went wrong so I started a little project to make an automated script to rebuild dirtsand. I was making fairly good progress getting up to creating the database. Then something flashed by my eye that either didn't exist before or I just never noticed...
In dbinit.sql, I received an error,,,
- Code: Select all
ERROR: syntax error at or near "ON"
LINE 1: CREATE INDEX ON auth."Scores" ("OwnerIdx", "Name");
I'm not sure whether this is where the error is or it happened somewhere before in the code... I don't know enough SQL to find it. Has anyone else seen this?
EDIT: I looked in auth."Scores" and no index was created there.
Ummm, shouldn't there be a name for the index? CREATE INDEX <name> ON <table...> (just asking.. IDK)