# Can you share a sample formula which is failing in PG \[Jan 06\] **URL:** https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173 **Category:** Discord-Discussions **Created:** [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173 "2022-11-03T07:51:55Z") **Posts on this page:** 20 **Page:** 1
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/1 "2022-11-03T07:51:55Z")
> πŸ™‹β€β™‚οΈ **sskg** _asked_ ## Also, the formula field doesn’t work on PostgreSQL databases. Works fine on MySQL and SQLLite though. ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/2 "2022-11-03T07:51:56Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### Can you share a formula which is failing in pg ? # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/3 "2022-11-03T07:51:57Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### I’m seeing the same problem; formula doesn’t work at all, e.g. 1 + 1 does not work # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/4 "2022-11-03T07:51:58Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### thanks for sharing , we will try to reproduce the problem and let you know # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:51am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/5 "2022-11-03T07:51:59Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### which version of postgres do you have ? # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/6 "2022-11-03T07:52:01Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### I’m actually using a very exotic database call splitgraph [https://www.splitgraph.com](https://www.splitgraph.com) # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/7 "2022-11-03T07:52:02Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### it’s based on postgres and i’m not using any of the special features so it should behave like postgres # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/8 "2022-11-03T07:52:03Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### We couldn’t able to reproduce the problem with postgres 13 # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/9 "2022-11-03T07:52:04Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### ok let me test again with normal postgres # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/10 "2022-11-03T07:52:05Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### can you try to do simple #### #### ``` #### select 1+1 #### ``` # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/11 "2022-11-03T07:52:06Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### sure # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/12 "2022-11-03T07:52:08Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### yes that works # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/13 "2022-11-03T07:52:09Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### 1+1 i mean # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/14 "2022-11-03T07:52:10Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### check your console log and browser network tab for any error # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/15 "2022-11-03T07:52:11Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### no errors. but I do see un-related errors. basically any db update fails with KNEX error even though I’m logged in as dbo # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/16 "2022-11-03T07:52:12Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### can you share the docker /nodejs log # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/17 "2022-11-03T07:52:13Z")
> πŸ‘¨β€πŸ’» **pranavxc** _replied_ #### try with normal postgres db as well # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/18 "2022-11-03T07:52:14Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### just tried with postgres 12.1, still doesn’t work. there’s almost nothing on the docker log # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/19 "2022-11-03T07:52:15Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### ``` #### POST /dashboard/?q=sqlOp\_tableXcModelGet 200 4484 - 2.239 ms #### GET /nc/postgres\_4uqg/api/v1/OrderDetails/count?where= 304 - - 6.841 ms #### GET /nc/postgres\_4uqg/api/v1/OrderDetails?limit=25&offset=0&where=&sort=&hm=&bt=orders,products&mm= 304 - - 8.884 ms #### DB OPS xcAuditModelCommentsCount #### POST /dashboard/?q=sqlOp\_xcAuditModelCommentsCount 200 2 - 2.237 ms #### POST /dashboard/?q=sqlOp\_xcVirtualTableUpdate 200 1 - 12.049 ms #### POST /dashboard/?q=sqlOp\_xcVirtualTableUpdate 200 1 - 12.039 ms #### POST /dashboard/?q=sqlOp\_xcVirtualTableUpdate 200 1 - 8.341 ms #### ``` # ---
### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB) #### Post date: [November 3, 2022, 7:52am UTC](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173/20 "2022-11-03T07:52:17Z")
> πŸ™‹β€β™‚οΈ **mingfang** _replied_ #### on the console, this is the object printed when i save the formula [message.txt](https://cdn.discordapp.com/attachments/927783601016303748/928177840871075870/message.txt) # [Next page](https://community.nocodb.com/t/can-you-share-a-sample-formula-which-is-failing-in-pg-jan-06/173.md?page=2)