Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgAdmin - no_spool

pgAdmin - no_spool

From
Pedro Doria Meunier
Date:
Hi Dave,

Could you please tell me why when I click on a cluster pgAdmin
exhibits a dialog stating:
"Column not found in pgSet: no_spool" ?

- pgAdmin version 1.10.0 Beta2 rev. 7749
- Slony ver 2.0.2
- Master on a remote server
- Slony-I not installed on localhost (could it be it?!)

BR,

-- 
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Re: pgAdmin - no_spool

From
Dave Page
Date:
On Wed, Jul 1, 2009 at 9:12 AM, Pedro Doria
Meunier<pdoria@netmadeira.com> wrote:
> Hi Dave,
>
> Could you please tell me why when I click on a cluster pgAdmin
> exhibits a dialog stating:
> "Column not found in pgSet: no_spool" ?
>
> - pgAdmin version 1.10.0 Beta2 rev. 7749
> - Slony ver 2.0.2
> - Master on a remote server
> - Slony-I not installed on localhost (could it be it?!)

I guess noone tried Slony 2.0 yet :-(. Please try the patch below:

Index: pgadmin/slony/slNode.cpp
===================================================================
--- pgadmin/slony/slNode.cpp    (revision 7945)
+++ pgadmin/slony/slNode.cpp    (working copy)
@@ -287,7 +287,10 @@            node->iSetComment(nodes->GetVal(wxT("no_comment")));
            if (collection->GetCluster()->ClusterMinimumVersion(1,1))
-                node->iSetSpool(nodes->GetBool(wxT("no_spool")));
+            {
+                if (nodes->HasColumn(wxT("no_spool")))
+                    node->iSetSpool(nodes->GetBool(wxT("no_spool")));
+            }
            if (browser)            {



-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Re: pgAdmin - no_spool

From
Pedro Doria Meunier
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dave,

It works perfectly! Thanks!

Perhaps you should commit the patch ;-)

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam



Dave Page wrote:
> On Wed, Jul 1, 2009 at 9:12 AM, Pedro Doria
> Meunier<pdoria@netmadeira.com> wrote:
>> Hi Dave,
>>
>> Could you please tell me why when I click on a cluster pgAdmin
>> exhibits a dialog stating:
>> "Column not found in pgSet: no_spool" ?
>>
>> - pgAdmin version 1.10.0 Beta2 rev. 7749
>> - Slony ver 2.0.2
>> - Master on a remote server
>> - Slony-I not installed on localhost (could it be it?!)
>
> I guess noone tried Slony 2.0 yet :-(. Please try the patch below:
>
> Index: pgadmin/slony/slNode.cpp
> ===================================================================
> --- pgadmin/slony/slNode.cpp    (revision 7945)
> +++ pgadmin/slony/slNode.cpp    (working copy)
> @@ -287,7 +287,10 @@
>              node->iSetComment(nodes->GetVal(wxT("no_comment")));
>
>              if (collection->GetCluster()->ClusterMinimumVersion(1,1))
> -                node->iSetSpool(nodes->GetBool(wxT("no_spool")));
> +            {
> +                if (nodes->HasColumn(wxT("no_spool")))
> +                    node->iSetSpool(nodes->GetBool(wxT("no_spool")));
> +            }
>
>              if (browser)
>              {
>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKS2v32FH5GXCfxAsRAmI+AJwM26NCm5RfgLCRpoVIY/wcbxo6JwCgvjxN
9JjkZG8urb9yTIXmAjJ7cPI=
=56rR
-----END PGP SIGNATURE-----

Re: pgAdmin - no_spool

From
Dave Page
Date:
On Wed, Jul 1, 2009 at 3:00 PM, Pedro Doria
Meunier<pdoria@netmadeira.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dave,
>
> It works perfectly! Thanks!
>
> Perhaps you should commit the patch ;-)

Thanks  - committed!

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com