smallserial / serial2
От | Mike Pultz |
---|---|
Тема | smallserial / serial2 |
Дата | |
Msg-id | 023001cbffc3$46f77840$d4e668c0$@mikepultz.com обсуждение исходный текст |
Ответы |
Re: smallserial / serial2
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: smallserial / serial2 (Brar Piening <brar@gmx.de>) |
Список | pgsql-hackers |
<div class="WordSection1"><p class="MsoPlainText">I use tables all the time that have sequences on smallint's; <p class="MsoPlainText"> <pclass="MsoPlainText">I’d like to simplify my create files by not having to create the sequence first,but I also don’t want to give up those 2 bytes per column!<p class="MsoPlainText"> <p class="MsoPlainText">Can thisbe added?<p class="MsoPlainText"> <p class="MsoPlainText">Mike<p class="MsoPlainText"> <p class="MsoPlainText"> <p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">--- postgresql-9.0.4/src/backend/parser/parse_utilcmd.c2011-04-14 23:15:53.000000000 -0400</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">+++ postgresql-9.0.4.new/src/backend/parser/parse_utilcmd.c 2011-04-20 21:10:26.000000000 -0400</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">@@ -280,8 +280,15 @@</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console""> {</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console""> char *typname = strVal(linitial(column->typeName->names));</span><pclass="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole""> </span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole"">- if (strcmp(typname, "serial") == 0 ||</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">- strcmp(typname, "serial4")== 0)</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">+ if (strcmp(typname, "smallserial") == 0 ||</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole"">+ strcmp(typname, "serial2") == 0)</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">+ {</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console"">+ is_serial = true;</span><pclass="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">+ column->typeName->names= NIL;</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">+ column->typeName->typeOid = INT2OID;</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole"">+ }</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole"">+ else if (strcmp(typname, "serial") == 0 ||</span><pclass="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">+ strcmp(typname, "serial4") == 0)</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole""> {</span><p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"LucidaConsole""> is_serial = true;</span><p class="MsoPlainText"><spanstyle="font-size:10.0pt;font-family:"Lucida Console""> column->typeName->names= NIL;</span></div>
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Robert HaasДата:
Сообщение: Re: pg_dump --binary-upgrade vs. ALTER TYPE ... DROP ATTRIBUTE