Tom Lane napisał(a):
It was discussed a week or two ago. We're still testing a patch, but
in the meantime you can work around it by making sure that the
postmaster is started with environment variables LC_COLLATE and LC_CTYPE
matching the settings used in the database.
It seems to work. Th
Tom Lane napisal:
Robert Osowiecki <[EMAIL PROTECTED]> writes:
Hm, are you using any plperl functions? This could be the same problem
already identified with plperl messing up the locale settings.
Yes, I am. Where can I read about that other problem, especially: does
plperl
Tom Lane napisał(a):
"Robert Osowiecki" <[EMAIL PROTECTED]> writes:
BUT when on "where ar_code = 'FOO'" unique_code_i index is used and query
returns NO ROWS!
Could you be more specific? Which values of 'FOO' does this happen for?
The following bug has been logged online:
Bug reference: 2143
Logged by: Robert Osowiecki
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.1
Operating system: Linux 2.6.14-gentoo-r5 #2 SMP Thu Dec 22 11:58:01 CET
2005 i686 Intel(R) Xeon(TM) CPU 3.20GHz GenuineIntel
The following bug has been logged online:
Bug reference: 2136
Logged by: Robert Osowiecki
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.1
Operating system: Linux 2.6.14-gentoo-r5 #2 SMP Thu Dec 22 11:58:01 CET
2005 i686 Intel(R) Xeon(TM) CPU 3.20GHz GenuineIntel
638.50
rows=11500 width=24)
Filter: ((ap_deleted = 0) AND (ap_se_code = $0))
EXPLAIN ANALYSE produces similar error (stats collector/query optimizer
bug?)
The database itself is fresh (populated by psql from pg_dumpall)
Please send any suggestions on how could
Richard Huxton wrote:
In 7.4 there is a postgresql.conf setting to control this behaviour
(add_missing_from). I'd turn it off, as I've always found it to cause
problems rather than solve them.
I agree :)
PG now reports "ERROR: missing from clause", I've added "table1.oid" do
view definition
and
POSTGRESQL BUG REPORT TEMPLATE
Your name : Robert Osowiecki
Your email address : [EMAIL PROTECTED]
System
