Thread: No smallserial data type in version 1.16.1

No smallserial data type in version 1.16.1

From
"Matthew Syphus"
Date:
<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>

Re: No smallserial data type in version 1.16.1

From
Dave Page
Date:
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



Re: No smallserial data type in version 1.16.1

From
Guillaume Lelarge
Date:
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