-
Notifications
You must be signed in to change notification settings - Fork 54
/
Copy pathpostgresql17-plpgsql_check.spec
182 lines (134 loc) · 6.2 KB
/
postgresql17-plpgsql_check.spec
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
%global pgmajorversion 17
%global pginstdir /usr/pgsql-17
%global sname plpgsql_check
Name: %{sname}_%{pgmajorversion}
Version: 2.8.0
Release: 1%{?dist}
Summary: Additional tools for plpgsql functions validation
Group: Applications/Databases
License: BSD
URL: https://github.com/okbob/plpgsql_check/archive/v%{version}.zip
Source0: plpgsql_check-%{version}.zip
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
BuildRequires: postgresql%{pgmajorversion}-devel
Requires: postgresql%{pgmajorversion}
%description
The plpgsql_check is PostgreSQL extension with functionality for direct
or indirect extra validation of functions in plpgsql language. It verifies
a validity of SQL identifiers used in plpgsql code. It try to identify
a performance issues.
%prep
%setup -q -n %{sname}-%{version}
%build
PATH="%{pginstdir}/bin;$PATH" ; export PATH
CFLAGS="${CFLAGS:-%optflags}" ; export CFLAGS
make USE_PGXS=1 PG_CONFIG=%{pginstdir}/bin/pg_config %{?_smp_mflags}
%install
rm -rf %{buildroot}
make install DESTDIR=%{buildroot} PG_CONFIG=%{pginstdir}/bin/pg_config %{?_smp_mflags}
%clean
rm -rf %{buildroot}
%files
%defattr(644,root,root,755)
%doc README.md
%{pginstdir}/lib/plpgsql_check.so
%{pginstdir}/share/extension/plpgsql_check--2.1.sql
%{pginstdir}/share/extension/plpgsql_check.control
%{pginstdir}/lib/bitcode/*.bc
%{pginstdir}/lib/bitcode/plpgsql_check/src/*.bc
%{pginstdir}/share/extension/*.control
%changelog
* Tue Mar 18 2025 - Pavel Stehule <[email protected]> 2.8.0
- remove support for PostgreSQL 12 and 13
* Wed Dec 6 2023 - Pavel Stehule <[email protected]> 2.7.0
- unclosed cursors detection
* Tue Oct 31 2023 - Pavel Stehule <[email protected]> 2.6.0
- simple constant tracing support
* Sat Apr 29 2023 - Pavel Stehule <[email protected]> 2.4.0
- remove support for PostgreSQL 10 and 11
* Wed Jan 11 2023 - Pavel Stehule <[email protected]> 2.3.0
- possibility to detect compatibility issues (obsolete setting of refcursor)
* Tue Sep 20 2022 - Pavel Stehule <[email protected]> 2.2.0
- possibility to use in comment options
* Wed Dec 29 2021 - Pavel Stehule <[email protected]> 2.1.0
- possibility to count statement's aborted execution
- possibility to count "unfinished" statements due exception
* Mon Sep 27 2021 - Pavel Stehule <[email protected]> 2.0.0
- pragma type for setting type to record variable
- pragma table for creating ephemeral table
* Mon Jun 21 2021 - Pavel Stehule <[email protected]> 1.17.0
- remove support for PostgreSQL 9.5 and 9.6
* Sat Mar 6 2021 - Pavel Stehule <[email protected]> 1.16.0
- plpgsql_profiler_functions_all
* Mon Nov 16 2020 - Pavel Stehule <[email protected]> 1.14.0
- queryid can be displayed in profiler's reports (Julien Rouhaud)
- new profiler's GUC plpgsql_check.profiler_max_shared_chunks (Julien Rouhaud)
- few minor bugfixes
* Fri Aug 14 2020 - Pavel Stehule <[email protected]> 1.13.0
- tracer
- pragma support to control checks, warnings and tracing
* Thu Jul 2 2020 - Pavel STEHULE <[email protected]> 1.11.0
- possibility to check functions with arguments of polymorphic type
- possibility to specify type used as real type instead polymorphic type
* Fri Jun 05 2020 - Pavel STEHULE <[email protected]> 1.10.0
- deduction record type structure from result of polymorphic function
* Mon Apr 27 2020 - Pavel STEHULE <[email protected]> 1.9.1
- minor bugfixes
* Mon Mar 30 2020 - Pavel STEHULE <[email protected]> 1.9.0
- statement and branch coverage metrics
- remove support for Postgres 9.4
* Mon Jan 06 2020 - Pavel STEHULE <[email protected]> 1.8.2
- fix of compilation issue
* Sun Jan 05 2020 - Pavel STEHULE <[email protected]> 1.8.1
- cleaner detection function oid from name or signature
* Sun Dec 29 2019 - Pavel STEHULE <[email protected]> 1.8.0
- use Postgres tool for calling functions from plpgsql library instead dynamic linking
- it solve issues related to dependency plpgsq_check on plpgsql
* Mon Sep 23 2019 - Pavel STEHULE <[email protected]> 1.7.6
- fix false alarm - multiple plans in EXECUTE statement, and possible crash
* Tue Sep 10 2019 - Pavel STEHULE <[email protected]> 1.7.5
- allow some work on tables with rules
* Wed Jul 24 2019 - Pavel STEHULE <[email protected]> 1.7.3
- profiler bugfixes
* Tue May 21 2019 - Pavel STEHULE <[email protected]> 1.7.2
- profiler bugfixes
* Fri Apr 26 2019 - Pavel STEHULE <[email protected]> 1.7.1
- bugfixes
* Wed Apr 17 2019 - Pavel STEHULE <[email protected]> 1.7.0
- check of format of fmt string of "format" function
- better check of dynamic SQL when it is const string
- check of SQL injection vulnerability of stmt expression at EXECUTE stmt
* Sun Dec 23 2018 - Pavel STEHULE <[email protected]> 1.4.2-1
- metada fix
* Fri Dec 21 2018 - Pavel STEHULE <[email protected]> 1.4.1-1
- minor bugfixes
* Sun Dec 2 2018 - Pavel STEHULE <[email protected]> 1.4.0-1
- possible to show function's dependency on functions and tables
- integrated profiler
- bug fixes (almost false alarms)
* Wed Jun 6 2018 - Pavel STEHULE <[email protected]> 1.2.3-1
- PostgreSQL 11 support
- detect hidden casts in expressions
* Thu Oct 26 2017 - Pavel STEHULE <[email protected]> 1.2.2-1
- never read variables detection
- fix false alarm on MOVE command
* Fri Sep 15 2017 - Pavel STEHULE <[email protected]> 1.2.1-1
- missing RETURN detection
- fix some bugs and false alarms
- PostgreSQL 11 support
* Fri Nov 11 2016 - Pavel STEHULE <[email protected]> 1.2.0-1
- support extra warnings - shadowed variables
* Thu Aug 25 2016 - Pavel STEHULE <[email protected]> 1.0.5-1
- minor fixes, support for PostgreSQL 10
* Fri Apr 15 2016 - Pavel STEHULE <[email protected]> 1.0.4-1
- support for PostgreSQL 9.6
* Mon Oct 12 2015 - Pavel STEHULE <[email protected]> 1.0.3-1
- fix false alarms of unused cursor variables
- fix regress tests
* Thu Jul 09 2015 - Pavel STEHULE <[email protected]> 1.0.2-2
- bugfix release
* Fri Dec 19 2014 - Pavel STEHULE <[email protected]> 0.9.3-1
- fix a broken record field type checking
- add check for assign to array field
* Mon Aug 25 2014 - Pavel STEHULE <[email protected]> 0.9.1-1
- Initial packaging