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

2008-04-07 Thread Magnus Hagander
Looks like it could be a knocked BOM. Can you open the file in a bed editor and check the first couple of bytes? /Magnus > --- Original Message --- > From: Kev <[EMAIL PROTECTED]> > To: pgadmin-support@postgresql.org > Sent: 08-04-07, 22:34:42 > Subject: [pgadmin-support] win32 psql synt

Re: [pgadmin-support] Removing Context Messages

2008-04-07 Thread Julius Tuskenis
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? Fernando Hevia rašė: Hi list, How do I remove CONTEXT messages from being displayed in pgadmin? Those messages clutter my functions output with information I

Re: [pgadmin-support] Removing Context Messages

2008-04-07 Thread Guillaume Lelarge
Fernando Hevia a écrit : On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED] > wrote: > Hi list, > > How do I remove CONTEXT messages from being displayed in pgadmin? > Those messages clutter my functions output with information I dont need so I > w

Re: [pgadmin-support] Removing Context Messages

2008-04-07 Thread Fernando Hevia
On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote: > Hi list, > > How do I remove CONTEXT messages from being displayed in pgadmin? > Those messages clutter my functions output with information I dont need so I > would like to get rid of them. > > Is that possible? > On Mon,

Re: [pgadmin-support] Removing Context Messages

2008-04-07 Thread Michael Shapiro
I'd like to know the answer to this as well. I don't think it is PgAdmin doing it, but the server On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote: > Hi list, > > How do I remove CONTEXT messages from being displayed in pgadmin? > Those messages clutter my functions ou

[pgadmin-support] Removing Context Messages

2008-04-07 Thread Fernando Hevia
Hi list, How do I remove CONTEXT messages from being displayed in pgadmin? Those messages clutter my functions output with information I dont need so I would like to get rid of them. Is that possible? Thanks, Fernando.

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

2008-04-07 Thread Raymond O'Donnell
On 07/04/2008 21:34, Kev wrote: If I open the file in TextPad, it says it's of UNIX type. If I then save it again using TextPad and run it, it runs fine without errors. This also happens even if I go Edit->Line Ends-> and choose either DOS or UNIX in the query editor and then save again. Thi

[pgadmin-support] win32 psql syntax error running any .sql created by the query editor

2008-04-07 Thread Kev
Hi, This is reproducible every time on my Windows 2003 Server box running pgAdmin3 1.8.2 and pgsql 8.3. 1. Open the query editor. 2. Type any valid query. 3. Save. 4. In a DOS box, run psql -f on the file you just saved. I get the following error: psql:path/to/test.sql:71: ERROR: syntax error

Re: [pgadmin-support] pgAdmin hang on connection drop/reconnect

2008-04-07 Thread Willy-Bas Loos
Hi, We also have issues with connections ending abrubtly. Not only with pgAdmin by the way. We're at the end of a DSL line, and the connection usually has a lot of hiccups. After one of those hiccups, you have to wait for at least 30 seconds to find out what happened, after which you get a correct

Re: Re [pgadmin-support] pgadmin datatype

2008-04-07 Thread Melvin Davidson
Hello Abhi, It seems to me that a datatype of real[] would be appropriate. Alternative syntax is real ARRAY[3] http://www.postgresql.org/docs/8.2/interactive/arrays.html#AEN5738 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of leoabhi Sent: Monday, April

Re [pgadmin-support] pgadmin datatype

2008-04-07 Thread leoabhi
Hallo, I want to make a column which will store (x,y,z) cordinates Eg(2.12 , -3.00012 , 5.2132) Is there any inbuilt datatype for Pgadmin III?? Please reply with your suggestions thanks Abhi -- View this message in context: http://www.nabble.com/Re-pgadmin-datatype-tp16536685p16536685.

Re: [pgadmin-support] Failed ot lounch pgAdmin3 on Leopard

2008-04-07 Thread Dave Page
On Mon, Apr 7, 2008 at 9:36 AM, Ilya Dyoshin <[EMAIL PROTECTED]> wrote: > Good day, > > I'm getting trouble to make pgAdmin3 running on Leopard. I'm always get the > error. If I start the pgAdmin 1.8.2, 1.6.3, 1.4.3 it get the error. > > If I build pgAdmin3 using the macports - the same situation

[pgadmin-support] Failed ot lounch pgAdmin3 on Leopard

2008-04-07 Thread Ilya Dyoshin
Good day, I'm getting trouble to make pgAdmin3 running on Leopard. I'm always get the error. If I start the pgAdmin 1.8.2, 1.6.3, 1.4.3 it get the error. If I build pgAdmin3 using the macports - the same situation. In the internet I found that pgAdmin 1.9 would run on Leopard. Can you poi