[pgadmin-support] Drop Schema Refresh Bug
Hi, First off all, congratulation for this really useful software tool. I don't know whether this bug is already known: a) Drop a schema via sql b) Press the refresh button with the schema selected c) pgAdmin crashes Environment: pgAdmin 1.0.1 Suse8.2 -- Oliver Archner University of Bayreuth. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support] Problem with pgAdmin3 on Fedora
Greetings! pgAdmin3 doesn't work on Fedora Core 1 after updating from Red Hat 9 like it used to because libcom_err.so.3 is not included in the Kerberos packages Fedora now uses. Would it be possible for someone to build a pgAdmin3 RPM for Fedora? I tryed, but I miss some libraries needed to compile it. Thank you very much. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Problem with pgAdmin3 on Fedora
Hi, -- Original Message --- From: "Fernando J. Leal" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Fri, 14 Nov 2003 11:09:24 + Subject: [pgadmin-support] Problem with pgAdmin3 on Fedora > pgAdmin3 doesn't work on Fedora Core 1 after updating from Red Hat 9 > like it used to because libcom_err.so.3 is not included in the > Kerberos packages Fedora now uses. > > Would it be possible for someone to build a pgAdmin3 RPM for Fedora? > I tryed, but I miss some libraries needed to compile it. I intended to build one now, but I could not find a SRPM in my nearest mirror. I just have a test.txt file in that directory, and it just says "Hello" :) "ftp://ftp.tr.postgresql.org/pub/SQL/postgresql/pgadmin3/release/SRPMS/test.txt"; Hackers, where were the SRPMS? Regards, Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.com http://www.gunduz.org ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-support] Problem with pgAdmin3 on Fedora
> -Original Message- > From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] > Sent: 14 November 2003 11:41 > To: Fernando J. Leal > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Problem with pgAdmin3 on Fedora > > "ftp://ftp.tr.postgresql.org/pub/SQL/postgresql/pgadmin3/relea > se/SRPMS/test.txt" > > Hackers, where were the SRPMS? Dunno about the release ones - Jean-Michel? Snapshot ones are at http://snake.pgadmin.org/snapshots/linux/SRPMS/ Regards, Dave. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Problem with pgAdmin3 on Fedora
Hi, -- Original Message --- From: "Dave Page" <[EMAIL PROTECTED]> To: "Devrim GUNDUZ" <[EMAIL PROTECTED]>, "Fernando J. Leal" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>, "Jean-Michel POURE" <[EMAIL PROTECTED]> Sent: Fri, 14 Nov 2003 11:50:12 - Subject: RE: [pgadmin-support] Problem with pgAdmin3 on Fedora > > Hackers, where were the SRPMS? > > Dunno about the release ones - Jean-Michel? > > Snapshot ones are at http://snake.pgadmin.org/snapshots/linux/SRPMS/ Ok hold on. I'm building packages. I'll rebuild wxWindows for FC1, then build pgadmin3 for FC1. Regards, -- Devrim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Problem with pgAdmin3 on Fedora
Le Vendredi 14 Novembre 2003 12:41, Devrim GUNDUZ a écrit : > I intended to build one now, but I could not find a SRPM in my nearest > mirror. I just have a test.txt file in that directory, and it just says > "Hello" :) > "ftp://ftp.tr.postgresql.org/pub/SQL/postgresql/pgadmin3/release/SRPMS/test >.txt" Dear Devrim, My fault. Uploading the file now. As Dave wrote, you should better use the SRPM snapshot, as it includes the latest fixes. To rebuild : 1) wxGTK-2.5.1 Only use pgadmin wxGTK-2.5 version as it includes several patches. You can download source and binary RPMs from http://pgadmin.postgresql.org/snapshots/ wxwindows. To ease installation, it is recommanded to install wxGTK2ud binary RPMs. Otherwise, if you need to rebuild from source SRPM: rpmbuild --rebuild wxGTK2ud-2.5-.src.rpm 2>&1 | tee wxGTK2ud-2.5-.log Read the log file and make sure the needed libraries are included in your system (if they are not, install them using the stock RPMs for your distro). For example, under RedHat 9, the log includes: ** Configured wxWindows 2.5.1 for `i686-pc-linux-gnu' Which GUI toolkit should wxWindows use? GTK Should wxWindows be compiled into single library? yes Should wxWindows be compiled in debug mode? yes Should wxWindows be linked as a shared library? no Should wxWindows be compiled in Unicode mode? yes What level of wxWindows compatibility should be enabled? wxWindows 2.2 no wxWindows 2.4 yes Which libraries should wxWindows use? jpeg sys png sys regex sys tiff sys zlib sys odbc no expat sys libmspack no ** The absence of ODBC and limmspack is normal as ODBC is not supported in a Unicode build by default and limspack is brand new. Other libraries (jpeg, png, etc...) should have the 'sys' flag on. 2) Then, rebuild the pgAdmin3 binary RPM from Snapshots. rpmbuild --rebuild pgadmin3-xxx-src.rpm 2>&1 | tee log.txt This will allow you to send us the log in case of problem. Best regards, Jean-Michel ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Drop Schema Refresh Bug
> -Original Message- > From: Oliver Archner [mailto:[EMAIL PROTECTED] > Sent: 14 November 2003 10:34 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Drop Schema Refresh Bug > > Hi, > > First off all, congratulation for this > really useful software tool. > > I don't know whether this bug is already known: > a) Drop a schema via sql > b) Press the refresh button with the schema selected > c) pgAdmin crashes Hi Oliver, Thanks for the bug report. This doesn't occur under Windows by the look of it. I have added it to the known bugs list. Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] many panels are too small
> -Original Message- > From: teknokrat [mailto:[EMAIL PROTECTED] > Sent: 13 November 2003 10:56 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] many panels are too small > > > thats great. I'd like to know if there is any effort under > way to add greater monitoring and visualisation features to > pgadmin. for example it would be great if pgadmin could > examine the output of vacuum verbose and make recommendations > on vacuum frequency etc. Or perhaps doing some analysis of > the statistics collected and recommending better settings. > maybe coming up with a better graphical display for analyze ( > with problems/slowdowns hilighted) etc. HI, There are no plans currently to attempt to analyse vacuum output etc - I suspect this could be potentially quite difficult to do effectively and accurately (I'm not even sure off hand if it would give any particularly useful info). There are however, plans for an index checker that will warn if you have missing indexes that will help foreign keys work efficiently. I believe Andreas has already commited some code for this. Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] Problem saving query files
Hi Hiroshi, Sorry, I don't have time to look into this properly at the moment as amongst other things I'm working on the 7.4 PostgreSQL release :-) Andreas, can you take a look please? Thanks, Dave. > -Original Message- > From: Hiroshi Saito [mailto:[EMAIL PROTECTED] > Sent: 13 November 2003 12:54 > To: Dave Page; Andreas Pflug; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Problem saving query files > > Hi Dave. > > I have one solution seen though it doesn't become the > solution of the root. > As for it, it is definite to be a ComCtl32 problem with Windows-XP. > I noticed what was ignored though it was defined with Main > with wxNB_BOTTOM so far. > However, > #define wxUSE_UXTHEME 0 > It didn't become ineffective.?? > I can't be done though it thinks that it should run away by > this establishment though originally there is bug. > This is a screen on XP after it was applied. > http://cre-ent.skcapi.co.jp/~saito/pgadmin3/comctl32_patch_After.jpg > It clears a problem perfectly. > > Any comment? > ---> Andreas, too. > > regards, > Hiroshi Saito > > From: "Dave Page" <[EMAIL PROTECTED]> > > > -Original Message- > > From: Hiroshi Saito [mailto:[EMAIL PROTECTED] > > Sent: 13 November 2003 08:04 > > To: 'Andreas Pflug'; [EMAIL PROTECTED] > > Cc: Dave Page; [EMAIL PROTECTED] > > Subject: Re: [pgadmin-support] Problem saving query files > > > > Hi Dave. > > Andreas,too. > > > > I forgot this problem foolishly.:-( > > It was certainly put up before. > > Add it to Bugs.txt. > > Or, could you solve it? --> Andreas. > > Hi Hiroshi, > > Added to bugs... > > Regards, Dave. > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] many panels are too small
Dave Page wrote: There are however, plans for an index checker that will warn if you have missing indexes that will help foreign keys work efficiently. I believe Andreas has already commited some code for this. Not really, just some preparation so far. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] pgAdmin bug? creating functions
I am having problems creating functions with PgAdmin. I have searched the lists at archives.postgresql.org/pgadmin-support, but didn't find anything about it. The basic problem appears to be that PgAdmin may not be setting the search_path properly when it issues its updates. The scenario is this: I am working in a schema which is neither the public schema nor the name of the current user. When I try create functions that take arguments that are table names, postgres says it can't find the table. For example, if the user is xxx and the schema is sss, the following should work create or replace function sss.doit(sss.mytable) ... If I create this function using psql, it works just fine. However, when I look at the function in PgAdmin, I see this create or replace function sss.doit(mytable) (mytable has lost its schema prefix). Mods to the doit function using PgAdmin result in the following error: ERROR: Type "packet_tbl" does not exist. A similar problem occurs when creating triggers. If doit (above) were a trigger function (ie, returns trigger), PgAdmin lists it in the pulldown when creating the trigger, but when it tries to create the trigger, the following error occurs: ERROR: CreateTrigger: function doit() does not exist. I think it might be a search path issue that the GUI isn't handling properly. Any help would be appreciated. --- Michael ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-support] Problem with pgAdmin3 on Fedora
Dear Jean-Michel, -- Original Message --- From: Jean-Michel POURE <[EMAIL PROTECTED]> To: "Devrim GUNDUZ" <[EMAIL PROTECTED]>, "Fernando J. Leal" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Sent: Fri, 14 Nov 2003 13:35:56 +0100 Subject: Re: [pgadmin-support] Problem with pgAdmin3 on Fedora > 1) wxGTK-2.5.1 > > Only use pgadmin wxGTK-2.5 version as it includes several patches. > You can download source and binary RPMs from http://pgadmin.postgresql.org/snapshots/ > wxwindows. > > To ease installation, it is recommanded to install wxGTK2ud binary > RPMs. Otherwise, if you need to rebuild from source SRPM: rebuilt of wxWindows failed on FC1, since I do not have to look at the erros and fix it, I just used the rpms for RH :)) Ok, I've successfully rebuild the pgadmin3 rpm for FC 1. Here is the log file of FC1: ** Configured wxWindows 2.5.1 for `i686-pc-linux-gnu' Which GUI toolkit should wxWindows use? GTK Should wxWindows be compiled into single library? yes Should wxWindows be compiled in debug mode? yes Should wxWindows be linked as a shared library? no Should wxWindows be compiled in Unicode mode? yes What level of wxWindows compatibility should be enabled? wxWindows 2.2 no wxWindows 2.4 yes Which libraries should wxWindows use? jpeg builtin pngbuiltin regex sys tiff builtin zlib sys odbc no expat sys libmspack no * I'm trying to upload the rpm; I'll post the URL to this list when it's ready. Regards, -- Devrim GUNDUZ [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.tdmsoft.com http://www.gunduz.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] pgAdmin bug? creating functions
Hi Michael, > -Original Message- > From: Michael Shapiro [mailto:[EMAIL PROTECTED] > Sent: 14 November 2003 19:25 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] pgAdmin bug? creating functions > > If I create this function using psql, it works just fine. > However, when I look at the function in PgAdmin, I see this > > create or replace function sss.doit(mytable) > I have just commited a fix to cvs that should resolve this, and allow you to create functions with class type arguments and return types as well. This should appear in the next snapshot release (these can be found at http://snake.pgadmin.org/snapshots for various platforms - Windows ones are created manually every now and again by Andreas). > A similar problem occurs when creating triggers. If doit > (above) were a trigger function (ie, returns trigger), > PgAdmin lists it in the pulldown when creating the trigger, > but when it tries to create the trigger, the following error occurs: > > ERROR: CreateTrigger: function doit() does not exist. This already appears to be fixed. > I think it might be a search path issue that the GUI isn't > handling properly. pgAdmin goes out of it's way to ignore the search path actually :-) It's safer to prefix everything, some things just get missed though :-( Thanks for the bug report. Regards, Dave. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
