Forum OpenACS Q&A: Postgres table name MAX length?

Collapse
1: Postgres table name MAX length?
Posted by James Thornton on 12/20/01 09:33 PM
I'm using the metadata object table described in the ASJ KM article,
and it has the column for table name set to varchar(21) -- it's
truncating some of my existing table names.

What is the MAX length for a PG table in 7.x -- is it different for
7.0 and 7.1?

Collapse
2: Response to Postgres table name MAX length? (response to 1)
Posted by Don Baccus on 12/20/01 10:43 PM
It's configurable if you build from source.  As distributed, it's set to 32.  If you give it a name that's too long, PG will just truncate it, warn you, and continue on its way.