Re: [pgadmin-support] PgAdmin III 1.20 error on Windows 7 (64 bits)

2015-01-12 Thread Paragon Corporation
Are you using the 32-bit version of pgAdmin or the 64-bit? If you have the 32-bit version of pgAdmin, you need the 32-bit version of Visual C++ 2013 redistributable which would be located in C:\windows\SysWow64\MSVCP120.dll Hope that helps, Regina -Original Message- From: pgadmin-s

Re: [pgadmin-support] PgAdmin III 1.20 windows - not valid

2014-12-20 Thread Paragon Corporation
I think pgAdmin v1.20.0 was compiled with the same VS chain (2013 as I recall) as the PostgreSQL 9.4 binaries. These don't work on Windows XP. Probably should be noted somewhere on the site that Windows XP is not supported. So you have to use a lower version of pgAdmin III . Also you can't use

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

2014-02-09 Thread Paragon Corporation
We're having the same issue as described in this post. http://www.postgresql.org/message-id/CA+OCxoxoCGc7d7tRdyC5-32dDMtXyT1m59s_Lk 3mohtxxfm...@mail.gmail.com It sounds from the post that this issue was fixed. Was this change ever pushed to stack builder? I was thinking maybe it wasn't since

[pgadmin-support] Parallel Jobs option feature for backup

2013-09-07 Thread Paragon Corporation
Now that PostgreSQL 9.3 has the parallel backup feature in pg_dump, would it be possible to have that option on the pgAdmin Backup menu panel? I didn't see it on 1.18.0 RC1 when connected to PostgreSQL 9.3 db. Thanks, Regina -- Sent via pgadmin-support mailing list (pgadmin-support@postgresq

Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

2013-08-16 Thread Paragon Corporation
d D Levine [mailto:richard_d_lev...@raytheon.com] Sent: Friday, August 16, 2013 11:38 AM To: Neel Patel Cc: Paragon Corporation; pgadmin-support@postgresql.org; pgadmin-support-ow...@postgresql.org Subject: Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane I can find no refere

[pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

2013-08-14 Thread Paragon Corporation
I'm running pgAdmin 1.18.0 Alpha 1 on Windows IF I create a view CREATE MATERIALIZED VIEW mat_test AS SELECT generate_series(1,10) ; Then look at the view in the SQL pane, it shows this: CREATE OR REPLACE VIEW public.mat_test AS SELECT generate_series(1, 10) AS generate_series; Thanks, Regi

[pgadmin-support] BUG: Can not wait for thread termination pgAdmin III 1.18.0-beta1

2013-07-04 Thread Paragon Corporation
This seems to be an issue with the Query window. I should note that if I run the same commands using psql Errors just return back without any weird alert and also doesn't happen if I run an older pgAdmin with 9.3beta2 -- pgAdmin III 1.16.1 for example does not have this problem. --- I just insta

[pgadmin-support] Issue with pgAgent jobs forever running state after server restart

2013-03-16 Thread Paragon Corporation
This has been an issue for a while but has only become a more common issue for us recently and one we can more easily predict. We are running pgAgent on windows, and whenever we restart the server, if a job is in the middle of a run when we restart, it gets stuck in a forever endless running state

[pgadmin-support] Bug: Default parameters in functions not being maintained in pgAdmin definition

2012-09-07 Thread Paragon Corporation
I'm using 1.16 beta 4 on Windows (the version that comes with EDB PostgreSQL 9.2RC1) When I do this: CREATE OR REPLACE FUNCTION test_defaults(param_int integer, param_def text DEFAULT NULL::text) RETURNS text AS $$ SELECT $2; $$ language sql; Then right click or look in code paid to see the

[pgadmin-support] BUG: Rename database wipes out Server Groups

2012-08-25 Thread Paragon Corporation
I think this is a bug. I'm running 1.16.0 beta4 on Windows 7 64-bit When rename a database on the tree interface, the tree refreshes and all the servers I have registered in Server Groups disappear. I'm using the compiled EDB zip binaries packaged with PostgreSQL 9.2 beta 4. Thanks, Regina

[pgadmin-support] Feature Request: No gui for creating user mappings

2012-04-16 Thread Paragon Corporation
I didn't see this on your list, but seems glaringly missing since. Using 1.14.2 There is no right-click menu for create a new FDW Foreign Server User Mapping Thanks, Regina

[pgadmin-support] Bug: Foreign Data Table DDL SQL is mangled

2012-04-16 Thread Paragon Corporation
I'm testing on Windows 2008 64-bit pgAdmin 1.14.2 I used the odbc_fdw based foreign data table that I created with this statement: CREATE FOREIGN TABLE my_tables (table_catalog character varying(128) , table_schema character varying(128) , table_name character varying(128) , table_type character

[pgadmin-support] Bug: Issue with Default Parameters

2011-11-22 Thread Paragon Corporation
I noticed another issue with default parameters which I didn't see listed. I see it in 1.14 at any rate not sure it is an issue in lower versions. That is if I write a function like this: CREATE OR REPLACE FUNCTION test_defaults(test text DEFAULT '') RETURNS text AS $$ SELECT 'hello'::t

[pgadmin-support] Some functions with variadics don't show the right CREATE FUNCTION SQL

2011-11-21 Thread Paragon Corporation
We discovered a recent issue on PostGIS dev which we think is a pgAdmin issue. We have reproduced on 1.14 and 1.10 That is when we create a function like this: CREATE OR REPLACE FUNCTION test_regprocedure( func regprocedure, VARIADIC junk text[] DEFAULT NULL ) RETURNS text

[pgadmin-support] SQL/MED Foreign Data Wrappers where is Handler?

2011-05-13 Thread Paragon Corporation
I'm using pgAdmin 1.14.0 beta 1 and was trying to create a Foreign Data Wrapper entry. I see a Validator drop down, but no Handler drop down. Am I missing something? Thanks, Regina -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription:

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Paragon Corporation
Dan, > Ok, I understand and it's a shame the vars aren't strong typed. It's little things like that that make me want SQL Server back. It doesn't seem like a big thing to some people, but for a lot of developers the amount of > work added by this when debugging sql adds up over time. I know it'

[pgadmin-support] BUG can't set variables for some GUC variables

2010-06-07 Thread Paragon Corporation
I'm not sure how many variables are at issue, but I tried setting the bytea_output variable via the variables tab of PgAdmin 1.12.0 beta 1 and can't because it only allows me to type in one character When this variable requires escape Or bytea Thanks, Regina -- Sent via pgadmin-support

[pgadmin-support] Get error when viewing dependency tab of sequence objects

2009-11-21 Thread Paragon Corporation
This is for PgAdmin III version 1.10 1) go to sequences -- select sequence 2) Go to depency tab Get error LINE 2 D ref.rename ISNT NULL THEN Syntax error at or near "att" Can't drop sequences using the GUI either. Thanks, Leo -- Sent via pgadmin-support mailing list (pgadmin-support@p

[pgadmin-support] PgAdmin III 1.10 1 beta can't create pgagent batch job steps

2009-04-07 Thread Paragon Corporation
This worked in pgAdmin III 1.8 and I believe it worked in 1.9 beta too. When I try to create a batch job step with 1.10 beta 1, I get an error - looking at the sql it looks like its missing the last argument jstdbname Creating SQL jobs seems to work fine though. I tried against both a PostgreSQ