Problem: Failed Make on Linux Pgres v. 7.1.2

R Talbot <rjtalbo@attglobal.net> writes:

First is there a great need to move to v. 7.1.2?
What advantages are offred?

7.1.x has a lot of enhancements, including outer joins, write-ahead
logging (WAL) for better performance, enhancements to PL/pgSQL and
much more.

Below are my results ... PLease advise

Postgresql 7.1.2 make errors

/usr/lib/gcc-lib/i386-linux/egcs-2.91.66/crtendS.o: In function
`init_dummy':
/usr/lib/gcc-lib/i386-linux/egcs-2.91.66/crtendS.o(.text+0x53):
undefined reference to
`___brk_addr'

This looks like your build environmemt is all messed up. Are you
actually able to compile C programs on this system with this compiler?

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm. -Dylan

Doug McNaught wrote:

R Talbot <rjtalbo@attglobal.net> writes:

Below are my results ... PLease advise

Postgresql 7.1.2 make errors

/usr/lib/gcc-lib/i386-linux/egcs-2.91.66/crtendS.o: In function
`init_dummy':
/usr/lib/gcc-lib/i386-linux/egcs-2.91.66/crtendS.o(.text+0x53):
undefined reference to
`___brk_addr'

This looks like your build environmemt is all messed up. Are you
actually able to compile C programs on this system with this compiler?

-Doug

Doug & All
Yeah, I compiled v. 7.0.2 It is installed and has run fine for a year.
I did this on three machines.. I have compile many other working
programs.
One of the Postgres FAQs note that you can not use the RPM binary
on a the Caldera Desktop Install.. SO I must Complie ..
I tried the binary and it fails even on v. 7.0.2...

I also have the same problem with Mysql , the binary doesn't work.
You must compile for Caldera.. Has to do with the fact that Red Hat
places some items in non GNU locations.. And Everbody prepares
for Red Hat..

So my question is it worth my time to upgrade my libc, no small
task.
Because it may not even make a differece regarding my Success.

I have too much invested in time and apps and upgrades to abandon
four Caldera installations...
Any help is appreciated, I would like to stick with Postgres..

Installed and working fine
PostgeSQL 7.0.2
DB2 v 7.1
Sybase Server 11
MySQL 3.22.32
VA for Java v.2.0
Perl v 5.003
JDK 1.18

Bob T

Hi,

I want to log the primary key of a table whenever a new row is inserted.
To achieve this, I created the following function as trigger on update.
However I get the following error on inserts:

ERROR: NEW used in non-rule query

Here is my function:
The first select inside the function body gives me the name of the primary
key field.

-----------------------------------------------------------------------
create function log_insert() returns opaque as '
declare
currtime timestamp := ''now'';
pkeyname name;
query text;
begin
select into pkeyname c.attname
from pg_class a,
pg_index b,
pg_attribute c
where
a.relname = TG_RELNAME and
a.oid = b.indrelid and
a.oid = c.attrelid and
b.indkey[0] = c.attnum and
b.indisprimary=''t'';
query := ''insert into logtable (pkvalue, tablename, time)
values (NEW.'' ||
quote_ident(pkeyname) ||
'', '' ||
quote_ident(TG_RELNAME) ||
'', '' ||
quote_ident(currtime) ||
'');'';
execute query;
return null;
end;
' language 'plpgsql';
----------------------------------------------------------------------

I would be extremely grateful for any help. I might add that when I print
the dynamic query with a "raise notice" the query looks fine.

Thanks in advance

Gurunandan