Re: [pgadmin-support] pgAdmin 1.12.1 issues talking with master node of a SR-ROHS setup.

2010-11-17 Thread Mark_Sloan
I found the problem. There was a modified connection pooler in-between that I had forgotten even existed... That appears to be problem for me. Sorry to bother, Mea culpa . ..: Mark On 11/17/10 10:47 AM, "Guillaume Lelarge" wrote: >Le 17/11/2010 16:43, mark_sl...@mcafee.com a écrit : >> H

Re: [pgadmin-support] pgAdmin 1.12.1 issues talking with master node of a SR-ROHS setup.

2010-11-17 Thread Guillaume Lelarge
Le 17/11/2010 16:43, mark_sl...@mcafee.com a écrit : > Hi pgAdmin support list, > > I am using pgAdmin 1.12.1 on OSX to connected to a postgresql 9.0.1 instance > that is the master in a SR++ROHS pair. > > pgAdmin sees the master as being in recovery mode and will of course disallow > me to cre

[pgadmin-support] pgAdmin 1.12.1 issues talking with master node of a SR-ROHS setup.

2010-11-17 Thread Mark_Sloan
Hi pgAdmin support list, I am using pgAdmin 1.12.1 on OSX to connected to a postgresql 9.0.1 instance that is the master in a SR++ROHS pair. pgAdmin sees the master as being in recovery mode and will of course disallow me to create new tables, insert records …etc. I am able to do all of these

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Raymond O'Donnell
On 17/11/2010 11:22, Dan Shoubridge wrote: Dan, Ok, I understand and it's a shame the vars aren't strong typed. It's little things like that that make me want SQL Server back. It doesn't seem like a big thing to some people, but for a lot of developers the amount of work added by this when debug

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Dan Shoubridge
>>Dan, >> Ok, I understand and it's a shame the vars aren't strong typed. It's little things like that that make me want SQL Server back. It doesn't seem like a big thing to some people, but for a lot of developers the amount of work added by this when debugging sql adds up over time. >I know it'

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Paragon Corporation
Dan, > Ok, I understand and it's a shame the vars aren't strong typed. It's little things like that that make me want SQL Server back. It doesn't seem like a big thing to some people, but for a lot of developers the amount of > work added by this when debugging sql adds up over time. I know it'

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Dave Page
On Wed, Nov 17, 2010 at 9:40 AM, Dan Shoubridge wrote:> > > Ok, I understand and it’s a shame the vars aren’t strong typed. It's little > things like that that make me want SQL Server back. It doesn't seem like a > big thing to some people, but for a lot of developers the amount of work > added by

Re: [pgadmin-support] Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables

2010-11-17 Thread Dan Shoubridge
>Le 16/11/2010 23:26, Guillaume Lelarge a écrit : >> Le 16/11/2010 14:01, Dan Shoubridge a écrit : >> Originally from SQL Server background, there is one feature that I >> am missing and would save developers hours of time. >> >> In SQL Server I could copy sql code out of an applic