Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Bruce Momjian
Bruce Momjian wrote: > Richard Huxton wrote: > > On Thursday 15 April 2004 15:58, Bruce Momjian wrote: > > > > > > OK, so we need a list of columns for output with quotes, and a list of > > > columns where NULL should be changed to zero-length strings. > > > > > > How about if we use FORCE to force

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Bruce Momjian
Richard Huxton wrote: > On Thursday 15 April 2004 15:58, Bruce Momjian wrote: > > > > OK, so we need a list of columns for output with quotes, and a list of > > columns where NULL should be changed to zero-length strings. > > > > How about if we use FORCE to force quotes on output, and CONVERT to >

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Richard Huxton
On Thursday 15 April 2004 15:58, Bruce Momjian wrote: > > OK, so we need a list of columns for output with quotes, and a list of > columns where NULL should be changed to zero-length strings. > > How about if we use FORCE to force quotes on output, and CONVERT to > convert null to zero-length strin

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian wrote: What about NULL input? Is my warning and promotion to zero-length string for NOT NULL columns OK? I know I originally floated this idea or one very like it, but I have become con

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Bruce Momjian
Andrew Dunstan wrote: > Bruce Momjian wrote: > > >What about NULL input? Is my warning and promotion to zero-length > >string for NOT NULL columns OK? > > > > > > > > > I know I originally floated this idea or one very like it, but I have > become convinced it is not a good idea after all. T

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian said: Andrew Dunstan wrote: copy mytable to 'mydata.csv' csv force zipcode; seems OK to me. I'm all in favor of low-tecH solutions where appropriate. ;-) Could we have FORCE just force quotes on all values, rather th

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Andrew Dunstan
Bruce Momjian wrote: What about NULL input? Is my warning and promotion to zero-length string for NOT NULL columns OK? I know I originally floated this idea or one very like it, but I have become convinced it is not a good idea after all. The user might not know or expect that the data fil

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Bruce Momjian
Andrew Dunstan wrote: > Bruce Momjian said: > > Andrew Dunstan wrote: > >> > >> copy mytable to 'mydata.csv' csv force zipcode; > >> > >> seems OK to me. I'm all in favor of low-tecH solutions where > >> appropriate. ;-) > > > > Could we have FORCE just force quotes on all values, rather than > > a

Re: [PATCHES] Plan for CSV handling of quotes, NULL

2004-04-15 Thread Andrew Dunstan
Bruce Momjian said: > Andrew Dunstan wrote: >> >> copy mytable to 'mydata.csv' csv force zipcode; >> >> seems OK to me. I'm all in favor of low-tecH solutions where >> appropriate. ;-) > > Could we have FORCE just force quotes on all values, rather than > allowing a list of columns to be specified?

Re: [PATCHES] Update french translation of the 7.4 branch

2004-04-15 Thread Peter Eisentraut
LELARGE Guillaume wrote: > LELARGE Guillaume wrote: > > Here are some updates of the french .po files. > > > > ## pg_dump-fr.po > > 391 messages traduits. > > ## pg_resetxlog-fr.po > > 57 messages traduits. > > ## pgscripts-fr.po > > 112 messages traduits. > > ## psql-fr.po > > 455 messages traduit

Re: [PATCHES] Translation updates for 7.5: pg_resetxlog-ru;pg_controldata-ru;pg_dump-ru;initdb-ru

2004-04-15 Thread Peter Eisentraut
Serguei Mokhov wrote: > Please install attached translation updates. > This is for 7.5. Done. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster