On 2011-11-15 v46 01.43, Josh Berkus wrote:
... somehow the query to dump the sequences is getting mangled. Any
clue how?
Seems you have a sequence called "new"; seems we don't handle that
well.
So, tested this some more. For some reason, 8.4's pg_dump would
recognize NEW as a reserved word
Zdenek Kotala wrote:
>
> Main problem is -fast switch. It modifies behavior of floating point
> operation (it is reason why It is not good option for postgres) and
> use another floating point libraries and some function are inlined. It
> is reason why pow test passed with -fast switch without -lm
: test -z
|| test ! -s conftest.err
configure:5211: $? = 0
configure:5214: test -s conftest
configure:5217: $? = 0
configure:5287: result: none required
regards,
Andreas Lange
Alvaro Herrera wrote:
Andreas Lange wrote:
configure:13462: checking for cbrt
configure:13519: /sw/sun-studio-11/SUNWspro/bin/cc -Xa -o conftest -fast
-fns=no -fsimple=1 -xtarget=opteron -xarch=amd64a conftest.c -lz
-lrt -lsocket >&5
"conftest.c",
Alvaro Herrera wrote:
Andreas Lange wrote:
And here is from configure:
checking whether gettimeofday takes only one argument... no
checking for cbrt... no
Undoubtely this is the problem. Can you show the relevant config.log
extract?
Ok, here we go:
configure
Hi,
I have problems building 8.2beta2 on a Solaris 10 x86-64 machine:
gmake[4]: Entering directory
`/files/dsk1/lsw/src/postgresql/postgresql-8.2beta2/src/backend/utils/adt'
/sw/sun-studio-11/SUNWspro/bin/cc -Xa -fast -fns=no -fsimple=1
-xtarget=opteron -xarch=amd64a -I../../../../src/include -
Hi!
Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables
got dumped in the wrong order (before their dependecies) and had to get
their contents added manually after the restore. I've atleast isolated
the part where things go wrong.
Two files are attached, related as follows (al
Hi!
Our admin upgraded PostgreSQL 7.2.3 to 7.3.1 a while ago (dump and
restore).
Previously I had a table with a long name (>32 chars), which at creation
was truncated to proper length. The table was used from a perl-script
(using the full name) doing mostly DELETE's and INSERT's. The user
ac
