Thread: Strict mode in postgresql??

Arun P.L <arunpl@hotmail.com> wrote:

> Hi,
>
> Is there any settings in postgresql version 9.2 similar to mysql strict mode? I
> need to get rid of some type casting errors in the upgrading process from
> version 7.4 to 9.2, if this mode is not available I have to modify queries in
> the system to make it work...

No, there isn't such an option.

If you now on 9.2 and there are problems with missings casts, you can
recreate that, read
http://petereisentraut.blogspot.de/2008/03/readding-implicit-casts-in-postgresql.html


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

On 06/23/2013 10:33 PM, Andreas Kretschmer wrote:
>
> Arun P.L <arunpl@hotmail.com> wrote:
>
>> Hi,
>>
>> Is there any settings in postgresql version 9.2 similar to mysql strict mode? I
>> need to get rid of some type casting errors in the upgrading process from
>> version 7.4 to 9.2, if this mode is not available I have to modify queries in
>> the system to make it work...
>
> No, there isn't such an option.
>
> If you now on 9.2 and there are problems with missings casts, you can
> recreate that, read
> http://petereisentraut.blogspot.de/2008/03/readding-implicit-casts-in-postgresql.html

Or fix the casting which is the real problem.

JD


>
>
> Andreas
>


--
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
    a rose in the deeps of my heart. - W.B. Yeats