Re: [pgadmin-hackers] Suggestions for the next version

2003-08-01 Thread Andreas Pflug
Brage Førland wrote:

 

Why should you run the reverse-engineered SQL? It reflects (partially) 
what's already present in the database! It's suggested as a starting 
point or template to make some more complicated changes. And they could 
be quite dangerous too!
   

This is what you get currently if you select the QueryTool. 
 

Brage,

there's still no solution for the two complete separate sets of menu 
items which would be needed. I'm not a fan of exchanging the menu case 
by case, because this can be irritating, and wxWindows showed some 
trouble with exchanging menus too. And again: it's a bit dangerous, 
because F5 is dual-used, you could trigger something you don't really 
intended in the current context.

Regards,
Andreas


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


[pgadmin-hackers] Multilingual website available for preview

2003-08-01 Thread Jean-Michel POURE
Dear friends,

pgAdmin3 website has been internationalized using Gettext, the same technique 
which enables the translation of pgAdmin3.

A preview is available at http://snake.pgadmin.org/pgadmin3/index.php.

Please note that only the home page and the French language are available 
because the content of the site is not yet validated. I hope to finish the 
site late Friday at night.

Cheers,
Jean-Michel Pouré


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] Multilingual website available for preview

2003-08-01 Thread Devrim GUNDUZ

Hi,
On Fri, 1 Aug 2003, Jean-Michel POURE wrote:

 pgAdmin3 website has been internationalized using Gettext, the same technique 
 which enables the translation of pgAdmin3.

That's very good news. I'm going to holiday tomorrow, for 10 days.. After 
returning, on 23th of August, we have a one-day PostgreSQL Workshop in 
Istanbul, Turkey. It would be good for us to promote pgadmin3 with a 
Turkish site.

I'd be happy to help you after holiday, if you need.

BTW, I've cc'ed this message to Volkan Yazici. He helps me a lot in 
translating documents into Turkish..

Regards,
-- 
Devrim GUNDUZ
[EMAIL PROTECTED]   [EMAIL PROTECTED] 
http://www.tdmsoft.com
http://www.gunduz.org


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] Snake Php configuration

2003-08-01 Thread Jean-Michel POURE
Dear Mark or Dave,

Languages do not display well under Snake because of an UTF-8 problem.

Php is currently compiled with:
'./configure' '--without-mysql' '--with-pgsql=/usr/local/pgsql' 
'--with-gettext' '--with-apxs=/usr/local/apache/bin/apxs' 

It should also carry this additional option:
--with-iconv --enable-mbstring=all

Then, restart Apache and connect to pgadmin3/phpinfo.php.
You should read the environment variable:
_ENV[locale]=en_US

When it is done, please drop me an email, I will upload the required code to 
display UTF-8 data.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] Snake Php configuration

2003-08-01 Thread Jean-Michel POURE
On Friday 01 August 2003 14:44, Jean-Michel POURE wrote:
 When it is done, please drop me an email, I will upload the required code
 to display UTF-8 data.

After PHP installation on Snake, if you want to test UTF-8 display yourself:

- open pgadmin3/class/pgadmin_session.php
- uncomment line 42,
- comment line 43

Connect to pgadmin3/index.php and select the French language.
You should be able to see the accentuated characters.

Otherwise, it might be a locale configuration problem under GNU/Linux. The 
first thing to do before tweaking the system is to build PHP with iconv 
(inconv needed on the system, does not seem to be installed on Snake) and 
mb_string support.

When/if it is done, please drop me an email. Thanks for your help.

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Table permissions

2003-08-01 Thread Andreas Pflug
Adam H. Pendleton wrote:

How, using pgadmin3, can I change the permissions for a table?  Or for 
a particular user.  In the past, with other postgres managers, I've 
seen something like a permissions grid created, which showed, for each 
user, tables on the y axis, and permissions on the x axis.  I can't 
seem to find anything like this in pgadmin3.  In fact, I can't figure 
out how to change permissions at all.  I'm sure I'm just being dense, 
but can you guys point me in the right direction.

ahp


It's the security tab on most object properties. Note that only groups 
are offered by default (see options).
More security tools (e.g. for multi-table changes) to come in V2.

Regards,
Andreas
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [pgadmin-hackers] Snake Php configuration

2003-08-01 Thread Jean-Michel POURE
Dear all,

I could tweak the PHP scripts to display UTF-8 data, but it is not very 
interesting. Now and then, if you have time, compiling PHP with iconv would 
be great.

Cheers,
Jean-Michel

 Dear Mark or Dave,

 Languages do not display well under Snake because of an UTF-8 problem.

 Php is currently compiled with:
 './configure' '--without-mysql' '--with-pgsql=/usr/local/pgsql'
 '--with-gettext' '--with-apxs=/usr/local/apache/bin/apxs'

 It should also carry this additional option:
 --with-iconv --enable-mbstring=all

 Then, restart Apache and connect to pgadmin3/phpinfo.php.
 You should read the environment variable:
 _ENV[locale]=en_US

 When it is done, please drop me an email, I will upload the required code
 to display UTF-8 data.

 Cheers,
 Jean-Michel


 ---(end of broadcast)---
 TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[pgadmin-hackers] PHP configuration options

2003-08-01 Thread Jean-Michel POURE
Dear Dave,

Hi again. There is also another requirement for PHP: --enable-trans-sid

This option allows to manage sessions without cookies, which is fine in the 
case of a public site like pgAdmin. A summary of needed ./configure options:

./configure --without-mysql
--with-pgsql=/usr/local/pgsql 
--with-gettext
--with-apxs=/usr/local/apache/bin/apxs 
--with-iconv
--enable-mbstring=all
--enable-trans-sid
--enable-wddx
--enable-magic-quotes

Cheers,
Jean-Michel


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [pgadmin-hackers] Website preview

2003-08-01 Thread Dave Page
It's rumoured that Jean-Michel POURE once said:
 On Thursday 31 July 2003 12:30, Dave Page wrote:
 I have the original in a bizarre Microsoft vector format (which won't
 convert well to Photoshop). I can do something when I get back (late
 Sunday) if required.

 The can check the logo on Snake. I used Gimp-1.3 instable version from
 http://www.freshrpms.net (in RPM format). The new gimp is getting
 closer to  the levels of Photoshop. I am quite impressed. The .xcf
 extension is Gimp  format.

Umm, bg colour is wrong, and the font is wrong (sorry to be so negative).
Also, the language selector messes up the bar in IE6.
I'll do a logo when I return.

Regards, Dave.



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] Website preview

2003-08-01 Thread Jean-Michel POURE
On Friday 01 August 2003 22:11, Dave Page wrote:
 I'll do a logo when I return.

The Gimp 1.3 template is on Snake. It has layers which you can modify.
Cheers, Jean-Michel


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match