|
From:
pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of Tony Linden Dear
We
have a developer doing an application for us using a Postgre Db. One of the
items is to export the data into a xml file and then either email or whatever
but the ability is there then to import the xml data back into the database. So
what happens is that the contents of certain tables are exported into this xml
file, and this is all the columns data related to that table. We have checked
the XML file and we can verify that all the columns of each table have been
exported. The
problem comes in now when the import takes place all the columns data does not
appear to be imported and when we asked the developer about this his reply was There is a known bug in PostGre regarding the number of
columns that can be imported….. Is this a fact and where can I find more information on
this? >> Here is the documentation for
the copy command: http://www.postgresql.org/docs/8.3/interactive/sql-copy.html Here are the limits on columns: http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html In particular: “A table cannot have more
than 1600 columns. (In practice, the effective limit is usually lower because
of tuple-length constraints.) ” << Please would you comment on this ? Many thanks Regards Tony
Linden Database
Administrator Catholic
Relief Services Email:
tlinden@xxxxxxxxxxxx Cell
: 0765419357 Fax
: 0865007123 |
