Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL State : 42703
- Error Code : 0
- Message : ERROR: column "ELEVATOR_CAR_TRIM" does NOT exist
- WHERE: PL/pgSQL FUNCTION inline_code_block line 17 AT FOR over EXECUTE statement
- Location : db/migration/V2020.07.06.14.00__add_new_options_fields.SQL (C:\git\elevators\elevator-toolbox\persistence\target\classes\db\migration\V2020.07.06.14.00__add_new_options_fields.SQL)
- Line : 9
- Statement : DO
- $$
- <<first_block>>
- DECLARE
- mirror_size_field_id bigint;
- dowels_count_field_id bigint;
- spec_iter1 int;
- spec_iter2 int;
- rec RECORD;
- ff_query text;
- BEGIN
- SELECT id INTO mirror_size_field_id FROM field WHERE name = 'mirror_size';
- SELECT id INTO dowels_count_field_id FROM field WHERE name = 'dowels_count';
- ff_query := 'select id from filled_form where form_id = "ELEVATOR_CAR_TRIM"';
- FOR rec IN EXECUTE ff_query USING spec_iter1
- LOOP
- INSERT INTO filled_field (field_id, filled_form_id, VALUE, created)
- VALUES (mirror_size_field_id, rec.id, NULL, CURRENT_TIMESTAMP);
- END LOOP;
- ff_query := 'select id from filled_form where form_id = "OPTIONS"';
- FOR rec IN EXECUTE ff_query USING spec_iter2
- LOOP
- INSERT INTO filled_field (field_id, filled_form_id, VALUE, created)
- VALUES (dowels_count_field_id, rec.id, NULL, CURRENT_TIMESTAMP);
- END LOOP;
- END first_block
- $$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement