Re: No length checking for "name" input

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
Cc: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: No length checking for "name" input
Date: 2006-03-21 14:46:25
Message-ID: 16577.1142952385@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Donald Fraser" <postgres(at)kiwi-fraser(dot)net> writes:
> There appears to be no length checking for data types of "name".

What there is is automatic truncation to the maximum allowed length (63
by default). This is the same behavior specified for identifiers in the
SQL standard, and it's also the same behavior as for, say, casting to
varchar(63). So I don't see why you'd expect something different.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2006-03-21 16:06:45 Re: BUG #2343: Silent installers fails
Previous Message Kashin Oleg 2006-03-21 07:53:04 BUG #2345: odbc driver doesn't work