[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    Re: [Slony1-general] 'public' schema problem
From:       Shoaib Mir <shoaibmir () gmail ! com>
Date:       2009-04-08 23:34:35
Message-ID: bf54be870904081634k520f9e78ld38f65951f3b5319 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


>
> This seems rather curious; there are no references to the "public" schema
> in Slony-I itself (although there are in test scripts).
>
> There is also no such error message within Slony-I itself as "No schema
> available to setup objects".


This was not exactly the error but it was something like this, I will try to
replicate the same again and will paste the exact one again when I get time.


>
>
> That doesn't mean you didn't see it - just that it would have had to be
> induced somewhere else.  I also don't see it in PostgreSQL code (in HEAD,
> but I doubt that's material).
>
> The only plausible thing that comes to mind would be that perhaps the user
> you connected as had some vestigal reference to "public" as being its
> default schema, so that when the user connected, something was left devoid
> of a place to create objects that weren't tied to a specific schema.


This is true as the user had the default schema set to public as it was the
default 'postgres' user I was using so I am pretty sure it can be linked to
this as it didnt have any schema to create objects.

-- 
Shoaib Mir

[Attachment #5 (text/html)]

<div class="gmail_quote"><div class="im"><blockquote class="gmail_quote" \
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; \
padding-left: 1ex;">This seems rather curious; there are no references to the \
&quot;public&quot; schema in Slony-I itself (although there are in test scripts).<br>

<br>
There is also no such error message within Slony-I itself as &quot;No schema \
available to setup objects&quot;.</blockquote></div><div><br>This was not exactly the \
error but it was something like this, I will try to replicate the same again and will \
paste the exact one again when I get time.<br>
 </div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid \
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br> <br>
That doesn&#39;t mean you didn&#39;t see it - just that it would have had to be
induced somewhere else.  I also don&#39;t see it in PostgreSQL code (in
HEAD, but I doubt that&#39;s material).<br>
<br>
The only plausible thing that comes to mind would be that perhaps the
user you connected as had some vestigal reference to &quot;public&quot; as being
its default schema, so that when the user connected, something was left
devoid of a place to create objects that weren&#39;t tied to a specific
schema.</blockquote>
</div><div><br>This is true as the user had the default schema set to
public as it was the default &#39;postgres&#39; user I was using so I am pretty
sure it can be linked to this as it didnt have any schema to create
objects. <br>
<br></div></div>-- <br><font color="#888888">Shoaib Mir</font>



_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general


[prev in list] [next in list] [prev in thread] [next in thread]