Re: [pgadmin-support] Current database
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Chris Velevitch > Sent: 06 April 2006 02:56 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Current database > > 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? You can't. I'm not sure how that feature is supposed to work given how it's been coded. You should manually issue the rename SQL in a query tool window when no users are connected to the database you're renaming. Regards, Dave. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] sql window issues
Hi, I have always liked the fact that when I click on a table I get the code to (re)create the table. It just don't seem to work when I try it in the sql window though... Even under 1.4.2, I regularly have queries that I can't execute in the sql window - what gives? Today I had to copy and paste a create table into a psql console on my remote postgres server! Can someone give me some idea of what is happening here? Cheers Antoine -- This is where I should put some witty comment. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-support] sql window issues
On 6/4/06 21:30, "Antoine" <[EMAIL PROTECTED]> wrote: > Hi, > I have always liked the fact that when I click on a table I get the > code to (re)create the table. It just don't seem to work when I try it > in the sql window though... Even under 1.4.2, I regularly have queries > that I can't execute in the sql window - what gives? Today I had to > copy and paste a create table into a psql console on my remote > postgres server! > Can someone give me some idea of what is happening here? Not without a better definition of "It just don't seem to work". What error message do you get? Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
