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

Posted by James Thornton on
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?

Posted by Don Baccus on
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.