[pgadmin-support] problem with pgAdmin 4 on Windows

2016-11-30 Thread Harasty, Daniel J
Greetings, I'm trying to install pgAdmin 4 on my Windows laptop (without installing the full version of PostgreSQL) so that I can admin my 9.3 server on a nearby Ubuntu box. The download of version 1.1 and install seemed to work fine. However, upon launching, I get stuck in a loop of where th

Re: [pgadmin-support] Problem createing table with citext

2016-10-18 Thread Dave Page
On Mon, Oct 17, 2016 at 11:05 AM, Johann Spies wrote: > When I try to create a table using the gui, it generates this definition > which fails: > > CREATE TABLE o.r_url > ( > id bigserial NOT NULL, > orc character varying(19) NOT NULL, > ex_id_com_name "public.citext", > ex_id_ref

[pgadmin-support] Problem createing table with citext

2016-10-18 Thread Johann Spies
When I try to create a table using the gui, it generates this definition which fails: CREATE TABLE o.r_url ( id bigserial NOT NULL, orc character varying(19) NOT NULL, ex_id_com_name "public.citext", ex_id_ref "public.citext", ex_id_url "public.citext", PRIMARY KEY (orc) )

Re: [pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Marc-André Goderre
Thank you for the response. Marc De : Dave Page [mailto:dp...@pgadmin.org] Envoyé : 8 août 2016 15:29 À : Marc-André Goderre Cc : pgadmin-support@postgresql.org Objet : Re: [pgadmin-support] Problem with capital letter in column name This has already been fixed for beta 4. Thanks for the report

Re: [pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Dave Page
This has already been fixed for beta 4. Thanks for the report though. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 8 Aug 2016, at 19:43, Marc-André Goderre wrote: > > I work with an existi

Re: [pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Patrick Headley
août 2016 14:49 *À :* pgadmin-support@postgresql.org *Objet :* Re: [pgadmin-support] Problem with capital letter in column name Put double-quotes around it or else it will get rolled down to lower case and won't match the actual field name. */Patrick Headley/* Linx Consulting, Inc.

Re: [pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Marc-André Goderre
in pgAdmin4? Thanks Marc De : pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] De la part de Patrick Headley Envoyé : 8 août 2016 14:49 À : pgadmin-support@postgresql.org Objet : Re: [pgadmin-support] Problem with capital letter in column name Put double-quo

Re: [pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Patrick Headley
Put double-quotes around it or else it will get rolled down to lower case and won't match the actual field name. */Patrick Headley/* Linx Consulting, Inc. phead...@linxco-inc.com (303) 916-5522 www.linxco-inc.com On 08/08/2016 12:43 PM, Marc-André Goderre wrote: I work with an existing datab

[pgadmin-support] Problem with capital letter in column name

2016-08-08 Thread Marc-André Goderre
I work with an existing database containing capital letter in column name. When i want to view data from conextual meny, it always send an error : i.e.: ERROR: column "idmunicipaliteexterne" does not exist LINE 2: ORDER BY idMunicipaliteExterne ^ ** Error ** ERROR

Re: [pgadmin-support] Problem displaying intervals and timestamps with pgAdmin 4

2016-06-13 Thread Dave Page
On Mon, Jun 13, 2016 at 10:51 AM, Albe Laurenz wrote: > Dave Page wrote: >> Please log any additional issues directly at >> https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me >> a step :-) > > Gladly. Thanks. > Wouldn't it be good to mention > https://redmine.postgresql.org/

Re: [pgadmin-support] Problem displaying intervals and timestamps with pgAdmin 4

2016-06-13 Thread Albe Laurenz
Dave Page wrote: > Please log any additional issues directly at > https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me > a step :-) Gladly. Wouldn't it be good to mention https://redmine.postgresql.org/projects/pgadmin4/ on https://www.pgadmin.org/support/ ? Yours, Laurenz Albe

Re: [pgadmin-support] Problem displaying intervals and timestamps with pgAdmin 4

2016-06-13 Thread Dave Page
Thanks - issue #1352 created. Please log any additional issues directly at https://redmine.postgresql.org/projects/pgadmin4/issues/new to save me a step :-) On Mon, Jun 13, 2016 at 10:32 AM, Albe Laurenz wrote: > I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7. > > I

[pgadmin-support] Problem displaying intervals and timestamps with pgAdmin 4

2016-06-13 Thread Albe Laurenz
I am using pgAdmin 4 1.0-beta1 (downloaded from pgadmin.org) on Windows 7. I get an error message like this: 500 Internal Server Error Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in

[pgadmin-support] problem regarding box2d function

2015-06-10 Thread ofezzaz
Hello, I'm not sure if i should create a new topic for this but i did not find anything about this so here it is. I 've loaded a script that contains the structure of the database but when i try to execute the SQL request i have some errors. I've loaded a picture so you can see what i wrote and

Re: [pgadmin-support] Problem building on MacOS

2014-09-24 Thread Dave Page
On Tue, Sep 23, 2014 at 5:49 PM, Charlie Clark wrote: > Am .09.2014, 17:17 Uhr, schrieb Dave Page : > >> wxWidgets 3.0 should work in 64 bit, but it's not very well tested. > > > Builds fine. There are some alerts in some of the windows. But as I was > preparing the build I noticed that there is a

Re: [pgadmin-support] Problem building on MacOS

2014-09-23 Thread Charlie Clark
Am .09.2014, 17:17 Uhr, schrieb Dave Page : wxWidgets 3.0 should work in 64 bit, but it's not very well tested. Builds fine. There are some alerts in some of the windows. But as I was preparing the build I noticed that there is also a build of the new beta on postgresql.org so http://www.p

Re: [pgadmin-support] Problem building on MacOS

2014-09-23 Thread Charlie Clark
Am .09.2014, 17:17 Uhr, schrieb Dave Page : wxWidgets 3.0 should work in 64 bit, but it's not very well tested. The binary from MacPorts seems to be 64-bit and works fine. It's a much smaller package. I'll see how I get on by updating the Portfile for the beta. Charlie -- Charlie Clark

Re: [pgadmin-support] Problem building on MacOS

2014-09-23 Thread Charlie Clark
Am .09.2014, 17:00 Uhr, schrieb Dave Page : You need to use a 32 bit build of libxml2 (and possibly some of the other libraries used). We typically use private builds for some such libraries, and install them into /usr/local. Oh, I generally rely on MacPorts to manage all my libraries. I was l

Re: [pgadmin-support] Problem building on MacOS

2014-09-23 Thread Dave Page
On Tue, Sep 23, 2014 at 4:12 PM, Charlie Clark wrote: > Am .09.2014, 17:00 Uhr, schrieb Dave Page : > >> You need to use a 32 bit build of libxml2 (and possibly some of the >> other libraries used). We typically use private builds for some such >> libraries, and install them into /usr/local. > > >

Re: [pgadmin-support] Problem building on MacOS

2014-09-23 Thread Dave Page
On Tue, Sep 23, 2014 at 3:57 PM, Charlie Clark wrote: > Hi, > > I thought I'd give the beta a spin but I'm having trouble building it. > > I get the following error: > > "_xmlTextWriterWriteString", referenced from: > frmQuery::SaveQueries() in frmQuery.o > queryFavouriteFolder::save

[pgadmin-support] Problem building on MacOS

2014-09-23 Thread Charlie Clark
Hi, I thought I'd give the beta a spin but I'm having trouble building it. I get the following error: "_xmlTextWriterWriteString", referenced from: frmQuery::SaveQueries() in frmQuery.o queryFavouriteFolder::saveFolder(_xmlTextWriter*) in favourites.o queryMacroList::saveLis

[pgadmin-support] Problem installing pgadmin3_93 on rhel-6.5

2014-05-23 Thread Oliver
Hi guys, I've installed rpm repository from http://yum.postgresql.org/9.3/redhat/rhel-6.5-x86_64/, and then I've installed postgresql93, postgresql93-server and postgresql93-contrib packages correctly, but I'm having problems for installing pgadmin3_93 (64 bits version). It is due to dependency err

Re: [pgadmin-support] Problem with pg_baselinebackup

2014-01-16 Thread Darren Duncan
John, I believe that in Postgres-land, the term 'pgdata' has a fairly standard meaning which lets you tell the program where your database directory is if it isn't in a standard location, that might be part of it. -- Darren Duncan On 1/16/2014, 9:18 AM, Sebastian, John (CONTR) wrote: Hi Folks,

[pgadmin-support] Problem with pg_baselinebackup

2014-01-16 Thread Sebastian, John (CONTR)
Hi Folks, I'm pretty new to Postgres. I have an extensive Oracle and MySQL background here. We are putting up test and production servers. I'm interested in doing online backups with WAL archiving turned on so that I can do point in time recovery. My database files are stored in /u01/postgres/d

[pgadmin-support] Problem generating database using pgAdmin III - PostgreSQL version is 9.1

2013-08-29 Thread Hager, Paul CIV NAVSEA Crane, NAVSEA
This is going to be complicated so I'll try to be as succinct as possible. I am trying to port two PostgreSQL databases from a Linux system to Windows. After I do that, I will use a tool to convert the two databases to Access. I know this can be done - another person already did it. The probl

Re: [pgadmin-support] Problem: List view collapses upon change

2013-06-24 Thread Dave Page
On Sun, Jun 23, 2013 at 10:45 PM, Eike Dierks wrote: > Hi everyone reading pgadmin-support, > > PgAdmin is a very fine tool. > > There is a single erratic behaviour which I'd love to see fixed, > to make it an even more valuable tool. > > > When I'm changing the properties of a column, > the tree

[pgadmin-support] Problem: List view collapses upon change

2013-06-23 Thread Eike Dierks
Hi everyone reading pgadmin-support, PgAdmin is a very fine tool. There is a single erratic behaviour which I'd love to see fixed, to make it an even more valuable tool. When I'm changing the properties of a column, the tree on the left side of the pgadmin window collapses and I have to navigat

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-10 Thread Dave Page
On Tue, Apr 9, 2013 at 5:00 PM, Michael Shapiro wrote: > Yes and no. > > If I run the script that creates the function, does the set > client_min_messages, then runs the function, > I get the DEBUG. > > But then if I just runt he function (in a new query window). I do not get > the DEBUG messages.

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-09 Thread Michael Shapiro
Yes and no. If I run the script that creates the function, does the set client_min_messages, then runs the function, I get the DEBUG. But then if I just runt he function (in a new query window). I do not get the DEBUG messages. However, if I add SET client_min_messages to 'DEBUG'; in the q

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-09 Thread Dave Page
On Tue, Apr 9, 2013 at 4:47 PM, Michael Shapiro wrote: > I have a very similar function and client_min_message set exactly the same, > When I run the procedure in the query tool, I do not see any DEBUG message. > If I run it in PSQL console, the DEBUG message appear. > > There must be something in

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-09 Thread Michael Shapiro
I have a very similar function and client_min_message set exactly the same, When I run the procedure in the query tool, I do not see any DEBUG message. If I run it in PSQL console, the DEBUG message appear. There must be something in PgAdmin that is doing this ... On Tue, Apr 9, 2013 at 10:01 AM,

Re: [pgadmin-support] Problem with DEBUG messages

2013-04-09 Thread Dave Page
Hi On Mon, Apr 8, 2013 at 5:58 PM, Michael Shapiro wrote: > Hi Dave, > > I reported a problem I am having with PgAdmin and DEBUG messages (April > 2nd). There has been no repsonse. I am pretty sure it is a PgAdmin issue, as > other tools show the DEBUG messages but they do not show in PgAdmin. I

Re: [pgadmin-support] Problem w Favourites menu

2013-04-08 Thread Dinesh Kumar
Thank you so much Dave for the valuable instructions. I will keep this in mind, and will take care by going forward. Best Regards, Dinesh On Mon, Apr 8, 2013 at 10:05 PM, Dave Page wrote: > Hi > > On Wed, Mar 27, 2013 at 7:03 AM, Dinesh Kumar > wrote: > > Hi Dave, > > > > Thanks for the guida

[pgadmin-support] Problem with DEBUG messages

2013-04-08 Thread Michael Shapiro
Hi Dave, I reported a problem I am having with PgAdmin and DEBUG messages (April 2nd). There has been no repsonse. I am pretty sure it is a PgAdmin issue, as other tools show the DEBUG messages but they do not show in PgAdmin. == Message ID: CAGCvxeb6KStFf95QAcCmo7sc49nvS6usEKV_ntthLr

Re: [pgadmin-support] Problem w Favourites menu

2013-04-08 Thread Dave Page
Hi On Wed, Mar 27, 2013 at 7:03 AM, Dinesh Kumar wrote: > Hi Dave, > > Thanks for the guidance on this. I am attaching the patch for the same. Unfortunately I think there are a few issues here. 1) Please keep an eye on your formatting: - There are spelling mistakes in comments. - There shou

Re: [pgadmin-support] Problem installing pgAgent v3.3 on Mac OS X 10.5.8 Intel

2013-04-05 Thread Dave Page
On Tue, Apr 2, 2013 at 8:08 AM, David Blaymires wrote: > Hi, > > I installed pgsql v9.1.8, used Stackbuilder to download pgAgent v3.3 and > tried to run the installer. After getting to the window where the details > for the server are confirmed and you enter the postgres user password, you > click

Re: [pgadmin-support] Problem w Favourites menu

2013-04-02 Thread Dinesh Kumar
Hi Lou O’Quin, Can you please share the requested file " pgadmin_favourites.xml " to reproduce the same issue. So that, we will improve quality of pgAdmin tool. Thanks for your attention. Best Regards, Dinesh

[pgadmin-support] Problem installing pgAgent v3.3 on Mac OS X 10.5.8 Intel

2013-04-02 Thread David Blaymires
Hi, I installed pgsql v9.1.8, used Stackbuilder to download pgAgent v3.3 and tried to run the installer. After getting to the window where the details for the server are confirmed and you enter the postgres user password, you click next - then I got this error (note: this is taken from the cras

Re: [pgadmin-support] Problem w Favourites menu

2013-03-27 Thread Dinesh Kumar
Hi Dave, Thanks for the guidance on this. I am attaching the patch for the same. Hi Lou O’Quin, Please share the requested details for resolving the issues. Thanks for your attention. Best Regards, Dinesh On Tue, Mar 26, 2013 at 12:15 PM, Dinesh Kumar < dinesh.ku...@enterprisedb.com> wrote:

Re: [pgadmin-support] Problem w Favourites menu

2013-03-25 Thread Dinesh Kumar
On Mon, Mar 25, 2013 at 11:58 PM, Dave Page wrote: > On Mon, Mar 25, 2013 at 9:15 AM, Dinesh Kumar > wrote: > > > > While working on this issue in my local machine i have tried some test > cases > > to re-produce the same and found that "pgadmin_favourites.xml" > overwriting > > it's favorite det

Re: [pgadmin-support] Problem w Favourites menu

2013-03-25 Thread Dave Page
On Mon, Mar 25, 2013 at 9:15 AM, Dinesh Kumar wrote: > > While working on this issue in my local machine i have tried some test cases > to re-produce the same and found that "pgadmin_favourites.xml" overwriting > it's favorite details among the concurrent "Favourite" items. > > To re-produce the s

Re: [pgadmin-support] Problem w Favourites menu

2013-03-25 Thread Dinesh Kumar
Hi Lou O’Quin, Would like to say thanks for reporting to pgAdmin-support list about this issue. I have tried to re-produce the issue with my local machine, but unfortunately i am not able to reproduce the same issue. Hence, would like to request you to share the following details from your side.

Re: [pgadmin-support] Problem w Favourites menu

2013-03-22 Thread Dinesh Kumar
Sure Ashesh, I will update this thread with my findings. Thanks. Best Regards, Dinesh On Fri, Mar 22, 2013 at 9:25 AM, Ashesh Vashi wrote: > Dinesh, > > Can you please take a look at it? > > > On Thu, Mar 21, 2013 at 11:35 PM, Lou Oquin wrote: > >> When I select Favourites, Add from the que

Re: [pgadmin-support] Problem w Favourites menu

2013-03-22 Thread Dinesh Kumar
Sure Ashesh, I will update this thread with my findings. Thanks. Best Regards, Dinesh

Re: [pgadmin-support] Problem w Favourites menu

2013-03-21 Thread Ashesh Vashi
Dinesh, Can you please take a look at it? On Thu, Mar 21, 2013 at 11:35 PM, Lou Oquin wrote: > When I select Favourites, Add from the query window menu, and I enter a > favourites name which contains spaces, I almost always get a fatal error > message from Windows 7. The image (and text) of

[pgadmin-support] Problem w Favourites menu

2013-03-21 Thread Lou Oquin
When I select Favourites, Add from the query window menu, and I enter a favourites name which contains spaces, I almost always get a fatal error message from Windows 7. The image (and text) of the error message is below. When I restart pgAdmin, the favourite has been added (with spaces.) If I th

Re: [pgadmin-support] Problem with pgAdmin and Server Status encode

2013-03-04 Thread Jan-Peter Seifert
Hello, Original-Nachricht > Datum: Sat, 23 Feb 2013 15:56:50 +0100 > Von: Guillaume Lelarge > An: "Manuel Fdez (JVR)" > CC: pgadmin-support@postgresql.org > Betreff: Re: [pgadmin-support] Problem with pgAdmin and Server Status encode > Well, I

Re: [pgadmin-support] Problem with pgAdmin and Server Status encode

2013-02-23 Thread Guillaume Lelarge
On Thu, 2013-02-21 at 21:02 +0100, Manuel Fdez (JVR) wrote: > Version pgAdminIII: 1.16.1 > > > > Server PostgreSQL: 9.1 > > > > OS: Windows 7 Professional SP1 > > > > When I try to open Server Status I receive this message continuously: > > > > cid:image001.png@01CE1069.DB3DBD30 >

[pgadmin-support] Problem with pgAdmin and Server Status encode

2013-02-21 Thread Manuel Fdez (JVR)
Version pgAdminIII: 1.16.1 Server PostgreSQL: 9.1 OS: Windows 7 Professional SP1 When I try to open Server Status I receive this message continuously: cid:image001.png@01CE1069.DB3DBD30 My Database encode: UTF8 and Collation and Charset Spanish, Spain. Thanks.

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Dave Page
On Fri, Dec 7, 2012 at 1:14 PM, Magnus Hagander wrote: > On Thu, Dec 6, 2012 at 6:39 PM, Dave Page wrote: >> On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: >>> Certainly sounds like a very similar problem. If so, the query is >>> simply buggy - it's just that a pg_upgrade'd environment

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Magnus Hagander
On Thu, Dec 6, 2012 at 6:39 PM, Dave Page wrote: > On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: >> Certainly sounds like a very similar problem. If so, the query is >> simply buggy - it's just that a pg_upgrade'd environment is *much* >> more likely to run into the problem than before.

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Dave Page
Thanks - I've committed and pushed the patch. On Fri, Dec 7, 2012 at 10:39 AM, Per Wigren wrote: > Unfortunately I don't have a build environment for this here at work but I > can confirm that by manually applying the change to the query in > edbPackage.cpp in the diff to the query I snatched fro

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Per Wigren
Unfortunately I don't have a build environment for this here at work but I can confirm that by manually applying the change to the query in edbPackage.cpp in the diff to the query I snatched from pg_log, the output looks good. No more duplicates. // Per 2012/12/6 Dave Page > On Thu, Dec 6, 2012

Re: [pgadmin-support] Problem with multiple comments

2012-12-07 Thread Dave Page
On Thu, Dec 6, 2012 at 11:32 PM, Andrzej Zawadzki wrote: > On 06.12.2012 18:39, Dave Page wrote: >> On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: >>> Certainly sounds like a very similar problem. If so, the query is >>> simply buggy - it's just that a pg_upgrade'd environment is *much*

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Andrzej Zawadzki
On 06.12.2012 18:39, Dave Page wrote: > On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: >> Certainly sounds like a very similar problem. If so, the query is >> simply buggy - it's just that a pg_upgrade'd environment is *much* >> more likely to run into the problem than before. >> >> I onl

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Dave Page
On Thu, Dec 6, 2012 at 11:48 AM, Magnus Hagander wrote: > Certainly sounds like a very similar problem. If so, the query is > simply buggy - it's just that a pg_upgrade'd environment is *much* > more likely to run into the problem than before. > > I only checked the usages of pg_shdescription. The

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Magnus Hagander
Certainly sounds like a very similar problem. If so, the query is simply buggy - it's just that a pg_upgrade'd environment is *much* more likely to run into the problem than before. I only checked the usages of pg_shdescription. The same bug might well exist with almost all uses of pg_description.

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Per Wigren
ok, then the same issue occurs with functions as well because there are the same kind of duplicates in the list of functions. 2012/12/6 Dave Page > On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren wrote: > > Yes, I have actually run pg_upgrade on it... Where can I find details > about > > this bug

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Dave Page
On Thu, Dec 6, 2012 at 11:03 AM, Per Wigren wrote: > Yes, I have actually run pg_upgrade on it... Where can I find details about > this bug? The CHANGELOG just says: 2012-11-26 MH 1.16.1 Fix query for database descriptions So I guess the same issue occurs with schemas. I believe it occurs be

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Per Wigren
Yes, I have actually run pg_upgrade on it... Where can I find details about this bug? The same thing happens with 1.16.1. 2012/12/6 Dave Page > On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren wrote: > > I mailed you the screenshots. > > > > I snatched the SQL from pg_log that pgAdmin runs when r

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Dave Page
On Thu, Dec 6, 2012 at 10:47 AM, Per Wigren wrote: > I mailed you the screenshots. > > I snatched the SQL from pg_log that pgAdmin runs when refreshing the list of > schemas and that query also returns these duplicate schemas. So do the > Object List Report html output. Hmm, odd. I don't suppose

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Per Wigren
I mailed you the screenshots. I snatched the SQL from pg_log that pgAdmin runs when refreshing the list of schemas and that query also returns these duplicate schemas. So do the Object List Report html output. 2012/12/6 Dave Page > On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren wrote: > > When q

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Dave Page
On Thu, Dec 6, 2012 at 10:31 AM, Per Wigren wrote: > When querying pg_description for the oid of one schema that has duplicates > in pgAdmin I get this: > > bix_live=# select * from pg_description where objoid = 16458; > objoid | classoid | objsubid | > description > +--+-

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Per Wigren
When querying pg_description for the oid of one schema that has duplicates in pgAdmin I get this: bix_live=# select * from pg_description where objoid = 16458; objoid | classoid | objsubid | description +--+--+--

Re: [pgadmin-support] Problem with multiple comments

2012-12-06 Thread Dave Page
On Thu, Dec 6, 2012 at 9:42 AM, Per Wigren wrote: > When there are multiple comments on a schema, pgAdmin 1.16 will display one > duplicate of the schema for each comment, where the only difference is the > last line "COMMENT ON SCHEMA schema_name IS 'something';". The same thing > happens in the

[pgadmin-support] Problem with multiple comments

2012-12-06 Thread Per Wigren
When there are multiple comments on a schema, pgAdmin 1.16 will display one duplicate of the schema for each comment, where the only difference is the last line "COMMENT ON SCHEMA schema_name IS 'something';". The same thing happens in the function list, where there are many duplicates only differe

Re: [pgadmin-support] Problem with pgadmin3 1.16.0

2012-11-25 Thread Guillaume Lelarge
On Wed, 2012-10-24 at 17:39 +0200, Andrzej Zawadzki wrote: > Hi! > > After upgrade database to version 9.2.1 I have very strange situation. > Look at the screenshot: > > http://imageshack.us/photo/my-images/577/pgadminfunctionssnapsho.png/ > > Function is multiplied by notes from comments on one

[pgadmin-support] Problem with pgadmin3 1.16.0

2012-10-24 Thread Andrzej Zawadzki
Hi! After upgrade database to version 9.2.1 I have very strange situation. Look at the screenshot: http://imageshack.us/photo/my-images/577/pgadminfunctionssnapsho.png/ Function is multiplied by notes from comments on one table :-D Sources are equal. In psql it looks properly. qstest=# \df ali

Re: [pgadmin-support] problem with empty arguments of trigger procedure

2012-07-19 Thread Guillaume Lelarge
On Wed, 2012-07-04 at 21:55 +0200, Guillaume Lelarge wrote: > On Tue, 2012-07-03 at 10:05 +0200, Michał Sienicki wrote: > > Bug report - pgAdmin 1.14.3, Windows > > > > Trigger definition is not shown properly when function contains "empty" > > arguments. > > > > Example > > > > Trigger definit

Re: [pgadmin-support] problem with empty arguments of trigger procedure

2012-07-04 Thread Guillaume Lelarge
On Tue, 2012-07-03 at 10:05 +0200, Michał Sienicki wrote: > Bug report - pgAdmin 1.14.3, Windows > > Trigger definition is not shown properly when function contains "empty" > arguments. > > Example > > Trigger definition: > > CREATE TRIGGER test_trigger > BEFORE INSERT > ON test_table > FOR EA

[pgadmin-support] problem with empty arguments of trigger procedure

2012-07-03 Thread Michał Sienicki
Bug report - pgAdmin 1.14.3, Windows Trigger definition is not shown properly when function contains "empty" arguments. Example Trigger definition: CREATE TRIGGER test_trigger BEFORE INSERT ON test_table FOR EACH ROW EXECUTE PROCEDURE test_function('arg1', '', 'arg3'); is displayed in pgAdmin

Re: [pgadmin-support] problem using pgAdmin III

2012-02-13 Thread Vjacheslav A.
On Sat, Feb 11, 2012 at 4:16 PM, Raymond O'Donnell wrote: > On 11/02/2012 00:22, James Ib Akoma wrote: > > My pgAdmin will not allow me to edit a table. > > Need help. > Maybe table doesn't have a primary key.

Re: [pgadmin-support] problem using pgAdmin III

2012-02-11 Thread Raymond O'Donnell
On 11/02/2012 00:22, James Ib Akoma wrote: > My pgAdmin will not allow me to edit a table. > Need help. Some details would help - we can't read your mind :-) - What platform(s) are pgAdmin and the server on? - What versions of pgAdmin and PostgreSQL? - Is the server local or remote? - What

[pgadmin-support] problem using pgAdmin III

2012-02-11 Thread James Ib Akoma
My pgAdmin will not allow me to edit a table. Need help. James I.

Re: [pgadmin-support] problem with server status window

2012-02-07 Thread Maximilian Tyrtania
Am 07.02.2012 um 10:44 schrieb Dave Page: > On Tue, Feb 7, 2012 at 9:41 AM, Maximilian Tyrtania > wrote: >> Am 06.02.2012 um 23:28 schrieb Guillaume Lelarge: >> >>> No. Looking at your report, I found a bug. At the opening of the status >>> server window, the log pane is selected but its widgets

Re: [pgadmin-support] problem with server status window

2012-02-07 Thread Dave Page
On Tue, Feb 7, 2012 at 9:41 AM, Maximilian Tyrtania wrote: > Am 06.02.2012 um 23:28 schrieb Guillaume Lelarge: > >> No. Looking at your report, I found a bug. At the opening of the status >> server window, the log pane is selected but its widgets aren't. This bug >> is now fixed. Before we can hav

Re: [pgadmin-support] problem with server status window

2012-02-07 Thread Maximilian Tyrtania
Am 06.02.2012 um 23:28 schrieb Guillaume Lelarge: > No. Looking at your report, I found a bug. At the opening of the status > server window, the log pane is selected but its widgets aren't. This bug > is now fixed. Before we can have another minor release, there is a > workaround: select another p

Re: [pgadmin-support] problem with server status window

2012-02-06 Thread Guillaume Lelarge
On Sat, 2012-02-04 at 11:43 +0100, Maximilian Tyrtania wrote: > Am 03.02.2012 um 16:26 schrieb Maximilian Tyrtania: > > > im using PGAdmin 1.14.1 on Mac OS 10.7.2 with PG 9.0 running on Ubuntu and > > keep having the following problem. The log files displayed in the server > > status window show

Re: [pgadmin-support] problem with server status window

2012-02-04 Thread Maximilian Tyrtania
Am 03.02.2012 um 16:26 schrieb Maximilian Tyrtania: > im using PGAdmin 1.14.1 on Mac OS 10.7.2 with PG 9.0 running on Ubuntu and > keep having the following problem. The log files displayed in the server > status window show up for the current log file only. I am aware of the fact > that I have

[pgadmin-support] problem with server status window

2012-02-03 Thread Maximilian Tyrtania
Hi there, im using PGAdmin 1.14.1 on Mac OS 10.7.2 with PG 9.0 running on Ubuntu and keep having the following problem. The log files displayed in the server status window show up for the current log file only. I am aware of the fact that I have to click on a row of the log file pane on the rig

Re: [pgadmin-support] Problem with selection of table column type

2012-01-12 Thread Guillaume Lelarge
On Thu, 2012-01-12 at 21:29 +0100, bdmyt...@eranet.pl wrote: [...] > I found problem with dynamic filtering of column types during tabele > creation/column modification using GUI. > It is impossible to start typing column type, it is only possible to select > column type form the drop down menu.

[pgadmin-support] Problem with selection of table column type

2012-01-12 Thread bdmyt...@eranet.pl
Hello All, I found problem with dynamic filtering of column types during tabele creation/column modification using GUI. It is impossible to start typing column type, it is only possible to select column type form the drop down menu. Field is not "read only", but it is not possible to type any le

Re: [pgadmin-support] Problem with pdAdminIII and postgres 9.1.2 on Solaris 10?

2011-12-14 Thread Dave Page
On Wed, Dec 14, 2011 at 3:45 AM, Petra Systems wrote: > Hi: >    I am running postgres 8,3 and 9.1.2 concurrently on solaris 10 08/11. >  pgAdminIII handles the 8.3 cluster very well but for the 9.1.2 cluster it > will not display the databases.  It throws error messages to the effect that > it ca

[pgadmin-support] Problem with pdAdminIII and postgres 9.1.2 on Solaris 10?

2011-12-13 Thread Petra Systems
Hi: I am running postgres 8,3 and 9.1.2 concurrently on solaris 10 08/11. pgAdminIII handles the 8.3 cluster very well but for the 9.1.2 cluster it will not display the databases. It throws error messages to the effect that it can't find columns such as datconfig. The version of pgAdmin

Re: [pgadmin-support] Problem in ubuntu

2011-10-10 Thread Guillaume Lelarge
On Mon, 10 Oct 2011 14:07:28 +0200, Iñigo Delgado wrote: > I've a strange error in ubuntu when trying to open de SQL editor. When I > connect to a DDBB (pg 9.1) and open a SQLEditor window pgadmin3 > crashes > I execute from console: > user@machine:$ pgadmin3  > And the message thrown is: > /

[pgadmin-support] Problem in ubuntu

2011-10-10 Thread Iñigo Delgado
I've a strange error in ubuntu when trying to open de SQL editor. When I connect to a DDBB (pg 9.1) and open a SQLEditor window pgadmin3 crashes I execute from console: user@machine:$ pgadmin3 And the message thrown is: /home/user/.pgadmin_histoqueries:26869: error: xmlSAX2Characters: huge

Re: [pgadmin-support] problem with server status window

2011-08-31 Thread Maximilian Tyrtania
> On Wed, Aug 31, 2011 at 9:31 AM, Maximilian Tyrtania > wrote: >> I'm using PGAdmin 1.14rc1 under Mac OS 10.6.8 and ran into a problem. >> Launched the server status window, clicked on a log file entry on the pane >> on the right, hoping that the popup menu for the different logfiles on the >>

Re: [pgadmin-support] problem with server status window

2011-08-31 Thread Dave Page
On Wed, Aug 31, 2011 at 9:31 AM, Maximilian Tyrtania wrote: > I'm using PGAdmin 1.14rc1 under Mac OS 10.6.8 and ran into a problem. > Launched the server status window, clicked on a log file entry on the pane on > the right, hoping that the popup menu for the different logfiles on the upper > l

[pgadmin-support] problem with server status window

2011-08-31 Thread Maximilian Tyrtania
I'm using PGAdmin 1.14rc1 under Mac OS 10.6.8 and ran into a problem. Launched the server status window, clicked on a log file entry on the pane on the right, hoping that the popup menu for the different logfiles on the upper left corner would enable (which used to work in 1.12). And it would, b

Re: [pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-19 Thread Ashesh Vashi
Hi Peter, It seems, it's trying to load wxWidgets library from the '/usr/lib'. You need to export the LD_LIBRARY_PATH as show below, before running the pgadmin3. *export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH ./pgadmin3* -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise P

Re: [pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-19 Thread Peter Oram
# ldd /usr/local/pgadmin3/bin/pgadmin3 libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 libkrb5.so.1 => /usr/lib/libkrb5.so.1 libnsl.so.1 => /usr/lib/libnsl.so.1 libwx_gtk2u_stc-2.8.so.0 => /usr/lib/libwx_gtk2u_stc-2.8.so.0 libwx_gtk2u_ogl-2.8.so.0 => /usr/lib/l

Re: [pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-19 Thread Ashesh Vashi
What is the output of 'ldd pgadmin3'? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company *http://www.linkedin.com/in/asheshvashi* On Mon, Dec 20, 2010 at 5:25 AM, Peter Oram wrote: > I have

Re: [pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-19 Thread Peter Oram
I have successfully rebuilt wxWidgets using the build-wxgtk script, then rebuilt pgAdmin3. However, once again when I try to run the pgAdmin3 application I am still getting the same relocation error as before. Now I have two versions of wxWidgets installed on the system. The original version

Re: [pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-16 Thread Ashesh Vashi
Hi Peter, Please use the script 'xtra/wx-build/build-wxgtk' found under pgadmin source directory to build the wxGTK/wxWidgets. i.e. (with root) /bin/bash /xtra/wx-build/build-wxgtk The error suggests that stc (wxStyledText) is not installed from the contrib module of wxGTK. -- Thanks & Regards,

[pgadmin-support] Problem installing pgadmin3-1.12.1

2010-12-16 Thread Peter Oram
I am attempting to install pgAdmin3 version 1.12.1 on an Oracle Solaris 11 Express 2010.11 system. I have the recommended version of GTK2, GNU automake, autoconf and gcc installed as part of my development environment. I have updated the wxGTK package to 2.8.11, and also have above the reco

Re: [pgadmin-support] problem with copy from on a windows system

2010-10-27 Thread Guillaume Lelarge
Le 27/10/2010 03:24, Marie-Claude QUIDOZ a écrit : > [...] > Yes, but both are on windows system > When you use the COPY command, the file you specify must be on the PostgreSQL server. When you use \copy from psql, the file must be on the computer where you execute the \copy command. If you use

Re: [pgadmin-support] problem with copy from on a windows system

2010-10-27 Thread Dave Page
On Mon, Oct 25, 2010 at 5:54 PM, Marie-Claude QUIDOZ wrote: > Hello > > I don't find how i can use the command "copy from" with pgadmin in sql > windows > > When i try to execute this command > "copy dico_coordonnee_geographique from 'C:/Dossier de > travail/Temporaire/dico_coordonnee" > > I recei

Re: [pgadmin-support] problem with copy from on a windows system

2010-10-27 Thread Marie-Claude QUIDOZ
 : Re: [pgadmin-support] problem with copy from on a windows system Hello Yes, but both are on windows system MCQ -Message d'origine- De : Guillaume Lelarge [mailto:guilla...@lelarge.info] Envoyé : mardi 26 octobre 2010 05:43 À : Marie-Claude QUIDOZ Cc : pgadmin-support@postgresql.org

Re: [pgadmin-support] problem with copy from on a windows system

2010-10-25 Thread Marie-Claude QUIDOZ
Hello Yes, but both are on windows system MCQ -Message d'origine- De : Guillaume Lelarge [mailto:guilla...@lelarge.info] Envoyé : mardi 26 octobre 2010 05:43 À : Marie-Claude QUIDOZ Cc : pgadmin-support@postgresql.org Objet : Re: [pgadmin-support] problem with copy from on a wi

Re: [pgadmin-support] problem with copy from on a windows system

2010-10-25 Thread Guillaume Lelarge
Le 25/10/2010 09:54, Marie-Claude QUIDOZ a écrit : > [...] > I don't find how i can use the command "copy from" with pgadmin in sql > windows > > When i try to execute this command > "copy dico_coordonnee_geographique from 'C:/Dossier de > travail/Temporaire/dico_coordonnee" > > I receive this te

  1   2   3   4   >