On Fri, 2003-07-11 at 01:58, Zeno R.R. Davatz wrote:
> Hi List
>
> Out of some reason our data of our postgresql database has been corrupted. When we
> try to connect to the database we get:
>
> psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
> No such file or directory
>
Robert Treat writes:
On Fri, 2003-07-11 at 01:58, Zeno R.R. Davatz wrote:
Hi List
Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get:
psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
No such file or di
On Fri, Jul 11, 2003 at 03:08:19PM +0200, stephane parenton wrote:
hi,
> is it possible to have something like "select blah1 blah2 from mytable1
> where blah45=thing12 as xml using formatfile" ?
no, this belongs to the client - not the server.
you could write an psql replacement which understand
Hi all,
I'm running the followin example on Postgres 7.3.3
I notice that if I declare an immutable function like this:
CREATE OR REPLACE FUNCTION test (integer) RETURNS integer
AS '
declare
begin
raise notice ''test called'';
return $1+1;
end;'
LANGUAGE plpgsql IMMUTABLE;
and I use this func
"Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> the function is immutable but is executed 3 times
> ( one for each row).
So? Sounds to me like it's working as intended.
regards, tom lane
---(end of broadcast)---
TIP 5: Have
