pgAudit 1.0.8 commit log

by Yogesh Sharma
pgAudit
CommitLog

Stamp 1.0.8.

commit   : 634911bec73872ef8f1c8cb04ca55419c56de3ae    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 5 Oct 2020 17:09:16 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 5 Oct 2020 17:09:16 -0400

Click here for diff

M Makefile
A pgaudit–1.0.7–1.0.8.sql
R094 pgaudit–1.0.7.sql pgaudit–1.0.8.sql
M pgaudit.control

Add PostgreSQL 12/13 versions and update URLs.

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

Click here for diff

M README.md

Fix "pgaudit stack is not empty" error.

commit   : 859700d93a4f18a80de8c1ac893536b58c006f50    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 08:42:36 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 9 Sep 2020 08:42:36 -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   : 593c71f30a878127f0a8eae77a6a3cef36457bab    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:23:30 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:23:30 -0400

Click here for diff

M pgaudit.c

Add *.bc to .gitignore.

commit   : 0e3eb55aa08ef2cebfe2db14baf2130467bb9eaf    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:10:12 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:10:12 -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   : 6a3df3867c0009b86d3a0fcc6846207ddc5b774e    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:04:26 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 18 Jun 2020 08:04:26 -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   : 0c177eecdac09dc5cad35dac2273d357979b9ab7    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 17 Jun 2020 14:53:00 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 17 Jun 2020 14:53:00 -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   : 14dbf8814e92487184e5923fba87abac4cfde44b    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 14:20:56 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 14:20:56 -0400

Click here for diff

M pgaudit.c