From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | josue <josue(at)lamundial(dot)hn> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: Manejo de multiples esquemas |
Date: | 2005-03-31 21:34:40 |
Message-ID: | 20050331213440.GA27924@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
On Thu, Mar 31, 2005 at 03:20:51PM -0600, josue wrote:
> Alvaro Herrera wrote:
> >Hmm, Works For Me(tm). Que version estas usando?
>
> dbalm=# select version();
> version
>
> ---------------------------------------------------------------------------------------------------------
> PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
> 20020903 (Red Hat Linux 8.0 3.2-7)
> (1 row)
>
> La diferencia es que yo alteré la base de datos
> ALTER DATABASE dbalm SET search_path='public,test,t2';
Eso me da un notice aca:
alvherre=# alter database alvherre set search_path = 'public,alvherre,test';
NOTICE: no existe el esquema «public,alvherre,test»
ALTER DATABASE
alvherre=# alter database alvherre set search_path = 'public','alvherre','test';
ALTER DATABASE
Si lo ignoras obviamente no funciona ...
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
Major Fambrough: You wish to see the frontier?
John Dunbar: Yes sir, before it's gone.
From | Date | Subject | |
---|---|---|---|
Next Message | Mario A. Soto Cordones | 2005-03-31 21:56:09 | Re: Manejo de multiples esquemas |
Previous Message | josue | 2005-03-31 21:26:21 | Re: Manejo de multiples esquemas |