By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

PostgreSQL Alias Name Length

P: n/a
Hi...

I am currently working on a Java-based product that is backed by
PostgreSQL (among other databases).

I have noticed that PostgreSQL appears to truncate column alias names
after 31 characters. I have replicated this through JDBC (in Java),
PEAR (in PHP), and on the command-line interface (psql).

For example (this is from the psql command-line tool):

SELECT rss_headline_id as abcdefghijklmnopqrstuvwxyz123456, title, url
FROM news_rss_headlines headlines WHERE rss_headline_id = 22833;
NOTICE: identifier "abcdefghijklmnopqrstuvwxyz123456" will be
truncated to "abcdefghijklmnopqrstuvwxyz12345"

Granted, having alias names this long may seem a little goofy, but I
am working on an object Persistence Layer that has the capability of
sometimes generating long aliases behind the scenes.

Does anyone know if this is a known limitation to PostgreSQL ? (I
couldn't find any documentation which specifically addresses this
issue) Is there a way to make PostreSQL support longer alias names?
Are there any plans to address this in future version of PostgreSQL?
Or... should I just "suck it up" and fix my code? ;-)

I am using PostgreSQL version 7.2.3 on a RedHat 8 platform.

Any insights or comments would be appreciated.

Thanks,

--Bill K.

----
Bill Kratzer
Senior Software Developer
CommNav, Inc.
http://www.commnav.com
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
As of version 7.3, the maximum identifier length has been increased to
63 characters. You should probably upgrade anyway, as there are quite a
few improvements in 7.3 (7.3.3 is the latest stable version).
HTH
Ron
Bill Kratzer wrote:
Hi...

I am currently working on a Java-based product that is backed by
PostgreSQL (among other databases).

I have noticed that PostgreSQL appears to truncate column alias names
after 31 characters. I have replicated this through JDBC (in Java),
PEAR (in PHP), and on the command-line interface (psql).

For example (this is from the psql command-line tool):

SELECT rss_headline_id as abcdefghijklmnopqrstuvwxyz123456, title, url
FROM news_rss_headlines headlines WHERE rss_headline_id = 22833;
NOTICE: identifier "abcdefghijklmnopqrstuvwxyz123456" will be
truncated to "abcdefghijklmnopqrstuvwxyz12345"

Granted, having alias names this long may seem a little goofy, but I
am working on an object Persistence Layer that has the capability of
sometimes generating long aliases behind the scenes.

Does anyone know if this is a known limitation to PostgreSQL ? (I
couldn't find any documentation which specifically addresses this
issue) Is there a way to make PostreSQL support longer alias names?
Are there any plans to address this in future version of PostgreSQL?
Or... should I just "suck it up" and fix my code? ;-)

I am using PostgreSQL version 7.2.3 on a RedHat 8 platform.

Any insights or comments would be appreciated.

Thanks,

--Bill K.

----
Bill Kratzer
Senior Software Developer
CommNav, Inc.
http://www.commnav.com


Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.