I took the white space between characters out of my script 'create.txt4' and
ran it on database 'test'. There were errors:
26
27 -- Create Orders Table
28
29 CREATE TABLE Orders
30 (
31 Order_num int NOT NULL,
32 Order_date datetime NOT NULL,
33 cust_id char(10) NOT NULL
34 );
CREATE TABLE
psql:create.txt 4:34: ERROR: type "datetime" does not exist
Does this mean this datatype doesn't exist on this line (34) or that it
doesn't exist at all? If it doesn't exist at all what is the correct
datatype to use here?
Also:
66
67 -- Define Foreign Keys
68 ALTER TABLE OrderItems ADD CONSTRAINT FK_OrderItems_O rders FOREIGN
KEY(order_num) REFERENCE Orders(order_nu m);
69 ALTER TABLE OrderItems ADD CONSTRAINT FK_OrderItems_P roducts FOREIGN KEY
(prod_id) REFERENCE Products(prod_i d);
70 ALTER TABLE Orders ADD CONSTRAINT FK_Orders_Custo mers FOREIGN KEY (cust_id)
REFERENCE Customers(cust_ id);
71 ALTER TABLE Products ADD CONSTRAINT FK_Products_Ven dors FOREIGN KEY
(vend_id) REFERENCE Vendors(vend_id );
generates these errors:
psql:create.txt 4:68: ERROR: syntax error at or near "REFERENCE" at character
83
psql:create.txt 4:69: ERROR: syntax error at or near "REFERENCE" at character
84
psql:create.txt 4:70: ERROR: syntax error at or near "REFERENCE" at character
77
psql:create.txt 4:71: ERROR: syntax error at or near "REFERENCE" at character
79
What, where is the syntac error??
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
