[pgadmin-support] question about connection settings

2007-08-01 Thread Jack
Hi, all I tried to use "set search_path to x1, x2, public" for postgreSQL when doing a connection. After that, I won't specify schema for any database object in sql, or plpgsql for postgreSQL will search it by the order I set at the connection. While with pgAdmin, I can't find such a connection

Re: [pgadmin-support] Problem with Query Tool F5

2007-08-01 Thread R. Kevin Bean
Thanks for your help. After your replay looked farther into maybe a keyboard issue which it was. Fixed sticky key and now works fine. Kevin On 7/31/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote: > On 31/07/2007 20:53, R. Kevin Bean wrote: > > > When using the query tool there is a problem usi

Re: [pgadmin-support] question about connection settings

2007-08-01 Thread Guillaume Lelarge
Dave Page a écrit : > Jack wrote: >> Hi, all >> >> I tried to use "set search_path to x1, x2, public" for postgreSQL >> when doing a connection. After that, I won't specify schema for >> any database object in sql, or plpgsql for postgreSQL will search it by >> the order I set at the connection.

Re: [pgadmin-support] question about connection settings

2007-08-01 Thread Dave Page
Jack wrote: > Hi, all > > I tried to use "set search_path to x1, x2, public" for postgreSQL > when doing a connection. After that, I won't specify schema for > any database object in sql, or plpgsql for postgreSQL will search it by > the order I set at the connection. While with pgAdmin, I can't

Re: [pgadmin-support] Problem with Query Tool F5

2007-08-01 Thread Raymond O'Donnell
On 01/08/2007 03:56, R. Kevin Bean wrote: Thanks for your help. After your replay looked farther into maybe a keyboard issue which it was. Fixed sticky key and now works fine. I remember once spilling apple juice over a keyboardeven after removing all the keys and cleaning it as careful

[pgadmin-support] demande de support

2007-08-01 Thread Henry Valéry TEGUIAK
bonjour, j'utilise pgAdmin III et j'aimerai avoir un support pouvant m'aider à bien l'utiliser. cordialement

Re: [pgadmin-support] demande de support

2007-08-01 Thread Guillaume Lelarge
Henry Valéry TEGUIAK a écrit : > bonjour, > j'utilise pgAdmin III et j'aimerai avoir un support pouvant m'aider à > bien l'utiliser. > 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. De qu

[pgadmin-support] bug - when Restore env option

2007-08-01 Thread 李飞
PostgreSQL version: 8.2.4 pgAdmin version:1.8.0 beta2 Operating system: Windows XP SP2 Details: 1. connect to the server. in treeview open one schema (etc ,public) 2. select server and executing "properties" 3. turn Restore env option on and click Ok button to save properties 4. c

[pgadmin-support] bug - when Restore env option on

2007-08-01 Thread 李飞
PostgreSQL version: 8.2.4 pgAdmin version:1.8.0 beta2 Operating system: Windows XP SP2 Details: 1. connect to the server. in treeview open one schema (etc ,public) 2. select server and executing "properties" 3. turn Restore env option on and click Ok button to save properties 4. close

Re: [pgadmin-support] question about connection settings

2007-08-01 Thread Qulas Jack
Guillaume, Thank you very much! I would like to use a macro to do set search_path, because the whole database will become in that search order when I do alter database. But there is still a problem when writing a new function and using either %TYPE or %ROWTYPE, postgreSQL will check whether th

Re: [pgadmin-support] demande de support

2007-08-01 Thread Vishal Arora
You can find support on - http://www.pgadmin.org. Vishal Date: Wed, 1 Aug 2007 16:46:36 +0200From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [pgadmin-support] demande de support bonjour, j'utilise pgAdmin III et j'aimerai avoir un support pouvant m'aider à bien l'utiliser. cordialement