Re: [pgadmin-support] Freeze when trying to run a pg_dump backup file as SQL query

2012-07-14 Thread Evan Martin
Great, thanks for the fix, Guillaume! I tested it the latest master version with my original 15 MB file and it no longer freezes even on that. (It does take a few seconds just to open the file, but that's OK.) Regards, Evan On 14/07/2012 10:46 PM, Guillaume Lelarge wrote: On Sat, 2012-07-14

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 15:54 +0200, Jan-Peter Seifert wrote: > Hello, > > another thing came to my mind. > > pgAdmin III 1.14 does seem to commit the changes as soon as the new > value has been entered. > Wouldn't it be nice to display a warning or do a rollback if more than > one row had been upd

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 15:43 +0200, Jan-Peter Seifert wrote: > Hello, > > thank you very much for your feedback everyone! > > Am 14.07.2012 15:06, schrieb Dave Page: > > > > it would be nice to have additional/other fallback options ( via > > check box in pgAdmin's general options? ) to

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Jan-Peter Seifert
Hello, another thing came to my mind. pgAdmin III 1.14 does seem to commit the changes as soon as the new value has been entered. Wouldn't it be nice to display a warning or do a rollback if more than one row had been updated instead of one or none then? Thank you very much, Peter -- Sent via

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Jan-Peter Seifert
Hello, thank you very much for your feedback everyone! Am 14.07.2012 15:06, schrieb Dave Page: > > it would be nice to have additional/other fallback options ( via > check box in pgAdmin's general options? ) to identify rows for > editing in tables without primary keys. > > > I'

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 14:01 +0100, Thom Brown wrote: > On 14 July 2012 13:57, Guillaume Lelarge wrote: > > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > >> Use of the CTID system column would work. > > > > I don't see how that could work. CTIDs obviously are unique, but anyone, > > updati

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 14:06 +0100, Dave Page wrote: > > > On Saturday, July 14, 2012, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > > On 12 July 2012 12:20, Jan-Peter Seifert > wrote: > > > Hello, > > > > > > I h

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Dave Page
On Saturday, July 14, 2012, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > > On 12 July 2012 12:20, Jan-Peter Seifert > > > > wrote: > > > Hello, > > > > > > I have a feature request for the 'Edit data' window that is available > for each table in pgAdmin. > > >

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Thom Brown
On 14 July 2012 13:57, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: >> Use of the CTID system column would work. > > I don't see how that could work. CTIDs obviously are unique, but anyone, > updating a line will get another CTID for this line. If you try to > up

Re: [pgadmin-support] pgScript error when relation name contains ")" symbol

2012-07-14 Thread Guillaume Lelarge
On Sun, 2012-07-08 at 19:18 +0400, Vjacheslav A. wrote: > Hi, > I have pgScript error when relation name contains ")" symbol, > try this example (just execute by F6 - pgScript): > > CREATE TABLE "table1)d" > ( > code character varying(10) > ) > WITH ( > OIDS=FALSE > ); > > (its executed norma

Re: [pgadmin-support] Launching Application on Desktop in RHEL 6.1 pgsql 8.4

2012-07-14 Thread Guillaume Lelarge
Hi On Thu, 2012-07-12 at 17:01 +1000, John Olsen wrote: > -- Hi > > We have RHEL 6.1 and postgres 8.4 we wanted to see and launch pgadmin > from application pad but not visible (neither is postgres itself) > > How do you attach the postgres system to the desktop app launch system > in RHEL 6

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > On 12 July 2012 12:20, Jan-Peter Seifert wrote: > > Hello, > > > > I have a feature request for the 'Edit data' window that is available for > > each table in pgAdmin. > > > > As the OID column is not guaranteed to contain unique OIDs Oops,

Re: [pgadmin-support] demande de support

2012-07-14 Thread Guillaume Lelarge
On Thu, 2012-07-12 at 13:58 +0200, Isabelle Froc wrote: > Bonjour, > > > > Est il possible d’obtenir un support pour PG ADMIN svp ? > Ceci une liste de discussion en anglais seulement. Merci d'utiliser l'anglais dans vos messages. Si vous ne parlez pas anglais, contactez-moi directement ou ut

Re: [pgadmin-support] Freeze when trying to run a pg_dump backup file as SQL query

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 01:26 +1000, Evan Martin wrote: > No comments at all? Can anyone else at least repro this? > Don't know for others, but I was overloaded translating in french the PostgreSQL 9.2 manual. Now that's it's done, I can get back on hacking pgAdmin. > On 6/07/2012 10:33 PM, Evan M

Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

2012-07-14 Thread Guillaume Lelarge
On Thu, 2012-07-12 at 18:40 +, Zhang, Nancy wrote: > Hi , > > I have come across this issue all the time. > > I reinstalled and it works for a while. Once the computer rebooted, it > appeared again. > Well, without any kind of error messages, how do you want us to help you? -- Guillaume

Re: [pgadmin-support] Dialog box obscures information

2012-07-14 Thread Guillaume Lelarge
On Fri, 2012-07-13 at 10:01 -0400, Colin Beckingham wrote: > Using wxw 2.9.3, latest 1.17 pgadmin: > > This is not an error, just a suggestion for improved interaction. > > When viewing data from a table or view, begin by selecting all data. > Then click on the funnel icon to get the dialog that