Re: Function problems redux

You wrote:
> there is a missing ; in the line
> >INSERT INTO individu (individu_id,nom,prenom,type2) VALUES (ival, nom,
> >prenom, art)

I got that one after hitting send... sorry

Now on to todays question:

how do I get currval and nextval to work in pl/pgsql? They seem to be stuck and won't update during the session.

Cheers

Tony Grant

--
tony(at)animaproductions(dot)com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gateway
>From pgsql-general-owner(at)postgresql(dot)org Tue Nov 6 09:54:05 2001
Received: from news.tht.net (news.hub.org [216.126.91.242])
by postgresql.org (8.11.3/8.11.4) with ESMTP id fA667Mq96832
for <pgsql-general(at)postgresql(dot)org>; Tue, 6 Nov 2001 01:07:22 -0500 (EST)
(envelope-from news(at)news(dot)tht(dot)net)
Received: (from news(at)localhost)
by news.tht.net (8.11.4/8.11.4) id fA65we906830
for pgsql-general(at)postgresql(dot)org; Tue, 6 Nov 2001 00:58:40 -0500 (EST)
(envelope-from news)
From: "Rudy Amid" <radix33(at)hotmail(dot)com>
X-Newsgroups: comp.databases.postgresql.questions
Subject: postgres 7.1.1 on Freebsd 4.3?
Date: Mon, 5 Nov 2001 21:58:37 -0800
Organization: Home Sweet Home
Lines: 20
Message-ID: <9s7u6e$6lb$1(at)news(dot)tht(dot)net>
X-Complaints-To: scrappy(at)hub(dot)org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
To: pgsql-general(at)postgresql(dot)org
X-Archive-Number: 200111/208
X-Sequence-Number: 17207

I hope I got the right newsgroup to ask this question, so here goes:

Anyone got Postgres 7.1.1 to work under FreeBSD 4.3? It compiled fine but
here's what I got when I ran postmaster:

IpcMemoryCreate: shmget(keyT32001, size36992, 03600) failed: Cannot
allocate memory

The Postgres FAQ states that my kernel may not have enough (~10Mb) of shared
memory, but to my dismay, I also can't figure out how to tweak that on the
freebsd kernel config.

If anyone ran across this problem before and have a solution, please let me
know.

Thanks!
Rudy