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

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

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

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

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

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

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

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

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

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

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

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

Re: [pgadmin-support] Problem building on MacOS

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

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

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

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

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

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

Re: [pgadmin-support] Problem with pg_baselinebackup

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,

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

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

Re: [pgadmin-support] Problem with DEBUG messages

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

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

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

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

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

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

Re: [pgadmin-support] Problem w Favourites menu

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

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

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

Re: [pgadmin-support] Problem w Favourites menu

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

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

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

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

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

Sure Ashesh, I will update this thread with my findings. Thanks. Best Regards, Dinesh

Re: [pgadmin-support] Problem w Favourites menu

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

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

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

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 >

Re: [pgadmin-support] Problem with multiple comments

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: [pgadmin-support] Problem with pgadmin3 1.16.0

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

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

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

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

Re: [pgadmin-support] problem using pgAdmin III

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

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

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

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

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

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

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

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

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

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.

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

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

Re: [pgadmin-support] Problem in ubuntu

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

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

> 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

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

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

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

# 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

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

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

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,

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

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

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

 : 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

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

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

Re: [pgadmin-support] problem with access database

On Mon, Oct 4, 2010 at 5:45 PM, Raymond O'Donnell wrote: > I presume that "edb" is the equivalent in EnterpriseDB - the EDB folks here > will be able to confirm. It is. > "template1" is what was used in older versions of PostgreSQL. However, > template1 is also used as a default template when n

Re: [pgadmin-support] problem with access database

On 04/10/2010 17:36, Marie-Claude QUIDOZ wrote: Hello By default, pgAdmin connects to the postgres database. With "by default" I mean that you didn't change the maintenance DB in the server dialog. Yes I haven't change because I don't know what to put. I have the choice between postgres, edb

Re: [pgadmin-support] problem with access database

Le 04/10/2010 18:36, Marie-Claude QUIDOZ a écrit : > Hello > >> By default, pgAdmin connects to the postgres database. With "by default" >> I mean that you didn't change the maintenance DB in the server dialog. > > Yes I haven't change because I don't know what to put. I have the choice > betwe

Re: [pgadmin-support] problem with access database

template1 and I don't find any documentation to help me to understand. I don't understand what is "maintenance DB" Bye MCQ -Message d'origine- De : Guillaume Lelarge [mailto:guilla...@lelarge.info] Envoyé : vendredi 1 octobre 2010 23:20 À : Marie-Claude QUIDOZ Cc : pga

Re: [pgadmin-support] problem with access database

Le 01/10/2010 16:20, Marie-Claude QUIDOZ a écrit : > Hello > > I use 1.12.0 PGAdminIII from a client for seven windows connect to a postgres > server 8.4.2.1 installed on a Windows 2008 server 32-bit server (service pack > 2). > > I want to give access at the database "PicSaintLoup" to user "r

Re: [pgadmin-support] Problem creating backup of schema

Le 01/06/2010 16:16, Niklas Olsson a écrit : > > Hi > I run windows xp, pgdemo 1.10.3. > In this version I can no longer create a backup when schema has been > changed. > this is what I do, > > I have a schema in one database, export that one. > Restore in into another database. > Rename the sc

Re: [pgadmin-support] Problem creating backup of schema

On 03/06/2010 08:22, Niklas Olsson wrote: > > > I sure mean pgAdmin :) :-) > I rename it via pgAdmin's interface > what is the sql command to rename a schame that way? Here you go: http://www.postgresql.org/docs/8.4/static/sql-alterschema.html However, if you're renaming via pgAdmin, then

Re: [pgadmin-support] Problem creating backup of schema

I sure mean pgAdmin :) I rename it via pgAdmin's interface what is the sql command to rename a schame that way? /Niklas > Date: Tue, 1 Jun 2010 15:28:28 +0100 > From: r...@iol.ie > To: nikl...@hotmail.com > CC: pgadmin-support@postgresql.org > Subject: Re: [pgad

Re: [pgadmin-support] Problem creating backup of schema

On 01/06/2010 15:16, Niklas Olsson wrote: > I run windows xp, pgdemo 1.10.3. I'm sure you mean pgAdmin. :-) > I have a schema in one database, export that one. > Restore in into another database. > Rename the schema, try to make a backup of it and get the error > > pg_dump: No matching schemas

Re: [pgadmin-support] Problem with restore

Le 20/04/2010 18:52, Guillaume Lelarge a écrit : > Hi, > > Le 20/04/2010 18:18, Kieran McCusker a écrit : >> [...] >> Sorry if this has been raised before but I have just tried to restore a >> table from one of my schemas. >> >> The problem was that this table name is very common - It is used in m

Re: [pgadmin-support] Problem with restore

Hi, Le 20/04/2010 18:18, Kieran McCusker a écrit : > [...] > Sorry if this has been raised before but I have just tried to restore a > table from one of my schemas. > > The problem was that this table name is very common - It is used in many > schemas as each schema is the data for an individual

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

I think - there is something wrong with the file. It says - libpq.so.5 is not a dynamic executable. Can you please follow this steps? - Change directory to /usr/local/pgadmin3 - Create lib directory (if not exits) - Copy all the libraries from postgresql-lib to this directory - Make sure each file

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Yes, I just copied the libpq.so.5. The output: bash-3.1# ldd /usr/lib64/libpq.so.5 not a dynamic executable Thanks 2010/3/18 Ashesh Vashi > > > On Thu, Mar 18, 2010 at 5:43 PM, Vinicius Borges wrote: > >> I installed the pgadmin3 using the file INSTALL in the source path. >> Afte

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

I installed the pgadmin3 using the file INSTALL in the source path. After installation, with this problems, I downloaded the postgresql-libs(that has libpq.so.5) for 64 bit and manually copied the libpq.so.5 to /usr/lib64 and /usr/lib. Did I make a mistake? Thanks 2010/3/18 Ashesh Vashi > Hi V

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Hi Vinicius, On Thu, Mar 18, 2010 at 4:04 PM, Vinicius Borges wrote: > > Hello Ashesh, > > when I type > > bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3 > /usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64, > version 1 (SYSV), dynamically linked (uses shared libs), not stripped

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Hello Ashesh, when I type bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3 /usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), not stripped and bash-3.1# file /usr/local/lib/libpq.so.5 /usr/local/lib/libpq.so.5: ELF 32-bit

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

What is the output of the following commands: *file /usr/local/pgadmin3/bin/pgadmin3* *file /usr/local/lib/libpq.so.5* -- Ashesh On Wed, Mar 17, 2010 at 6:39 PM, Vinicius Borges wrote: > Hello, > > I installed pgadmin3-1.10.2 and I got an error that might strange... > > bash-3.1# /usr/local/pgad

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

On Wed, 2010-03-17 at 13:33 -0300, Vinicius Borges wrote: > Right. How can I do that? Just compile PostgreSQL sources (don't run make install). When make is finished, manually copy libpq,libecpg and libpgtypes to related directories, and see what happens. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Hello Devrim, Right. How can I do that? thanks 2010/3/17 Devrim GÜNDÜZ > On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote: > > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared > > libraries: > > /usr/lib64/libpq.so.5: ELF file OS ABI invalid > > You may need to compile your

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote: > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared > libraries: > /usr/lib64/libpq.so.5: ELF file OS ABI invalid You may need to compile your own libpq from using PostgreSQL 8.2... -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consult

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Hello, I saw that libpq.so.5 wasn't in /usr/lib64/. Then I installed libpq.so.5 for 64-bit. from http://rpm.pbone.net/index.php3/stat/4/idpl/13529891/dir/fedora_other/com/postgresql-libs-8.4.2-6.fc13.x86_64.rpm.html But now appears other error. #$ /usr/local/pgadmin3/bin/pgadmin3 /usr/local/pgad

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Please keep the list on CC. Le 17/03/2010 15:22, Vinicius Borges a écrit : > #$ ldd /usr/local/pgadmin3/bin/pgadmin3 >[...] > libpq.so.5 => not found ldd doesn't find it too. Kind of strange. How did you install libpq? did you install the 32-bits library? (which would explain where it is loca

Re: [pgadmin-support] Problem with libpq.so.5 in pgadmin3-1.10.2

Le 17/03/2010 14:09, Vinicius Borges a écrit : > Hello, > > I installed pgadmin3-1.10.2 and I got an error that might strange... > > bash-3.1# /usr/local/pgadmin3/bin/pgadmin3 > /usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries: > libpq.so.5: cannot open shared object file: N

Re: [pgadmin-support] problem in restoring database when connected via named socket

Il giorno mar, 12/01/2010 alle 11.21 +0100, Guillaume Lelarge ha scritto: > Did you re-run ./bootstrap? if not, try to do so. I didn't. That fixed the problem. Thanks again, Giuseppe -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription

  1   2   3   >