Groups
Groups
Sign in
Groups
Groups
pgTAP Users
Conversations
About
Send feedback
Help
pgTAP Users
Contact owners and managers
1–30 of 50
Mark all as read
Report group
0 selected
kevin
, …
Logan Grosz
3
Aug 21
check constraint names
Just wanted to chime in and say I was looking for this feature last week. I'd use such a thing. I
unread,
check constraint names
Just wanted to chime in and say I was looking for this feature last week. I'd use such a thing. I
Aug 21
Matt DeLuco
, …
David E. Wheeler
13
Aug 17
pgtap and sqitch - recommended test style
On Aug 16, 2025, at 15:34, kevin <kbra...@pwhome.com> wrote: > I'm willing to donate
unread,
pgtap and sqitch - recommended test style
On Aug 16, 2025, at 15:34, kevin <kbra...@pwhome.com> wrote: > I'm willing to donate
Aug 17
Matt DeLuco
,
David E. Wheeler
4
Aug 12
Using functions and variables with pg_prove scripts
On Aug 11, 2025, at 23:42, 'Matt DeLuco' via pgTAP Users <pgtap...@googlegroups.com>
unread,
Using functions and variables with pg_prove scripts
On Aug 11, 2025, at 23:42, 'Matt DeLuco' via pgTAP Users <pgtap...@googlegroups.com>
Aug 12
David E. Wheeler
Mar 14
Re: [pgtap-users] questions about user impersonization
On Feb 24, 2025, at 06:18, Point Lamont <point...@gmail.com> wrote: > I was wondering on
unread,
Re: [pgtap-users] questions about user impersonization
On Feb 24, 2025, at 06:18, Point Lamont <point...@gmail.com> wrote: > I was wondering on
Mar 14
kevin
,
David E. Wheeler
2
Mar 14
function_returns questions
On Feb 4, 2025, at 12:19, kevin <kbra...@pwhome.com> wrote: > Hi, Hello, and apologies for
unread,
function_returns questions
On Feb 4, 2025, at 12:19, kevin <kbra...@pwhome.com> wrote: > Hi, Hello, and apologies for
Mar 14
Logan Grosz
,
David E. Wheeler
3
11/28/24
Request for review of my pgTAP test
Hi, David I appreciate the response! Dion't forget `fk_ok()`, so you can test that it references
unread,
Request for review of my pgTAP test
Hi, David I appreciate the response! Dion't forget `fk_ok()`, so you can test that it references
11/28/24
Jens Troeger
, …
kevin
4
11/21/24
Ordering or sorting tests
On 11/17/24 13:21, David E. Wheeler wrote: > On Nov 2, 2024, at 11:04, Jens Troeger <jens.
unread,
Ordering or sorting tests
On 11/17/24 13:21, David E. Wheeler wrote: > On Nov 2, 2024, at 11:04, Jens Troeger <jens.
11/21/24
Matthew Hoopes
,
David E. Wheeler
5
9/29/24
storing an inserted record as a variable within a test
On Sep 28, 2024, at 20:41, Matthew Hoopes <matthew...@gmail.com> wrote: > RETURN QUERY
unread,
storing an inserted record as a variable within a test
On Sep 28, 2024, at 20:41, Matthew Hoopes <matthew...@gmail.com> wrote: > RETURN QUERY
9/29/24
kevin
7/31/24
new test idea: column_is
Has anyone considered doing a test like: column_is(:schema, :table, :column, :type, :nullable, :
unread,
new test idea: column_is
Has anyone considered doing a test like: column_is(:schema, :table, :column, :type, :nullable, :
7/31/24
mgs
,
David E. Wheeler
2
7/23/24
tests for procedures(not function) having transaction block in it(like commit)
On Jul 23, 2024, at 01:33, mgs <mgs2...@gmail.com> wrote: > is there a way to write tests
unread,
tests for procedures(not function) having transaction block in it(like commit)
On Jul 23, 2024, at 01:33, mgs <mgs2...@gmail.com> wrote: > is there a way to write tests
7/23/24
kevin
,
David E. Wheeler
4
9/25/23
identity work around [was: pgtap identity error]
On Sep 25, 2023, at 11:50, kevin <kbra...@pwhome.com> wrote: > I think we should ignore the
unread,
identity work around [was: pgtap identity error]
On Sep 25, 2023, at 11:50, kevin <kbra...@pwhome.com> wrote: > I think we should ignore the
9/25/23
kevin
, …
David E. Wheeler
12
9/8/23
Fwd: pgtap identity error
Well, it's 2'ish years later and I've moved onto another job, but I just ran into this
unread,
Fwd: pgtap identity error
Well, it's 2'ish years later and I've moved onto another job, but I just ran into this
9/8/23
kevin
3/28/23
CURRENT_TIMESTAMP is different between versions
I'm finding that CURRENT_TIMESTAMP is treated differently between PG v13 & v14. You can see
unread,
CURRENT_TIMESTAMP is different between versions
I'm finding that CURRENT_TIMESTAMP is treated differently between PG v13 & v14. You can see
3/28/23
Robert L. Kirby
,
David E. Wheeler
6
12/28/22
make test fails "myType"
On Dec 25, 2022, at 13:20, Robert L. Kirby <kirb...@gmail.com> wrote: > I'm surprised
unread,
make test fails "myType"
On Dec 25, 2022, at 13:20, Robert L. Kirby <kirb...@gmail.com> wrote: > I'm surprised
12/28/22
Robert L. Kirby
,
David E. Wheeler
4
12/18/22
Perl for new PostgreSQL and pgTAP
On Dec 17, 2022, at 18:37, Robert L. Kirby <kirb...@gmail.com> wrote: > In order to build
unread,
Perl for new PostgreSQL and pgTAP
On Dec 17, 2022, at 18:37, Robert L. Kirby <kirb...@gmail.com> wrote: > In order to build
12/18/22
Alejandro Imass
, …
David E. Wheeler
5
11/28/22
Newbie question on lives_ok()
Thank you ! NVL what I am testing is that a trigger updated a field. Best, -- Alex On Sun, Nov 27,
unread,
Newbie question on lives_ok()
Thank you ! NVL what I am testing is that a trigger updated a field. Best, -- Alex On Sun, Nov 27,
11/28/22
JedW ICD
, …
Robert L. Kirby
9
7/15/22
Testing set_eq on function that returns type table
As above I finally figured out a way to make the results of the function table return look like a
unread,
Testing set_eq on function that returns type table
As above I finally figured out a way to make the results of the function table return look like a
7/15/22
Rory Campbell-Lange
,
David E. Wheeler
5
2/27/22
Use psql variables for "want" values?
On Feb 26, 2022, at 14:38, Rory Campbell-Lange <ro...@campbell-lange.net> wrote: > Is there a
unread,
Use psql variables for "want" values?
On Feb 26, 2022, at 14:38, Rory Campbell-Lange <ro...@campbell-lange.net> wrote: > Is there a
2/27/22
Sagar Pachore
,
David E. Wheeler
2
1/25/22
can we generate report from pgTAP for test results
On Jan 25, 2022, at 00:04, Sagar Pachore <sagar....@thinkitive.com> wrote: > how to
unread,
can we generate report from pgTAP for test results
On Jan 25, 2022, at 00:04, Sagar Pachore <sagar....@thinkitive.com> wrote: > how to
1/25/22
Sagar Pachore
,
David E. Wheeler
6
1/12/22
to test function in postgres
On Jan 12, 2022, at 01:37, Sagar Pachore <sagar....@thinkitive.com> wrote: > begin; >
unread,
to test function in postgres
On Jan 12, 2022, at 01:37, Sagar Pachore <sagar....@thinkitive.com> wrote: > begin; >
1/12/22
Stefan Chipilov
,
David E. Wheeler
2
1/9/22
Rollback of startup functions
On Jan 9, 2022, at 09:12, Stefan Chipilov <chip...@gmail.com> wrote: > > Is there a way
unread,
Rollback of startup functions
On Jan 9, 2022, at 09:12, Stefan Chipilov <chip...@gmail.com> wrote: > > Is there a way
1/9/22
Sagar Pachore
,
David E. Wheeler
2
1/8/22
Check upsert function is insert the data or update
On Jan 6, 2022, at 02:14, Sagar Pachore <sagar....@thinkitive.com> wrote: > Check upsert
unread,
Check upsert function is insert the data or update
On Jan 6, 2022, at 02:14, Sagar Pachore <sagar....@thinkitive.com> wrote: > Check upsert
1/8/22
Stefan Chipilov
, …
Nasby, Jim
10
1/7/22
Associate setup/startup functions with particular tests
Thanks for sharing this approach, Jim. To be honest, I am not very familiar with some of the details
unread,
Associate setup/startup functions with particular tests
Thanks for sharing this approach, Jim. To be honest, I am not very familiar with some of the details
1/7/22
JedW ICD
,
David E. Wheeler
15
12/1/21
Install issues with create extensions and installcheck
On Dec 1, 2021, at 12:54, Jed Walker <jed.w...@icd-tech.com> wrote: > I really appreciate
unread,
Install issues with create extensions and installcheck
On Dec 1, 2021, at 12:54, Jed Walker <jed.w...@icd-tech.com> wrote: > I really appreciate
12/1/21
Yauheni Tsiarokhin
,
David E. Wheeler
2
10/26/21
tests with do-end blocks
On Oct 26, 2021, at 09:53, Yauheni Tsiarokhin <hihih...@gmail.com> wrote: > begin; > do
unread,
tests with do-end blocks
On Oct 26, 2021, at 09:53, Yauheni Tsiarokhin <hihih...@gmail.com> wrote: > begin; > do
10/26/21
Landon Boyd
,
David E. Wheeler
2
8/7/21
Comparing row type to null on PG12
On Aug 6, 2021, at 20:46, Landon Boyd <lan...@withreach.com> wrote: > Output on PG12: >
unread,
Comparing row type to null on PG12
On Aug 6, 2021, at 20:46, Landon Boyd <lan...@withreach.com> wrote: > Output on PG12: >
8/7/21
said
2
6/17/21
col_is_unique failing
Please disregard this issue. It was a similar issue that was failing... Sorry for the inconvenience.
unread,
col_is_unique failing
Please disregard this issue. It was a similar issue that was failing... Sorry for the inconvenience.
6/17/21
Curtis Bradley
6/8/21
Stored Procedure inout parameter value not being set
== pgTAP -- The follow runs but fails. \set payload '\'{"foo":"bar"}\
unread,
Stored Procedure inout parameter value not being set
== pgTAP -- The follow runs but fails. \set payload '\'{"foo":"bar"}\
6/8/21
Mitch
, …
Nasby, Jim
4
5/20/21
Trying to reset primary keys
A key concept with pgTap is to avoid testing that Postgres itself works. In this case, you're in
unread,
Trying to reset primary keys
A key concept with pgTap is to avoid testing that Postgres itself works. In this case, you're in
5/20/21
Kyle Jensen
, …
David E. Wheeler
10
5/18/21
How best to test near equality with numeric values?
On May 11, 2021, at 17:12, 'Nasby, Jim' via pgTAP Users <pgtap...@googlegroups.com>
unread,
How best to test near equality with numeric values?
On May 11, 2021, at 17:12, 'Nasby, Jim' via pgTAP Users <pgtap...@googlegroups.com>
5/18/21
