Re: [pgadmin-support] FC2 make problems

2004-08-18 Thread Diego A. Gil
Chester: Don't use wxWindows-pgAdmin3-20031010-7, use wxWindows-pgAdmin3-20040711-1.tar.bz2 instead. (http://developer.pgadmin.org/snapshots/wxWidgets/wxWidgets-pgAdmin3-20040711-1.tar.bz2) and use the last pgadmin3 source snapshot (http://developer.pgadmin.org/snapshots/pgadmin3-src.tar.gz).

[pgadmin-support] FC2 make problems

2004-08-18 Thread chester c young
Hi Moved from FC1 to FC2 and need to build. Following instructions: wxWindows-pgAdmin3-20031010-7: - in src/gtk/settings.cpp, comment lines //const gchar *font_name = //_gtk_rc_context_get_default_font_name(gtk_settings_get_default()); //g_systemFont = new wxFont(wxString::FromAscii

Re: [pgadmin-support] Newlines in pl/python functions

2004-08-18 Thread Andreas Pflug
Jason Hyett wrote: Hello all, Sorry if this is not the right forum, but... I'm running postgres 7.4.3 on Linux with pl/python installed, and pgadmin 1.0.2 on windows XP. If I try and create a python function via pgadmin I cannot include newlines in the script. The function is updated ok, but I g

Re: [pgadmin-support] pgAdmin3 bug

2004-08-18 Thread Andreas Pflug
Fixed in CVS, thanks for reporting. Regards, Andreas ---(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] pgAdmin3 bug

2004-08-18 Thread Giovanni P. Tirloni
Andreas Pflug disse: > [EMAIL PROTECTED]> wrote: > >> >> I didn't enter " in the name field. The login name is stevie-o. >> Because the hyphen is treated as a token separator, the grant >> statement (as SQL) needs to look like this: >> >> GRANT SELECT ON TABLE foo TO "stevie-o" >> >> But when pgA

[pgadmin-support] Error Message: Index out of bounds

2004-08-18 Thread Patel, Biren
Title: Error Message: Index out of bounds -- System Information -- Platform:       Windows XP Version:        5.1 Build:      2600 Service Pack 2 -- Application Information -- Name:       pgAdmin II Version:        1.6.0 Descripton:     Name:      

Re: [pgadmin-support] pgAdmin3 bug

2004-08-18 Thread Andreas Pflug
[EMAIL PROTECTED]> wrote: I didn't enter " in the name field. The login name is stevie-o. Because the hyphen is treated as a token separator, the grant statement (as SQL) needs to look like this: GRANT SELECT ON TABLE foo TO "stevie-o" But when pgAdmin3 tries to show the SQL that would recreate ta

Re: [pgadmin-support] pgAdmin3 bug

2004-08-18 Thread Stephen Oberholtzer
On Wed, 18 Aug 2004 10:18:42 +, Andreas Pflug <[EMAIL PROTECTED]> wrote: > Stephen Oberholtzer wrote: > > I downloaded the latest win32 version - dated 8/17, although the > > executable was dated 8/15? > > This is correct, the new snapshot includes an old executable, with new docs. > > > > How

[pgadmin-support] PgAdmin "make" failure on Slackware 10

2004-08-18 Thread Darren Beukes
Hello There, I'm using the Slackware 10 and am compiling pgadmin from source. I installed wxWindows 2.5 from source, as per the specification in the docs folder. PGadmin appeared to be run smoothly, running ./configure with no hassles. Make appears to go fine for about 10-15 minutes until I g

Re: [pgadmin-support] pgadmin III - database backup / restore

2004-08-18 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Sorry about that Andreas, I'm used to the Xitami list where I just reply to a message and it automatically goes to the list. When I run pg_dump with or without the -U switch to provide the db user name, I always get prompted for a password, then (providing the passsword w

Re: [pgadmin-support] PGAdmin does not support tables that have reseved

2004-08-18 Thread Andreas Pflug
Joe Grist wrote: Hoping this is the right spot to post to. Thought somebody might be intrerested. pgAdmin III on Windows XP generates syntax errors when you try and work with tables that use a reserved words as their name (I have a table called 'user'). Granted, this should never happen, b

Re: [pgadmin-support] pgAdmin3 bug

2004-08-18 Thread Andreas Pflug
Stephen Oberholtzer wrote: I downloaded the latest win32 version - dated 8/17, although the executable was dated 8/15? This is correct, the new snapshot includes an old executable, with new docs. However, the little preview window that shows the script to recreate the table gets a teeny little bit

Re: [pgadmin-support] weird problem, cant edit data in tables

2004-08-18 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Roger D. Vargas > Sent: 17 August 2004 13:14 > To: PgAdmin Support Mailing List > Subject: Re: [pgadmin-support] weird problem, cant edit data in tables > > El mar, 17-08-2004 a las 08:11, Dave P

[pgadmin-support] PGAdmin does not support tables that have reseved words for tables well

2004-08-18 Thread Joe Grist
Title: Message   Hoping this is the right spot to post to.  Thought somebody might be intrerested.   pgAdmin III on Windows XP generates syntax errors when you try and work with tables that use a reserved words as their name (I have a table called 'user').  Granted, this should never happen

[pgadmin-support] pgAdmin3 bug

2004-08-18 Thread Stephen Oberholtzer
I downloaded the latest win32 version - dated 8/17, although the executable was dated 8/15? (This is where it pays off to do things different from everyone else.) I created for myself an account named "stevie-o". Thus, to grant access to the database, I have to do this: grant select on foo to "

[pgadmin-support] Newlines in pl/python functions

2004-08-18 Thread Jason Hyett
Hello all, Sorry if this is not the right forum, but... I'm running postgres 7.4.3 on Linux with pl/python installed, and pgadmin 1.0.2 on windows XP. If I try and create a python function via pgadmin I cannot include newlines in the script. The function is updated ok, but I get syntax errors wh

[pgadmin-support] Regarding Migration from Oracle9i to Postgres

2004-08-18 Thread arvind
Hi,     We need to migrate oracle9i database to Postgres 7.4. We have been successfull in migrating the schema and the data. Can you please suggest us the best way to convert / migrate the Functions / Stored Procedures / Packages & Triggers. Is there a tool available for this?   Thanks and R