[pgadmin-support] How can I test a function in the SQL window?

2015-04-02 Thread Rob Richardson
Hello! I suddenly find myself stumped. A co-worker gave me a function to use in my database, but it doesn't seem to be doing anything. So, I wanted to run it from PGAdmin's SQL window. But I can't call it. When I try select standupdatestatus('12', 'Loaded', 100); I get: ERROR: query has

Re: [pgadmin-support] Why do backups take so long?

2015-03-06 Thread Rob Richardson
It completed successfully in about two seconds. RobR -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: Friday, March 06, 2015 1:33 PM To: Rob Richardson; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Why do backups take so long? On 06/03/2015

[pgadmin-support] Why do backups take so long?

2015-03-06 Thread Rob Richardson
I have PostgreSQL 9.3 and the associated version of PGAdmin loaded on my Windows 7 Pro box. I am trying to take a backup of a tiny database on my local machine. When I request the backup, PGAdmin flashes for three minutes before finally deciding to make the backup. Why does it do that, and is

[pgadmin-support] Database backup is very slow

2014-10-02 Thread Rob Richardson
When I try to back up a small database, the backup dialog box appears, and flashes every couple of seconds for a very long time. (My first title for this message was "Database backup does not work".) After several minutes, it will finally decide that it knows what do, and will run the backup.

Re: [pgadmin-support] PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

2014-05-30 Thread Rob Richardson
Thank you for your reply. You said, in part: What's happening in your case is that the table must have been created like this: create table "Log" [.] But the whole point of my message is that that is not how this table was created. I did not open an SQL window a

[pgadmin-support] PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

2014-05-30 Thread Rob Richardson
I just spent half a day trying to set up a log4net AdoNetAppender to write into a PostgreSQL table named "Log". It was not working, and I was not getting any error messages anyplace. Not my application, not PostgreSQL log files. I stripped the log4net configuration file to a bare minimum, whe

[pgadmin-support] How do I restore this file?

2014-03-12 Thread Rob Richardson
Hello! I have been using PostgreSQL v8.4 and its associated PGAdmin version for a few years. I've only recently begin migrating to the PostgreSQL 9 world. I have PostreSQL 9.1 and PGAdmin version 1.14.0. I have a backup file named WSC.backup. The file begins with: -- -- PostgreSQL databas

[pgadmin-support] Why doesn't PGAdmin support backing up of schema only or data only?

2014-02-07 Thread Rob Richardson
Greetings! I have been curious for several years: Why doesn't PGAdmin's backup screen allow me to save data only or schema only in custom format? I am trying to test a long-running application that uses a PostgreSQL database. I occasionally need to change or add a database function or make s