[pgadmin-support] Current database

2006-04-05 Thread Chris Velevitch
I'm using windows version 1.4.2 on Win XP Sp1. Right-clicking a non current database makes it current. Why? I'm trying to rename the database but I can't because you can't rename the current database. How do you make a database non-current? Chris -- Chris Velevitch Manager - Sydney Flash Platfo

Re: [pgadmin-support] pgAgent problems

2006-04-05 Thread Dave Page
Title: Re: [pgadmin-support] pgAgent problems On 5/4/06 19:18, "Benjamin Krajmalnik" <[EMAIL PROTECTED]> wrote: I am having problems with pgAgent. I installed the seervice with the following command: C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL

[pgadmin-support] pgAgent problems

2006-04-05 Thread Benjamin Krajmalnik
I am having problems with pgAgent. I installed the seervice with the following command:   C:\Program Files\PostgreSQL\8.1\bin>"C:\Program Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -u postgres -p postgres -t 60 hostaddr=127.0.0.1 dbname=postgres user=postgres   In the services, the path t

Re: [pgadmin-support] line number in error output

2006-04-05 Thread Miha Radej
Hi! Dave Page wrote: I'm using Windows version 1.4.2 on Win XP sp1. When I get an error in executing a sql code, I get ERROR: syntax error at or near "45183" at character 5848 There is no line number included. Such information would make very easy to locate the offending code. The er

[pgadmin-support] rename database

2006-04-05 Thread Chris Velevitch
I'm using windows version 1.4.2 on Win XP sp1 and pg 7.4.11. I can't rename a database because I get an error saying it's in use, but I'm the only one using it. So how do I do it? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au -

[pgadmin-support] ERROR: permission denied for schema public

2006-04-05 Thread Chris Velevitch
I'm using Windows version 1.4.2 on Win Xp Sp1. I've just pg_dump a database and when I open the file and run it, I get:- ERROR: permission denied for schema public but I don't know what it's referring to. There is no marker indicating the offending line. What does this mean? Chris -- Ch

Re: [pgadmin-support] Create db problem

2006-04-05 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mauro Bertoli > Sent: 05 April 2006 09:40 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Create db problem > > Hi, I've some strange behaviours managing databases: > > - if I

[pgadmin-support] Create db problem

2006-04-05 Thread Mauro Bertoli
Hi, I've some strange behaviours managing databases: - if I want create a new db from a postgres console (psql) I MUST have all pgAdmin clients closed (because 'maintenance db' lock postgres db) - using pgAdmin I cannot create a new db using the connected db as template Thank you

[pgadmin-support] UI Request

2006-04-05 Thread Mauro Bertoli
Hi, I've a suggest: - is possible to make "index" default name (in the "new index" form, after selecting the field/s ) created by pgAdmin as that postgres default use? (tablename_fieldname_index) Thank you Great work, I'm waiting next release! _

Re: [pgadmin-support] line number in error output

2006-04-05 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 08:17 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] line number in error output > > I'm using Windows version 1.4.2 on Win XP sp1. > > W

[pgadmin-support] line number in error output

2006-04-05 Thread Chris Velevitch
I'm using Windows version 1.4.2 on Win XP sp1. When I get an error in executing a sql code, I get ERROR: syntax error at or near "45183" at character 5848 There is no line number included. Such information would make very easy to locate the offending code. Chris -- Chris Velevitch Manage

Re: [pgadmin-support] silently fails to connect to remote server

2006-04-05 Thread Chris Velevitch
On 4/5/06, Dave Page wrote: > > Also the log shows nothing. > > Please turn logging to debug level under File->Options, retry the > connection and then check/send the logfile over. I did that, nothing was logged. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.fla

Re: [pgadmin-support] Maintenance DB

2006-04-05 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 07:37 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Maintenance DB > > I'm using Windows version 1.4.2 on Win XP Sp1. > > I'm trying to

Re: [pgadmin-support] silently fails to connect to remote server

2006-04-05 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 05 April 2006 07:30 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] silently fails to connect to remote server > > I'm using the Windows version 1.4.2 on