Hi All,
i'm using RedhatLinux7.2, on top of this i upgrade the Postgres with V7.3.3.
After that, i tried to create a language with a createlang command.
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed:
/usr/local/pgsql/lib/plpgsql.so: un
defined symbol: xlateSqlType
createlang: language
On Friday 12 September 2003 16:49, Robert Treat wrote:
> rather do an rpm -qa | grep post to see if postgresql-pl-7.3.4-2PGDG is
> installed, it is the rpm for procedural languages in 7.3.* and didn't
> exist in the 7.2.* rpmset.
Ah, but the .so isn't in the -pl RPM (I'm guessing plpgsql is consid
rather do an rpm -qa | grep post to see if postgresql-pl-7.3.4-2PGDG is
installed, it is the rpm for procedural languages in 7.3.* and didn't
exist in the 7.2.* rpmset.
Robert Treat
On Fri, 2003-09-12 at 10:12, Richard Huxton wrote:
> Please don't post html-only messages to the list, it makes q
Please don't post html-only messages to the list, it makes quoting hard...
On Friday 12 September 2003 14:49, vijaykumar M wrote:
> We have a machine with RedhatLinix 7.2, on top of this i upgraded
> the postgresql7.3.3 version. After creating a database, i'm trying to
> create a language for tha
sad <[EMAIL PROTECTED]> writes:
> how to call a function with a row_type arg ??
> CREATE FUNCTION foo(tablename) returns int .
SELECT foo(tablename) FROM tablename;
or
SELECT foo(tablename.*) FROM tablename;
The first is traditional Postgres usage, but I think the second mak
Hi All, I'm getting some problem on "createlang plpgsql". with REDHATLINUX7.2
These are all my system configurations..
We have a machine with RedhatLinix 7.2, on top of this i upgraded the postgresql7.3.3 version. After creating a database, i'm trying to create a language for that database by us
DECLARE
I INTEGER;
BEGIN
SELECT *
INTO I
FROM foo(
)
That part is easy, but I don't understand what you are using as a function
parameter.
Rick
sad wrote:
hi
how to call a function with a row_type arg ??
that is the question
CREATE FUNCTION foo(tablename) returns
> Stephen replied :
>
>> Something like the above should work, what's the exact function and
>> error
>> message and what version are you using?
>>
>>
> thanks Stephen.
>
> Exact function definition follows:
> PG Version is 7.3.1 on Windows 2000
> select "max"(seq_val) as m into lastrsn from fseqk
