Thread: No smallserial data type in version 1.16.1
<div class="WordSection1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">I have searchedand not seen any reference to this issue. I apologize if it has been brought up already.</span><p class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif""> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">InpgAdmin III version 1.16.1 the smallserial data type is not listedwhen creating a new column. It works fine when later editing the SQL manually.</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> </span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thiswas added in Postgres 9.2</span><p class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif""><a href="http://www.postgresql.org/docs/9.2/interactive/datatype-numeric.html">http://www.postgresql.org/docs/9.2/interactive/datatype-numeric.html</a></span><p class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif""> </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">MS</span></div>
On Thu, Mar 14, 2013 at 12:44 AM, Matthew Syphus <MSyphus@lhtac.org> wrote: > I have searched and not seen any reference to this issue. I apologize if it > has been brought up already. > > > > In pgAdmin III version 1.16.1 the smallserial data type is not listed when > creating a new column. It works fine when later editing the SQL manually. > > > > This was added in Postgres 9.2 > > http://www.postgresql.org/docs/9.2/interactive/datatype-numeric.html Yeah, this was never added. Frankly, I've never heard of it until now - read into that what you will :-p Any volunteers to implement it? It should be a good little first time starter project. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, 2013-03-14 at 13:48 +0000, Dave Page wrote: > On Thu, Mar 14, 2013 at 12:44 AM, Matthew Syphus <MSyphus@lhtac.org> wrote: > > I have searched and not seen any reference to this issue. I apologize if it > > has been brought up already. > > > > > > > > In pgAdmin III version 1.16.1 the smallserial data type is not listed when > > creating a new column. It works fine when later editing the SQL manually. > > > > > > > > This was added in Postgres 9.2 > > > > http://www.postgresql.org/docs/9.2/interactive/datatype-numeric.html > > Yeah, this was never added. Frankly, I've never heard of it until now > - read into that what you will :-p > > Any volunteers to implement it? It should be a good little first time > starter project. > As nobody asked for it, and that I had a little extra time, I've done it. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com