[pgadmin-support] query result set displaying data types in output window..

2008-04-08 Thread David Wheeler
Hello, In pgAdmin 1.8.2 - is there a way to *not display the data types in the query data output window? Below the selected field names? Eg: Fieldname1 Fieldname2 Biginit double precision,etc,,etc,,, Your help in this would be greatly appreciated. Thanks d

Re: [pgadmin-support] Removing Context Messages

2008-04-08 Thread Fernando Hevia
> > > Regardless of your request about silencing context messages (did not > look into that): maybe SQL along these lines would do the job for you? > > select id_cliente, array_to_string(ARRAY(SELECT apellido from clientes > c0 WHERE c0.id_cliente = c.id_cliente), E'\n') > from clientes c > group b

Re: [pgadmin-support] Removing Context Messages

2008-04-08 Thread Erwin Brandstetter
On Apr 8, 3:01 pm, [EMAIL PROTECTED] ("Fernando Hevia") wrote: (...) > --- Function declaration follows in case it helps --- > CREATE OR REPLACE FUNCTION f_inner(p_client numeric(10)) RETURNS void AS > $BODY$ > DECLARE > r_clients clientes%ROWTYPE; > BEGIN > SELECT * INTO r_clients FROM cliente

Re: [pgadmin-support] Grant RULE removed in pg 8.2

2008-04-08 Thread Erwin Brandstetter
Dave Page wrote: On Tue, Apr 1, 2008 at 1:17 AM, Erwin Brandstetter <[EMAIL PROTECTED]> wrote: Mistaken I am! A related, but different bug it is. This time, views it affects, not tables. Fixed it is. Pleased you'll be. Pleased I shall be. May the force be with you, Master Dave! -

Re: [pgadmin-support] Removing Context Messages

2008-04-08 Thread Fernando Hevia
On Tue, Apr 8, 2008 at 3:22 AM, Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > Fernando Hevia a écrit : > > > On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED] > [EMAIL PROTECTED]>> wrote: > > > Hi list, > > > > > > How do I remove CONTEXT messages from being displayed in pgadmi

Re: [pgadmin-support] Removing Context Messages

2008-04-08 Thread Fernando Hevia
On Tue, Apr 8, 2008 at 3:29 AM, Julius Tuskenis <[EMAIL PROTECTED]> wrote: > Hello. > > What do you mean saying CONTEXT messages? Could you give an example what > you get and what you want to get from your functions? > > > Sure. I have made a simple example to show this with 2 functions: f_outer w

Re: [pgadmin-support] Is Changing database Name possible ?

2008-04-08 Thread Melvin Davidson
Abhi, 1st., the word is Hello, not Hallo! Next, PgAdmin does allow you to change the name, but you cannot have a current connection to that same database. Steps to do this. 1. Right click the Databases branch and select refresh. 2. Click on database postgres and then open a Query window. 3. AL

Re: [pgadmin-support] Is Changing database Name possible ?

2008-04-08 Thread Julius Tuskenis
Hi, backup, create a new DB with the name you want and then restore data into it. -- Julius Tuskenis leoabhi rašė: Hallo, Thanks for your reply. It helped and worked. I tried to change the name of Database to small letters, but Pgadmin doesnt allow me to do so or i failed to figure it o

[pgadmin-support] Is Changing database Name possible ?

2008-04-08 Thread leoabhi
Hallo, Thanks for your reply. It helped and worked. I tried to change the name of Database to small letters, but Pgadmin doesnt allow me to do so or i failed to figure it out ? Any suggestions how i can replace my existing database with a new name ? thanks Rgrds, Abhi Melvin Davidson-3 wr

Re: [pgadmin-support] Grant RULE removed in pg 8.2

2008-04-08 Thread Dave Page
On Tue, Apr 1, 2008 at 1:17 AM, Erwin Brandstetter <[EMAIL PROTECTED]> wrote: > I slightly miswrote: > > > > I am afraid, the RULE privilege for pg >= 8.2 has risen from the dead in > pgadmin 1.8.2. > > My original bug report (to pgadmin-support@postgresql.org at 2007-03-05) > applies in full again

Re: [pgadmin-support] win32 psql syntax error running any .sql crea ted by the query editor

2008-04-08 Thread Magnus Hagander
Gah, that's what I get for not doublechekcing what that darn word completion on my phone did with what I wrote :-) That looks like it could be a *unicode* BOM. Can you open the file in a *hex* editor and check the first couple of bytes.. //Magnus Magnus Hagander wrote: > Looks like it could be a