pgAudit 1.1.3 (upcoming) commit log

Add PostgreSQL 12/13 versions and update URLs.

commit   : 766c773e9329c98ebf993ccc3b022cbc6866848a    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 09:59:23 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 09:59:23 -0400    

Click here for diff

M README.md

Fix "pgaudit stack is not empty" error.

commit   : 83333e2c166e3ba03f24a0f99d47d8d024b494a0    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 08:40:32 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 08:40:32 -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

commit   : 7657139e6aabc70f2661e7e0cacaa85f6994957e    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:23:15 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:23:15 -0400    

Click here for diff

M pgaudit.c

Add *.bc to .gitignore.

commit   : e529e48ef43f73c17ea431976718f61986b53864    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:09:58 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:09:58 -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   : 8315d095672a82b0b22bddc269c5a0325455b866    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 07:59:53 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 07:59:53 -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   : 51f85979cec81a03ae3c22c121195aa85f53ae3b    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 17 Jun 2020 14:49:51 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 17 Jun 2020 14:49:51 -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   : 7f66b9ee8994f7c09d63594b5ef65864415e652e    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 14:20:32 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 14:20:32 -0400    

Click here for diff

M pgaudit.c