Hi,
sorry wrong cut/paste
Still the same error :
Constraint "PRIMARY KEY | UNIQUE (TYPES)" not found; SQL statement:
CREATE TABLE FCOUNTS( ID IDENTITY primary key , NR VARCHAR,
NAME VARCHAR, TYPES VARCHAR, TAG VARCHAR, Foreign key(types)
references ftypes(types), Foreign key(tag) references ftags(tag) )
[90057-200]
create table ftypes(
ID IDENTITY primary key ,
types VARCHAR
);
create unique index ftype_idx on ftypes(types);
create table ftags(
ID IDENTITY primary key ,
tag VARCHAR
);
create unique index ftag_idx on ftags(tag);
CREATE TABLE FCOUNTS(
ID IDENTITY primary key ,
NR VARCHAR,
NAME VARCHAR,
TYPES VARCHAR,
TAG VARCHAR,
Foreign key(types) references ftypes(types),
Foreign key(tag) references ftags(tag)
);
On 11/23/21 14:51, Andrei Tokar wrote:
I wonder if that's because of *create unique index ftag_idx on
fintags(tag); *
contains invalid table name?
On Sunday, November 21, 2021 at 4:07:10 AM UTC-5 yambo wrote:
Hi,
The following works in 1.4.200, but gives the following error in
1.4.201 :
Any ideas ?
Kind regards
Willy
Constraint "PRIMARY KEY | UNIQUE (TYPES)" not found; SQL statement:
CREATE TABLE FCOUNTS( ID IDENTITY primary key , NR VARCHAR,
NAME VARCHAR, TYPES VARCHAR, TAG VARCHAR, Foreign key(types)
references ftypes(types), Foreign key(tag) references
ftags(tag) )
Code :
create table ftypes(
ID IDENTITY primary key ,
types VARCHAR
);
create unique index ftype_idx on ftypes(types);
create table ftags(
ID IDENTITY primary key ,
tag VARCHAR
);
create unique index ftag_idx on fintags(tag);
CREATE TABLE FCOUNTS(
ID IDENTITY primary key ,
NR VARCHAR,
NAME VARCHAR,
TYPES VARCHAR,
TAG VARCHAR,
Foreign key(types) references ftypes(types),
Foreign key(tag) references ftags(tag)
);
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/3d57f368-0b7a-4960-81ec-4cdc82ab4b3an%40googlegroups.com
<https://groups.google.com/d/msgid/h2-database/3d57f368-0b7a-4960-81ec-4cdc82ab4b3an%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/cfa47051-ec4b-45a9-f615-c39dc2367522%40gmail.com.
