hi folks,
as i'm new, i'm not sure if this forum is the right one. i found a bug,
maybe in postgresql 7.2.1 or in my brain (you tell me):
i want to copy a table from one datbase (DB1) to another (DB2).
So i start psql with DB1 and execute:
\copy phfields to phfields.bak using delimiters '"'
\q
then i start psql again with DB2 and execute:
\copy fields from phfields.bak using delimiters '"'
ok, i also changed the name of the table. but the problem is: i receive the
following message:
ERROR: copy: line 1, pg_atoi: error in "VARCHAR(16)": can't parse
"VARCHAR(16)"
psql just produced the file phfields.bak. Why is it a problem to read it? Is
just some seconds later and i did not touch the .bak-file manually.
thanks in advance
--------------------------- the create-table command --------------
CREATE TABLE fields (
pflid SERIAL PRIMARY KEY,
pfltbl VARCHAR(16),
pflindx INTEGER,
pflname VARCHAR(16),
pflaname VARCHAR(32),
pfldlevel INTEGER,
pflmlevel INTEGER,
pfldefstr INTEGER,
pflcomment INTEGER,
pflsorti INTEGER,
pflquickv INTEGER,
pflselv INTEGER,
pflinput INTEGER,
pflupdate INTEGER,
pflconv INTEGER,
pflres15 INTEGER,
pflres16 INTEGER
);
----------------- some records of the .bak-file: ---------------
2"phfields"1"pfltbl"Tabelle"12"14"VARCHAR(16)"Name der Tabelle, in der sich
die Variable befindet"\N"\N"\N"\N"\N"\N"\N"\N
3"phfields"2"pflindx"Nr. in Tabelle"12"14"INTEGER"Index der Variablen in
ihrer Tabelle"\N"\N"\N"\N"\N"\N"\N"\N
1"phfields"0"pflid"Index"12"14"SERIAL PRIMARY KEY"Index der Einträge in
phfields"\N"\N"\N"\N"\N"\N"\N"\N
4"phfields"3"pflname"Feldname"12"14"VARCHAR(16)"Variablenname in
DB-Tabelle"\N"\N"\N"\N"\N"\N"\N"\N
5"phfields"4"pflaname"Anzeigename"12"14"VARCHAR(32)"Name der angezeigt
wird"\N"\N"\N"\N"\N"\N"\N"\N
6"phfields"5"pfldlevel"Anzeigeberechtigung"12"14"INTEGER"Mindsetberechtigung
zur Anzeige des Feldes"\N"\N"\N"\N"\N"\N"\N"\N
7"phfields"6"pflmlevel"Modif. Brechtigung"12"14"INTEGER"Mindestberechtigung
zur Modifikation des Feldes"\N"\N"\N"\N"\N"\N"\N"\N
17"phfields"7"pfldefstr"Definition"12"14"INTEGER"Definitions
String"\N"\N"\N"\N"\N"\N"\N"\N
--------------------------- the end ----------------------------
this table describes entries in other tables!
Bogdan
mailto:bogdan@chytrek.de
p.s. How do i see the answers to that posting???