Re: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)

On Wed, May 06, 2009 at 10:33:11AM -0400, Tom Lane wrote:
> Stefan Huehner <stefan(at)huehner(dot)org> writes:
> > I noticed the following bug when testing an application (openbravo 2.40) on postgresql 8.4:
>
> Thank you for the report, but I do not see any problem when trying the
> test case here. Do you have any nondefault planner parameter settings?

None that i know of. I did use some prepackaed 8.4beta for ubuntu and i will try to reproduce the problem on a unmodified self-compiled version:

For reference the configure options used by the package:
--mandir=\$${prefix}/share/postgresql/$(MAJOR_VER)/man \
--with-docdir=\$${prefix}/share/doc/postgresql-doc-$(MAJOR_VER) \
--sysconfdir=/etc/postgresql-common \
--datadir=\$${prefix}/share/postgresql/$(MAJOR_VER) \
--bindir=\$${prefix}/lib/postgresql/$(MAJOR_VER)/bin \
--includedir=\$${prefix}/include/postgresql/ \
--enable-nls \
--enable-integer-datetimes \
--enable-thread-safety \
--enable-debug \
--enable-cassert \
--disable-rpath \
--with-tcl \
--with-perl \
--with-python \
--with-pam \
--with-krb5 \
--with-gssapi \
--with-openssl \
--with-libxml \
--with-libxslt \
--with-ldap \
--with-ossp-uuid \
--with-gnu-ld \
--with-tclconfig=/usr/lib/tcl$(TCL_VER) \
--with-tkconfig=/usr/lib/tk$(TCL_VER) \
--with-includes=/usr/include/tcl$(TCL_VER) \
--with-system-tzdata=/usr/share/zoneinfo \
--with-pgport=5432

and all non-comment: postgresql.conf options:

data_directory = '/var/lib/postgresql/8.4/main' # use data in another directory
datestyle = 'iso, mdy'
default_text_search_config = 'pg_catalog.english'
external_pid_file = '/var/run/postgresql/8.4-main.pid' # write an extra PID file
hba_file = '/etc/postgresql/8.4/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/8.4/main/pg_ident.conf' # ident configuration file
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
log_error_verbosity=verbose
log_line_prefix = '%t ' # special values:
max_connections = 100 # (change requires restart)
port = 5434 # (change requires restart)
shared_buffers = 32MB # min 128kB
ssl = false # (change requires restart)
unix_socket_directory = '/var/run/postgresql' # (change requires restart)

Regards,
Stefan