From 169f1c8c1db0a6d8cebf308ced1de064eadcdc4d Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sun, 25 Jun 2017 17:05:09 +0200 Subject: allow NULL fields for varsize --- src/datacache/plugin_datacache_postgres.c | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/datacache/plugin_datacache_postgres.c') diff --git a/src/datacache/plugin_datacache_postgres.c b/src/datacache/plugin_datacache_postgres.c index 5c497cdf8e..2fe6498a51 100644 --- a/src/datacache/plugin_datacache_postgres.c +++ b/src/datacache/plugin_datacache_postgres.c @@ -68,11 +68,11 @@ init_connection (struct Plugin *plugin) { struct GNUNET_PQ_ExecuteStatement es[] = { GNUNET_PQ_make_execute ("CREATE TEMPORARY TABLE IF NOT EXISTS gn090dc (" - " type INTEGER NOT NULL DEFAULT 0," - " discard_time BIGINT NOT NULL DEFAULT 0," - " key BYTEA NOT NULL DEFAULT ''," - " value BYTEA NOT NULL DEFAULT ''," - " path BYTEA DEFAULT '')" + " type INTEGER NOT NULL," + " discard_time BIGINT NOT NULL," + " key BYTEA NOT NULL," + " value BYTEA NOT NULL," + " path BYTEA DEFAULT NULL)" "WITH OIDS"), GNUNET_PQ_make_try_execute ("CREATE INDEX IF NOT EXISTS idx_key ON gn090dc (key)"), GNUNET_PQ_make_try_execute ("CREATE INDEX IF NOT EXISTS idx_dt ON gn090dc (discard_time)"), -- cgit v1.2.3-18-g5258