That's probably because CASTS are database-wide and are not in schemas. Chris
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Eduardo Stern > Sent: Sunday, 19 January 2003 11:07 PM > To: [EMAIL PROTECTED] > Subject: [HACKERS] Cast and Schemas don't work as expected > > > The CREATE CAST command is't supporting schemas on the type parameters. > > A query such as: > > CREATE CAST (public.lo AS oid) WITH FUNCTION newoid (public.lo) > AS IMPLICIT; > > Gives an error. And the problem happens when you create a CAST without the > schema notation, and then try to do a dump/restore cycle. > > > []s > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
