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@huehner.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
unmodifiedself-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