From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Bugs for PostgreSQL <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Problem with domains |
Date: | 2003-09-25 13:23:42 |
Message-ID: | 20030925072342.535b20b2.Robert_Creager@LogicalChaos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Once upon a time (Thu, 25 Sep 2003 01:28:29 -0400)
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> uttered something amazingly similar to:
> Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> >> Seems like the correct behavior to me. When CONSTRAINT is given, the
> >> name is not optional AFAICS.
>
> > True, but the second CREATE DOMAIN, which is a valid form, fails when
> > preceded by the invalid form. This was the error I was referring to.
> > Not the fact that I didn't know how to use domains ;-) If the
> > transaction is bad after the first invalid CREATE DOMAIN, the error
> > should say so, rather than waiting for a second valid statement to
> > come along, shouldn't it?
>
> Uh, which part of "queries ignored until end of transaction block"
> didn't you understand?
I understand every word of it. Why doesn't that error come up after the first
CREATE DOMAIN error, since I was in a transaction. Then it would of been
perfectly clear that the transaction I was in needed to be rolled back. Rather
that error doesn't occur until the second valid CREATE DOMAIN is executed.
I was not aware of what Stephan indicated: "All errors are considered
unrecoverable ones by PostgreSQL so after any error the transaction is in an
effectively unusable state and should be rolled back". I know better now. It
still seams that the "queries ignored until end of transaction block" should of
been thrown after the first invalid CREATE DOMAIN. That's all.
>
> > begin;
> > create domain test as integer constraint check( value > 0 );
> > -- ERROR: syntax error at or near "check" at character 42
> > create domain test as integer check( value > 0 );
> > -- ERROR: current transaction is aborted, queries ignored until end
> > of transaction block
Cheers,
Rob
--
07:16:42 up 54 days, 23:48, 5 users, load average: 2.17, 2.06, 2.01
From | Date | Subject | |
---|---|---|---|
Next Message | Javier Carlos | 2003-09-25 15:06:31 | Postgresql 'eats' all mi data partition |
Previous Message | Tom Lane | 2003-09-25 05:28:29 | Re: Problem with domains |