Hi,
Apologies for flooding the list. I was updating the table when I should
update the view.
That's the price for working after a regular day job.
Regards,
Geraldo Lopes de Souza
2011/4/16 Geraldo Lopes de Souza
> Hi,
>
> I'm trying to implement tenant view filter with
function current_tenant() returns tenant_id as $$
begin
if substring(current_user,1,3) = 'tnt' then
return cast( substring(current_user,4,10) as integer);
else
return null;
end if;
end
$$ language plpgsql
create or replace view public.tnt_operadora as
select * from public.oper
x27;t scale well due to its
single file data storage implementation. A good disk farm is mostly wasted
on it.
You can partitionate a database with multiple archives.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
