[pgadmin-support] pgAdmin isn't quoting quotes

2007-10-17 Thread Stephen Denne
(1.8RC1) If for some unusual reason I want to use pgadmin to add a column named: one "two" three Then I am able to specify this identifier as "one ""two"" three" but pgadmin will always show it as one "two" three Which I think is ok, but it shows it in generated SQL as "one "two" three" i

[pgadmin-support] WinXP Hibernation problem

2007-10-17 Thread Steve Midgley
Hi, I'm not sure if this is a general problem but here's the steps I undertook: Running IBM T43 w/WinXP SP2 / current patches (+special patch for >1GB hibernation) Running PgAdmin 1.8 beta 5 connected to local pg server with sql window open Put computer into Hibernation Woke it up SQL win

Re: [pgadmin-support] pgAdmin 1.8RC1 - failed to launch on Mac OS X

2007-10-17 Thread Dave Page
[EMAIL PROTECTED] wrote: "~/Library/Preferences/pgadmin3 preferences" on your system? Any change if you remove it? >>> I have no such file in ~/Library/Preferences or in /Library/Preferences >> OK. Can you tell me what the output from the following commands is >> ple

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Guillaume Lelarge
Dave Page a écrit : > Guillaume Lelarge wrote: >> Dave Page a écrit : >>> Guillaume Lelarge wrote: > I guess the general ordering of the statements should be as follows: > 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range > 2 SETVAL > 3 Any ALTER SEQUENCE MIN/MAXVALU

Re: [pgadmin-support] pgAdmin 1.8RC1 - failed to launch on Mac OS X

2007-10-17 Thread Dave Page
[EMAIL PROTECTED] wrote: >> "~/Library/Preferences/pgadmin3 preferences" on your system? Any change >> if you remove it? > I have no such file in ~/Library/Preferences or in /Library/Preferences OK. Can you tell me what the output from the following commands is please: ot

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Dave Page
Guillaume Lelarge wrote: > Dave Page a écrit : >> Guillaume Lelarge wrote: I guess the general ordering of the statements should be as follows: 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range 2 SETVAL 3 Any ALTER SEQUENCE MIN/MAXVALUE statements that narrow the

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Dave Page
Horvath Gabor wrote: > On 9/24/07, Dave Page <[EMAIL PROTECTED]> wrote: >> Horvath Gabor wrote: >>> pgAdminIII v1.8-Beta5 >>> Windows XP >>> PostgreSQL 8.1, linux >>> >>> I tried to adjust the Minimum value in the properties dialog of a sequence. >>> I wanted to adjust the range so that the present

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Guillaume Lelarge
Dave Page a écrit : > Guillaume Lelarge wrote: >>> I guess the general ordering of the statements should be as follows: >>> 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range >>> 2 SETVAL >>> 3 Any ALTER SEQUENCE MIN/MAXVALUE statements that narrow the range. >>> >> We can't add this

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Dave Page
Guillaume Lelarge wrote: >> I guess the general ordering of the statements should be as follows: >> 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range >> 2 SETVAL >> 3 Any ALTER SEQUENCE MIN/MAXVALUE statements that narrow the range. >> > > We can't add this kind of functionnality n

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Guillaume Lelarge
Horvath Gabor a écrit : > On 9/24/07, Dave Page <[EMAIL PROTECTED]> wrote: >> Horvath Gabor wrote: >>> pgAdminIII v1.8-Beta5 >>> Windows XP >>> PostgreSQL 8.1, linux >>> >>> I tried to adjust the Minimum value in the properties dialog of a sequence. >>> I wanted to adjust the range so that the pres

Re: [pgadmin-support] 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

2007-10-17 Thread Horvath Gabor
On 9/24/07, Dave Page <[EMAIL PROTECTED]> wrote: > Horvath Gabor wrote: > > pgAdminIII v1.8-Beta5 > > Windows XP > > PostgreSQL 8.1, linux > > > > I tried to adjust the Minimum value in the properties dialog of a sequence. > > I wanted to adjust the range so that the present current value would > >