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�

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general