Skip site navigation (1) Skip section navigation (2)

Re: NOLOGGING option, or ?

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: NOLOGGING option, or ?
Date: 2005-06-02 02:47:26
Message-ID: 20050602024726.GA12894@gp.word-to-the-wise.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jun 01, 2005 at 07:35:33PM -0700, Luke Lonergan wrote:
> >> I propose an extended syntax to COPY with a change in semantics to remove
> >> the default of "WITH ESCAPE '\'".
> > 
> > Er, doesn't this break existing database dumps?
> 
> Yes, one of the previously stated reasons to create another command for
> loading data.
> 
> Another possible approach is to keep the default, but allow the escape
> processing to be turned off.

I've been following this thread, and I'm a little confused. Could you
possibly clarify what you mean, by providing a couple of lines of
input as it would be formatted with escape processing turned off - 
containing a text field with an embedded newline and tab and a null field.

Cheers,
  Steve

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2005-06-02 03:24:03
Subject: SELECT FOR UPDATE and UNION ALL
Previous:From: Luke LonerganDate: 2005-06-02 02:40:06
Subject: Re: NOLOGGING option, or ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group