search

JCKalt / General-Work

Modeling database
0 stars 0 forks source link

pgdb: Fix insert errors #145

Open JCKalt opened 7 months ago

JCKalt commented 7 months ago

current version of $(gg pgdb) sql/create-all-tables.sql at the end does these things...

psql:customer_site.sql:17: ERROR: integer out of range psql:customer_site.sql:18: ERROR: integer out of range psql:customer_site.sql:19: ERROR: insert or update on table "customer_site" violates foreign key constraint "customer_site_customer_id_fkey" DETAIL: Key (customer_id)=(Northlink_001) is not present in table "customer". psql:customer_site.sql:20: ERROR: insert or update on table "customer_site" violates foreign key constraint "customer_site_customer_id_fkey" DETAIL: Key (customer_id)=(PG002) is not present in table "customer". psql:customer_site.sql:21: ERROR: insert or update on table "customer_site" violates foreign key constraint "customer_site_customer_id_fkey" DETAIL: Key (customer_id)=(PG001) is not present in table "customer". psql:customer_site.sql:22: ERROR: insert or update on table "customer_site" violates foreign key constraint "customer_site_customer_id_fkey" DETAIL: Key (customer_id)=(PG001) is not present in table "customer". INSERT 0 1 psql:customer_site.sql:24: ERROR: invalid input syntax for type integer: "(+)302104190343" LINE 1: ...es Solutions', 'PG004', 'Captain Manolis Sarlis', '(+)302104... ^ CREATE TABLE CREATE INDEX CREATE INDEX psql:orders.sql:18: ERROR: invalid input syntax for type integer: "F001" LINE 1: ...der_due_date, order_terms) VALUES (1, null, null, 'F001', 'P... ^ psql:orders.sql:19: ERROR: invalid input syntax for type integer: "F002" LINE 1: ...der_due_date, order_terms) VALUES (2, null, null, 'F002', 'P... ^ psql:orders.sql:20: ERROR: invalid input syntax for type integer: "F003" LINE 1: ...der_due_date, order_terms) VALUES (3, null, null, 'F003', 'P... ^ psql:orders.sql:21: ERROR: invalid input syntax for type integer: "F004" LINE 1: ...der_due_date, order_terms) VALUES (4, null, null, 'F004', 'P... ^ psql:orders.sql:22: ERROR: invalid input syntax for type integer: "F005" LINE 1: ...der_due_date, order_terms) VALUES (5, null, null, 'F005', 'P... ^ psql:orders.sql:23: ERROR: insert or update on table "orders" violates foreign key constraint "orders_customer_id_fkey" DETAIL: Key (customer_id)=(PG004) is not present in table "customer". psql:orders.sql:24: ERROR: insert or update on table "orders" violates foreign key constraint "orders_customer_id_fkey" DETAIL: Key (customer_id)=(PG004) is not present in table "customer". psql:orders.sql:25: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10008, null, null, null). psql:orders.sql:26: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10009, null, null, null). psql:orders.sql:27: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10010, null, null, null). psql:orders.sql:28: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10011, null, null, null). psql:orders.sql:29: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10012, null, null, null). psql:orders.sql:30: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10013, null, null, null). psql:orders.sql:31: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10014, null, null, null). psql:orders.sql:32: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10015, null, null, null). psql:orders.sql:33: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10016, null, null, null). psql:orders.sql:34: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10017, null, null, null). psql:orders.sql:35: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10018, null, null, null). psql:orders.sql:36: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10019, null, null, null). psql:orders.sql:37: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10020, null, null, null). psql:orders.sql:38: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10021, null, null, null). psql:orders.sql:39: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10022, null, null, null). psql:orders.sql:40: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10023, null, null, null). psql:orders.sql:41: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10024, null, null, null). psql:orders.sql:42: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10025, null, null, null). psql:orders.sql:43: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10026, null, null, null). psql:orders.sql:44: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10027, null, null, null). psql:orders.sql:45: ERROR: null value in column "purchase_order_number" of relation "orders" violates not-null constraint DETAIL: Failing row contains (null, null, null, null, null, null, 10028, null, null, null). CREATE TABLE psql:order_data.sql:13: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:14: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:15: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:16: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:17: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:18: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10001) is not present in table "orders". psql:order_data.sql:19: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10002) is not present in table "orders". psql:order_data.sql:20: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10002) is not present in table "orders". psql:order_data.sql:21: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10002) is not present in table "orders". psql:order_data.sql:22: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10002) is not present in table "orders". psql:order_data.sql:23: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10003) is not present in table "orders". psql:order_data.sql:24: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10003) is not present in table "orders". psql:order_data.sql:25: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10004) is not present in table "orders". psql:order_data.sql:26: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10004) is not present in table "orders". psql:order_data.sql:27: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10004) is not present in table "orders". psql:order_data.sql:28: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10004) is not present in table "orders". psql:order_data.sql:29: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10005) is not present in table "orders". psql:order_data.sql:30: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10006) is not present in table "orders". psql:order_data.sql:31: ERROR: insert or update on table "order_data" violates foreign key constraint "order_data_order_data_id_fkey" DETAIL: Key (order_data_id)=(10007) is not present in table "orders". CREATE TABLE CREATE TABLE psql:prospect.sql:21: ERROR: insert or update on table "prospect" violates foreign key constraint "prospect_region_fkey" DETAIL: Key (region)=(Japan) is not present in table "region". psql:prospect.sql:22: ERROR: syntax error at or near "s" LINE 1: ...rity, notes, potential_deal_size) VALUES ('Domino's Pizza_ID... ^ psql:prospect.sql:23: ERROR: insert or update on table "prospect" violates foreign key constraint "prospect_region_fkey" DETAIL: Key (region)=(United States) is not present in table "region". psql:prospect.sql:24: ERROR: syntax error at or near "s" LINE 1: ...iority, notes, potential_deal_size) VALUES ('Dick's Sporting... ^ psql:prospect.sql:25: ERROR: insert or update on table "prospect" violates foreign key constraint "prospect_region_fkey" DETAIL: Key (region)=(United States) is not present in table "region". psql:prospect.sql:26: ERROR: insert or update on table "prospect" violates foreign key constraint "prospect_region_fkey" DETAIL: Key (region)=(United States) is not present in table "region". CREATE TABLE

JCKalt commented 7 months ago

problem #1. Customer_site.phonenumber s/b varchar not integer