From 6af9fd66fbfe30dba89bc530a0a272db2d23a17e Mon Sep 17 00:00:00 2001
From: Joseph <Joseph.xu@efrei.net>
Date: Mon, 27 Mar 2023 08:57:29 -0400
Subject: New spi files

---
 src/exchangedb/.gitignore       |   6 ++++++
 src/exchangedb/spi/own_test.c   |   8 ++++++++
 src/exchangedb/spi/own_test.so  | Bin 76824 -> 76824 bytes
 src/exchangedb/spi/own_test.sql |   2 +-
 4 files changed, 15 insertions(+), 1 deletion(-)

(limited to 'src/exchangedb')

diff --git a/src/exchangedb/.gitignore b/src/exchangedb/.gitignore
index 264217a3d..fa833d81f 100644
--- a/src/exchangedb/.gitignore
+++ b/src/exchangedb/.gitignore
@@ -7,3 +7,9 @@ perf_select_refunds_by_coin-postgres
 exchange-0002.sql
 procedures.sql
 exchange-0003.sql
+perf-exchangedb-reserves-in-insert-postgres
+test-exchangedb-batch-reserves-in-insert-postgres
+test-exchangedb-by-j-postgres
+test-exchangedb-populate-link-data-postgres
+test-exchangedb-populate-ready-deposit-postgres
+test-exchangedb-populate-select-refunds-by-coin-postgres
\ No newline at end of file
diff --git a/src/exchangedb/spi/own_test.c b/src/exchangedb/spi/own_test.c
index 04798bfa7..10af02e31 100644
--- a/src/exchangedb/spi/own_test.c
+++ b/src/exchangedb/spi/own_test.c
@@ -530,6 +530,11 @@ pg_spi_update_y(PG_FUNCTION_ARGS)
   PG_RETURN_VOID();
 }
 
+
+
+
+
+
 Datum
 pg_spi_prepare_update(PG_FUNCTION_ARGS)
 {
@@ -580,6 +585,9 @@ void _PG_fini(void)
 
 */
 
+
+
+
 Datum
 pg_spi_get_dep_ref_fees (PG_FUNCTION_ARGS) {
   /* Define plan to save */
diff --git a/src/exchangedb/spi/own_test.so b/src/exchangedb/spi/own_test.so
index fda70c9d0..09ae99597 100755
Binary files a/src/exchangedb/spi/own_test.so and b/src/exchangedb/spi/own_test.so differ
diff --git a/src/exchangedb/spi/own_test.sql b/src/exchangedb/spi/own_test.sql
index 369c56a60..9fe42c0a4 100644
--- a/src/exchangedb/spi/own_test.sql
+++ b/src/exchangedb/spi/own_test.sql
@@ -137,7 +137,7 @@ CREATE OR REPLACE FUNCTION pg_spi_get_dep_ref_fees(
  ,IN wtid BYTEA
 )
   RETURNS VOID
-  LANGUAGE c COST 100
+  LANGUAGE c VOLATILE COST 100
 AS '$libdir/own_test', 'pg_spi_get_dep_ref_fees';
 
 CREATE OR REPLACE FUNCTION update_pg_spi_get_dep_ref_fees(
-- 
cgit v1.2.3