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

2009-01-13 Thread Tom Lane
"Nykolyn, Andrew" 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 implicit casts and exp

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

2009-01-13 Thread Nykolyn, Andrew
2009/1/13 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

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

2009-01-13 Thread Tom Lane
"Scott Marlowe" writes: > On Tue, Jan 13, 2009 at 8:23 AM, 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 ba

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 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 procedu

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

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 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

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 ri

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

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 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

[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