Re: Problem reloading regression database

[2002-01-13 11:41] Tom Lane said:
| Brent Verner <brent(at)rcfile(dot)org> writes:
| > In CopyFrom, if attlist present, create Form_pg_attribute* ordered
| > same as attlist.
|
| Doesn't seem like this can possibly work as-is. The eventual call to
| heap_formtuple must supply the column values in the order expected
| by the table, but I don't see you remapping from input-column indices to
| table-column indices anywhere in the data processing loop.

yup. back to the drawing board ;-)

| Also, a reasonable version of this capability would allow the input
| column list to be just a subset of the table column list; with the
| column default expressions, if any, being evaluated to fill the missing
| columns. This would answer the requests we keep having for COPY to be
| able to load a table containing a serial-number column.

right.

| Don't forget that if the syntax allows COPY (collist) TO file, people
| will expect that to work too.

;-) darnit!

thanks.
brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman