Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_misc=# create schema test1;
CREATE SCHEMA
soport
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_mi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_mi
Gabriel Ramirez wrote:
> so seems if one don't specified the schemaname.objects to list the
> database don't return them, or maybe I'm missing a step after creating
> the schema and objects to be able to list them.
>
This is not a bug. You need to set your schema in the search_path [1].
[1]
http
Euler Taveira de Oliveira wrote:
> Bruce Momjian wrote:
> >> Agreed. Feel free to add whitespace before every /> of simple xml
> >> elements.
> >
> > Uh, was this done?
>
> Nope. Attached is a patch that does it. I'm attaching another cosmetic
> patch that replaces the use of some single quotes wit
Euler Taveira de Oliveira wrote:
> Gabriel Ramirez wrote:
>
>> so seems if one don't specified the schemaname.objects to list the
>> database don't return them, or maybe I'm missing a step after creating
>> the schema and objects to be able to list them.
>>
> This is not a bug. You need to set you
On Wed, Nov 07, 2007 at 02:44:23PM -0500, Tom Lane wrote:
> I don't have access to a machine on which the failure occurs, but
> perhaps Martin can try it. I'd think it'd be pretty easy, say
> #include
> #include
> void
> ereport(const char *msg)
> {
> fprintf(stderr, "%s\n", msg);
>
