Re: Error Help - Mailing list pgsql-novice

--- Daniel Blavos <dblavos@wyops.com> wrote:

> My site_properties came out like this:
> ____________________________
> docmgrdb=# \d site_properties
>                               Table
> "public.site_properties"
>       Column      |   Type   |
>   Modifiers
>
------------------+----------+----------------------------------------------
> --------------
>  id               | integer  | not null default
> nextval('"site_properties_id_seq"'::text)
>  module_name      | text     | not null
>  module_type      | smallint | not null default
> (1)::smallint
>  module_directory | text     | not null
>  define_name      | text     | not null
>  sort_order       | smallint |
>  hidden           | smallint | not null
>  auth_only        | smallint |
>  perm_level       | text     |
>  perm_message     | text     |
>  owner            | integer  | not null
> Indexes:
>     "id_site_properties_ukey" unique, btree (id)
> ___________________________
>
> And doing the command \dt gave this output:
> ___________________________
> docmgrdb=# \dt
>                 List of relations
>  Schema |        Name         | Type  |  Owner
> --------+---------------------+-------+----------
>  public | auth_accounts       | table | postgres
>  public | auth_grouplink      | table | postgres
>  public | auth_groups         | table | postgres
>  public | auth_permissions    | table | postgres
>  public | auth_permlink       | table | postgres
>  public | dm_cat_permissions  | table | postgres
>  public | dm_category         | table | postgres
>  public | dm_discussion       | table | postgres
>  public | dm_file_cat         | table | postgres
>  public | dm_file_history     | table | postgres
>  public | dm_file_log         | table | postgres
>  public | dm_file_permissions | table | postgres
>  public | dm_index            | table | postgres
>  public | dm_object           | table | postgres
>  public | site_properties     | table | postgres
> (15 rows)

Wow, most strange.  The only likely cause for this
failure that jumps to mind is that your schema search
path is being set so as to not include "public", which
is unusual.

Is your app issuing a "set search_path" command?  How
is that set in your postgresql.conf file?  I suggest
you look at your postgresql.conf, and also turn on
logging, if you haven't already, so as to capture the
SQL commands that are being sent to the backend.  What
gets there may not be what you think your app is
sending.  Look at section 16.4 in the PostgreSQL
manual for information about all of this.  If you
don't want to use syslog, you can direct log output to
any file of your choice using the -l option to the
pg_ctl utility.

> ______________________________
>
>
> ----- Original Message -----
> From: "Jeff Eckermann" <jeff_eckermann@yahoo.com>
> To: "Daniel Blavos" <dblavos@wyops.com>;
> <pgsql-novice@postgresql.org>
> Sent: Friday, 21 January, 2005 07:57 AM
> Subject: Re: [NOVICE] Error Help
>
>
> > --- Daniel Blavos <dblavos@wyops.com> wrote:
> >
> > > Hello,
> > >
> > > I have been working on two errors that I
> continue to
> > > recieve.  I am attempting to get DocMgr to work
> with
> > > Postgres and PHP4.  Postgres is version 7.4.6,
> and
> > > PHP4 is version 4.3.10.  I am able to access the
> > > test.php page and my apache server page like
> normal.
> > >  When I try to access my /doc/ directory in my
> web
> > > browser, I recieve this error:
> > >
> > >
> > > Warning: pg_query(): Query failed: ERROR:
> relation
> > > "site_properties" does not exist in
> > > /var/www/doc/include/postgresql.inc.php on line
> 46
> >
> > 'relation "site_properties" does not exist' looks
> like
> > a database error.  Can you show us the table
> > definition?  The output of "\d site_properties",
> using
> > psql, would be good.  If you get a similar message
> (as
> > I suspect you will), the output of "\dt" will be
> > helpful.
> >
> > Your problem appears to be related to case
> folding,
> > but it is difficult to be more specific without
> more
> > information.
> >
> > > ERROR_SQL=SELECT * FROM site_properties ORDER BY
> > > sort_order
> > > Warning: pg_numrows(): supplied argument is not
> a
> > > valid PostgreSQL result resource in
> > > /var/www/doc/include/postgresql.inc.php on line
> 49
> > >
> > > Error! No modules are configured in this system
> > >
> > > I am absoutley stuck on what to do.  All my
> > > variables and account permissions are set
> correctly,
> > > yet it still keeps giving me this error.  Any
> ideas?
> > >
> > >
> > >
> > >     Thank you,
> > >
> > >     Daniel Blavos
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - now with 250MB free storage. Learn
> more.
> > http://info.mail.yahoo.com/mail_250
> >
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250