[pgadmin-support] Regarding Migration from Oracle9i to Postgres
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 Regards, Arvind.
[pgadmin-support] Newlines in pl/python functions
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 when the script compiles. If I remove the newlines and put all the code onto one long line then the function compiles and executes fine. If I create the same function on the server using psql then newlines work ok, so I'm guessing there's a problem translating the newlines from the Windows to Unix formats. Presumably this ought to work? Just though I'd mention it since I can't find any reference elsewhere suggesting this is a known issue. many thanks, Jason ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support] pgAdmin3 bug
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 "stevie-o"; However, the little preview window that shows the script to recreate the table gets a teeny little bit overzealous with the quote marks: GRANT SELECT ON TABLE foo TO "\""stevie-o\"""; -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] PGAdmin does not support tables that have reseved words for tables well
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, but it does sometimes.
Re: [pgadmin-support] weird problem, cant edit data in tables
> -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 Page escribió: > > > > > > my version is 1.0.2 for windows, and some recently created tables > > > cant be edited to insert/update values. Simply the grid doesnt > > > appears or if there is data (inserted in psql by > > > hand) it cant be modified. Seems to happen only for > tables that has > > > a field referencing a master table. > > > I created the table using pgadmin, and then using sql commands in > > > psql, but the result is the same. > > > > Do you have a primary key specified? > > > Yes, in the master table (created using pgadmin) You need one in each table, otherwise pgAdmin has no way of identifying which row you are editting. Regard,s Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] pgAdmin3 bug
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 overzealous with the quote marks: GRANT SELECT ON TABLE foo TO "\""stevie-o\"""; Don't enter " in the name field. pgAdmin adds them as required. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-support] PGAdmin does not support tables that have reseved
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, but it does sometimes. Yes, keyword checks are currently not performed. Adam, the reason why keywords aren't checked in qtIdent is that db/keyword.c still isn't compiled on *ix, can you have a look at it? Regards, Andreas ---(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] pgadmin III - database backup / restore
[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 was correct) the dump executes successfully. Oh dear, I didn't notice that. I always tested on trusted connections. Since pg_dump doesn't have a switch to supply the password (it always appears to want the password interactively) I would guess that pgadmin would need to supply stdin to the spawned copy of pg_dump. Will take me some time to fix. Regards, Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] PgAdmin "make" failure on Slackware 10
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 get a very, very long list of errors, mainly complaining about "undefined references". These are are the last few lines of the error: collect2: ld returned 1 exit status make[2]: *** [pgadmin3] Error 1 make[2]: Leaving directory `/usr/local/src/pgadmin3-1.0.2/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/pgadmin3-1.0.2' make: *** [all] Error 2 Please help me! Darren [EMAIL PROTECTED] ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] pgAdmin3 bug
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. > > > > However, the little preview window that shows the script to recreate > > the table gets a teeny little bit overzealous with the quote marks: > > > > GRANT SELECT ON TABLE foo TO "\""stevie-o\"""; > > Don't enter " in the name field. pgAdmin adds them as required. 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 table foo, it appears to be adding two additional pairs of quotation marks. > > Regards, > Andreas > -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] pgAdmin3 bug
[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 table foo, it appears to be adding two additional pairs of quotation marks. Can anybody check this on 7.4? On 8.0 the acl has \" in it, seems this is new. Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] Error Message: Index out of bounds
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: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 0.0.0 Descripton: -- Driver Information -- Name: Version: 0.0.0 Descripton: -- Error Information -- Description: Index out of bounds Number: 35600 Routine: pgAdmin II:basMisc.BuildConnectionMenu Insert your comment:
Re: [pgadmin-support] pgAdmin3 bug
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 pgAdmin3 tries to show the SQL that would recreate table foo, >> it appears to be adding two additional pairs of quotation marks. >> > > Can anybody check this on 7.4? On 8.0 the acl has \" in it, seems this > is new. > > Regards, > Andreas > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > This is pgadmin3 (2004/08/17) with PostgreSQL 7.4.3. It shows: GRANT SELECT ON TABLE foo TO "\""stevie-o\"""; after I used this on psql: GRANT SELECT ON TABLE foo TO "stevie-o"; -- Giovanni P. Tirloni ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] pgAdmin3 bug
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] Newlines in pl/python functions
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 get syntax errors when the script compiles. If I remove the newlines and put all the code onto one long line then the function compiles and executes fine. If I create the same function on the server using psql then newlines work ok, so I'm guessing there's a problem translating the newlines from the Windows to Unix formats. Presumably this ought to work? Just though I'd mention it since I can't find any reference elsewhere suggesting this is a known issue. I wonder if this is a problem with carriage returns (not linefeed). Does the problem persist if you use pgAdmin on Linux? Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-support] FC2 make problems
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(font_name)); - ./configure --with-gtk --enable-gtk2 \ --enable-unicode --disable-shared --enable-debug - make - sudo make install - ldconfig <-- necessary? from contrib/src/stc and src - make - sudo make install pgadmin3-1.0.2: - download, untar - ./configure --enable-static --enable-debug - make all problem: many undefined reference to wx* eg, to `wxXmlResource::Load(wxString const&)' fail also tried ./configure without --enable-static - same problem also, almost everyone I know has moved off FC1 to FC2 - many advantages (except pgAdmin not working ;) ) thanks, cy __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] FC2 make problems
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). I did it last night and worked very well. Don't forget to carefully read instructions in pgadmin3-1.1.0/docs/en_US/unix_compilation.html after you extract pgadmin3-src.tar.gz. Modify xxx-2003xxx names acordingly. Diego. El miÃ, 18-08-2004 a las 19:14, chester c young escribiÃ: > 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(font_name)); > - ./configure --with-gtk --enable-gtk2 \ >--enable-unicode --disable-shared --enable-debug > - make > - sudo make install > - ldconfig <-- necessary? > > from contrib/src/stc and src > - make > - sudo make install > > pgadmin3-1.0.2: > - download, untar > - ./configure --enable-static --enable-debug > - make all > > problem: > many undefined reference to wx* > eg, to `wxXmlResource::Load(wxString const&)' > fail > > also tried ./configure without --enable-static - same problem > > also, almost everyone I know has moved off FC1 to FC2 - many advantages > (except pgAdmin not working ;) ) > > thanks, > cy > > > > > > > __ > Do you Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile phone. > http://mobile.yahoo.com/maildemo > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org > > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
