Re: quote style in buffer - Mailing list pgsql-novice

From Tom Lane
Subject Re: quote style in buffer
Date
Msg-id 19166.1075652193@sss.pgh.pa.us
Whole thread Raw
In response to quote style in buffer  (joseph speigle <joe.speigle@jklh.us>)
List 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 by date:

Previous
From: Lawrence Smith
Date:
Subject: Re: Q: Reclaiming deleted space in data files
Next
From: Tom Lane
Date:
Subject: Re: simple update closes connection. why?