[OPEN-ILS-DEV] cstore problem

[Don Hamilton]

Hi again... sorry about not responding to the list, Don... Me bad,
again!..
 
Anyway, \dt also only shows the 4 tables that hennie reported.
I did find ~/Evergreen/Open-ILS/src/sql/Pg/build-db.sh, and ran it,
entering the password several times, and watching output that looked
like it was working... but still no tables show with a \dt.
 
don

>>> don.mcmorris at gmail.com 5/15/2007 2:15 AM >>>

My bad guys! \z is privileges.  Instead, run \dt.  According to the
manual, this should show the tables.

--Don

On 5/15/07, Hennie Rautenbach <hennie at sabinet.co.za> wrote:
> Don McMorris wrote:
> > First, I want to make sure the PostgreSQL server is functioning
right
> > and that the evergreen database is populated properly.  To do
this:
> > root# su postgres -c "psql -h tamarak -p 5432 -U evergreen
evergreen"
> > evergreen> \z
> > evergreen> \q
> > root#
> Thought I'd do the same:
>
> opensrf at leo:~$ psql -h leo.sabinet.co.za -p 5432 -U postgres
evergreen
> Password for user postgres:
> Welcome to psql 8.1.8, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>
> evergreen=# \z
>     Access privileges for database "evergreen"
>  Schema |     Name     | Type  | Access privileges
> --------+--------------+-------+-------------------
>  public | pg_ts_cfg    | table |
>  public | pg_ts_cfgmap | table |
>  public | pg_ts_dict   | table |
>  public | pg_ts_parser | table |
> (4 rows)
>
> evergreen=# \q
> opensrf at leo:~$
>
> Hennie
>
>
>
--------------------------------------------------------------------------------
>
> This transmission is for the intended addressee only and is
confidential
> information. If you have received this transmission in error, please
> delete it and notify the sender. The contents of this e-mail are the
> opinion of the writer only and are not endorsed by Sabinet Online
> Limited unless expressly stated otherwise.
>
--------------------------------------------------------------------------------
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20070515/c1d98aeb/attachment.html