Deprecated: Function split() is deprecated in /home/tbriggs/public_html/s9y/plugins/serendipity_event_metadesc/serendipity_event_metadesc.php on line 101

0

Truncate This

Posted by Tom
on Tuesday, June 5. 2007
Just stumbled across this little nugged from the PostgresSQL documention:

The system uses no more than NAMEDATALEN-1 characters of an identifier; longer names can be written in commands, but they will be truncated. By default, NAMEDATALEN is 64 so the maximum identifier length is 63. If this limit is problematic, it can be raised by changing the NAMEDATALEN constant in src/include/postgres_ext.h.


Err... yeah, I'd say that's problematic... if I specify a table in a query, I want to either query that table or be notified that it doesn't exist. Don't go modifying the table name on me...
PostgreSQL
Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

No comments

Add Comment



Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.