Re: [pgadmin-support] pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18

2013-02-22 Thread Dave Page
Hi On Fri, Feb 22, 2013 at 3:37 PM, James B. Byrne wrote: > > On Fri, February 22, 2013 09:09, Dave Page wrote: > >> >> Thanks - turning on notices was the key to finding this. I've >> committed a fix for 1.16.2 and later. >> > > Glad I was of some help. > > I have another anomaly to report as we

Re: [pgadmin-support] pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18

2013-02-22 Thread James B. Byrne
On Fri, February 22, 2013 09:09, Dave Page wrote: > > Thanks - turning on notices was the key to finding this. I've > committed a fix for 1.16.2 and later. > Glad I was of some help. I have another anomaly to report as well: OS: CentOS-6.3 Arch: x86_64 pgadmin3_92.x86_64 1.16.1-4.rhe

Re: [pgadmin-support] Redefining a column within a view

2013-02-22 Thread Schade, Jeffrey
Thanks to Laurenz for providing the answer to my problem: Try: [...] Substr(col3,1,1)::char(1) as col3_part1, Substr(col3,2)::char(2) as col3_part2, [...] Yours, Laurenz Albe Jeff _ Jeffrey Schade Sys

Re: [pgadmin-support] pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18

2013-02-22 Thread Dave Page
On Thu, Feb 21, 2013 at 4:13 PM, James B. Byrne wrote: > With reference to: > http://www.postgresql.org/message-id/a98bbda7653c7241be0bcf46af5a043eed8fe...@m4exchdb1.m4systems.com > > OS: CentOS-6.3 > Arch: x86_64 > pgadmin3_92.x86_64 1.16.1-4.rhel6 @pgdg92 > > I have this exact error occurring

[pgadmin-support] Redefining a column within a view

2013-02-22 Thread Schade, Jeffrey
We have a table which contains a 3 byte column with datatype CHAR(3) which we want to redefine within the view as a CHAR(1) column and a CHAR(2) column. When I code the SUBSTR function the resulting column datatype is TEXT. I would like to see the CHAR datatype, is there anything I can do to set th

Re: [pgadmin-support] mac os x 10.8 pgadmin3 can't use backup / restore

2013-02-22 Thread Raymond O'Donnell
On 22/02/2013 09:58, aloysius wrote: > at mac os x 10.8 , i download pgadmin3 1.16.1 , the backup and > restore button is deactivate . any one can help me? please... Hi there, I don't know about Macs, but on Windows you need to tell PgAdmin where your pg_dump and pg_restore are. Go to File -> Opt

[pgadmin-support] mac os x 10.8 pgadmin3 can't use backup / restore

2013-02-22 Thread aloysius
at mac os x 10.8 , i download pgadmin3 1.16.1 , the backup and restore button is deactivate . any one can help me? please... -- View this message in context: http://postgresql.1045698.n5.nabble.com/mac-os-x-10-8-pgadmin3-can-t-use-backup-restore-tp5746217.html Sent from the PostgreSQL - pgadmin