Re: [pgadmin-hackers] pgAdmin III commit: Support the new check_option parameter of views

2014-07-09 Thread Guillaume Lelarge
Hi, 2014-07-09 17:08 GMT+02:00 J.F. Oster : > Hello Guillaume, > > I've noticed that views for which I had never specified check_option > or security_barrier (in pgsql 9.3) have got incorrect DDL generated - > the "WITH (options)" clause is empty: > > CREATE OR REPLACE VIEW account_v WITH () AS >

[pgadmin-hackers] pgAdmin III commit: Fix generated DDL for views

2014-07-09 Thread Guillaume Lelarge
Fix generated DDL for views I've noticed that views for which I had never specified check_option or security_barrier (in pgsql 9.3) have got incorrect DDL generated - the "WITH (options)" clause is empty. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=comm

[pgadmin-hackers] PATCH: new feature for Query tool: Favourites injection

2014-07-09 Thread J.F. Oster
Hello! When writing ad hoc queries or plpgsql code it is often handy to operate with small text snippets as the building blocks. PgAdmin has no Templates feature, but Favourites is very close to it. What is missing - the ability to quickly apply (inject) some snippet in the cursor position, prefer

Re: [pgadmin-hackers] pgAdmin III commit: Support the new check_option parameter of views

2014-07-09 Thread J.F. Oster
Hello Guillaume, I've noticed that views for which I had never specified check_option or security_barrier (in pgsql 9.3) have got incorrect DDL generated - the "WITH (options)" clause is empty: CREATE OR REPLACE VIEW account_v WITH () AS SELECT acc.id, ... Once I set security_barrier on and bac

Re: [pgadmin-hackers] PATCH: More search in object's definitions

2014-07-09 Thread Dave Page
Thanks - patch applied. On Tue, Jul 8, 2014 at 6:39 PM, J.F. Oster wrote: > Hello! > > This patch adds search capabilities for: > > * Column's type names and default values > * Everything in a view definition > * Column names in composite types, tables and foreign tables > > I'm not sure how far

[pgadmin-hackers] pgAdmin III commit: This patch adds search capabilities for:

2014-07-09 Thread Dave Page
This patch adds search capabilities for: * Column's type names and default values * Everything in a view definition * Column names in composite types, tables and foreign tables Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=9a06bfc7ef03d792287

[pgadmin-hackers] pgAdmin III commit: Save search settings whenever the dialogue is close

2014-07-09 Thread Dave Page
Save search settings whenever the dialogue is closed. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=e7e60947c84b46cf218dcd2924add570c328acc3 Author: Dmitriy Olshevskiy Modified Files -- pgadmin/dlg/dlgSearchObject.cpp |2 +- 1

Re: [pgadmin-hackers] PATCH: save and restore the settings of the search objects dialog

2014-07-09 Thread Dave Page
Thanks - patch applied. On Tue, Jul 8, 2014 at 7:28 PM, Dmitriy Olshevskiy wrote: > Hello J.F. > Honestly, I don't sure that SaveSettings() must be called every time you > push the Find button. > What about the destructor method? (see the attached file) > > 08.07.2014 21:16, J.F. Oster пишет: > >