Re: quote style in buffer

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: quote style in buffer
Дата
Msg-id 19166.1075652193@sss.pgh.pa.us
обсуждение исходный текст
Ответ на quote style in buffer  (joseph speigle <joe.speigle@jklh.us>)
Список pgsql-novice
joseph speigle <joe.speigle@jklh.us> writes:
> I can't seem to find the comment for an sql file

> drop function dups();
> -- joe speigle
> -- Feb 1 2004
> CREATE FUNCTION dups() RETURNS int4
>       AS 'SELECT 1 as RESULT' LANGUAGE 'sql';
> this always stops after the first line.

It looks just fine as you've shown it.  Define "stops" --- what did you
do exactly, and what happened exactly?

The only theory that comes to mind right away is that what you think are
newlines are not really, so that the database is seeing the file as one
long line.

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Lawrence Smith
Дата:
Сообщение: Re: Q: Reclaiming deleted space in data files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: simple update closes connection. why?