search

asyncee / fias2pgsql

Скрипты для импорта ФИАС в Postgresql
64 stars 21 forks source link

Ошибки в update_schema.sql #2

Closed gebv closed 5 years ago

gebv commented 5 years ago

Version - psql (10.5 (Debian 10.5-2.pgdg90+1))

Являются ли эти ошибки фатальными? Текущая реализация должна уметь искать по адрусу ФИАС? Например запрос по ФИАС 3e8d1508-25c9-4100-9608-fa1a085137ab выдает пустой результат

UPDATE 54395
psql:update_schema.sql:45: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET enddate = NULL WHERE enddate = '';
                                                            ^
psql:update_schema.sql:48: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET startdate = NULL WHERE startdate = '';
                                                                ^
UPDATE 247962
BEGIN

Весь лог сценария index.sh.

PGPASSWORD=fias PGPORT=5433 PGHOST=127.0.0.1 PGUSER=fias bash index.sh "fias"
_______________________НАЧИНАЮ ИМПОРТ ИЗ ФАЙЛОВ__________________
++++++++++++++++++ HELLO, DB = fias
++++++++++++++++++ SOCRBASE TABLE CREATED
BEGIN
SET
NOTICE:  table "socrbase" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ CHECKING ADDROBJ FILES
BEGIN
SET
NOTICE:  table "addrobj" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ INITIAL ADDROBJ TABLE CREATED
BEGIN
SET
NOTICE:  table "addrob02" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB02 CREATED
++++++++++++++++++ INSERT ADDROB02 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob03" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB03 CREATED
++++++++++++++++++ INSERT ADDROB03 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob04" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB04 CREATED
++++++++++++++++++ INSERT ADDROB04 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob05" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB05 CREATED
++++++++++++++++++ INSERT ADDROB05 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob06" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB06 CREATED
++++++++++++++++++ INSERT ADDROB06 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob07" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB07 CREATED
++++++++++++++++++ INSERT ADDROB07 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob08" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB08 CREATED
++++++++++++++++++ INSERT ADDROB08 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob09" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB09 CREATED
++++++++++++++++++ INSERT ADDROB09 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob10" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB10 CREATED
++++++++++++++++++ INSERT ADDROB10 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob11" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB11 CREATED
++++++++++++++++++ INSERT ADDROB11 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob12" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB12 CREATED
++++++++++++++++++ INSERT ADDROB12 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob13" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB13 CREATED
++++++++++++++++++ INSERT ADDROB13 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob14" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB14 CREATED
++++++++++++++++++ INSERT ADDROB14 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob15" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB15 CREATED
++++++++++++++++++ INSERT ADDROB15 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob16" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB16 CREATED
++++++++++++++++++ INSERT ADDROB16 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob17" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB17 CREATED
++++++++++++++++++ INSERT ADDROB17 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob18" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB18 CREATED
++++++++++++++++++ INSERT ADDROB18 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob19" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB19 CREATED
++++++++++++++++++ INSERT ADDROB19 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob20" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB20 CREATED
++++++++++++++++++ INSERT ADDROB20 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob21" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB21 CREATED
++++++++++++++++++ INSERT ADDROB21 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob22" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB22 CREATED
++++++++++++++++++ INSERT ADDROB22 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob23" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB23 CREATED
++++++++++++++++++ INSERT ADDROB23 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob24" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB24 CREATED
++++++++++++++++++ INSERT ADDROB24 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob25" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB25 CREATED
++++++++++++++++++ INSERT ADDROB25 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob26" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB26 CREATED
++++++++++++++++++ INSERT ADDROB26 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob27" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB27 CREATED
++++++++++++++++++ INSERT ADDROB27 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob28" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB28 CREATED
++++++++++++++++++ INSERT ADDROB28 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob29" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB29 CREATED
++++++++++++++++++ INSERT ADDROB29 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob30" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB30 CREATED
++++++++++++++++++ INSERT ADDROB30 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob31" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB31 CREATED
++++++++++++++++++ INSERT ADDROB31 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob32" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB32 CREATED
++++++++++++++++++ INSERT ADDROB32 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob33" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB33 CREATED
++++++++++++++++++ INSERT ADDROB33 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob34" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB34 CREATED
++++++++++++++++++ INSERT ADDROB34 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob35" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB35 CREATED
++++++++++++++++++ INSERT ADDROB35 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob36" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB36 CREATED
++++++++++++++++++ INSERT ADDROB36 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob37" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB37 CREATED
++++++++++++++++++ INSERT ADDROB37 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob38" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB38 CREATED
++++++++++++++++++ INSERT ADDROB38 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob39" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB39 CREATED
++++++++++++++++++ INSERT ADDROB39 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob40" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB40 CREATED
++++++++++++++++++ INSERT ADDROB40 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob41" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB41 CREATED
++++++++++++++++++ INSERT ADDROB41 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob42" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB42 CREATED
++++++++++++++++++ INSERT ADDROB42 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob43" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB43 CREATED
++++++++++++++++++ INSERT ADDROB43 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob44" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB44 CREATED
++++++++++++++++++ INSERT ADDROB44 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob45" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB45 CREATED
++++++++++++++++++ INSERT ADDROB45 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob46" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB46 CREATED
++++++++++++++++++ INSERT ADDROB46 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob47" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB47 CREATED
++++++++++++++++++ INSERT ADDROB47 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob48" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB48 CREATED
++++++++++++++++++ INSERT ADDROB48 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob49" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB49 CREATED
++++++++++++++++++ INSERT ADDROB49 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob50" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB50 CREATED
++++++++++++++++++ INSERT ADDROB50 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob51" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB51 CREATED
++++++++++++++++++ INSERT ADDROB51 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob52" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB52 CREATED
++++++++++++++++++ INSERT ADDROB52 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob53" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB53 CREATED
++++++++++++++++++ INSERT ADDROB53 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob54" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB54 CREATED
++++++++++++++++++ INSERT ADDROB54 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob55" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB55 CREATED
++++++++++++++++++ INSERT ADDROB55 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob56" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB56 CREATED
++++++++++++++++++ INSERT ADDROB56 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob57" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB57 CREATED
++++++++++++++++++ INSERT ADDROB57 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob58" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB58 CREATED
++++++++++++++++++ INSERT ADDROB58 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob59" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB59 CREATED
++++++++++++++++++ INSERT ADDROB59 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob60" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB60 CREATED
++++++++++++++++++ INSERT ADDROB60 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob61" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB61 CREATED
++++++++++++++++++ INSERT ADDROB61 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob62" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB62 CREATED
++++++++++++++++++ INSERT ADDROB62 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob63" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB63 CREATED
++++++++++++++++++ INSERT ADDROB63 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob64" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB64 CREATED
++++++++++++++++++ INSERT ADDROB64 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob65" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB65 CREATED
++++++++++++++++++ INSERT ADDROB65 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob66" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB66 CREATED
++++++++++++++++++ INSERT ADDROB66 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob67" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB67 CREATED
++++++++++++++++++ INSERT ADDROB67 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob68" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB68 CREATED
++++++++++++++++++ INSERT ADDROB68 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob69" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB69 CREATED
++++++++++++++++++ INSERT ADDROB69 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob70" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB70 CREATED
++++++++++++++++++ INSERT ADDROB70 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob71" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB71 CREATED
++++++++++++++++++ INSERT ADDROB71 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob72" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB72 CREATED
++++++++++++++++++ INSERT ADDROB72 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob73" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB73 CREATED
++++++++++++++++++ INSERT ADDROB73 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob74" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB74 CREATED
++++++++++++++++++ INSERT ADDROB74 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob75" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB75 CREATED
++++++++++++++++++ INSERT ADDROB75 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob76" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB76 CREATED
++++++++++++++++++ INSERT ADDROB76 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob77" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB77 CREATED
++++++++++++++++++ INSERT ADDROB77 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob78" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB78 CREATED
++++++++++++++++++ INSERT ADDROB78 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob79" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB79 CREATED
++++++++++++++++++ INSERT ADDROB79 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob83" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB83 CREATED
++++++++++++++++++ INSERT ADDROB83 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob86" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB86 CREATED
++++++++++++++++++ INSERT ADDROB86 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob87" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB87 CREATED
++++++++++++++++++ INSERT ADDROB87 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob89" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB89 CREATED
++++++++++++++++++ INSERT ADDROB89 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob91" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB91 CREATED
++++++++++++++++++ INSERT ADDROB91 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob92" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB92 CREATED
++++++++++++++++++ INSERT ADDROB92 DATA INTO ADDROBJ
DROP TABLE
BEGIN
SET
NOTICE:  table "addrob99" does not exist, skipping
DROP TABLE
SET
CREATE TABLE
COMMIT
++++++++++++++++++ TABLE ADDROB99 CREATED
++++++++++++++++++ INSERT ADDROB99 DATA INTO ADDROBJ
DROP TABLE
SKIPPING ADDROBJ
SKIPPING ADDROBJ
_______________________НАЧИНАЮ ОБНОВЛЕНИЕ СХЕМЫ__________________
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 408
ALTER TABLE
COMMIT
UPDATE 1405645
UPDATE 1413399
UPDATE 2139783
UPDATE 2128000
UPDATE 11819
UPDATE 11829
UPDATE 2530681
UPDATE 105
UPDATE 44840
UPDATE 54395
psql:update_schema.sql:45: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET enddate = NULL WHERE enddate = '';
                                                            ^
psql:update_schema.sql:48: ERROR:  invalid input syntax for type date: ""
СТРОКА 1: UPDATE addrobj SET startdate = NULL WHERE startdate = '';
                                                                ^
UPDATE 247962
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
BEGIN
ALTER TABLE
ALTER TABLE
UPDATE 3791568
ALTER TABLE
COMMIT
_______________________НАЧИНАЮ СОЗДАНИЕ ИНДЕКСОВ_________________
psql:indexes.sql:2: ERROR:  extension "pg_trgm" already exists
DELETE 2467296
ALTER TABLE
CREATE INDEX
CREATE INDEX
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
_______________________ _________ГОТОВО________ _________________
[root@142223 fias2pgsql]#
asyncee commented 5 years ago

К сожалению, на данный момент этот набор скриптов поддерживается только сообществом, последние изменения были в #1, поэтому предлагаю уточнить у @xlazex.

xlazex commented 5 years ago
  1. По фиас вы ищете по aoid или aoguid?
  2. да, по UPDATE ошибка в скриптах, это не критичная ошибка.

спасибо за отклик, проверю в своем форке (там были ещё изменения, возможно, проблема там уже решена)

gebv commented 5 years ago

@asyncee @xlazex Спасибо за быстрый ответ Да по обоим полям пробовал искать aoid, aoguid @xlazex ваш форк с мастера тоже пробовал развернуть, совсем ни чего не завелось сходу. Мастер не поломан? Либо может есть какие то нюансы которые следует знать при старте? Запускал так же bash index.sh

asyncee commented 5 years ago

@xlazex есть есть желание поддерживать форк на постоянной основе, могу добавить ссылку на него в readme, чтобы люди видели актуальный репозиторий.

Либо могу принимать PR.

xlazex commented 5 years ago
  1. @gebv Нюансы описаны в readme на мастере, там появились обязательные аргументы для запуска скрипта. Т.к. для своих целей я запускаю скрип на на localhost-е, поэтому необходимо указать параметры подключения для psql.
  2. @gebv А откуда такой идентификатор 3e8d1508-25c9-4100-9608-fa1a085137ab? У меня находится только дом по такому айдишнику (house_guid) Кемеровская обл, Кемерово г, Линия 1-я ул, дом 20Д.
  3. @gebv Также на мастере появилась возможность прогрузки таблицы houses, но пока что без PK.
  4. @gebv @asyncee Вообще планировал пересмотреть полностью и оптимизировать обNULLивание значений и еще несколько правок мелких внести. Но пока что у себя я вручную всё сделал, и не знаю, когда будет время заниматься репозиторием.
  5. @asyncee лучше через пул реквесты, считаю. Новые не создавал, т.к. моя реализация houses (на мастере) ещё не годится для применения в боевых условиях.
gebv commented 5 years ago

Кажется понял свою ошибку - детализация была не до домов. Да все верно именно этот дом и ожидал увидеть

PS @xlazex ошиблись username не @debv а @gebv. Deborah Venuti наверное сейчас думает что за хакеры из РФ на него ссылаются