Re: [pgadmin-support] Edit data on the data output tab

2012-07-19 Thread Michael Shapiro
One idea is to provide a dialog that asks for the table and columns to use for the insert stmts. That way the user can define the insert without having to actually export the data and write scripts to produce the inserts And it would allow inserts into different tables than were used in the select.

Re: [pgadmin-support] problem with empty arguments of trigger procedure

2012-07-19 Thread Guillaume Lelarge
On Wed, 2012-07-04 at 21:55 +0200, Guillaume Lelarge wrote: > On Tue, 2012-07-03 at 10:05 +0200, Michał Sienicki wrote: > > Bug report - pgAdmin 1.14.3, Windows > > > > Trigger definition is not shown properly when function contains "empty" > > arguments. > > > > Example > > > > Trigger definit

Re: [pgadmin-support] Edit data on the data output tab

2012-07-19 Thread Claudio Freire
On Thu, Jul 19, 2012 at 4:30 PM, Guillaume Lelarge wrote: > No. And I don't see how we would be able to do that. Even if you simply > do a "SELECT * FROM something", that "something" may be many thing: a > table of course, but also a view, a foreign table. > > So, no, sorry. (no as in "not me") A

Re: [pgadmin-support] Edit data on the data output tab

2012-07-19 Thread Guillaume Lelarge
On Thu, 2012-07-19 at 11:39 -0300, Nelson A. de Oliveira wrote: > Hi! > > We can edit the data from a table by using View Data → View Filtered > Rows, but we can't edit the same data when running the same query in > the SQL Editor. > Is it possible to be able to edit the data when viewing it via t

Re: [pgadmin-support] Search the schema

2012-07-19 Thread Guillaume Lelarge
On Thu, 2012-07-19 at 05:40 -0500, Michael Shapiro wrote: > Of course, makes sense, which is why I made the feature request I did > (ie, search). Would you consider adding regex expressions to the > search? > Well, it wouldn't be hard to do because the search is done by PostgreSQL. So we can use

[pgadmin-support] Edit data on the data output tab

2012-07-19 Thread Nelson A. de Oliveira
Hi! We can edit the data from a table by using View Data → View Filtered Rows, but we can't edit the same data when running the same query in the SQL Editor. Is it possible to be able to edit the data when viewing it via the Data Output in the SQL Editor too? Thank you! Best regards, Nelson --

Re: [pgadmin-support] Search the schema

2012-07-19 Thread Michael Shapiro
Of course, makes sense, which is why I made the feature request I did (ie, search). Would you consider adding regex expressions to the search? On Thu, Jul 19, 2012 at 3:13 AM, Guillaume Lelarge wrote: > On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote: > > What motivated me to ask for thi

Re: [pgadmin-support] Search the schema

2012-07-19 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote: > What motivated me to ask for this feature was that I was looking to > see if the dependents/dependencies tabs > on function would show all the objects that use the function and the > objects that the functions uses, including other functio

Re: [pgadmin-support] Rename database destroys server connections

2012-07-19 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 19:39 -0400, Colin Beckingham wrote: > > On 07/18/2012 05:23 PM, Guillaume Lelarge wrote: > > On Mon, 2012-07-16 at 11:05 -0400, Colin Beckingham wrote: > >> Using wxw 2.9.3, latest dev 1.17, Opensuse 12.1 > >> > >> With two servers connected, select database in object browse