[GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Nykolyn, Andrew
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I have many stored procedures that rely on those casts

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 Nykolyn, Andrew andrew.nyko...@ngc.com: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I have many stored procedures that

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Aleksander Kmetec
Nykolyn, Andrew wrote: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I have many stored procedures that rely on those casts I'm

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si: Nykolyn, Andrew wrote: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I have

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Scott Marlowe
On Tue, Jan 13, 2009 at 8:23 AM, Nykolyn, Andrew andrew.nyko...@ngc.com wrote: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I have

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: On Tue, Jan 13, 2009 at 8:23 AM, Nykolyn, Andrew andrew.nyko...@ngc.com wrote: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Nykolyn, Andrew
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si: Nykolyn, Andrew wrote: I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found that the cast text-integer and integer-text are missing. Is there a reason why they are not there and how can I get them back. I

Re: [GENERAL] Cast for text-Integer missing in 8.3.5

2009-01-13 Thread Tom Lane
Nykolyn, Andrew andrew.nyko...@ngc.com writes: The above has all worked great to get me past the two issues described so far. Now I am having a problem with: function quote_literal is not unique. And you're going to have a few other problems after you get past that. You can't just insert