[SQL] SQL Statement too long

2001-08-20 Thread Jayson Callaway
e SQL statement as a string used through the Statement class, so I tried using a PreparedStatement, but I am still getting the same problem. -- Jayson Callaway ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresq

[SQL] changes to table creation syntax in 7.1.2?

2001-08-29 Thread Jayson Callaway
error that says it can not create the reference because the table category does not exist. How do I setup this type of reference structure in 7.1.2? Did the syntax change? I am running under Linux. -- Jayson Callaway ---(end of broadcast)--- TIP 1

RE: [SQL] changes to table creation syntax in 7.1.2?

2001-08-30 Thread Jayson Callaway
, "parent_category_uid" int4 NULL REFERENCES test_cat(uid) ); psql:test:6: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'test_cat_pkey' for table 'test_cat' psql:test:6: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY chec