[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Re: [BUGS] BUG #8260: problem with sequence and tablename
From: Daniel Degasperi <daniel.degasperi () r3-gis ! com>
Date: 2013-06-28 9:59:51
Message-ID: 51CD5E97.2040005 () r3-gis ! com
[Download RAW message or body]
Am 27.06.2013 19:10, schrieb Tom Lane:
> daniel.degasperi@r3-gis.com writes:
>> CREATE TABLE t23456789012345678901234567890123456789012345678901
>> (
>> t1234_id serial,
>> PRIMARY KEY (t1234_id)
>> )
>> WITH (
>> OIDS=FALSE
>> );
>> This generated the sequence:
>> CREATE SEQUENCE
>> t2345678901234567890123456789012345678901234567890_t1234_id_seq
> That's operating as designed.
>
>> The table-part in the sequence name was truncated.
> Would you rather it failed entirely? You're up against the limit on
> name length (63 bytes in a standard Postgres build).
I don't know if a fail is the best solution, maybe a NOTICE, that the
sequence name is not constructed as might be naively expected, would be
appropriate.
thanks and regards,
Daniel
>
> regards, tom lane
--
*Daniel Degasperi*
Project manager
*R3 GIS* Srl - GmbH
I-39012 Merano/Meran (BZ) - Via Johann Kravogl-Str. 2
I-20133 Milano (MI) - Via Vallisneri 2
web: www.r3-gis.com <http://www.r3-gis.com/>
Email: daniel.degasperi@r3-gis.com <mailto:daniel.degasperi@r3-gis.com>
Tel. : +39 0473 494949
Fax : +39 0473 069902
*ATTENZIONE!* Le informazioni contenute nella presente e-mail e nei
documenti eventualmente allegati sono confidenziali. La loro diffusione,
distribuzione e/o riproduzione da parte di terzi, senza autorizzazione
del mittente è vietata e può violare il D. Lgs. 196/2003. In caso di
ricezione per errore, Vogliate immediatamente informare il mittente del
messaggio e distruggere la e-mail.
*ACHTUNG!* Die in dieser Nachricht oder in den beigelegten Dokumenten
beinhalteten Informationen sind streng vertraulich. Ihre Verbreitung
und/oder ihre Wiedergabe durch Dritte ist ohne Erlaubnis des Absenders
verboten und verstößt gegen das Legislativdekret 196/2003. Sollten Sie
diese Mitteilung irrtümlicherweise erhalten haben, bitten wir Sie uns
umgehend zu informieren und anschließend die Mitteilung zu vernichten.
*WARNING!* This e-mail may contain confidential and/or privileged
information. If you are not the intended recipient (or have received
this e-mail in error) please notify the sender immediately and destroy
this e-mail. Any unauthorised copying, disclousure or distribution of
the material in this e-mail is strictly forbidden and could be against
the law (D. Lgs. 196/2003)
[Attachment #3 (text/html)]
<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Am 27.06.2013 19:10, schrieb Tom Lane:<br>
</div>
<blockquote cite="mid:25002.1372353006@sss.pgh.pa.us" type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" \
href="mailto:daniel.degasperi@r3-gis.com">daniel.degasperi@r3-gis.com</a> writes: \
</pre> <blockquote type="cite">
<pre wrap="">CREATE TABLE t23456789012345678901234567890123456789012345678901
(
t1234_id serial,
PRIMARY KEY (t1234_id)
)
WITH (
OIDS=FALSE
);
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">This generated the sequence:
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">CREATE SEQUENCE
t2345678901234567890123456789012345678901234567890_t1234_id_seq
</pre>
</blockquote>
<pre wrap="">
That's operating as designed.
</pre>
<blockquote type="cite">
<pre wrap="">The table-part in the sequence name was truncated.
</pre>
</blockquote>
<pre wrap="">
Would you rather it failed entirely? You're up against the limit on
name length (63 bytes in a standard Postgres build).</pre>
</blockquote>
I don't know if a fail is the best solution, maybe a NOTICE, that
the sequence name is not constructed as might be naively expected,
would be appropriate.<br>
<br>
thanks and regards,<br>
Daniel<br>
<br>
<blockquote cite="mid:25002.1372353006@sss.pgh.pa.us" type="cite">
<pre wrap="">
regards, tom lane
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<div class="moz-signature">
<table style="display: block;" width="100%" align="left"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="2"> <font face="DejaVu
Sans,Verdana,Arial,Helvetica,sans-serif" size="2"> <strong>Daniel
Degasperi</strong><br>
Project manager<br>
<br>
<strong><font color="#EE9018">R3 </font><font
color="#9C9E9F">GIS</font></strong> Srl - GmbH<br>
<br>
I-39012 Merano/Meran (BZ) - Via Johann Kravogl-Str. 2<br>
I-20133 Milano (MI) - Via Vallisneri 2<br>
web: <a href="http://www.r3-gis.com/" \
target="_blank">www.r3-gis.com</a><br> Email: <a \
href="mailto:daniel.degasperi@r3-gis.com" \
target="_blank">daniel.degasperi@r3-gis.com</a><br> Tel. : +39 0473 494949<br>
Fax : +39 0473 069902<br>
</font></td>
</tr>
<tr>
<td colspan="2"> <font face="DejaVu
Sans,Verdana,Arial,Helvetica,sans-serif" size="1"
color="#888888"><br>
<strong>ATTENZIONE!</strong> Le informazioni contenute
nella presente e-mail e nei documenti eventualmente
allegati sono confidenziali. La loro diffusione,
distribuzione e/o riproduzione da parte di terzi,
senza autorizzazione del mittente è vietata e può
violare il D. Lgs. 196/2003. In caso di ricezione per
errore, Vogliate immediatamente informare il mittente
del messaggio e distruggere la e-mail.<br>
<br>
<strong>ACHTUNG!</strong> Die in dieser Nachricht oder
in den beigelegten Dokumenten beinhalteten
Informationen sind streng vertraulich. Ihre
Verbreitung und/oder ihre Wiedergabe durch Dritte ist
ohne Erlaubnis des Absenders verboten und verstößt
gegen das Legislativdekret 196/2003. Sollten Sie diese
Mitteilung irrtümlicherweise erhalten haben, bitten
wir Sie uns umgehend zu informieren und anschließend
die Mitteilung zu vernichten.<br>
<br>
<strong>WARNING!</strong> This e-mail may contain
confidential and/or privileged information. If you are
not the intended recipient (or have received this
e-mail in error) please notify the sender immediately
and destroy this e-mail. Any unauthorised copying,
disclousure or distribution of the material in this
e-mail is strictly forbidden and could be against the
law (D. Lgs. 196/2003)<br>
<br>
<br>
</font></td>
</tr>
</tbody>
</table>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic