Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Pgadmin Support > Re: New sequenc...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 7 Topic 1933 of 2158
Post > Topic >>

Re: New sequence in 1.8.1

by andy.shellam-lists@[EMAIL PROTECTED] ("Andy Shellam") Jan 14, 2008 at 08:44 PM

------=_Part_9264_6538340.1200343446084
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Dave,

I see your point about it not doing anything after the column is created,
as
a serial column is just an integer column with a new default value.  I
liked
the idea of being able to specify a different sequence to use with the
serial column, but having said that I can't think of many uses where you'd
want to!

Unless you can make the sequence combo of any use (e.g. to change the
default sequence used when creating the column) I'd say get rid of it!

Thanks,

Andy

On 1/14/08, Dave Page <dpage@[EMAIL PROTECTED]
> wrote:
>
> On 14/01/2008, Guillaume Lelarge <guillaume@[EMAIL PROTECTED]
> wrote:
> > Andy Shellam wrote:
> > > I've noticed a small bug in 1.8.1 on Windows XP (SP2).
> > >
> > > If I create a new table, and add a new serial column to it before
> OK'ing
> > > the "create table" dialog, the "sequence" drop-down remains disabled
> for
> > > the column.
> > >
> > > If I create a table, and OK the dialog without any columns in, then
go
> > > back and modify the table and add a new serial column to it, the
> > > "sequence" drop-down is enabled correctly.
> > >
> >
> > I just had a quick look and you're right. Behaviour is different when
> > table is already created. I think we need to fix this so the behavior
> > remains consistent. I'm not sure what value has the "<new sequence>"
> > text. So should we add this text when we add a serial column at table
> > creation time or should we suppress this text ?
>
> Yeah, that box just doesn't work when the dialogue is called from the
> table dialogue (even when the control is enabled) - it tries to do
> things that just aren't possible given the way the two dialogues
> communicate. It also doesn't do anything when changing an existing
> column because at that point it thinks the column is an integer column
> with a default value.
>
> I'm of half a mind to remove the sequence combo box altogether.
>
> Thoughts?
>
> /D
>

------=_Part_9264_6538340.1200343446084
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Dave,<br><br>I see your point about it not doing anything after the
column is created, as a serial column is just an integer column with a
new default value.&nbsp; I liked the idea of being able to specify a
different sequence to use with the serial column, but having said that
I can&#39;t think of many uses where you&#39;d want to!
<br><br>Unless you can make the sequence combo of any use (e.g. to
change the default sequence used when creating the column) I&#39;d say get
rid of it!<br><br>Thanks,<br><span
class="sg"><br>Andy</span><br><br><div><span class="gmail_quote">On
1/14/08, <b class="gmail_sendername">Dave Page</b> &lt;<a
href="mailto:dpage@[EMAIL PROTECTED]
">dpage@[EMAIL PROTECTED]
>
&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;">On 14/01/2008, Guillaume Lelarge &lt;<a
href="mailto:guillaume@[EMAIL PROTECTED]
">
guillaume@[EMAIL PROTECTED]
>&gt; wrote:<br>&gt; Andy Shellam wrote:<br>&gt;
&gt; I&#39;ve noticed a small bug in 1.8.1 on Windows XP (SP2).<br>&gt;
&gt;<br>&gt; &gt; If I create a new table, and add a new serial column to
it before OK&#39;ing
<br>&gt; &gt; the &quot;create table&quot; dialog, the
&quot;sequence&quot; drop-down remains disabled for<br>&gt; &gt; the
column.<br>&gt; &gt;<br>&gt; &gt; If I create a table, and OK the dialog
without any columns in, then go
<br>&gt; &gt; back and modify the table and add a new serial column to it,
the<br>&gt; &gt; &quot;sequence&quot; drop-down is enabled
correctly.<br>&gt; &gt;<br>&gt;<br>&gt; I just had a quick look and
you&#39;re right. Behaviour is different when
<br>&gt; table is already created. I think we need to fix this so the
behavior<br>&gt; remains consistent. I&#39;m not sure what value has the
&quot;&lt;new sequence&gt;&quot;<br>&gt; text. So should we add this text
when we add a serial column at table
<br>&gt; creation time or should we suppress this text ?<br><br>Yeah, that
box just doesn&#39;t work when the dialogue is called from the<br>table
dialogue (even when the control is enabled) - it tries to do<br>things
that just aren&#39;t possible given the way the two dialogues
<br>communicate. It also doesn&#39;t do anything when changing an
existing<br>column because at that point it thinks the column is an
integer column<br>with a default value.<br><br>I&#39;m of half a mind to
remove the sequence combo box altogether.
<br><br>Thoughts?<br><br>/D<br></blockquote></div><br>

------=_Part_9264_6538340.1200343446084--
 




 7 Posts in Topic:
New sequence in 1.8.1
andy.shellam-lists@[EMAIL  2008-01-13 14:30:03 
Re: New sequence in 1.8.1
guillaume@[EMAIL PROTECTE  2008-01-14 10:12:14 
Re: New sequence in 1.8.1
dpage@[EMAIL PROTECTED]   2008-01-14 13:02:51 
Re: New sequence in 1.8.1
andy.shellam-lists@[EMAIL  2008-01-14 20:44:06 
Re: New sequence in 1.8.1
dpage@[EMAIL PROTECTED]   2008-01-15 09:38:01 
Re: New sequence in 1.8.1
guillaume@[EMAIL PROTECTE  2008-01-15 11:28:26 
Re: New sequence in 1.8.1
dpage@[EMAIL PROTECTED]   2008-01-18 15:44:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 18:28:03 CST 2008.