From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Nicolai Tufar <ntufar(at)apb(dot)com(dot)tr> |
Cc: | pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Segmentation fault while COPY in 7.3 |
Date: | 2002-12-01 05:32:22 |
Message-ID: | 3DE99EE6.3000102@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
Nicolai Tufar wrote:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>>Hm. Offhand it would seem that somebody's output function is returning
>>a non-palloc'd string. What are the datatypes in that table, exactly?
>
> apb=> \d maras2.mrk_yyn
> Table "maras2.mrk_yyn"
> Column | Type | Modifiers
> ---------+-----------------------+-----------
> bsvr_no | character varying(10) |
> yyn_tur | character varying(1) |
> yyn_no | numeric |
> yyn_syf | numeric |
> yyn_trh | date |
FWIW, I just tried to repeat this on cvs tip and could not. Seems to work just
fine:
regression=# create table foo(bsvr_no character varying(10),yyn_tur character
varying(1),yyn_no numeric,yyn_syf numeric,yyn_trh date);
CREATE TABLE
regression=# insert into foo values('a','a','1.0','1.0',now()::date);
INSERT 556825 1
regression=# copy foo to stdout;
a a 1.0 1.0 2002-11-30
regression=# copy foo(bsvr_no) to stdout;
a
regression=# copy foo(bsvr_no,yyn_tur,yyn_no,yyn_syf,yyn_trh) to stdout;
a a 1.0 1.0 2002-11-30
regression=# insert into foo values('a','a','1.0','1.0',null);
INSERT 556826 1
regression=# copy foo(bsvr_no,yyn_tur,yyn_no,yyn_syf,yyn_trh) to stdout;
a a 1.0 1.0 2002-11-30
a a 1.0 1.0 \N
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-01 05:55:14 | Re: 7.4 Wishlist |
Previous Message | Nicolai Tufar | 2002-12-01 05:11:31 | Re: Hard-coded PUBLIC in pg_dump |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-01 05:55:14 | Re: 7.4 Wishlist |
Previous Message | Nicolai Tufar | 2002-12-01 05:11:31 | Re: Hard-coded PUBLIC in pg_dump |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-01 05:47:53 | Re: ALTER TABLE schema SCHEMA TO new_schema? |
Previous Message | Joe Conway | 2002-12-01 05:27:44 | ALTER TABLE schema SCHEMA TO new_schema? |