============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Dinh Le
Your email address : dinh@flic.net
Category : runtime: back-end
Severity : non-critical
Summary: pg_attribute a.attlen does not return correct values
System Configuration
--------------------
Operating System : Linux 2.0.36
PostgreSQL version : 6.4.2
Compiler used : gcc 2.7.2
Hardware:
---------
Versions of other tools:
------------------------
gnu make
--------------------------------------------------------------------------
Problem Description:
--------------------
Execute the following SQL command
SELECT a.attnum, a.attname, t.typname, a.attlen,
a.atttypmod, a.attnotnull, a.atthasdef
FROM pg_class c, pg_attribute a, pg_type t
WHERE c.relname = 'a table'
and a.attnum > 0
and a.attrelid = c.oid
and a.atttypid = t.oid
ORDER BY attnum;
used to return the correct value for a.attlen. The
current Postgres 6.4.2 for Linux always return -1.
--------------------------------------------------------------------------
Test Case:
----------
Run psql and execute the SQL command
SELECT a.attnum, a.attname, t.typname, a.attlen,
a.atttypmod, a.attnotnull, a.atthasdef
FROM pg_class c, pg_attribute a, pg_type t
WHERE c.relname = 'table'
and a.attnum > 0
and a.attrelid = c.oid
and a.atttypid = t.oid
ORDER BY attnum;
where 'table' is an existing table.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------