Re: [pgadmin-support] what permissions must a user have?

2007-10-12 Thread Dave Page
Belbin, Peter wrote: > What permissions / rights must a user have in order to be able to use > the arbitrary sql statement tool please? > > I have a user using 1.6.3 that is unable to enter text into the text > field, and am curious which permissions are required. The only permissions required ar

[pgadmin-support] what permissions must a user have?

2007-10-12 Thread Belbin, Peter
What permissions / rights must a user have in order to be able to use the arbitrary sql statement tool please? I have a user using 1.6.3 that is unable to enter text into the text field, and am curious which permissions are required. Regards, Peter. NOTICE: This electronic mail transmission ma

Re: [pgadmin-support] Bug report pgadmin 1.8.0 Beta 5 (Sep 10 2007, rev 6631)

2007-10-12 Thread Guillaume Lelarge
Hi, Rolf A. de By a écrit : > I am running on a PG server 8.2, Windows XP, trying the following and > getting a run time error plus crash of pgadmin > > 1. open my database, navigate to Tables > 2. right click, to New Table option > 3. Fill out table name, owner, inherit from one already existing

Re: [pgadmin-support] Small change needed to support Greenplum DB

2007-10-12 Thread Luke Lonergan
Thanks Dave - much appreciated, pgadmin is a great product. - Luke Msg is shrt cuz m on ma treo -Original Message- From: Dave Page [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:41 AM Eastern Standard Time To: Luke Lonergan Cc: pgadmin-support@postgresql.org Sub

Re: [pgadmin-support] Grid editor crash during row insert

2007-10-12 Thread Dave Page
Alexander Kirpa wrote: > On 8 Oct 2007, at 15:02, Dave Page wrote: > >> Alexander Kirpa wrote: >>> PGAdmin III 1.8 Beta 5 >>> Windows 2000 >>> >>> Still stable crash during insert rows in table over grid editor. For >>> crash need sequential insert 128-130 rows without closing grid >>> editor. >>

Re: [pgadmin-support] Small change needed to support Greenplum DB

2007-10-12 Thread Dave Page
Thanks Luke - fix committed for 1.8 using the DISTINCT ON version of the query. Regards, Dave Luke Lonergan wrote: > Yes it does! > > - Luke > > Msg is shrt cuz m on ma treo > > -Original Message- > From: Dave Page [mailto:[EMAIL PROTECTED] > Sent: Friday, October 12, 2007 10:21 A

Re: [pgadmin-support] Small change needed to support Greenplum DB

2007-10-12 Thread Luke Lonergan
Yes it does! - Luke Msg is shrt cuz m on ma treo -Original Message- From: Dave Page [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM Eastern Standard Time To: Luke Lonergan Cc: pgadmin-support@postgresql.org Subject:Re: [pgadmin-support] Small change

Re: [pgadmin-support] Bug report pgadmin 1.8.0 Beta 5 (Sep 10 2007, rev 6631)

2007-10-12 Thread Dave Page
Rolf A. de By wrote: > Greetings, pgadmin team, > > I am running on a PG server 8.2, Windows XP, trying the following and > getting a run time error plus crash of pgadmin > > 1. open my database, navigate to Tables > 2. right click, to New Table option > 3. Fill out table name, owner, inherit fro

[pgadmin-support] Bug report pgadmin 1.8.0 Beta 5 (Sep 10 2007, rev 6631)

2007-10-12 Thread Rolf A. de By
Greetings, pgadmin team, I am running on a PG server 8.2, Windows XP, trying the following and getting a run time error plus crash of pgadmin 1. open my database, navigate to Tables 2. right click, to New Table option 3. Fill out table name, owner, inherit from one already existing table, and

Re: [pgadmin-support] ALTER TABLE sample SET TABLESPACE

2007-10-12 Thread Guillaume Lelarge
Ariel R. Giomi a écrit : > Hello, I speak little English language but try to understand me. > > I am running "PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC > gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)" on a remote server > and running pgadminiii 1.8.0 RC1 on windows xp (ES) > >

Re: [pgadmin-support] Problem with tablespaces on older versions of PostgreSQL

2007-10-12 Thread Guillaume Lelarge
Albin Blaschka a écrit : > I just discovered the following problem with PGAdmin 1.8 RC1 (on WinXP) > I have a server where still PostgreSQL version 7.4.7 is running (Debian > Sarge). I created a table with PGAdmin, finished (which went fine) and > added a little bit later some more columns. > PGAdm

Re: [pgadmin-support] Small change needed to support Greenplum DB

2007-10-12 Thread Dave Page
Luke Lonergan wrote: > Hi all, > > A customer of ours is using pgAgent with Greenplum Database and needs a > change to one of the queries used by pgAgent to allow it to work with > Greenplum. > > Here is the conversation: > > _http://groups.google.com/group/pgsql.bugs/browse_thread/thread/2786

[pgadmin-support] ALTER TABLE sample SET TABLESPACE

2007-10-12 Thread Ariel R. Giomi
Hello, I speak little English language but try to understand me. I am running "PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)" on a remote server and running pgadminiii 1.8.0 RC1 on windows xp (ES) When such change a "comment" on a t

[pgadmin-support] Problem with tablespaces on older versions of PostgreSQL

2007-10-12 Thread Albin Blaschka
Hello! I just discovered the following problem with PGAdmin 1.8 RC1 (on WinXP) I have a server where still PostgreSQL version 7.4.7 is running (Debian Sarge). I created a table with PGAdmin, finished (which went fine) and added a little bit later some more columns. PGAdmin gave me a syntax err

Re: [pgadmin-support] windows, pgadminiii 1.8.0 RC1 crash after server restart

2007-10-12 Thread Dave Page
Roger Moloney wrote: > running postgres 8.1.4 on Linux machine > > running pgadminiii 1.8.0 RC1 on windows xp > > restarted server. > clicked on databases in pgadminiii tree > pgadminiii crashed I committed a probably-related fix earlier today, and now cannot reproduce this problem, so it look

[pgadmin-support] Bug report and improvement proposal of the search function in the query editor

2007-10-12 Thread Artur Linhart - PostgresQL Comunication
Hello, I have installed pgAdmin 1.6.3 on Windows XP and work with the query (SQL) editor, where I found following issues: 1. The search function does not find occurences of the characters on very long lines (for example by the line (11629,1,10265,'Simon Karl','2007-09-25 13:37:

[pgadmin-support] windows, pgadminiii 1.8.0 RC1 crash after server restart

2007-10-12 Thread Roger Moloney
running postgres 8.1.4 on Linux machine running pgadminiii 1.8.0 RC1 on windows xp restarted server. clicked on databases in pgadminiii tree pgadminiii crashed [earlier versions of pgadminiii gave notice that connection was lost and restarted ok]

Re: [pgadmin-support] PGAdmin crashes on Windows if the file pgpass.conf locally does not exist

2007-10-12 Thread Dave Page
Artur Linhart - PostgresQL Comunication wrote: > I installed pgAdmin 1.6.3 on Windows XP Czech version > > After I could log in to the database, the program displayed the > message it cannot write the file > > "c:\Documents and Settings\linhart1\Data > aplikací\postgresql\pgpass.conf" > > (The „

[pgadmin-support] PGAdmin crashes on Windows if the file pgpass.conf locally does not exist

2007-10-12 Thread Artur Linhart - PostgresQL Comunication
I installed pgAdmin 1.6.3 on Windows XP Czech version After I could log in to the database, the program displayed the message it cannot write the file "c:\Documents and Settings\linhart1\Data aplikací\postgresql\pgpass.conf" (The "application data" directory is localized to "data aplikací" o

Re: [pgadmin-support] Grid editor crash during row insert

2007-10-12 Thread Alexander Kirpa
On 8 Oct 2007, at 15:02, Dave Page wrote: > Alexander Kirpa wrote: > > PGAdmin III 1.8 Beta 5 > > Windows 2000 > > > > Still stable crash during insert rows in table over grid editor. For > > crash need sequential insert 128-130 rows without closing grid > > editor. > > I nearly gave myself RSI