Thread: Autocompletion and Table cell edition problems

Autocompletion and Table cell edition problems

From
Olivier Bouiron
Date:
Hi.
I have 2 problems since a long time, they are just irritating but they 
are not very importants.
I'm using pgadminIII 8.10 and ubuntu 9.10 (but these problems seems to 
be reccurents on linux since a long time, before pga8.10!)
I used synaptic to get pgadmin.

1) I open the frame that add a column in a table (in the column's menu 
of table properties)
Then I want to set the type of my column using the combobox. The bug is 
that I can't edit it for autocompletion, i just can select the type I 
want in the combo, but it's impossible to enter in edition in it.

2) I want to edit a table in order to change a column value.
So, I edit a cell, but I decide not to change the value, so I stop the 
cell edition without any change.
Then, I can't close the frame normaly: pgadmin ask me if I want to save 
the modifications
=> If I say 'Yes', then I can't close the frame because, again and again 
I'll get the message asking me if I xant to save the modifications!!
=> If I say 'No' I can close the frame.

Thanks to see it if you have the time...

Olivier

-- 
Olivier Bouiron
Institut Sainte Catherine
1750, chemin du lavarin
84000 AVIGNON
Tel: 04.90.27.57.43



Re: Autocompletion and Table cell edition problems

From
Raymond O'Donnell
Date:
On 17/11/2009 11:02, Olivier Bouiron wrote:

> 2) I want to edit a table in order to change a column value.
> So, I edit a cell, but I decide not to change the value, so I stop the
> cell edition without any change.
> Then, I can't close the frame normaly: pgadmin ask me if I want to save
> the modifications
> => If I say 'Yes', then I can't close the frame because, again and again
> I'll get the message asking me if I xant to save the modifications!!
> => If I say 'No' I can close the frame.

This is the same on Windows, so I'd say it's by design, and I actually
think it's a good idea - it reminds you of the separation between server
and client, and that you have to commit or rollback any changes explicitly.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


Re: Autocompletion and Table cell edition problems

From
Olivier Bouiron
Date:
You're right, I might not use pgadmin to do that, but it's really more faster to use it!<br /><br /> But if pgadmin
givesus the possibility to change a cell value, it should not have that (little) problem.<br /><br /> The question is
whyif I say "Yes, save it!", It don't work? It's like if the save action don't use the same algorithm to determin if a
cellis modified than the algorithm which is used when I close the frame...<br /><br /><br /><br /> Raymond O'Donnell a
écrit :<blockquote cite="mid:4B028627.8090604@iol.ie" type="cite"><pre wrap="">On 17/11/2009 11:02, Olivier Bouiron
wrote:
 </pre><blockquote type="cite"><pre wrap="">2) I want to edit a table in order to change a column value.
So, I edit a cell, but I decide not to change the value, so I stop the
cell edition without any change.
Then, I can't close the frame normaly: pgadmin ask me if I want to save
the modifications
=> If I say 'Yes', then I can't close the frame because, again and again
I'll get the message asking me if I xant to save the modifications!!
=> If I say 'No' I can close the frame.   </pre></blockquote><pre wrap="">
This is the same on Windows, so I'd say it's by design, and I actually
think it's a good idea - it reminds you of the separation between server
and client, and that you have to commit or rollback any changes explicitly.

Ray.
 </pre></blockquote><br /><pre class="moz-signature" cols="72">-- 
Olivier Bouiron
Institut Sainte Catherine
1750, chemin du lavarin
84000 AVIGNON
Tel: 04.90.27.57.43
</pre>

Re: Autocompletion and Table cell edition problems

From
Guillaume Lelarge
Date:
Hi,

Le mardi 17 novembre 2009 à 12:02:51, Olivier Bouiron a écrit :
> [...]
> 1) I open the frame that add a column in a table (in the column's menu
> of table properties)
> Then I want to set the type of my column using the combobox. The bug is
> that I can't edit it for autocompletion, i just can select the type I
> want in the combo, but it's impossible to enter in edition in it.
>

This is a wxWidgets issue. Dave is working on a redesign of the table form.
I'm waiting to see what the results of his work will be on this before working
on the combobox issue.

> 2) I want to edit a table in order to change a column value.
> So, I edit a cell, but I decide not to change the value, so I stop the
> cell edition without any change.
> Then, I can't close the frame normaly: pgadmin ask me if I want to save
> the modifications
> => If I say 'Yes', then I can't close the frame because, again and again
> I'll get the message asking me if I xant to save the modifications!!
> => If I say 'No' I can close the frame.
>

I didn't know about that one. I did some work on it tonight and will continue
to do so to fix this issue.


--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com