Hi,
when I run H2 in postgres compatibility mode an run the following postgres
valid SQL statement to rename the column:
CREATE TABLE Test (
id SERIAL PRIMARY KEY
, uid VARCHAR(255) NOT NULL
);
ALTER TABLE Test RENAME COLUMN uid TO userId;
I get the following error:
Syntax error in SQL statement "ALTER TABLE "Test" RENAME COLUMN[*] UID TO
USERID "; expected "TO"; SQL statement:
ALTER TABLE Test RENAME COLUMN uid TO userId [42001-168]
Any Idea ?
(I know if I use the H2 syntax it works - but I want to use the postgresql
compatibility mode)
Thank you
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/QN8jG_waF-sJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
