No length checking for "name" input

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Subject: No length checking for "name" input
Date: 2006-03-20 22:41:11
Message-ID: 00a601c64c6f$6321acf0$0264a8c0@demolish1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL versions: 7.4.x and 8.0.x
(I don't have a 8.1.x installation to test against)

There appears to be no length checking for data types of "name".

For example:
template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates('::name) AS name_len;
name_len
----------
63
(1 row)

I get exactly the same result for this query which is obviously not the same length and yet I get no error?

template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates(date,date)'::name) AS name_len;
name_len
----------
63
(1 row)

I don't know whether you consider this a bug, certainly most of the other data types appear to have range checking as part of the input.

Regards
Donald Fraser

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kashin Oleg 2006-03-21 07:53:04 BUG #2345: odbc driver doesn't work
Previous Message Tom Lane 2006-03-20 22:12:05 Re: BUG #2342: Extremely bad performance on a specific query, compared to 7.4