We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent0a3b7e5 commitef2be57Copy full SHA for ef2be57
expected/pg_pathman.out
@@ -1770,15 +1770,14 @@ NOTICE: 100 rows copied from test_fkey_0
1770
1771
/* Check callbacks */
1772
CREATE TABLE log(id serial, message text);
1773
-CREATE FUNCTION abc_on_partition_created_callback(args jsonb)
+CREATEOR REPLACEFUNCTION abc_on_partition_created_callback(args jsonb)
1774
RETURNS VOID AS $$
1775
DECLARE
1776
-start_value TEXT := args->>'start';
1777
-end_value TEXT := args::jsonb->'end';
+start_value TEXT := args->>'start';
+end_value TEXT := args::jsonb->'end';
1778
BEGIN
1779
- -- raise notice 'callback: %', args->start;
1780
- INSERT INTO log(message)
1781
- VALUES (start_value || '-' || end_value);
+INSERT INTO log(message)
+VALUES (start_value || '-' || end_value);
1782
END
1783
$$ language plpgsql;
1784
CREATE TABLE abc(a serial, b int);