Re: Prompt display in Panther build

[Michael Mauger]

I'm the maintainer of sql.el -- see my comments below...

Matt Tenenbaum wrote --
> When I run 'sql-postgres' to start the interactive SQL mode 
> (to connect to a local pgsql server) the behavior differs 
> between the command line invocation and the Carbon build. 
> In particular, on the command line, everything is (or seems) 
> as it is supposed to be; on the Carbon build, there is no 
> prompt. If I enter commands (despite the lack of prompt) 
> everything behaves normally (it transforms the text to 
> boldface and writes the query results, as usual), but I 
> still don't get any prompt showing up.
> 

First things to check:  
What version of postgres?
What are the prompt strings?
         \echo :PROMPT1
         \echo :PROMPT2
         \echo :PROMPT3

(sql.el is telling comint to expect a prompt of the form "^.*> *")

> Initially I thought this might be related to the problems 
> that seem to exist with subprocess responses on the terminal, 
> but the problem isn't in the terminal nor does it seem to 
> be with the _responses_ to commands, so I don't so much 
> think that anymore.
> 

I've had a similar problem with the command interpreter for SQL Server. 
Is it possible that psql is detecting that it's not connected to a
terminal and thus is skipping the prompt?  Do you get the prompt if you
start up a shell under Emacs and then enter psql?

> Anybody have any ideas, what might be causing this? Could 
> it be a problem with the sql.el in CVS? It is especially 
> strange to me that it is different between invocation-types. 
> Any help is greatly appreciated.
>

Unfortunately, I don't have a postgres config that I can test.  You may
want to also try the mailing list address@hidden -- I know that there are
some postgres users on that list.

-- Michael


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com