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

Re: Psql crashes with Segmentation fault on copy from

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lists(at)stringsutils(dot)com
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Psql crashes with Segmentation fault on copy from
Date: 2008-05-28 20:42:53
Message-ID: 5424.1212007373@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Francisco Reyes" <lists(at)stringsutils(dot)com> writes:
> On 3:09 pm 05/28/08 Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
>> Does it really have a COPY command at the beginning? Are you really doing >\i data/usb_t_60M.sql or were you trying to do a copy from this file?

> Argh..That's it.
> When I re-organized the scripts I must have taken the copy command from the top of the data file and did not put a 'copy from' in the calling script.

Hmm ... even so, it shouldn't have crashed, it should at worst have
given you an out-of-memory error message.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: hobbesDate: 2008-05-28 21:17:52
Subject: Help with remote connection to remote Postgresql 8.3 Server...
Previous:From: Pavel StehuleDate: 2008-05-28 20:18:27
Subject: Re: Populating a sparse array piecemeal in plpgsql (REDUX)

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