[BUGS] PostgreSQL fails to build [ Solaris 8 ]
I am getting a error while trying to compile
PostgreSQL on my Solaris Sparc 20.
Solaris 8
Attach is the error I'm getting when I ran gmake.
# uname -a
SunOS SPARC20 5.8 Generic sun4m sparc SUNW,SPARCstation-20
---
# gmake --version
GNU Make version 3.78.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.8
Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
Report bugs to <[EMAIL PROTECTED]>.
---
# ./configure
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking echo setting...
checking setting template to... solaris_sparc_gcc
checking whether to support locale... disabled
checking whether to support cyrillic recode... disabled
checking whether to support multibyte... disabled
checking setting DEF_PGPORT... 5432
checking setting DEF_MAXBACKENDS... 32
checking setting USE_TCL... disabled
checking setting USE_PERL... disabled
checking setting USE_ODBC... disabled
checking setproctitle... disabled
checking setting ASSERT CHECKING... disabled
checking for gcc... (cached) gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking how to run the C preprocessor... (cached) gcc -E
checking whether gcc needs -traditional... (cached) no
- setting CPPFLAGS=
- setting LDFLAGS=
checking setting debug compiler flag... using default
checking for c++... (cached) c++
checking whether the C++ compiler (c++ ) works... yes
checking whether the C++ compiler (c++ ) is a cross-compiler... no
checking whether we are using GNU C++... (cached) yes
checking whether c++ accepts -g... (cached) yes
checking for include in C++... yes
checking for namespace std in C++... yes
checking for a BSD compatible install... /usr/Data/TMP/postgresql-7.0.2/src/install-sh
-c
checking for flex... (cached) flex
checking for yywrap in -lfl... (cached) yes
checking whether ln -s works... (cached) yes
checking whether make sets ${MAKE}... (cached) yes
checking for ranlib... (cached) ranlib
checking for find... (cached) /usr/bin/find
checking for tar... (cached) /usr/sbin/tar
checking for split... (cached) /usr/bin/split
checking for etags... no
checking for xargs... (cached) /usr/bin/xargs
checking for gzcat... (cached) /usr/bin/gzcat
checking for perl... (cached) perl
checking for bison... (cached) /opt/sfw/bin/bison
- Using /opt/sfw/bin/bison -y -d
checking for main in -lsfio... (cached) no
checking for main in -lncurses... (cached) yes
checking for main in -ltermcap... (cached) yes
checking for main in -lreadline... (cached) yes
checking for using_history in -lreadline... (cached) yes
checking for main in -lbsd... (cached) no
checking for main in -lutil... (cached) no
checking for main in -lm... (cached) yes
checking for main in -ldl... (cached) yes
checking for main in -lsocket... (cached) yes
checking for main in -lnsl... (cached) yes
checking for main in -lipc... (cached) no
checking for main in -lIPC... (cached) no
checking for main in -llc... (cached) no
checking for main in -ldld... (cached) no
checking for main in -lln... (cached) no
checking for main in -lld... (cached) no
checking for main in -lcompat... (cached) no
checking for main in -lBSD... (cached) no
checking for main in -lcrypt... (cached) yes
checking for main in -lgen... (cached) yes
checking for main in -lPW... (cached) no
checking for ANSI C header files... (cached) no
checking for sys/wait.h that is POSIX.1 compatible... (cached) yes
checking for arpa/inet.h... (cached) yes
checking for crypt.h... (cached) yes
checking for dld.h... (cached) no
checking for endian.h... (cached) no
checking for float.h... (cached) yes
checking for fp_class.h... (cached) no
checking for getopt.h... (cached) no
checking for history.h... (cached) no
checking for ieeefp.h... (cached) yes
checking for limits.h... (cached) yes
checking for netdb.h... (cached) yes
checking for netinet/in.h... (cached) yes
checking for readline.h... (cached) no
checking for readline/history.h... (cached) yes
checking for readline/readline.h... (cached) yes
checking for sys/select.h... (cached) yes
checking for termios.h... (cached) yes
checking for unistd.h... (cached) yes
checking for values.h... (cached) yes
checking for sys/param.h... (cached) yes
checking for pwd.h... (cached) yes
checking for working const... (cached) yes
checking for inline... (cached) inline
checking for preprocessor stringizing operator... (cached) yes
checking for uid_t in sys/types.h... (cached) yes
checking for mode_t... (cached) yes
checking for off_t... (cached) yes
checking for size_t... (cached) yes
checking
[BUGS] PostgreSQL fails to build [ Solaris 8 ]
I am getting a error while trying to compile
PostgreSQL on my Solaris Sparc 20.
Solaris 8
Attach is the error I'm getting when I ran gmake.
# uname -a
SunOS SPARC20 5.8 Generic sun4m sparc SUNW,SPARCstation-20
---
# gmake --version
GNU Make version 3.78.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.8
Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
Report bugs to <[EMAIL PROTECTED]>.
---
# ./configure
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking echo setting...
checking setting template to... solaris_sparc_gcc
checking whether to support locale... disabled
checking whether to support cyrillic recode... disabled
checking whether to support multibyte... disabled
checking setting DEF_PGPORT... 5432
checking setting DEF_MAXBACKENDS... 32
checking setting USE_TCL... disabled
checking setting USE_PERL... disabled
checking setting USE_ODBC... disabled
checking setproctitle... disabled
checking setting ASSERT CHECKING... disabled
checking for gcc... (cached) gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking how to run the C preprocessor... (cached) gcc -E
checking whether gcc needs -traditional... (cached) no
- setting CPPFLAGS=
- setting LDFLAGS=
checking setting debug compiler flag... using default
checking for c++... (cached) c++
checking whether the C++ compiler (c++ ) works... yes
checking whether the C++ compiler (c++ ) is a cross-compiler... no
checking whether we are using GNU C++... (cached) yes
checking whether c++ accepts -g... (cached) yes
checking for include in C++... yes
checking for namespace std in C++... yes
checking for a BSD compatible install... /usr/Data/TMP/postgresql-7.0.2/src/install-sh
-c
checking for flex... (cached) flex
checking for yywrap in -lfl... (cached) yes
checking whether ln -s works... (cached) yes
checking whether make sets ${MAKE}... (cached) yes
checking for ranlib... (cached) ranlib
checking for find... (cached) /usr/bin/find
checking for tar... (cached) /usr/sbin/tar
checking for split... (cached) /usr/bin/split
checking for etags... no
checking for xargs... (cached) /usr/bin/xargs
checking for gzcat... (cached) /usr/bin/gzcat
checking for perl... (cached) perl
checking for bison... (cached) /opt/sfw/bin/bison
- Using /opt/sfw/bin/bison -y -d
checking for main in -lsfio... (cached) no
checking for main in -lncurses... (cached) yes
checking for main in -ltermcap... (cached) yes
checking for main in -lreadline... (cached) yes
checking for using_history in -lreadline... (cached) yes
checking for main in -lbsd... (cached) no
checking for main in -lutil... (cached) no
checking for main in -lm... (cached) yes
checking for main in -ldl... (cached) yes
checking for main in -lsocket... (cached) yes
checking for main in -lnsl... (cached) yes
checking for main in -lipc... (cached) no
checking for main in -lIPC... (cached) no
checking for main in -llc... (cached) no
checking for main in -ldld... (cached) no
checking for main in -lln... (cached) no
checking for main in -lld... (cached) no
checking for main in -lcompat... (cached) no
checking for main in -lBSD... (cached) no
checking for main in -lcrypt... (cached) yes
checking for main in -lgen... (cached) yes
checking for main in -lPW... (cached) no
checking for ANSI C header files... (cached) no
checking for sys/wait.h that is POSIX.1 compatible... (cached) yes
checking for arpa/inet.h... (cached) yes
checking for crypt.h... (cached) yes
checking for dld.h... (cached) no
checking for endian.h... (cached) no
checking for float.h... (cached) yes
checking for fp_class.h... (cached) no
checking for getopt.h... (cached) no
checking for history.h... (cached) no
checking for ieeefp.h... (cached) yes
checking for limits.h... (cached) yes
checking for netdb.h... (cached) yes
checking for netinet/in.h... (cached) yes
checking for readline.h... (cached) no
checking for readline/history.h... (cached) yes
checking for readline/readline.h... (cached) yes
checking for sys/select.h... (cached) yes
checking for termios.h... (cached) yes
checking for unistd.h... (cached) yes
checking for values.h... (cached) yes
checking for sys/param.h... (cached) yes
checking for pwd.h... (cached) yes
checking for working const... (cached) yes
checking for inline... (cached) inline
checking for preprocessor stringizing operator... (cached) yes
checking for uid_t in sys/types.h... (cached) yes
checking for mode_t... (cached) yes
checking for off_t... (cached) yes
checking for size_t... (cached) yes
checking
[BUGS] Help
POSTGRESQL BUG REPORT TEMPLATE Your name : Thomas Waelde Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.7 PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.3 Compiler used (example: gcc 2.8.0) : gcc 2.0.8 Please enter a FULL description of your problem: The database was not shut down in a proper manner. Since then the database is not coming up, because: Database is in production state .. Database is shutting down .. Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: -- If you know how this problem might be fixed, list the solution below: - ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[BUGS] pq_shadow
I am writing you because I am new to Postgesql and I have encountered a problem that I have not been able to solve through your doc's or mailing list. The problem is with the createuser utility. When I try to create a user I get the following error: ## [root@crescent1 root]# createuser webmaster -PEnter password for user "webmaster":Enter it again:Shall the new user be allowed to create databases? (y/n) yShall the new user be allowed to create more new users? (y/n) ypsql: FATAL 1: SetUserId: user 'root' is not in 'pg_shadow'createuser: creation of user "webmaster" failed[root@crescent1 root]# ## I would like to be able to use Postgresql (not just Mysql) but if I can not create a user I can not login to the Postgres data base. I advise me on how to fix this problem. I am using Red Hat 6.2 on a Intel based x86 with a Pentium CPU. Eric Williams
[BUGS] BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them
The following bug has been logged on the website: Bug reference: 7604 Logged by: Bill MacArthur Email address: webmas...@dhs-club.com PostgreSQL version: 9.2.1 Operating system: CentOS 5.8 Description: vip_declines_mailers_base is a VIEW that itself uses another VIEW alongside several other joined tables. nop_seed is a 1 column table that contains 1 date as a reference. members_cancel_pending is a VIEW. CREATE OR REPLACE VIEW vip_decline_mailers_base AS SELECT m.id, m.alias, m.firstname, m.lastname, m.emailaddress, CASE WHEN s.void = false THEN s.end_date ELSE (s.end_date - '1 mon'::interval)::date END AS paid_thru, mop.payment_method, m.mail_option_lvl, now()::date AS "current_date" FROM nop_seed, subscriptions s JOIN mop ON mop.id = s.member_id JOIN members_cancel_pending m ON m.id = s.member_id AND m.membertype::text = 'v'::text JOIN subscription_types st ON s.subscription_type = st.subscription_type WHERE (s.end_date < nop_seed.paid_thru OR s.void = true) AND st.sub_class::text = 'VM'::text; Then executing a query against vip_declines_mailers_base with no constraining arguments, the complete result set counts as this: network=# select count(*) from vip_decline_mailers_base; count --- 358 vip_declines_mailers_base is another VIEW that merely adds some criteria to limit the result set of the 'base' VIEW. In versions 9.0 and back it did just that. After upgrading to 9.2, the criteria actually expand the result set. CREATE OR REPLACE VIEW vip_mailer_unpaid_current AS SELECT vip_decline_mailers_base.id, vip_decline_mailers_base.alias, vip_decline_mailers_base.firstname, vip_decline_mailers_base.lastname, vip_decline_mailers_base.emailaddress, vip_decline_mailers_base.paid_thru, vip_decline_mailers_base.payment_method, vip_decline_mailers_base.mail_option_lvl, vip_decline_mailers_base."current_date", current_month_text(now()) AS current_month_text FROM vip_decline_mailers_base WHERE vip_decline_mailers_base.mail_option_lvl > 0 AND vip_decline_mailers_base.paid_thru >= first_of_another_month((now()::date - '1 mon'::interval)::date) AND vip_decline_mailers_base.paid_thru <= (first_of_month() - 1); network=# select count(*) from vip_mailer_unpaid_current; count --- 391 How can this be? What's worse, is that adding the criteria somehow mangles the inner workings of the 'base' VIEW and causes it to return results where the membertype does not even match the join criteria which should be 'v' only. I could create a self contained test case, but the number of tables and scrubbing the data could be tedious. Perhaps there is enough here to help pinpoint a trouble spot. I should restate, also, that these VIEWS have been working fine with 9.0 and earlier versions. FWIW, here are the EXPLAINs on the two queries. network=# explain select count(*) from vip_decline_mailers_base; QUERY PLAN -- Aggregate (cost=82439.33..82439.34 rows=1 width=0) -> Hash Right Join (cost=78647.01..82439.21 rows=47 width=0) Hash Cond: (c.id = m.id) Filter: ((CASE WHEN (c.id IS NULL) THEN m.membertype WHEN ((c.status = 'tr'::text) OR (c.status = 'p'::text) OR (c.status = 'cd'::text) OR (c.status = 'sp'::text) OR (c.status = 'sa'::text)) THEN m.membertype ELSE 'c'::character varying END)::text = 'v'::text) -> Seq Scan on cancellations c (cost=0.00..3325.35 rows=119735 width=6) -> Hash (cost=78529.91..78529.91 rows=9368 width=6) -> Hash Join (cost=6128.57..78529.91 rows=9368 width=6) Hash Cond: (m.id = mop.id) -> Seq Scan on members m (cost=0.00..66417.39 rows=1570739 width=6) -> Hash (cost=6011.47..6011.47 rows=9368 width=8) -> Hash Join (cost=3129.39..6011.47 rows=9368 width=8) Hash Cond: (mop.id = s.member_id) -> Seq Scan on mop (cost=0.00..2158.67 rows=71967 width=4) -> Hash (cost=3012.28..3012.28 rows=9369 width=4) -> Nested Loop (cost=2.67..3012.28 rows=9369 width=4) Join Filter: ((s.end_date < nop_seed.paid_thru) OR s.void) -> Seq Scan on nop_seed (cost=0.00..1.01 rows=1 width=4) -> Hash Join (cost=2.67..2723.56 rows=23017 width=9)
