examples-orms icon indicating copy to clipboard operation
examples-orms copied to clipboard

Invalid syntax on database table, example should work against 1.0

Open wdroste opened this issue 7 years ago • 0 comments

Example should work against 1.0

CockroachDB node starting at 2017-09-21 14:26:59.087913381 -0500 CDT
build:      CCL v1.0.5 @ 2017/08/24 17:43:46 (go1.8.3)
admin:      http://jackburton:2800
sql:        postgresql://root@jackburton:26257?sslmode=disable
logs:       /home/wdroste/tmp/cockroach-data/logs
store[0]:   path=/home/wdroste/tmp/cockroach-data
status:     initialized new cluster
clusterID:  e21342a8-06c0-41a8-bde8-3c1230ed0d72
nodeID:     1




CREATE TABLE IF NOT EXISTS product_orders (
  id           SERIAL PRIMARY KEY,
  product_id   INT    REFERENCES products(id),
  order_id     INT    REFERENCES orders(id) ON DELETE CASCADE
);

invalid syntax: statement ignored: unimplemented at or near "cascade"

wdroste avatar Sep 21 '17 21:09 wdroste