[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] 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] Subject: Re

[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,

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 = null 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 [EMAIL PROTECTED] CC: [EMAIL

[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

[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

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 PROTECTED] Subject: Re: [pgadmin-support] RC2 installer

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 [EMAIL PROTECTED

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] Subject: Re: [pgadmin-support] Can't alter

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

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 PROTECTED],[EMAIL PROTECTED] Subject: Re: [pgadmin-support] RC2 installer problem

[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

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.

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] postgres failed to start from services manager on windows 2008 r2

alled on your local computer or the installation is corrupted. You > can install or repair the component > > 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 include

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: > > >

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