Search found 5 matches

by nuci
Thu Jun 16, 2005 3:21 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] FIND - Forum Integrated News Delivery - Input
Replies: 1078
Views: 236965

CREATE TABLE tablename (
colname SERIAL
);is equivalent to specifying:

CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL

Found at:

http://www.postgresql.org/docs/7.3/inte ... YPE-SERIAL
by nuci
Thu Jun 16, 2005 9:02 am
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] FIND - Forum Integrated News Delivery - Input
Replies: 1078
Views: 236965

Could be, but it gives an error already in the first field. It seems to be that the error is in the type of character. The readme says it has to be int4, I presumed type integer, length 4. Is this correct? I tried others, like char, any, text, but the error stays the same. Only error near character ...
by nuci
Wed Jun 15, 2005 6:39 pm
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.6] FIND - Forum Integrated News Delivery - Input
Replies: 1078
Views: 236965

Can somebody please help me with this problem? I think it's quite simple for someone who knows a little of MyGresSql. I'm trying to create a table as described in the read me from the above mentioned mod, this is the description for PostGreSql, not MySql: CREATE SEQUENCE phpbb_newsfeeds_id_seq start...
by nuci
Wed Jun 15, 2005 5:37 pm
Forum: 2.0.x Discussion
Topic: Find Integrated News Delivery table create probl, PostGreSql
Replies: 3
Views: 97

Think so too, but my database doesn't support mysql, only postgresql. That's why I used this PostGreSql schema, but I can't see what I'm doing wrong.
by nuci
Wed Jun 15, 2005 3:21 pm
Forum: 2.0.x Discussion
Topic: Find Integrated News Delivery table create probl, PostGreSql
Replies: 3
Views: 97

Find Integrated News Delivery table create probl, PostGreSql

Can somebody please help me with this problem? I think it's quite simple for someone who knows a little of MyGresSql. I'm trying to create a table as described in the read me from the above mentioned mod, this is the description for PostGreSql, not MySql: CREATE SEQUENCE phpbb_newsfeeds_id_seq start...

Go to advanced search