[pgadmin-support] PGAdmin schema tracking a bit off...
Hi All, Don't know if anyone else has had this problem (I'm hoping someone else has had this problem:) If I create a second or third schema (PG7.3) in PgAdminII and then create a view or table in the new schema and attempt to view the data the following message results: 22/11/2002 07:51:05 - Error in pgAdmin II:frmMain.mnuPopupViewData_Click: -2147467259 - ERROR: Relation "test" does not exist Looking at the logs it has executed: 22/11/2002 07:51:05 - SQL (fsd): SELECT count(*) AS count FROM "test" When is should have executed: 22/11/2002 07:51:04 - SQL (fsd): SELECT count(*) AS rows FROM sch_parking.test .. which works fine. If I use the generic 'public' schema everything is fine... (but ofcourse why would I want to use schema's and put everthing into public? :) I have enabled and disabled the auto row count on tables and views to no success although I don't know how much effect this has (haven't bothered looking at the source code yet...) This happens regardless of whether it's a view or table. Is this a common problem until 7.3 is at release stage? Or does the issue lie with PGAdminII? (You guys have done a great job of this by the way!) I'm using PGAdminII 1.4 and PostgreSQL 7.3 RC1. Cheers, Jason ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] pgAdmin3 font behaviour under KDE
Hi All, I've been using pgAdmin3 quite a bit (my hat is off a second time to you and your team Dave - very very nice) however I don't know how to correct the font size under kde. When I run the app in Gnome the font sizes are goverened quite nicely by Gnome's settings so I can scale as desired. When I run it in KDE the default font sizes are used and these are quite large. I presumed that under X when you run a Gnome app in another Window manager that it would run using your current GTK setup (I think this works with QT and kde apps in other Window Managers). Anybody have any hints as to how the font sizes that I desire can be achieved? I'm presuming passing something on the command line would do it (I haven't googled for it yet). Rgds, Jason ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] pgAdmin3 font behaviour under KDE
Hi Dave, I'm using the Mandrake 9.1 rpm build so figured that it would already be wxw 2.5. Interestingly when I use Galeon in KDE the same problem pops up with regards to the GTK stuff... even if I tell KDE to apply colors and fonts to non-kde apps so maybe there's something wrong there - strange cause it's just a standard Mandrake install - no special stuffs. I'll try a build from source and let you know. Rgds, Jason On Sun, 10 Aug 2003 06:22 pm, Dave Page wrote: > It's rumoured that Jason Godden once said: > > Hi All, > > > > I've been using pgAdmin3 quite a bit (my hat is off a second time to > > you and your team Dave - very very nice) > > Thanks. :-) > > > however I don't know how to > > correct the font size under kde. > > You shouldn't need to. It should be determined by wxWindows/GTK but > perhaps is not. Are you using a build against wxWindow 2.4 per-chance? If > so, please try building again the wxWindows 2.5 tarball on our ftp servers > - it has vastly improved sizing code. > If it's one of our binary builds, then that should already be wx2.5, so in > that case can you email a screenshot showing the problem you have? > Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] pgAdminIII bug
Hi All, Dave - as I've posted once before in reference to pgAdminII - GREAT JOB. The pgAdmin team always creates a great tool. I have found a bug however in the 1.0 release of pgAdminIII. If you create a trigger linked to a stored procedure (normal means of creating a trigger), the trigger path does not reference the schema correctly so PG looks for the procedure in the public schema. Will eventually get around to submitting a few patches myself but I've been a bit lazy at getting wxWindows installed ;) Rgds, Jason ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] switching postgres from windows to linux
Vidhya - do you mean you are using IIS on Win 2000 with ASP and now want the same web server/scripts to connect to the Linux box? If so then you must have already conf'd everything in the ASP as it currently works and simply need to change the host you are connecting to. This should mean that you already have the pgODBC drivers installed. Is this right? Rgds, Jason On Tuesday 30 December 2003 14:51, vidhya wrote: > Hi, > > We installed postgres 7.3.3 in windows 2000 server and using ASP > applications. > > But, due to overload postgres crashes very often. > > So, we decided to switch the databases to Linux box. > > We have to access the PG databases in windows from Linux. > > Tell me how to the drivers required and how to establish connection between > windows and linux. > > Please tell me the steps involved to do this process. (very Urgent) > > Kindly mail me to [EMAIL PROTECTED] > > > With Regards, > > Vidhya ---(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
