Background Adding pretty much static data into a table and opted to use an identity column as a primary key. Noticed Noticed an inconsequential difference between the documentation and my experience. SQL DDL DML Output Here are the screenshots. Output - Initial load Output - Consequent Load Explanation The first time we loaded data, we … Continue reading Transact SQL :- Resetting Identity Value Using “DBCC CHECKIDENT”
Technical
Postgresql :- Error – “relation … is not a btree index”
Background Reviewing PostgreSQL metadata and ran into a tiny error. Error The error reads ... Text Image Premise PostgreSQL supports a variety of index types. Among supported index types are B-tree and fulltext ( Gin and Gist ). Remediation Outline Because the set of operations supported by an Index Type may vary, it is best … Continue reading Postgresql :- Error – “relation … is not a btree index”
PostgreSQL – Repair Application Binaries
Background Working from the console and not careful, it is not so hard to make stupid mistakes. Scenario Yesterday while trying to export and import files, I made a freshman mistake. To export data, I issued this command pg_dumpall > datafile Conversely, to import data, issued this command pg_dumpall < datafile Significance Directing datafile to … Continue reading PostgreSQL – Repair Application Binaries
PostgreSQL – v12 – Importing data from previous version
Background Let us import data from PostgreSQL Version 11 into Version 12. Lineage PostgreSQL – v12 – Installation/Upgrade on MS Windows Link Outline Previous Instance Start previous Instance Export Data Options pg_dumpall Using pg_dumpall, export data Stop previous Instance New Instance Start new Instance Import Data Options psql Using psql, import data Review imported … Continue reading PostgreSQL – v12 – Importing data from previous version
PostgreSQL – v12 – Installation/Upgrade on MS Windows
Background PostgreSQL Version 12 was released On October 3rd, 2019. That is about two weeks ago. Since then I have wanted to upgrade our Development instance from Version 11 to Version 12. Release Notes A brief summary of the Release Notes are available here. Installation Outline Here are the steps we will take :- … Continue reading PostgreSQL – v12 – Installation/Upgrade on MS Windows
Spritual Conviction
Background There is an area that I have wanted to cover and revisit for a while here. It is more than a desire, it is a conviction, a burden, that God laid on me. Current Affairs Again, watch too much youtube videos. Whether it is Paternity Court, Divorce Court, and so on. One can … Continue reading Spritual Conviction
PostgreSQL – Table Value Constructor
Background Part of a DBA's workload is to engage the Developers Community and make sure that SQL Changes are streamline and easy to review and deploy. Adding Data Recently we needed to add about one hundred records to a single table. Table Value Constructor Thankfully SQL 92 thought quite a bit ahead and recommends support … Continue reading PostgreSQL – Table Value Constructor
