Re: [pgadmin-support] 1.15 Dev: menu "table -> maintenance"

2012-03-10 Thread Guillaume Lelarge
On Sat, 2012-03-10 at 15:10 -0500, Colin Beckingham wrote: > 1. open pgadmin > 2. drill down to tables in a db > 3. right click to open submenu for a table > 4. select Maintenance, crash, offers backtrace, pgadmin dies. > Thanks, fixed (and also in backup, restore, backup globals, backup server).

Re: [pgadmin-support] feature request

2012-03-10 Thread Bartosz Dmytrak
Hi, I second the request. I am not wxWidgets developer but I think there are to different UI solutions: - different tabs in output section like in SQL Workbench - different record sets like in MS (something like table of tables) I think it could be configured in options which approach is pr

[pgadmin-support] 1.15 Dev: menu "table -> maintenance"

2012-03-10 Thread Colin Beckingham
1. open pgadmin 2. drill down to tables in a db 3. right click to open submenu for a table 4. select Maintenance, crash, offers backtrace, pgadmin dies. ASSERT INFO: ./src/gtk/textctrl.cpp(828): assert "IsSingleLine()" failed in GetEditable(): shouldn't be called for multiline BACKTRACE: [1] w

Re: [**Octum-Spam**] - 4,35 - Re: [pgadmin-support] Bug on multi screens

2012-03-10 Thread Guillaume Lelarge
On Fri, 2012-03-09 at 07:58 +, Steffen Decker wrote: > Now i have check this again. > > If i move the window to primary display and close pgadmin, next time it > starts on the same place (don't care whether the window is maximized or > not) > If i move the window to the secondary display

[pgadmin-support] QB - record count incorrect

2012-03-10 Thread Colin Beckingham
On open QB, drill down to table, right click table name, seek menu item View Data, sub menu items top and last contain odd number of records 398316718 which should be 100, table opens correctly, but count of records in status bar is also incorrect. -- --- Colin Beckingham 613-454-5369 http://ww

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Guillaume Lelarge
On Sat, 2012-03-10 at 09:59 -0500, Colin Beckingham wrote: > > On 03/10/2012 09:19 AM, Colin Beckingham wrote: > > > > > > On 03/10/2012 08:38 AM, Guillaume Lelarge wrote: > >> On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: > >>> [...] > >>> select distinct on (mname, nname) mname, nna

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Colin Beckingham
On 03/10/2012 09:19 AM, Colin Beckingham wrote: On 03/10/2012 08:38 AM, Guillaume Lelarge wrote: On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: [...] select distinct on (mname, nname) mname, nname from grammar \ inner join majors using (mid) \ inner join minors using (nid) \ inn

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Colin Beckingham
On 03/10/2012 08:38 AM, Guillaume Lelarge wrote: On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: [...] select distinct on (mname, nname) mname, nname from grammar \ inner join majors using (mid) \ inner join minors using (nid) \ inner join j

Re: [pgadmin-support] feature request

2012-03-10 Thread Guillaume Lelarge
On Thu, 2012-03-08 at 11:37 +0100, unterrainer.guent...@leitwind.com wrote: > Thanks for your answers!! > > > > You can already to that by selecting the query you want to execute. > > People ask that we add a new way to execute queries so that it > executes > > the query where your cursor is but

Re: [pgadmin-support] BUG

2012-03-10 Thread Guillaume Lelarge
On Fri, 2012-03-09 at 15:14 -0800, Cecil Eduardo Campos Costa wrote: > When I open a query window and type a open brace ({) or a open bracket > ([) it doesnt work with the spanish keyboard in Macintosh, so I have > to type in a separated editor and then copy and paste it. > I use PGAdmin from 3 or

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Guillaume Lelarge
On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote: > [...] > select distinct on (mname, nname) mname, nname from grammar \ > inner join majors using (mid) \ > inner join minors using (nid) \ > inner join jxgp using (gid) \ > where jxgp.pid = 9

Re: [pgadmin-support] Error on delete row

2012-03-10 Thread Guillaume Lelarge
On Fri, 2012-03-09 at 08:11 -0500, Colin Beckingham wrote: > I think this may be a dup of an earlier report, but maybe new info: > > 1.15 dev, opensuse 12.1 Gnome 3 > > Attempting to delete record > > 1. open pgadmin3 > 2. drill down to table, right click, select 'last 100 rows' > 3. table has o

Re: [pgadmin-support] Rename Trigger script error

2012-03-10 Thread Guillaume Lelarge
On Fri, 2012-03-09 at 11:49 +0100, Bartosz Dmytrak wrote: > Hi, > I think there is another bug in trigger script. > > Use case is: rename trigger using GUI, Trigger has to be based on camel > case function name > > Generated Code is: > ALTER TRIGGER "TriggerOldName" ON "MySchema"."MyTable" RENAME