aboutsummaryrefslogtreecommitdiff
path: root/src/backend/commands/sequence.c
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2011-02-22 14:42:45 -0500
committerRobert Haas <rhaas@postgresql.org>2011-02-22 14:46:19 -0500
commit3e6b305d9e2a4616bf69e31b0b21ebbb844ba50e (patch)
treee28d44546f3fbdeb0d41d76fac87bd99f6d4587c /src/backend/commands/sequence.c
parent1ab9b012bdf1f106792fc523e21b9ca8299bb8ed (diff)
downloadpostgresql-3e6b305d9e2a4616bf69e31b0b21ebbb844ba50e.tar.gz
postgresql-3e6b305d9e2a4616bf69e31b0b21ebbb844ba50e.zip
Fix a couple of unlogged tables goofs.
"SELECT ... INTO UNLOGGED tabname" works, but wasn't documented; CREATE UNLOGGED SEQUENCE and CREATE UNLOGGED VIEW failed an assertion, instead of throwing a sensible error. Latter issue reported by Itagaki Takahiro; patch review by Tom Lane.
Diffstat (limited to 'src/backend/commands/sequence.c')
-rw-r--r--src/backend/commands/sequence.c6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/backend/commands/sequence.c b/src/backend/commands/sequence.c
index 80ad516de1f..e71c311faf7 100644
--- a/src/backend/commands/sequence.c
+++ b/src/backend/commands/sequence.c
@@ -119,6 +119,12 @@ DefineSequence(CreateSeqStmt *seq)
int i;
NameData name;
+ /* Unlogged sequences are not implemented -- not clear if useful. */
+ if (seq->sequence->relpersistence == RELPERSISTENCE_UNLOGGED)
+ ereport(ERROR,
+ (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
+ errmsg("unlogged sequences are not supported")));
+
/* Check and set all option values */
init_params(seq->options, true, &new, &owned_by);