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
Следующее
От: tomas@tuxteam.de
Дата:
Сообщение: Re: Formatting Curmudgeons WAS: MMAP Buffers