[pgadmin-support] Error Message: ERROR: -- Error Information --
-- System Information -- Platform: Windows XP Version: 5.1 Build: 2600 Service Pack 1 -- 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: 7.2.1 Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0 -- Driver Information -- Name: PostgreSQL Version: 7.3.100 Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0 -- Error Information -- Description: ERROR: parser: parse error at or near "+" Number: -2147467259 Routine: pgAdmin II:frmSQLInput.cmdExecute_Click Insert your comment: I am having a lot of problems with the Beta Version of Postgres for Windows. Number one: I cannot restore a dump file that came off of my Red Hat and restore it to my Beta. The database is now located on the 2000 Server. I am going to attempt to do it on my Local Machine. Number two: I cannot do any of my previous sql’s that I performed on my Red Hat. ALL of my results are blank. The only SQL’s I can perform is very minor ones. And what has happened with the “=” and “+” type casts. Why would I have to do explicit typecasts for these? These are only a couple of issues that I am having. All I want to do is write my SQL’s and perform the operations, which I know had results in them at one time. Please, if there is anything I am missing, please let me know. I do not want to start this database from scratch. The migrations do work and the data is there, but that is all I seem to be getting. Thank you Mark Perez
[pgadmin-support] pgAdmin on Mandrake + export
Why does rpm's for mandrake is so big while on RedHat etc thay are much smaller? And second thing is it would be cool feature if there was possibility to export all database (with data or without) to sql file. Or maybe it's already there? :) Lafriks ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] pgAdmin on Mandrake + export
Lafriks wrote: And second thing is it would be cool feature if there was possibility to export all database (with data or without) to sql file. Or maybe it's already there? :) pg_dump does this. We have plans for a gui for pg_dump, but no implementation so far. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support] Out of buffer error
Hello, during a quite normal statement in the SQL window I got a “Out of buffer error – time to abort” error message. What is the reason for this message? Is this a message of pgadmin? Or a message of postgresql? Thanks for your help. Best regards, Christian Brosig
Re: [pgadmin-support] pgAdmin on Mandrake + export
I know that I can do that but not all can Leatly I had a lot of questions from my clients and friends about how to do it from pgAdmin. Because not all have shell accounts and not all know how to do it. I think that would just make easier life for lot of people who are developers not database admins. Lafriks Andreas Pflug wrote: Lafriks wrote: And second thing is it would be cool feature if there was possibility to export all database (with data or without) to sql file. Or maybe it's already there? :) pg_dump does this. We have plans for a gui for pg_dump, but no implementation so far. Regards, Andreas ---(end of broadcast)--- TIP 8: explain analyze is your friend
