can't create type lo (BLOB) 
Author Message
 can't create type lo (BLOB)


> Why this? With PostrgreSql 7.2 this works well.

7.3 tries to enforce type safety (with 7.2 it's trivial to create type
definitions that crash the server when used).  Your type declaration
doesn't pass because the I/O functions are declared to be for int4,
not lo.

My advice as of 7.3 would be to create type lo as a domain alias for
type OID:

regression=# create domain lo as oid;

                        regards, tom lane

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


Wed, 22 Jun 2005 04:16:42 GMT
 [ 1 post ] 

 Relevant Pages 

1. can't create type lo (BLOB)

2. pgsql/contrib/lo (lo.c

3. pgsql/contrib/lo (lo.c

4. I can′t create type lo in 7.3

5. pgsql-server/contrib/lo

6. pgsql/contrib/lo lo.c

7. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

8. creating tables with blob types

9. Creating a 'SET' type

10. Defining lo type in postgres 7.3

11. Creating BLOB's in C (IUS 9.14)

12. Q: Blob Fields in Delphi2 Can't create a DB

Powered by phpBB® Forum Software