[PATCH] Re: AW: [postgis-users] shp2pgsql problems with NULL value columns

Paul Ramsey pramsey at refractions.net
Wed Aug 7 09:35:09 PDT 2002


Committed.

Steffen Macke wrote:
> 
> > shp2pgsql -c -D adrstr_numpos adrstr DBname ¦ psql -d DBname
> 
> The dump format made the problem: psql expects \N instead of NULL here
> 
> replace
> printf("\tNULL");
> in line 412 with
> printf("\\N");
> 
> This is fixed in the attached patch.
> 
> Steffen
> 
>   ------------------------------------------------------------------------
>                                           Name: patch-shp2pgsql-aug-07-2002.diff.gz
>    patch-shp2pgsql-aug-07-2002.diff.gz    Type: application/x-gzip
>                                       Encoding: base64

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_




More information about the postgis-users mailing list