schema doesn't install in PostgreSQL
Josh Waihi - August 13, 2009 - 21:38
| Project: | Facebook-style Statuses (Microblog) |
| Version: | 6.x-2.0-rc1 |
| Component: | Code - Functionality |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
CREATE TABLE facebook_status (
sid serial CHECK (sid >= 0),
uid int_unsigned NOT NULL default 0,
pid int_unsigned NOT NULL default 0,
status_time int NOT NULL default 0,
status text(1024) NOT NULL default '',
PRIMARY KEY (sid)
)a TEXT data type doesn't have a length. MySQL is OK with this but PostgreSQL chokes. Can you please remove the length?
#1
I can't actually find any PostgreSQL docs that say this, but the MySQL docs seem to indicate that a length isn't required, so I'll go ahead with this when I get some time tomorrow. The original logic was based on a misunderstanding of the way the text data type uses space, so there's no reason not to change it. I suppose that also means the maximum character limit can be upped to 21,844...
#2
#3
Automatically closed -- issue fixed for 2 weeks with no activity.