[BUGS] BUG #2452: Error w/ pg_restore and blobs

2006-05-24 Thread Robert Treat 

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 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_restore: [archiver (db)] could not execute query: ERROR:  relation "BLOB
COMMENTS" does not exist
Command was: ALTER TABLE "BLOB COMMENTS" DISABLE TRIGGER ALL;
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "BLOB
COMMENTS" does not exist
Command was:
ALTER TABLE "BLOB COMMENTS" ENABLE TRIGGER ALL;
WARNING: errors ignored on restore: 2

real220m31.582s
user28m43.769s
sys 14m57.497s
[EMAIL PROTECTED] ~]#


Relevant lines from my restore file are:

[EMAIL PROTECTED] ~]# pg_restore -U postgres -Fc mojo.pgr -l | grep BLOB
4260; 0 0 BLOBS - BLOBS
4261; 0 0 BLOB COMMENTS - BLOB COMMENTS

This doesn't really cause any problem for me personally, but seems like it
isn't right, though I couldn't discern if the problem was with pg_restore
misinterpreting the blob comments line or pg_dump adding the line
erroneously.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[BUGS] "blah" is not a domain error

2006-05-24 Thread Jim C. Nasby 
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;
ERROR:  "money" is not a domain
decibel=# \dD
 List of domains
 Schema | Name | Type | Modifier | Check 
+--+--+--+---
(0 rows)

decibel=# \d test
Table "public.test"
 Column | Type  | Modifiers 
+---+---
 m  | money | 

decibel=# create domain money as numeric(99,2);
ERROR:  type "money" already exists
decibel=# select version();
version 
   
---
 PostgreSQL 8.1.2 on powerpc-apple-darwin8.4.0, compiled by GCC 
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 20041026 (Apple Computer, Inc. 
build 4061)
(1 row)

decibel=# 
-- 
Jim C. Nasby, Sr. Engineering Consultant  [EMAIL PROTECTED]
Pervasive Software  http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf   cell: 512-569-9461

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [BUGS] BUG #2452: Error w/ pg_restore and blobs

2006-05-24 Thread 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_restore: [archiver (db)] could not execute query: ERROR:  relation "BLOB
> COMMENTS" does not exist
> Command was: ALTER TABLE "BLOB COMMENTS" DISABLE TRIGGER ALL;

Dealt with, thanks for report.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] "blah" is not a domain error

2006-05-24 Thread Tom Lane 
"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

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match