Hmmm, i suspect the problem comes from the fact that i did not globally
change gcc to use -m64 nor did I set the enviroment flags (CFLAGS), but
changed the command in the makefile. The configure script did its tests with
the default -m32 and did not define HAVE_LONG_INT_64. Maybe even
INT64_IS_BUS
The platform is a redhat advanced server 4 update 2 for power5 64bit. the
compiler is gcc:
Reading specs from /usr/lib/gcc/ppc64-redhat-linux/3.4.4/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-
Hi there,
i am trying to restore a database I have dumped from
a postgres 8.0.4 power5 (64bit) machine onto another server with the same
version and architecture.
It seems that recreating sequences does not work:
The command
CREATE SEQUENCE assignment_task_elements_seq2
I
Hmm, i just tried to do the same thing (ppc64 sh, ...) but it seems to me
that the result is a 32bit executable:
[EMAIL PROTECTED] pg803]# ldd bin/psql
libpq.so.4 => /opt/learn-bench/pg803/lib/libpq.so.4 (0x0ff95000)
libz.so.1 => /usr/lib/libz.so.1 (0x0fbf)
libreadline
An: Peter Alberer
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Problem with 64-bit Postgres
"Peter Alberer" <[EMAIL PROTECTED]> writes:
> Server says:
> LOG: setsockopt(TCP_NODELAY) failed: Operation not supported
It's pretty unclear why that would fail
Hi,
i am having a problem with a test installation of postgres 8.0.3 on a 64-bit
power5 system. Let me say first that the system seems to work correctly when
compiled in 32-bit mode (which seems to be standard compile mode with gcc on
this installation).
I compiled postgres in 64-bit mode by ad
Sorry i forgot to mention:
-that you need pg 7.3 for the set-returning function feature.
-how to select from the function:
select * from _YOUR_FUNCTION(PARAMETER);
and NOT:
select _YOUR_FUNCTION(PARAMETER);
>-Ursprüngliche Nachricht-
>Von: [EMAIL PROTECTED] [mailto:pgsql-general-
>[E
Hi sylvain,
i think what you need is a so-called "set-returning-function":
if you just need sql (example with a table called user_data):
create or replace function user_info(integer)
returns setof user_data as '
select * from user_data where user_id = $1;
' language 'sql';
if you need plpgs
Hi wei,
it is quite easy to have two different version of postgres running on
one machine. You need 2 different directories for the data files and 2
different ports for the 2 postmasters to listen.
-first you prepare the data directories with initdb, you can use the -D
parameter to give the loca
Hmm, what about
create view v1 as
select *,1 as source from t1
union
select *,2 as source from t2;
>Hello list
>
>I have two tables with identical structure, one holds 'correct' data
(from
>an application standpoint) and the other has data 'in error'. Anyway, I
>need
>
10 matches
Mail list logo
