Skip to content
New issue

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

Invalid syntax on database table, example should work against 1.0 #40

Open
wdroste opened this issue Sep 21, 2017 · 0 comments
Open

Invalid syntax on database table, example should work against 1.0 #40

wdroste opened this issue Sep 21, 2017 · 0 comments

Comments

@wdroste
Copy link

wdroste commented Sep 21, 2017

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"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant