-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Devan Goodwin wrote:
> Suspect we might have something in our schema that doesn't work on 8.3,
> doing some testing on fedora and hit this:
>
> psql:tables/rhn_contact_groups.sql:45: ERROR: operator does not exist:
> character = integer HINT: No operator matches the given name and
> argument type(s). You might need to add explicit type casts.
>
> This is with: postgresql-server-8.3.6-1.fc10.i386
>
> Whereas the sql loads fine on postgresql-server-8.1.11-1.el5_1.1.
>
> Probably not a huge deal but it'll probably surface at some point. :) I
> can't even tell what it's complaining about... anybody know?
>
> Devan
>
I verified against PG version 8.1,8.2, it is working fine , for example take
this table :-
create table test(n char(1) not null check(n in (0,1))); :-by default it is
doing implicitly typecasting ,whereas on PG8.3 we need to do it explicitly
typecasting
like this :- create table test(n char(9) not null check(n in
(0::bpchar,1::bpchar))); it will work .
--
regards,tushar
http://webeatoracle.com
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
- --
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQFJrhbKfQNodY2PIRoRAm84AJ9tBrFxprTKwRJSfJwQ5ZWqtfiOJgCfV3ss
DHrWSiOX1dsx/VMtD90kgYY=
=syiU
-----END PGP SIGNATURE-----
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
