Re: [pgadmin-support] pgAdmin 4 1.1, query error while browsing columns

Hi, pgAdmin 4 supports PostgreSql 9.2 and above. I guess that’s the problem. Regards, Ben > On 2 Nov 2016, at 14:43, Mark Murawski wrote: > > Working with pgAdmin 4 1.1 on Mac 10.11.5 > > I connected to a postgres 9.1 database and I'm just clicking around looking > at individual columns in

Re: [pgadmin-support] OpenSSL Vulnerability in pgAdmin III

Hi, For pgAdmin III it might be worth looking at http://www.bigsql.org/pgadmin3/ . They are looking at updating and supporting pgAdmin III for a while longer. Regards, Ben > On 31 Oct 2016, at 04:43, Sathesh S wrote: > > > Hello All, > > We use pgAdmin

Re: [pgadmin-support] postgres failed to start from services manager on windows 2008 r2

onent > > on the local computer. > > If the event originated on another computer, the display information had to > be saved with the event. > > The following information was included with the event: > > Timed out waiting for server startup > > > could you

Re: [pgadmin-support] postgres failed to start from services manager on windows 2008 r2

Hi, FYI: You would be better off posting this message to the pgsql-admin or pgsql-general lists as this one is specific to PgAdmin. I can’t help you much with your question as I haven’t used postgres on windows for some time but I’d try the following: C:\> \pg_ctl.exe start -D This will try

Re: [pgadmin-support] back up

Hi, First of all I think you are better off asking this question on the pgsql-admin or pgsql-general lists or even on an Idart forum. To answer your question; I’d try using pg_dump or pg_dumpall on the command line and you’ll need to know the database administrator credentials to do a backup.

[pgadmin-support] Treatment of views with associated rules - Feature Request

All, I've just been trying to setup some updateable views using standard views and associated rules. Is there any possibility of when you open a view in the SQL editor the SQL for the associated rules also show up. It would seem to make sense. When a view is dropped the rules are silently dr

Re: [pgadmin-support] Can't alter columns with RC2

OK. Thanks. I'll have a look at a snapshot next week. Regards, Ben From: Andreas Pflug <[EMAIL PROTECTED]> CC: Ben Trewern <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: [pgadmin-support] Can't alter columns with RC2 Date: Fri, 26 Nov 2004 11:21:40 + Andreas Pf

Re: [pgadmin-support] RC2 installer problem on XP

bloke who wrote the Microsoft Installer or had anything to do with the Windows Registry had read this beforehand it would have saved us all a lot of headaches. Thanks for the info. Regards, Ben From: "Dave Page" <[EMAIL PROTECTED]> To: "Ben Trewern" <[EMAIL PROTECT

Re: [pgadmin-support] Can't alter columns with RC2

I'm using Windows XP. I'm also having some problems with the install see other thread - "RC2 installer problem on XP". Could this be related? Regards, Ben From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subj

[pgadmin-support] Can't alter columns with RC2

There seems to be a problem altering columns with pgAdmin 1.2 RC2. If you display the property box for a column, and change anything other than the field name, you don't get the opportunity to save those changes. OK is greyed out and the SQL window says "nothing to change". Any ideas? Regards,

Re: [pgadmin-support] RC2 installer problem on XP

I thought this had been fixed by installing with the local Administrator account but it's come back. Every time i start pgAdmin now it asks me if I want to reboot my machine. Click no and start it again and it runs. Any other ideas? Regards, Ben From: "Ben Trewern" <[EM

Re: [pgadmin-support] RC2 installer problem on XP

My user account is in the Administrators group on this machine. I'll try installing using the local administrator account and see if that fixes it. Regards, Ben From: "Dave Page" <[EMAIL PROTECTED]> To: "Ben Trewern" <[EMAIL PROTECTED]>, <[EMAIL PROTEC

[pgadmin-support] RC2 installer problem on XP

All, I've just installed the new RC of pgAdmin III. I seem to have got into a loop where the installer asks me to reboot my machine. I restart, and then try to start pgAdmin, it does some kind of install operation and then asks me to reboot my machine again ad infinitum. The only way to run p

[pgadmin-support] Adding Not Null constraints doesn't work with beta 3

All, There seems to be a new problem with beta 3. When you try to add a Not Null constraint, the SQL made is incorrect. When trying to change the operative_group_id field in the operatives table I get: ALTER TABLE operatives ALTER operative_group_id TYPE int4ALTER TABLE operatives ALTER COLUMN

Re: [pgadmin-support] Null boolean values show as false in the data

Sorry for the noise. Ben From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Null boolean values show as false in the data Date: Thu, 14 Oct 2004 13:52:17 + Ben Trewern wrote: While your at it null value

Re: [pgadmin-support] Null boolean values show as false in the data

While your at it null values need to be treated correctly for other field types. I don't think "" = in Postgres. If so then it would be nice to be able to set text/varchar to null somehow. Regards, Ben From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAI

[pgadmin-support] Null boolean values show as false in the data grid

All, PgAdmin III 1.2 beta 2 Postgres 8.0 beta 2 I've just noticed that null values in boolean fields show up as false in the data grid. This gave me a few headache this morning. I thought this had been discussed previously, but I could not see it in 'Know Issues'. If it's a wxWindows issue, it

Re: [pgadmin-support] Can't create foreign keys

Andreas, 1. The table does have a PK. 2. It used to work in pgAdmin III 1.0.2 3. Could it be that one field is int4 and the other is declared as a serial field? - Just a thought. Ben From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED]

[pgadmin-support] Can't create foreign keys

I'm testing pgAdmin III Aug 15 snapshot and have found that you can't add foreign keys. You go to your table of choice then: Properties -> Constraints -> Add -> Pick table in References drop down -> Pick a field in Local column -> No fields show up in Referencing! Regards, Ben ___

Re: [pgadmin-support] Error Message: ERROR: CREATE USER: permission denied

I don't think this is a pgAdmin problem. You need to log in as a superuser account to create a user. The superuser is usually called postgres in a standard PostgreSQL install although any user can be made a superuser (See ALTER USER CREATEUSER). Try CREATE USER ; via psql or the sql window i

[pgadmin-support] Problem with bool fields

All, Bool fields don't seem to work correctly in pgAdmin3. If the field value is it shows up as false in the grid. Also if the default value of the field is it defaults to false. I'm using the Aug 15th snapshot version. Ben _ It