[pgadmin-support] generating UPDATE SET ... WHERE PK = ...

2007-10-30 Thread Laurent ROCHE
Hi, I would like to generate with a request a SQL order like UPDATE tab1 SET col_a = ?, col_b = ? ... WHERE pk = ? for each table of a given schema (in fact what I want is slightly more complicated but if I can write the above, I will be able to get the rest). Will anyone be kind enough to sh

Re: [pgadmin-support] Error creating a new index with tablespace and fillfacotor

2007-10-30 Thread Dave Page
Stefan Wolf (Zielpunkt-Marketing) wrote: > Hi, if I try to add a new object – new index on MyTable. Using > Fillfactor 100 and Tablespace MyTablespace will caus an error. > > The order in the SQL-Text is wrong. Thanks - fixed in SVN for 1.8.1. Regards, Dave ---(end of br

Re: [pgadmin-support] error auto-completing "GRANT SELECT ON"

2007-10-30 Thread Dave Page
Alejandro Gasca wrote: > Hi, if i open a sql pane, and put: > GRANT SELECT ON > and press [ctrl]+[space] this error rise: > > ERROR: syntax error at or near "DATABASE" > LINE 6: UNION SELECT "DATABASE" UNION SELECT "FUNCTION" UNION S... Magnus - can you take a look at this please. I'm not overly

[pgadmin-support] Error creating a new index with tablespace and fillfacotor

2007-10-30 Thread Stefan Wolf (Zielpunkt-Marketing)
Hi, if I try to add a new object - new index on MyTable. Using Fillfactor 100 and Tablespace MyTablespace will caus an error. The order in the SQL-Text is wrong. pgAdmin 1.8.0 on Win32, PostgreSQL 8.2.5 and 8.3.1 Beta Regards, Stefan Wolf

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

2007-10-30 Thread Dave Page
Phill wrote: > >> Hi everybody! I'm having problems with launching pgAdmin (versions >> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin >> application, it just crashes every time. The bug is 100% reproducible. > > Similar problem here, can't get latest v1.8.0 it to launch on