[pgadmin-support] Troubleshooting connection problems

2016-10-29 Thread Jack Royal-Gordon
I have a local database that I am unable to connect to with pgAdmin 4 version 1.1 (. No problem connecting to it with pgAdmin III version 1.20.0. Datbase version is 9.2.2.0. Error is “Connection to the server has been lost.” I verified that the connection properties are the same. What are the ne

Re: [pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-14 Thread Viktor Trojanovic
On Mon, Oct 3, 2016 at 1:44 PM, Dave Page wrote: > On Mon, Oct 3, 2016 at 12:32 PM, Dave Page wrote: > > On Mon, Oct 3, 2016 at 11:33 AM, Viktor Trojanovic > wrote: > >> On Mon, Oct 3, 2016 at 11:01 AM, Dave Page wrote: > >>> > >>> Hi > >>> > >>> On Sun, Oct 2, 2016 at 11:43 PM, wrote: > >>>

Re: [pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-03 Thread Dave Page
On Mon, Oct 3, 2016 at 12:32 PM, Dave Page wrote: > On Mon, Oct 3, 2016 at 11:33 AM, Viktor Trojanovic wrote: >> On Mon, Oct 3, 2016 at 11:01 AM, Dave Page wrote: >>> >>> Hi >>> >>> On Sun, Oct 2, 2016 at 11:43 PM, wrote: >>> > Hi list, hi Dave, >>> > >>> > On Windows 10 using a high res scree

Re: [pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-03 Thread Dave Page
On Mon, Oct 3, 2016 at 11:33 AM, Viktor Trojanovic wrote: > On Mon, Oct 3, 2016 at 11:01 AM, Dave Page wrote: >> >> Hi >> >> On Sun, Oct 2, 2016 at 11:43 PM, wrote: >> > Hi list, hi Dave, >> > >> > On Windows 10 using a high res screen with high dpi scaling turned on >> > and >> > set to 200%,

Re: [pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-03 Thread Viktor Trojanovic
On Mon, Oct 3, 2016 at 11:01 AM, Dave Page wrote: > Hi > > On Sun, Oct 2, 2016 at 11:43 PM, wrote: > > Hi list, hi Dave, > > > > On Windows 10 using a high res screen with high dpi scaling turned on and > > set to 200%, the text in the pgAdmin 4 (standalone) interface becomes > almost > > illeg

Re: [pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-03 Thread Dave Page
Hi On Sun, Oct 2, 2016 at 11:43 PM, wrote: > Hi list, hi Dave, > > On Windows 10 using a high res screen with high dpi scaling turned on and > set to 200%, the text in the pgAdmin 4 (standalone) interface becomes almost > illegible. > > The issue seems to be that pgAdmin claims to Windows that i

[pgadmin-support] pgAdmin 4 v1.0: Problems with high dpi scaling on Win10

2016-10-02 Thread viktor
Hi list, hi Dave, On Windows 10 using a high res screen with high dpi scaling turned on and set to 200%, the text in the pgAdmin 4 (standalone) interface becomes almost illegible. The issue seems to be that pgAdmin claims to Windows that is high dpi aware when it actually isn’t. See http://d

[pgadmin-support] Dead keys problems on SQL Query Tool on OS X

2016-06-30 Thread Joel Peláez Jorge
pgAdmin 3: 1.22.1 (Feb 29 2016, rev: REL-1_22_1) Downloaded from pgadmin.org OS X 10.11.5 El Capitan When I type the open curly bracket on Spanish keyboard on OS X in Query tool not show anything, it’s the same with open square bracket and accents. I read that wxWidgets 2.8 has issue about it an

Re: [pgadmin-support] Make pgadmin3 1.20, wxwidgets problems

2015-03-09 Thread Dave Page
On Sat, Mar 7, 2015 at 9:15 PM, Ivan Pantic wrote: > Hello, > > I'm trying to build pgadmin 1.20 from sources on Debian Jessie. I already > have 1.20.0~beta2-1 0 installed through apt-get, but it's pretty buggy, > which is why I'm looking into moving forward to the latest, or back to 1.18. > >

[pgadmin-support] Make pgadmin3 1.20, wxwidgets problems

2015-03-07 Thread Ivan Pantic
Hello, I'm trying to build pgadmin 1.20 from sources on Debian Jessie. I already have 1.20.0~beta2-1 0 installed through apt-get, but it's pretty buggy, which is why I'm looking into moving forward to the latest, or back to 1.18. Anyway, I followed the script from INSTALL file. This is w

Re: [pgadmin-support] pgAdmin3 @1.18.1_1 UI problems

2014-08-09 Thread Enrico Maria Crisostomo
installed pgAdmin3 from MacPorts on an OS X 10.9.4 machine and it has UI issues (e.g.: missing borderless windows’ borders, missing text in “Guru Hints” windows). These problems do not appear when using the pgadmin3 binaries downloaded from the pgadmin website. I’ve opened a bug report on MacPorts

[pgadmin-support] pgAdmin3 @1.18.1_1 UI problems

2014-07-07 Thread Enrico Maria Crisostomo
Hi, I’ve installed pgAdmin3 from MacPorts on an OS X 10.9.4 machine and it has UI issues (e.g.: missing borderless windows’ borders, missing text in “Guru Hints” windows). These problems do not appear when using the pgadmin3 binaries downloaded from the pgadmin website. I’ve opened a bug

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-08 Thread Dinesh Kumar
OK. Thanks Dave. @Christian: We believe, you can get this max length option in pgAdmin 1.16.2 which is not released yet. Sorry, i am not aware of it's release schedule time. Thanks. Dinesh -- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-08 Thread Dave Page
We can't do anything about length restrictions in those controls, except suggest the use of the max length option, which will work correctly as of 1.16.2. On Thu, Aug 8, 2013 at 1:04 PM, Dinesh Kumar wrote: > Hi Dave, > > Adding to previous e-mail, i have tested this on Windows 7 with the latest

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-08 Thread Dinesh Kumar
Hi Dave, Adding to previous e-mail, i have tested this on Windows 7 with the latest pgAdmin master branch. Thanks. Dinesh -- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co m * Follow

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-08 Thread Dinesh Kumar
Hi Dave, Further to our discussion on this issue, it seems the problem is with the length of the text in the grid. Thanks for your guidance. In windows 7, if the length of a string in the grid exceeds "4679", then it's not able to render the values properly. SELECT substring(geom::text from 1 FO

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-08 Thread Dinesh Kumar
On Wed, Aug 7, 2013 at 11:53 PM, Christian H. Bruhn wrote: > am Mittwoch, 7. August 2013 um 09:59 schrieb Dinesh Kumar: > > > I have just done a quick test case with the given steps, but i am not > able > > to reproduce the case in Cent OS6.0. In CentOS 6, i am getting all the 16 > > non null gri

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-07 Thread Christian H. Bruhn
am Mittwoch, 7. August 2013 um 09:59 schrieb Dinesh Kumar: > I have just done a quick test case with the given steps, but i am not able > to reproduce the case in Cent OS6.0. In CentOS 6, i am getting all the 16 > non null grid values and 2 null values. Would you mind to share the Yes I think its

Re: [pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-07 Thread Dinesh Kumar
H i On Tue, Aug 6, 2013 at 7:31 PM, Christian H. Bruhn wrote: > Hi! > > I just installed Postgres 9.2.4 from [1] with the pgAdmin on Windows 7 > Prof. 64 Bit. I also installed Postgis 2.0.3-2. I've tried the > installation with the stackbuilder and also the separate download. > > Now I have the

[pgadmin-support] Problems with Postgis-geometries under Windows 7 64 Bit

2013-08-06 Thread Christian H. Bruhn
Hi! I just installed Postgres 9.2.4 from [1] with the pgAdmin on Windows 7 Prof. 64 Bit. I also installed Postgis 2.0.3-2. I've tried the installation with the stackbuilder and also the separate download. Now I have the problem that some data is missing, when displayed in pgAdmin. The geometry-co

Re: [pgadmin-support] pgAdmin and AWS Redshift Connection problems

2013-03-08 Thread Craig Ringer
On 03/08/2013 08:00 PM, Dave Page wrote: > Hi > > On Fri, Mar 8, 2013 at 7:04 AM, Justin Yan wrote: >> Hello! >> >> AWS Redshift, while proprietary, allows one to connect through any client >> that utilizes Postgres 8.0 drivers. Approximately a week ago, I tested >> connecting to a Redshift clust

Re: [pgadmin-support] pgAdmin and AWS Redshift Connection problems

2013-03-08 Thread Dave Page
Hi On Fri, Mar 8, 2013 at 7:04 AM, Justin Yan wrote: > Hello! > > AWS Redshift, while proprietary, allows one to connect through any client > that utilizes Postgres 8.0 drivers. Approximately a week ago, I tested > connecting to a Redshift cluster through pgAdmin v1.12.3 [for postgres 8.0] > on

[pgadmin-support] pgAdmin and AWS Redshift Connection problems

2013-03-07 Thread Justin Yan
Hello! AWS Redshift, while proprietary, allows one to connect through any client that utilizes Postgres 8.0 drivers. Approximately a week ago, I tested connecting to a Redshift cluster through pgAdmin v1.12.3 [for postgres 8.0] on Ubuntu through the master user which AWS provides, which has super

Re: [pgadmin-support] pgadmin3 problems

2012-10-13 Thread Raymond O'Donnell
ase server, and it isn't working. I've been using pgadmin3 1.8.4 >> with my old database server for some time now, without problems. I >> try to upgrade to pgadmin3 1.16.0, and that isn't working either. It >> seems the upgrade needs to see 1.14. Is there a fresh in

Re: [pgadmin-support] pgadmin3 problems

2012-10-13 Thread Raymond O'Donnell
; with my old database server for some time now, without problems. I > try to upgrade to pgadmin3 1.16.0, and that isn't working either. It > seems the upgrade needs to see 1.14. Is there a fresh installer for > 1.16 under windows? Yes, just ignore the "upgrade.bat" file an

[pgadmin-support] pgadmin3 problems

2012-10-13 Thread Vince Miller
Hi, I'm trying to connect with pgadmin3 from my Windows box across my lan to my working database on my new working Ubuntu 12.04/postgresql 9.1 database server, and it isn't working. I've been using pgadmin3 1.8.4 with my old database server for some time now, without problems. I

Re: [pgadmin-support] problems

2012-08-31 Thread Craig Ringer
I'd advise you to contact Poker Tracker's tech support for an issues with Poker Tracker. -- Craig Ringer On 09/01/2012 05:51 AM, Morten Nergaard wrote: hi i have downloaded poker tracker 3 to my mac.. so will i use posture SQL.. But didn't understand what and where to write down.. have tried

[pgadmin-support] problems

2012-08-31 Thread Morten Nergaard
hi i have downloaded poker tracker 3 to my mac.. so will i use posture SQL.. But didn't understand what and where to write down.. have tried some guides but didn't understand.. just add a connection to a server? when i have open a server i get red cross over when i log in again.. can you pl

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-15 Thread Guillaume Lelarge
; > > > > > Hello, > > > > > > > > > > > > > > PgAdmin 1.14.1 (Dec 2 2011, rev: REL-1_14_1) > > > > > > > OS: Windwos XP SP3 32bit > > > > > > > PostgreSQL 9.1.2 on i686-pc-linux-gnu, compiled by g

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-13 Thread Vjacheslav A.
2011, rev: REL-1_14_1) > > > > > > OS: Windwos XP SP3 32bit > > > > > > PostgreSQL 9.1.2 on i686-pc-linux-gnu, compiled by gcc (GCC) > 4.5.2, > > > > > 32-bit > > > > > > > > > > > > there are some problems with

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-13 Thread Guillaume Lelarge
t; > > > On Sat, 2011-12-10 at 15:53 +0400, Vjacheslav A. wrote: > > > > > Hello, > > > > > > > > > > PgAdmin 1.14.1 (Dec 2 2011, rev: REL-1_14_1) > > > > > OS: Windwos XP SP3 32bit > > > > > PostgreSQL 9.1.2 on i6

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-10 Thread Vjacheslav A.
iled by gcc (GCC) 4.5.2, > 32-bit > > > > there are some problems with servers treeview: > > 1. then tree is empty (if you have servers in tree, then you need to > delete > > its all and restart pgadmin), try to add new server with options: > > - fill Name, Hos

Re: [pgadmin-support] pgadmin - problems with servers treeview

2011-12-10 Thread Guillaume Lelarge
On Sat, 2011-12-10 at 15:53 +0400, Vjacheslav A. wrote: > Hello, > > PgAdmin 1.14.1 (Dec 2 2011, rev: REL-1_14_1) > OS: Windwos XP SP3 32bit > PostgreSQL 9.1.2 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.2, 32-bit > > there are some problems with servers treeview: > 1

[pgadmin-support] pgadmin - problems with servers treeview

2011-12-10 Thread Vjacheslav A.
Hello, PgAdmin 1.14.1 (Dec 2 2011, rev: REL-1_14_1) OS: Windwos XP SP3 32bit PostgreSQL 9.1.2 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.2, 32-bit there are some problems with servers treeview: 1. then tree is empty (if you have servers in tree, then you need to delete its all and restart

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Dave Page
On Saturday, December 3, 2011, Aren Cambre wrote: > Could pgAdmin detect if the view has no dependents and offer to drop and replace the view? Potentially, though that might be a a little tricky to do given the way that code is architected. It would probably have to do the check when the dialogue

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Aren Cambre
Could pgAdmin detect if the view has no dependents and offer to drop and replace the view? My views generally have no dependents. Don't know if that's typical, however. Aren On Fri, Dec 2, 2011 at 3:08 AM, Dave Page wrote: > > > On Fri, Dec 2, 2011 at 3:47 AM, Aren Cambre wrote: > >> If I cha

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Dave Page
On Fri, Dec 2, 2011 at 3:47 AM, Aren Cambre wrote: > If I change this view: > * SELECT dallas_rlc_locations.location_code, > count(dallas_rlc."CitationId") AS count, dallas_rlc_locations.location, > dallas_rlc_locations.the_geom* > * FROM raw.dallas_rlc_locations* > * LEFT JOIN raw.dallas_rlc

[pgadmin-support] Problems changing a view

2011-12-01 Thread Aren Cambre
If I change this view: * SELECT dallas_rlc_locations.location_code, count(dallas_rlc."CitationId") AS count, dallas_rlc_locations.location, dallas_rlc_locations.the_geom* * FROM raw.dallas_rlc_locations* * LEFT JOIN raw.dallas_rlc ON dallas_rlc."Loc Code" = dallas_rlc_locations.location_code* *

Re: [pgadmin-support] Problems with wxWidgets 2.6

2010-03-12 Thread Ashesh Vashi
pgAdmin 1.10 will satisfy your need for PostgreSQL 8.0.22. On Fri, Mar 12, 2010 at 6:18 PM, Vinicius Borges wrote: > Ashesh, > > It's a long history why I'm using the pgAdmin 1.4... the postgreSQL here > it's 8.0.22. > > That's the output when I type > > #$ wx-config --list... > Default config

Re: [pgadmin-support] Problems with wxWidgets 2.6

2010-03-12 Thread Vinicius Borges
Ashesh, It's a long history why I'm using the pgAdmin 1.4... the postgreSQL here it's 8.0.22. That's the output when I type #$ wx-config --list... Default config is gtk2-ansi-release-2.6 Default config will be used for output Alternate matches: gtk2-ansi-release-2.8

Re: [pgadmin-support] Problems with wxWidgets 2.6

2010-03-12 Thread Vinicius Borges
Guillaume, when I type #$ wx-config --unicode Warning: No config found to match: /usr/local/bin/wx-config --unicode in /usr/local/lib/wx/config If you require this configuration, please install the desired library build. If this is part of an automated configuration test and

Re: [pgadmin-support] Problems with wxWidgets 2.6

2010-03-12 Thread Ashesh Vashi
Hi, Why do you want to build a older version of pgAdmin III? Whatever.. What is the output of the following line? "wx-config --list" -- Ashesh Vashi EnterpriseDB INDIA On Fri, Mar 12, 2010 at 1:18 AM, Vinicius Borges wrote: > Hello, > > I'm trying to install pgadmin3-1.4.3 and when I do > >

Re: [pgadmin-support] Problems with wxWidgets 2.6

2010-03-12 Thread Guillaume Lelarge
Le 11/03/2010 20:48, Vinicius Borges a écrit : > Hello, > > I'm trying to install pgadmin3-1.4.3 and when I do > Why do you try to install pgAdmin 1.4 when the latest release is 1.10.2? > $# ./configure > > appears an error: > > ... > checking libpq-fe.h presence... yes > checking for libpq-f

[pgadmin-support] Problems with wxWidgets 2.6

2010-03-11 Thread Vinicius Borges
Hello, I'm trying to install pgadmin3-1.4.3 and when I do $# ./configure appears an error: ... checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking pgsql in /usr/local/pgsql... ok checking for wxWidgets... yes Warning: No config found to match: /usr/local/bin/wx-config

Re: [pgadmin-support] Problems reverse engineering functions

2010-02-16 Thread Guillaume Lelarge
Le 16/02/2010 18:57, Kieran McCusker a écrit : > [...] > Sorry if this has been raised before but the following function will not > be reverse engineered correctly - The final default clause will be removed. > > CREATE FUNCTION fn(a text, b integer DEFAULT NULL::integer, c integer > DEFAULT NULL::

[pgadmin-support] Problems reverse engineering functions

2010-02-16 Thread Kieran McCusker
Hi Sorry if this has been raised before but the following function will not be reverse engineered correctly - The final default clause will be removed. CREATE FUNCTION fn(a text, b integer DEFAULT NULL::integer, c integer DEFAULT NULL::integer) returns text as $$ BEGIN return 't'; END; $$

Re: [pgadmin-support] Autocompletion and Table cell edition problems

2009-11-17 Thread Guillaume Lelarge
Hi, Le mardi 17 novembre 2009 à 12:02:51, Olivier Bouiron a écrit : > [...] > 1) I open the frame that add a column in a table (in the column's menu > of table properties) > Then I want to set the type of my column using the combobox. The bug is > that I can't edit it for autocompletion, i just ca

Re: [pgadmin-support] Autocompletion and Table cell edition problems

2009-11-17 Thread Olivier Bouiron
You're right, I might not use pgadmin to do that, but it's really more faster to use it! But if pgadmin gives us the possibility to change a cell value, it should not have that (little) problem. The question is why if I say "Yes, save it!", It don't work? It's like if the save action don't us

Re: [pgadmin-support] Autocompletion and Table cell edition problems

2009-11-17 Thread Raymond O'Donnell
On 17/11/2009 11:02, Olivier Bouiron wrote: > 2) I want to edit a table in order to change a column value. > So, I edit a cell, but I decide not to change the value, so I stop the > cell edition without any change. > Then, I can't close the frame normaly: pgadmin ask me if I want to save > the mod

[pgadmin-support] Autocompletion and Table cell edition problems

2009-11-17 Thread Olivier Bouiron
Hi. I have 2 problems since a long time, they are just irritating but they are not very importants. I'm using pgadminIII 8.10 and ubuntu 9.10 (but these problems seems to be reccurents on linux since a long time, before pga8.10!) I used synaptic to get pgadmin. 1) I open the frame that

[pgadmin-support] Problems using pgScript

2009-07-06 Thread Kieran McCusker
Hi I have been trying to use pgScript to do something I would normally do by writing a function. It very nearly worked perfectly except I got stuck with a problem where the script would run indefinitely and could not be interrupted. If you find the line "UNCOMMENTING THE LINE BELOW CAUSES TH

Re: [pgadmin-support] Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command

2008-08-06 Thread Fernando Hevia
On Wed, Aug 6, 2008 at 10:46 AM, Dave Page <[EMAIL PROTECTED]> wrote: > > pgAdmin does include the context line, if the server gives us one: > > -- Executing query: > > select foo(); > > ERROR: division by zero > CONTEXT: PL/pgSQL function "foo" line 4 at assignment > Hi Dave. Since you mention

Re: [pgadmin-support] Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command

2008-08-06 Thread Dave Page
On Tue, Aug 5, 2008 at 2:08 PM, kaeptn haddock <[EMAIL PROTECTED]> wrote: > When issueing a COPY command like this one > > > COPY tablename FROM '/var/www/hdberat.tab' WITH NULL AS ''; > > > > The error-message in pgadminIII is quite short > > ** Er

[pgadmin-support] Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command

2008-08-05 Thread kaeptn haddock
When issueing a COPY command like this one COPY tablename FROM '/var/www/hdberat.tab' WITH NULL AS ''; The error-message in pgadminIII is quite short ** Error *** FEHLER: fehlende Daten für Spalte »te

Re: [pgadmin-support] scroll bar problems after pasting text into t he sql query tool

2007-10-15 Thread Dave Page
> --- Original Message --- > From: "Belbin, Peter" <[EMAIL PROTECTED]> > To: pgadmin-support@postgresql.org > Sent: 15/10/07, 17:20:37 > Subject: [pgadmin-support] scroll bar problems after pasting text into the > sql query tool > > I noticed t

[pgadmin-support] scroll bar problems after pasting text into the sql query tool

2007-10-15 Thread Belbin, Peter
I noticed the other day that when pasting sql query text into the sql query editor, and then grabbing the horizontal scroll bar and moving it all the way over to the right, that the end of the sql query text I'd just pasted in was not being shown. It seems that the scroll bar was only scrolling ba

[pgadmin-support] Build problems on Ubuntu Feisty and possibly on other Linux systems

2007-10-04 Thread Ferenczi Viktor
Hi, I recently solved a build problem that prevented me from compiling PgAdmin III 1.8.0beta5. Please let you know the details to prevent further problems. Details: OS: Ubuntu Feisty, up-to-date (I write here, since PgAdmin cannot be found in Ubuntu's bug reporting system, and 1.8bet

Re: [pgadmin-support] Problems with "NOTICE"-messages

2007-09-17 Thread Erwin Brandstetter
On Sep 17, 2:59 pm, [EMAIL PROTECTED] (Dave Page) wrote: > Hmm, works for me in SVN-Trunk (1.8 beta5 + a few minor unrelated tweaks): > (...) > Anyone else able to reproduce this? I cannot reproduce it either. Testing pgAdmin III 1.8.0 Beta 5 (Sep 10 2007, rev: 6631). Client Win XP, host: Debian

Re: [pgadmin-support] Problems with "NOTICE"-messages

2007-09-17 Thread Dave Page
Bintsarovsky Dima home wrote: > I have two functions: > > CREATE OR REPLACE FUNCTION tests.func1() RETURNS integer AS $BODY$ > DECLARE BEGIN RAISE NOTICE 'notice'; PERFORM tests.func2(); RETURN 1; > END;$BODY$ LANGUAGE 'plpgsql' VOLATILE; > > > CREATE OR REPLACE FUNCTION tests.func2() RETURNS

[pgadmin-support] Problems with "NOTICE"-messages

2007-09-17 Thread Bintsarovsky Dima home
I have two functions: CREATE OR REPLACE FUNCTION tests.func1() RETURNS integer AS $BODY$ DECLARE BEGIN RAISE NOTICE 'notice'; PERFORM tests.func2(); RETURN 1; END;$BODY$ LANGUAGE 'plpgsql' VOLATILE; CREATE OR REPLACE FUNCTION tests.func2() RETURNS integer AS $BODY$ DECLARE BEGIN RAISE NOTI

Re: [pgadmin-support] Problems editing tables

2007-06-12 Thread Dave Page
Roland Martin wrote: > Hi Dave, > > Mmm, OK. Thanks for your helpful response. > > Trouble, in this case, means that it can't be done. I do the following: > 1. Locate any geometry_columns table > 2. Right click -> View data (or view all rows in the submenu, or whatever) > 3. I click in a field in

Re: [pgadmin-support] Problems editing tables

2007-06-11 Thread Dave Page
Roland Martin wrote: > Hi, > > I'm going to reinstall the earlier version, since it does actually work. > If anyone is ever interested in fixing this bug, please get in touch. I fully intend to look at it, unfortunately sometimes I simply don't have time to turn around bug fixes immediately in fr

Re: [pgadmin-support] Problems editing tables

2007-06-11 Thread Roland Martin
Hi, I'm going to reinstall the earlier version, since it does actually work. If anyone is ever interested in fixing this bug, please get in touch. Cheers, Roland. On 04/06/07, Roland Martin <[EMAIL PROTECTED]> wrote: Hi Dave, Mmm, OK. Thanks for your helpful response. Trouble, in this cas

Re : [pgadmin-support] 1.6.3 and Ubuntu Feisty problems

2007-06-08 Thread Laurent ROCHE
>> 3) column headers are blank with no indication of the column name in the >> edit grids. > Wierd. I have seen this when the connexion to the database has been lost. _ Ne gardez plus qu'une seule adresse

Re: [pgadmin-support] 1.6.3 and Ubuntu Feisty problems

2007-06-08 Thread Dave Page
David Lazar wrote: > Hi, > > Am running 1.6.3 (May 18, rev 6115) on an Ubuntu Feisty install. > > 1) icons on the top tab for things like refresh, view data etc. are all > larger than the panel causing them to look clipped. Fixed in SVN. > 2) I cannot use cut and past from cells in the edit gri

[pgadmin-support] 1.6.3 and Ubuntu Feisty problems

2007-06-07 Thread David Lazar
Hi, Am running 1.6.3 (May 18, rev 6115) on an Ubuntu Feisty install. 1) icons on the top tab for things like refresh, view data etc. are all larger than the panel causing them to look clipped. 2) I cannot use cut and past from cells in the edit grid 3) column headers are blank with no indicati

Re: [pgadmin-support] Problems editing tables

2007-06-04 Thread Roland Martin
Hi Dave, Mmm, OK. Thanks for your helpful response. Trouble, in this case, means that it can't be done. I do the following: 1. Locate any geometry_columns table 2. Right click -> View data (or view all rows in the submenu, or whatever) 3. I click in a field in the f_table_name column, and make c

Re: [pgadmin-support] Problems editing tables

2007-06-04 Thread Dave Page
Roland Martin wrote: > Hi, > > I've been having trouble editing a couple of tables in pgAdmin 1.6.3. > The same operation works fine in 1.4.1, so I assume it's some sort of bug... > > The only tables (as far as I can tell) that are affected are PostGIS > 'geometry_columns' tables. Before anyone a

[pgadmin-support] Problems editing tables

2007-06-04 Thread Roland Martin
Hi, I've been having trouble editing a couple of tables in pgAdmin 1.6.3. The same operation works fine in 1.4.1, so I assume it's some sort of bug... The only tables (as far as I can tell) that are affected are PostGIS 'geometry_columns' tables. Before anyone asks, they do have OIDs. Is there

Re: [pgadmin-support] problems compiling PGAdmin III 1.6.1 with

2006-12-07 Thread Dave Page
[EMAIL PROTECTED] wrote: that worked fine. but now if i make install i get /usr/bin/ld: cannot find -lcrypto is that a ssl-problem? Guess so - you'll need to figure out what package it comes with on Ubuntu and install it. Regards, Dave. ---(end of broadcast)

Re: [pgadmin-support] problems compiling PGAdmin III 1.6.1 with ubuntu 6.06

2006-12-07 Thread Christian.Strobl
> -Ursprüngliche Nachricht- > Von: Dave Page [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 6. Dezember 2006 15:47 > An: Strobl, Christian > Cc: pgadmin-support@postgresql.org > Betreff: Re: [pgadmin-support] problems compiling PGAdmin III > 1.6.1 with ub

Re: [pgadmin-support] problems compiling PGAdmin III 1.6.1 with ubuntu

2006-12-06 Thread Dave Page
[EMAIL PROTECTED] wrote: hi all, i wanted to compile PGAdmin III 1.6.1 with ubuntu 6.06 according the compile-instructions at http://www.pgadmin.org/download/source.php and i got the following message configure: error: Your wxWidgets installation cannot support pgAdmin in the selected configu

[pgadmin-support] problems compiling PGAdmin III 1.6.1 with ubuntu 6.06

2006-12-06 Thread Christian.Strobl
hi all, i wanted to compile PGAdmin III 1.6.1 with ubuntu 6.06 according the compile-instructions at http://www.pgadmin.org/download/source.php and i got the following message configure: error: Your wxWidgets installation cannot support pgAdmin in the selected configuration. This may be because

[pgadmin-support] Problems with the new version

2006-12-01 Thread José Fermín francisco ferreras
Hello to all, I don't know to write english, but It will try to do it. I have found a problem using new version 1.6.1 (in Windows). When I create a table (and not inserted any registry to him with insert) and want to do it by the visual route using view dates grid, then when she opens the window

Re: [pgadmin-support] Problems with window management in SQL query dialogue

2006-10-17 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Erwin Brandstetter > Sent: 17 October 2006 03:16 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Problems with window management in > SQL query dia

[pgadmin-support] Problems with window management in SQL query dialogue

2006-10-16 Thread Erwin Brandstetter
Hi developers! I am testing pgAdmin III Beta 3 (Oct 12 2006, re: 5475) on Windows XP (German, latest patch level). - When I choose from the menu: View -> Default View, the previously closed "Scratch pad" becomes visible again. However, the menu does not get updated and keeps displaying the s

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-19 Thread Dave Page
Thanks, patch applied. /D > -Original Message- > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > Sent: 19 June 2006 09:40 > To: Dave Page; Jeremy Palmer; pgadmin-support@postgresql.org > Subject: RE: [pgadmin-support] Problems with SVN win32 build. > > (

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-19 Thread Magnus Hagander
(sorry about the delay) > > 3) When the auto-completion TAB character option is set and you hit > > TAB when there is more than one table option, the auto-complete > > function will always select the first table in the list. It > might be > > better to use the same > > ctrl+space logic with a

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-12 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page > Sent: 12 June 2006 13:59 > To: Jeremy Palmer; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Problems with SVN win32 build. > > Hmm, seems lik

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-12 Thread Dave Page
ilto:[EMAIL PROTECTED] > Sent: 12 June 2006 10:14 > To: pgadmin-support@postgresql.org > Cc: Dave Page > Subject: RE: [pgadmin-support] Problems with SVN win32 build. > > Thanks for the reply. > > I have attached the schema dump > > Jeremy > > > -Origin

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-12 Thread Dave Page
> -Original Message- > From: Jim C. Nasby [mailto:[EMAIL PROTECTED] > Sent: 06 June 2006 22:13 > To: Selber, Heiko > Cc: Dave Page; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Problems with pgagent Jobs > > On Fri, Jun 02, 2006 at 03:57:2

Re: [pgadmin-support] Problems with SVN win32 build.

2006-06-12 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jeremy Palmer > Sent: 05 June 2006 09:26 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Problems with SVN win32 build. > > I've compiled the

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-06 Thread Jim C. Nasby
On Fri, Jun 02, 2006 at 03:57:21PM +0200, Selber, Heiko wrote: > Hi Dave, > > no need to send you the dumps; I compared them and saw what was wrong: Some > of the functions of pgagent were missing. > > Apparently, pgagent.sql had gone only halfway through when it was installed. > > I executed t

[pgadmin-support] Problems with SVN win32 build.

2006-06-05 Thread Jeremy Palmer
I've compiled the trunk branch and have mostly had great success, (especially with quick report and auto-complete functionality) :) However I noticed a few little things: 1) I can't add a job for pgagent to run. I add a job with 1 schedule and 2 steps and I get a "duplicate key violates unique con

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-02 Thread Dave Page
> -Original Message- > From: Selber, Heiko [mailto:[EMAIL PROTECTED] > Sent: 02 June 2006 14:57 > To: Dave Page; pgadmin-support@postgresql.org > Subject: AW: [pgadmin-support] Problems with pgagent Jobs > > Hi Dave, > > no need to send you the dumps; I

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-02 Thread Selber, Heiko
. Thank you for your help, Heiko > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Dave Page > Gesendet: Freitag, 2. Juni 2006 11:57 > An: Selber, Heiko; pgadmin-support@postgresql.org > Betreff: Re: [pgadmin-support] Problems

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-02 Thread Dave Page
> -Original Message- > From: Selber, Heiko [mailto:[EMAIL PROTECTED] > Sent: 01 June 2006 16:35 > To: Dave Page; pgadmin-support@postgresql.org > Subject: AW: [pgadmin-support] Problems with pgagent Jobs > > It is a different database on a different host, but t

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-01 Thread Selber, Heiko
Hi Dave, thanks for your reply. > > 1. Under certain conditions the 'Jobs' icon doesn't appear in the > > pgadmin window. > > I can't imagine how 2 versions of pgAdmin could conflict in this way. > More likely I suspect you used a different maintenance DB (template1 > instead of postgres for exam

Re: [pgadmin-support] Problems with pgagent Jobs

2006-06-01 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Selber, Heiko > Sent: 01 June 2006 10:27 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Problems with pgagent Jobs > > Hello, > > I ha

[pgadmin-support] Problems with pgagent Jobs

2006-06-01 Thread Selber, Heiko
Hello, I have two problems with pgagent jobs: 1. Under certain conditions the 'Jobs' icon doesn't appear in the pgadmin window. I use postgres 8.0.6 on Fedora core 4 with pgadmin 1.4.2 or 1.4.1 on FC4, and I installed the postgres DB according to the instructions. I think th

Re: [pgadmin-support] pgAgent problems

2006-04-05 Thread Dave Page
Title: Re: [pgadmin-support] pgAgent problems On 5/4/06 19:18, "Benjamin Krajmalnik" <[EMAIL PROTECTED]> wrote: I am having problems with pgAgent. I installed the seervice with the following command: C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\

[pgadmin-support] pgAgent problems

2006-04-05 Thread Benjamin Krajmalnik
I am having problems with pgAgent. I installed the seervice with the following command:   C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -u postgres -p postgres -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres   In the servi

[pgadmin-support] Problems while installing pgsql

2006-04-03 Thread Ravi Kumar
– extracted and executed file psql.exe. It is saying error message – libpq.dll not found and re-install the application. Kindly help me to solve the installation problems earliest. Thanks - Ravi Kumar B V

[pgadmin-support] Help about somes problems occured while using The PostgreSQL 8.0 for Windows

2005-12-09 Thread acedeno
Hello, We are research`students on CEIS.. By this, we would like to catch The Postgre SQL`technical advisors attention about a problem occured while using this tool. These are the facts: while executing a consult, looked as a many to many relationship between

Re: [pgadmin-support] pgagent problems

2005-12-07 Thread Andreas Pflug
luca porcu wrote: Hello all, I have a problem with pgagent, installation of schema and service ok, when create a job with one or more steps and schedulate it, I see in Property Next RUN correct time, but the job never start ..! In the job property I set hostAgent black, the service is installe

[pgadmin-support] pgagent problems

2005-12-07 Thread luca porcu
Hello all,I have a problem with pgagent, installation of schema and service ok, when create a job with one or more steps and schedulate it, I see in Property Next RUN correct time, but the job never start ..!In the job property I set hostAgent black, the service is installed with: pgAgent.exe INSTA

[pgadmin-support] FW: Problems with PgAdmin 1.4

2005-11-23 Thread Dave Page
Forwarded to the support mailing list as I don't have time to look at this atm. Regards, Dave > -Original Message- > From: Piotr Hlawski [mailto:[EMAIL PROTECTED] > Sent: 22 November 2005 10:03 > To: Dave Page > Subject: Problems with PgAdmin 1.4 > > Hell

Re: [pgadmin-support] pgAdmin - pgAgent problems

2005-10-17 Thread Dave Page
edule ID instead of 1234 of course!   Regards, Dave. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paolo SaudinSent: 16 October 2005 09:08To: pgadmin-support@postgresql.orgSubject: [pgadmin-support] pgAdmin - pgAgent problems Hi,     I am using postg

[pgadmin-support] pgAdmin - pgAgent problems

2005-10-16 Thread Paolo Saudin
Hi,     I am using postgresql-8.1-beta3 on WinXP SP2 I installed it with default settings, then I loaded the "pgAgent.sql" script against the postgres database. pgAdmin can now manage jobs. I created a simple job that should insert a row in a test table. All ok. The problem is that I am not

[pgadmin-support] problems installing pgadminIII

2005-09-12 Thread miwalsh
I was trying to install PG Admin III on Redhat, here is the error message: rpm -Uvh pgadmin3-1.2.2-2.i686.rpm warning: pgadmin3-1.2.2-2.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e error: Failed dependencies: libXinerama.so.1 is needed by pgadmin3-1.2.2-2 libXxf86vm.so.1 is n

  1   2   3   >