Re: transfer database from Linux to Windows

Поиск
Список
Период
Сортировка
От Oleg
Тема Re: transfer database from Linux to Windows
Дата
Msg-id 43A97992.5010802@iwk.uka.de
обсуждение исходный текст
Ответ на Re: transfer database from Linux to Windows  (Jaime Casanova <systemguards@gmail.com>)
Ответы Re: transfer database from Linux to Windows  (Jaime Casanova <systemguards@gmail.com>)
Список pgsql-novice
Thanks a lot. Here is the copy of the log file.
There are some lines that could be important:
column "attrelid" of relation "geometry_columns" does not exist
multiple primary keys for table "spatial_ref_sys" are not allowed
multiple primary keys for table "geometry_columns" are not allowed

Best regards
Oleg

Jaime Casanova schrieb:

>always cc: list
>
>On 12/21/05, Oleg <evdakov@iwk.uka.de> wrote:
>
>
>>Jaime
>>I was trying to redirect errors from the screen to log file
>>I tried:
>>psql -d mydb -U postgres -f dumpfile.sql > output.txt
>>This gives only successful commands see attached psql_output.txt
>>
>>psql -d mydb -U postgres -f dumpfile.sql > output.txt 2>&1
>>Does not allow me to enter password
>>
>>What should I do?
>>Thanks a lot in advance
>>Oleg
>>
>>
>>
>>
>
>psql -d mydb -U postgres -f dumpfile.sql 2> output.txt
>
>or activate log in postgresql.conf
>
>--
>regards,
>Jaime Casanova
>(DBA: DataBase Aniquilator ;)
>
>
>
2005-12-21 16:46:32 ERROR:  user "gg33" does not exist
2005-12-21 16:46:32 ERROR:  function "plpgsql_call_handler" already exists with same argument types
2005-12-21 16:46:32 ERROR:  language "plpgsql" already exists
2005-12-21 16:46:33 ERROR:  user "gg26" does not exist
2005-12-21 16:46:33 ERROR:  user "gg33" does not exist
2005-12-21 16:46:33 ERROR:  function "histogram2d_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "histogram2d_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "histogram2d" already exists
2005-12-21 16:46:33 ERROR:  function "box3d_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "box3d_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "box3d" already exists
2005-12-21 16:46:33 ERROR:  function "spheroid_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "spheroid_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "spheroid" already exists
2005-12-21 16:46:33 ERROR:  function "wkb_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "wkb_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "wkb_recv" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "wkb_send" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "wkb" already exists
2005-12-21 16:46:33 ERROR:  function "chip_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "chip_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "chip" already exists
2005-12-21 16:46:33 ERROR:  function "geometry_in" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometry_out" already exists with same argument types
2005-12-21 16:46:33 ERROR:  type "geometry" already exists
2005-12-21 16:46:33 ERROR:  function "postgis_gist_sel" already exists with same argument types
2005-12-21 16:46:33 ERROR:  relation "spatial_ref_sys" already exists
2005-12-21 16:46:33 ERROR:  relation "geometry_columns" already exists
2005-12-21 16:46:33 ERROR:  function "postgis_version" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_lib_version" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_geos_version" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_proj_version" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_scripts_installed" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_scripts_released" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_uses_stats" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "postgis_full_version" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "find_srid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "get_proj4_from_srid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "rename_geometry_table_constraints" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "fix_geometry_columns" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "probe_geometry_columns" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "find_extent" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "find_extent" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "transform_geometry" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "transform" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "srid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "height" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "factor" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "width" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "datatype" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "compression" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "setsrid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "setfactor" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometry" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "box3d" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "box" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometry" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometry" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "expand" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "expand" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "asbinary" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "asbinary" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "bytea" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometry" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "pointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "pointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linestringfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linestringfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polygonfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polygonfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipointfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multilinefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multilinefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mlinefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mlinefromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpolyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpolyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipolyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipolyfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomcollfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomcollfromwkb" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "npoints" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "nrings" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mem_size" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "summary" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "translate" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "dimension" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometrytype" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "envelope" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "x" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "y" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "z" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "numpoints" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "pointn" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "exteriorring" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "numinteriorrings" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "interiorringn" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "numgeometries" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometryn" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "max_distance" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "optimistic_overlap" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "segmentize" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "distance" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "astext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "srid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometryfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geometryfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polyfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polygonfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polygonfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpolyfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linefromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mlinefromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multilinestringfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multilinestringfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "pointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomcollfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "setsrid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "polyfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpolyfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipolygonfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multipolygonfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linefromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linestringfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "linestringfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mlinefromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "pointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "mpointfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "geomcollfromtext" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "isempty" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "issimple" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "equals" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "length_spheroid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "length3d_spheroid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "distance_spheroid" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "multi" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "length3d" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "length" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "area2d" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "area" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "perimeter3d" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "perimeter" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "point_inside_circle" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "startpoint" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "endpoint" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "isclosed" already exists with same argument types
2005-12-21 16:46:33 ERROR:  function "centroid" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "isring" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "pointonsurface" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "xmin" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "ymin" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "zmin" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "xmax" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "ymax" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "zmax" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "box3dtobox" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geom_accum" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "combine_bbox" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "extent" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "collector" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "memcollect" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "collect_garray" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "collect" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_overleft" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_overright" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_left" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_right" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_contain" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_contained" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_overlap" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_same" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_lt" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_le" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_gt" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_ge" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_eq" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_cmp" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "force_2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "force_3d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "force_collection" already exists with same argument types
2005-12-21 16:46:34 ERROR:  operator >> already exists
2005-12-21 16:46:34 ERROR:  operator << already exists
2005-12-21 16:46:34 ERROR:  operator &> already exists
2005-12-21 16:46:34 ERROR:  operator &< already exists
2005-12-21 16:46:34 ERROR:  operator && already exists
2005-12-21 16:46:34 ERROR:  operator ~= already exists
2005-12-21 16:46:34 ERROR:  operator ~ already exists
2005-12-21 16:46:34 ERROR:  operator @ already exists
2005-12-21 16:46:34 ERROR:  operator > already exists
2005-12-21 16:46:34 ERROR:  operator >= already exists
2005-12-21 16:46:34 ERROR:  operator < already exists
2005-12-21 16:46:34 ERROR:  operator <= already exists
2005-12-21 16:46:34 ERROR:  operator = already exists
2005-12-21 16:46:34 ERROR:  function "intersection" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "buffer" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "convexhull" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "difference" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "boundary" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "symdifference" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "symmetricdifference" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geomunion" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "memgeomunion" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "unite_garray" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geomunion" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "relate" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "relate" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "disjoint" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "touches" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "intersects" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "crosses" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "within" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "contains" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "overlaps" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "isvalid" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geosnoop" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "simplify" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "line_interpolate_point" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "ggeometry_consistent" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "ggeometry_compress" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "rtree_decompress" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "gbox_penalty" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "gbox_picksplit" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "gbox_union" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "gbox_same" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_union" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_inter" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "geometry_size" already exists with same argument types
2005-12-21 16:46:34 ERROR:  operator class "gist_geometry_ops" for access method "gist" already exists
2005-12-21 16:46:34 ERROR:  operator class "btree_geometry_ops" for access method "btree" already exists
2005-12-21 16:46:34 ERROR:  cast from type public.geometry to type public.box3d already exists
2005-12-21 16:46:34 ERROR:  cast from type public.geometry to type box already exists
2005-12-21 16:46:34 ERROR:  cast from type public.box3d to type public.geometry already exists
2005-12-21 16:46:34 ERROR:  cast from type text to type public.geometry already exists
2005-12-21 16:46:34 ERROR:  cast from type public.wkb to type bytea already exists
2005-12-21 16:46:34 ERROR:  cast from type public.box3d to type box already exists
2005-12-21 16:46:34 ERROR:  cast from type public.geometry to type text already exists
2005-12-21 16:46:34 ERROR:  user "gg33" does not exist
2005-12-21 16:46:34 ERROR:  function "addgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "addgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "addgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrycolumn" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrytable" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrytable" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "dropgeometrytable" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "update_geometry_stats" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "update_geometry_stats" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "create_histogram2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "build_histogram2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "build_histogram2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "explode_histogram2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "estimate_histogram2d" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "assvg" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "assvg" already exists with same argument types
2005-12-21 16:46:34 ERROR:  function "assvg" already exists with same argument types
2005-12-21 16:46:34 ERROR:  user "gg11" does not exist
2005-12-21 16:46:35 ERROR:  user "gg11" does not exist
2005-12-21 16:46:35 ERROR:  user "gg33" does not exist
2005-12-21 16:46:35 ERROR:  user "gg11" does not exist
2005-12-21 16:46:35 ERROR:  user "gg33" does not exist
2005-12-21 16:46:36 ERROR:  user "gg26" does not exist
2005-12-21 16:46:36 ERROR:  user "gg33" does not exist
2005-12-21 16:46:36 ERROR:  column "attrelid" of relation "geometry_columns" does not exist
2005-12-21 16:46:36 ERROR:  user "gg11" does not exist
2005-12-21 16:46:36 ERROR:  user "gg33" does not exist
2005-12-21 16:46:37 ERROR:  user "gg26" does not exist
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_graphs_pkey" for table
"pga_graphs"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_layout_pkey" for table
"pga_layout"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_images_pkey" for table
"pga_images"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_queries_pkey" for table
"pga_queries"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_reports_pkey" for table
"pga_reports"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_forms_pkey" for table
"pga_forms"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_diagrams_pkey" for table
"pga_diagrams"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "pga_scripts_pkey" for table
"pga_scripts"
2005-12-21 16:46:37 ERROR:  user "gg33" does not exist
2005-12-21 16:46:37 ERROR:  multiple primary keys for table "spatial_ref_sys" are not allowed
2005-12-21 16:46:37 ERROR:  multiple primary keys for table "geometry_columns" are not allowed
2005-12-21 16:46:37 ERROR:  user "gg11" does not exist
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_typ_pkey" for table
"def_becken_typ"
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_ereignis_gruppe_pkey" for
table"def_ereignis_gruppe" 
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_flaechen_gruppe_pkey" for
table"def_flaechen_gruppe" 
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"def_flaechen_gruppe_variante_pkey"for table "def_flaechen_gruppe_variante" 
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_flaechen_szenario_pkey" for
table"def_flaechen_szenario" 
2005-12-21 16:46:37 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_knoten_typ_pkey" for table
"def_knoten_typ"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_kostra_niederschlag_pkey"
fortable "def_kostra_niederschlag" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_n_dauer_pkey" for table
"def_n_dauer"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_n_jaehrlichkeit_pkey" for
table"def_n_jaehrlichkeit" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_routing_szenario_pkey" for
table"def_routing_szenario" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_routing_verfahren_pkey" for
table"def_routing_verfahren" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ereignis_fläche_pkey" for table
"knoten_ereignis"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_flaeche_pkey" for table
"knoten_flaeche"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_pkey" for table "knoten"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_routing_pkey" for table
"knoten_routing"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_verbindung_pkey" for
table"knoten_verbindung" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "kostra_niederschlag_pkey" for
table"kostra_niederschlag" 
2005-12-21 16:46:38 ERROR:  user "gg33" does not exist
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_variante_pkey" for
table"def_becken_variante" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "knoten_becken_pkey" for table
"knoten_becken"
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "def_becken_layout_pkey" for
table"def_becken_layout" 
2005-12-21 16:46:38 NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "becken_varianten_pkey" for table
"becken_varianten"
2005-12-21 16:46:39 ERROR:  user "gg11" does not exist
2005-12-21 16:46:39 ERROR:  user "gg33" does not exist
2005-12-21 16:46:39 ERROR:  user "gg11" does not exist
2005-12-21 16:46:39 ERROR:  user "gg33" does not exist
2005-12-21 16:46:39 ERROR:  user "gg11" does not exist
2005-12-21 16:46:40 ERROR:  user "gg33" does not exist
2005-12-21 16:46:40 ERROR:  user "gg11" does not exist
2005-12-21 16:46:40 ERROR:  user "gg33" does not exist

В списке pgsql-novice по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: transfer database from Linux to Windows
Следующее
От: "Chandra Sekhar Surapaneni"
Дата:
Сообщение: Re: can not create trigger with parameter