Skip to content

Commit fe4f97d

Browse files
cboeckingcboecking
committed
updated sample table in postgres-convention - sample table - added call to changelog trigger
1 parent ccec59b commit fe4f97d

5 files changed

Lines changed: 14 additions & 5 deletions

File tree

‎ls/postgres-conventions.html‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -399,9 +399,12 @@ <h2 id="sample-table"><a class="header" href="#sample-table">Sample Table</a></h
399399
CREATE VIEW api.stk_changeme AS SELECT * FROM private.stk_changeme;
400400
COMMENT ON VIEW api.stk_changeme IS 'Holds changeme records';
401401

402-
----ignore in changelog
402+
----ignore in changelog - only uncomment if needed
403403
--insert into private.stk_change_log_exclude (table_name) values ('stk_changeme');
404404
--select private.stk_table_trigger_create();
405+
406+
-- create standard triggers just in case new tables created above
407+
select private.stk_table_trigger_create();
405408
</code></pre>
406409
<p>Note: the above created_by_uu and updated_by_uu will be uncommented when the stk_user_uu table is added to the stack.</p>
407410
<h2 id="scalability-considerations"><a class="header" href="#scalability-considerations">Scalability Considerations</a></h2>

‎ls/print.html‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1786,9 +1786,12 @@ <h2 id="sample-table"><a class="header" href="#sample-table">Sample Table</a></h
17861786
CREATE VIEW api.stk_changeme AS SELECT * FROM private.stk_changeme;
17871787
COMMENT ON VIEW api.stk_changeme IS 'Holds changeme records';
17881788

1789-
----ignore in changelog
1789+
----ignore in changelog - only uncomment if needed
17901790
--insert into private.stk_change_log_exclude (table_name) values ('stk_changeme');
17911791
--select private.stk_table_trigger_create();
1792+
1793+
-- create standard triggers just in case new tables created above
1794+
select private.stk_table_trigger_create();
17921795
</code></pre>
17931796
<p>Note: the above created_by_uu and updated_by_uu will be uncommented when the stk_user_uu table is added to the stack.</p>
17941797
<h2 id="scalability-considerations"><a class="header" href="#scalability-considerations">Scalability Considerations</a></h2>

‎ls/searchindex.js‎

Lines changed: 1 addition & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎ls/searchindex.json‎

Lines changed: 1 addition & 1 deletion
Large diffs are not rendered by default.

‎src-ls/postgres-conventions.md‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -256,9 +256,12 @@ COMMENT ON TABLE private.stk_changeme IS 'Holds changeme records';
256256
CREATE VIEW api.stk_changeme AS SELECT * FROM private.stk_changeme;
257257
COMMENT ON VIEW api.stk_changeme IS 'Holds changeme records';
258258

259-
----ignore in changelog
259+
----ignore in changelog - only uncomment if needed
260260
--insert into private.stk_change_log_exclude (table_name) values ('stk_changeme');
261261
--select private.stk_table_trigger_create();
262+
263+
-- create standard triggers just in case new tables created above
264+
select private.stk_table_trigger_create();
262265
```
263266

264267
Note: the above created_by_uu and updated_by_uu will be uncommented when the stk_user_uu table is added to the stack.

0 commit comments

Comments
 (0)