"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I know domain support is pretty broken, so maybe this is a known issue...
What are you concerned about exactly? It looks perfectly reasonable
to me. "money" is a base type not a domain.
regards, tom lane
-
"Robert Treat" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] ~]# time pg_restore -U postgres -a --disable-triggers -Fc
> mojo.pgr -d mojo
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 4261; 0 0 BLOB COMMENTS
> BLOB COMMENTS
> pg_resto
I know domain support is pretty broken, so maybe this is a known issue...
decibel=# create table test(m money);
CREATE TABLE
decibel=# insert into test values('-1.00');
INSERT 0 1
decibel=# alter domain money add check(money>0);
ERROR: "money" is not a domain
decibel=# drop domain money;
ERRO
The following bug has been logged online:
Bug reference: 2452
Logged by: Robert Treat
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Fedora Core 4
Description:Error w/ pg_restore and blobs
Details:
[EMAIL PROTECTED] ~]# time pg_restore -U
