In Solaris 10 with Postgres 8.0, I am getting only for " EDITOR". bash-2.05b$ echo $EDITOR /usr/dt/bin/dtpad bash-2.05b$ echo $VISUAL bash-2.05b$ bash-2.05b$ echo $PSQL_EDITOR bash-2.05b$ Thanks Dinesh Pandey -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Michael Fuhr Sent: Monday, May 02, 2005 8:32 PM To: Dinesh Pandey Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: unable to open editor. On Mon, May 02, 2005 at 06:06:46PM +0530, Dinesh Pandey wrote: > > In Solaris 10 with Postgres 8.0, I am getting this error and unable to open > editor. > > testdb=# \e test.sql > > ttdt_open failed: TT_ERR_PROCID The process id passed is not valid. This looks like a ToolTalk error. What editor are you trying to use? What's the value of the PSQL_EDITOR or EDITOR or VISUAL environment variable? Have you googled for this error message to see what might cause it and how to fix it? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx ---------------------------(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