We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
TEXT
PostgreSQL allows TEXT columns to be used in keys (without having to specify a prefix length), but Doltgres does not.
PostgreSQL:
CREATE TABLE users ( username text NOT NULL PRIMARY KEY, karma numeric NOT NULL ); CREATE TABLE
Doltgres:
CREATE TABLE users ( username text NOT NULL PRIMARY KEY, karma numeric NOT NULL ); ERROR: blob/text column 'username' used in key specification without a key length (errno 1105) (sqlstate HY000)
Discovered while testing multiple data dumps, including: Hasura, usda-r18, iso-3166
The text was updated successfully, but these errors were encountered:
No branches or pull requests
PostgreSQL allows
TEXT
columns to be used in keys (without having to specify a prefix length), but Doltgres does not.PostgreSQL:
Doltgres:
Discovered while testing multiple data dumps, including: Hasura, usda-r18, iso-3166
The text was updated successfully, but these errors were encountered: