zrhoffman commented on code in PR #6717: URL: https://github.com/apache/trafficcontrol/pull/6717#discussion_r864909118
########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN Review Comment: This should be `IF EXISTS (` ########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN + -- + -- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- + CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); Review Comment: This should be `CREATE INDEX IF NOT EXISTS` ########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN + -- + -- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- + CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +END IF; --- --- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'deliveryservice') THEN Review Comment: This should be `IF EXISTS (` ########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN + -- + -- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- + CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +END IF; --- --- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'deliveryservice') THEN + -- + -- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- -CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); + CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); Review Comment: This should be `CREATE INDEX IF NOT EXISTS` ########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN + -- + -- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- + CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +END IF; --- --- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'deliveryservice') THEN + -- + -- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- -CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); + CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); +END IF; --- --- Name: sslkey_version_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'version') THEN + -- + -- Name: sslkey_version_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- -CREATE INDEX sslkey_version_idx ON sslkey USING btree (version); + CREATE INDEX sslkey_version_idx ON sslkey USING btree (version); Review Comment: This should be `CREATE INDEX IF NOT EXISTS` ########## traffic_ops/app/db/trafficvault/create_tables.sql: ########## @@ -110,86 +110,102 @@ CREATE TABLE IF NOT EXISTS url_sig_key ( ALTER TABLE url_sig_key OWNER TO traffic_vault; --- --- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +DO $$ BEGIN +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'dnssec_pkey' AND table_name = 'dnssec') THEN + -- + -- Name: dnssec dnssec_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY dnssec - ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); + ALTER TABLE ONLY dnssec + ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn); +END IF; --- --- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'sslkey_pkey' AND table_name = 'sslkey') THEN + -- + -- Name: sslkey sslkey_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- -ALTER TABLE ONLY sslkey - ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); + ALTER TABLE ONLY sslkey + ADD CONSTRAINT sslkey_pkey PRIMARY KEY (deliveryservice, cdn, version); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'uri_signing_key_pkey' AND table_name = 'uri_signing_key') THEN + -- + -- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: uri_signing_key uri_signing_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY uri_signing_key - ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); + ALTER TABLE ONLY uri_signing_key + ADD CONSTRAINT uri_signing_key_pkey PRIMARY KEY (deliveryservice); +END IF; +IF NOT EXISTS (SELECT FROM information_schema.table_constraints WHERE constraint_name = 'url_sig_key_pkey' AND table_name = 'url_sig_key') THEN + -- + -- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault + -- --- --- Name: url_sig_key url_sig_key_pkey; Type: CONSTRAINT; Schema: public; Owner: traffic_vault --- - -ALTER TABLE ONLY url_sig_key - ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); - - --- --- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- + ALTER TABLE ONLY url_sig_key + ADD CONSTRAINT url_sig_key_pkey PRIMARY KEY (deliveryservice); +END IF; -CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'cdn') THEN + -- + -- Name: sslkey_cdn_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- + CREATE INDEX sslkey_cdn_idx ON sslkey USING btree (cdn); +END IF; --- --- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'deliveryservice') THEN + -- + -- Name: sslkey_deliveryservice_idx; Type: INDEX; Schema: public; Owner: traffic_vault + -- -CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); + CREATE INDEX sslkey_deliveryservice_idx ON sslkey USING btree (deliveryservice); +END IF; --- --- Name: sslkey_version_idx; Type: INDEX; Schema: public; Owner: traffic_vault --- +IF NOT EXISTS (SELECT FROM information_schema.columns WHERE table_name = 'sslkey' AND column_name = 'version') THEN Review Comment: This should be `IF EXISTS (` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
