pgAudit 1.2.2 commit log

Stamp 1.2.2.

commit   : 8178fc31cf758ccec7c1c9f7c21d1f6f41a4753b    
  
author   : David Steele <[email protected]>    
date     : Mon, 5 Oct 2020 15:57:06 -0400    
  
committer: David Steele <[email protected]>    
date     : Mon, 5 Oct 2020 15:57:06 -0400    

Click here for diff

M Makefile
A pgaudit–1.2.1–1.2.2.sql
R094 pgaudit–1.2.1.sql pgaudit–1.2.2.sql
M pgaudit.control

Add PostgreSQL 12/13 versions and update URLs.

commit   : 33121cd796d4538e1690439f6ec5b6a3e4445d67    
  
author   : David Steele <[email protected]>    
date     : Wed, 9 Sep 2020 09:57:54 -0400    
  
committer: David Steele <[email protected]>    
date     : Wed, 9 Sep 2020 09:57:54 -0400    

Click here for diff

M README.md

Fix "pgaudit stack is not empty" error.

commit   : c9b745a64eab5dadb6aabfeb1d9525a28d8a8096    
  
author   : David Steele <[email protected]>    
date     : Wed, 9 Sep 2020 08:34:54 -0400    
  
committer: David Steele <[email protected]>    
date     : Wed, 9 Sep 2020 08:34:54 -0400    

Click here for diff

Select, show, and explain cursors are not freed until they are closed, so they are left on the stack between calls to the backend. The assertion to make sure the stack was empty on each call did not expect to see them and threw an error.  
  
Allow select, show, and explain cursors on the stack between calls to handle this case.  
  
Also log and remove close statements from the stack immediately so they are logged correctly.  
  
Reported by @Giak79, @HesusFTW, @laurenz (Laurenz Albe), @svb007, @dylrich (Dylan Richardson)  
Tested by @yugo-n (Yugo Nagata)  

M expected/pgaudit.out
M pgaudit.c
M sql/pgaudit.sql

Fix misclassification of partitioned tables.

commit   : 62cd995e0207e4c7dc5f26fb0629be61bddb726e    
  
author   : gaoxueyu <[email protected]>    
date     : Tue, 21 Jul 2020 13:43:19 -0400    
  
committer: David Steele <[email protected]>    
date     : Tue, 21 Jul 2020 13:43:19 -0400    

Click here for diff

Partitioned tables were being classified as UNKNOWN but they should be classified as TABLE.  

M expected/pgaudit.out
M pgaudit.c
M sql/pgaudit.sql

commit   : 93bd45d1822516db627e3c0c88c8f3eba0f59187    
  
author   : David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 08:22:17 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 08:22:17 -0400    

Click here for diff

M pgaudit.c

Add *.bc to .gitignore.

commit   : e3ca409aba3594b0f0101c7c932ab78d35d8e3b2    
  
author   : David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 08:09:08 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 08:09:08 -0400    

Click here for diff

This exclusion is not needed in our current test environment but may be needed in other environments. It also prevents *.bc files from appearing during branch changes.  

M .gitignore

Use syscache to get relation namespace/name.

commit   : c31972eae64423025596f74e1a00104efa288244    
  
author   : David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 07:58:05 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 18 Jun 2020 07:58:05 -0400    

Click here for diff

The prior method of opening the relation with NoLock failed during assert builds.  
  
Using the syscache allows us to get the namespace/name without calling relation_open(). Since the syscache calls are performed after permissions have been checked it should not be possible to have a cache miss.  
  
Found by @rykp.  
Reviewed by Joe Conway (@jconway), Stephen Frost (@sfrost).  

M pgaudit.c

Use more common types for create conversion.

commit   : 63ea6fc04b2a6fbde47d9e766b83d04492a262cd    
  
author   : David Steele <[email protected]>    
date     : Wed, 17 Jun 2020 14:39:07 -0400    
  
committer: David Steele <[email protected]>    
date     : Wed, 17 Jun 2020 14:39:07 -0400    

Click here for diff

These types are available across all versions and forks of PostgreSQL and are not likely to go away anytime soon.  

M expected/pgaudit.out
M sql/pgaudit.sql

commit   : 96b86ae6fa5095b97d055e1271417c8221a7d1f4    
  
author   : David Steele <[email protected]>    
date     : Thu, 23 May 2019 14:20:11 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 23 May 2019 14:20:11 -0400    

Click here for diff

M pgaudit.c