| From: | Tony Capobianco <tcapobianco(at)prospectiv(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | null tablespace? |
| Date: | 2011-12-15 18:41:27 |
| Message-ID: | 1323974487.1988.4.camel@tony1.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have not defined my default tablespace:
show default_tablespace ;
default_tablespace
--------------------
However, I have tables with null tablespaces values in pg_tables:
pg_dw=# select * from pg_tables where tablename = 'source_prev';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------------------+------------+------------+------------+----------+-------------
support | source_prev | jspool | | t | f | f
We have defined out search_path correctly, so what tablespace is this table stored in?
Thanks!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirill Simonov | 2011-12-15 18:52:00 | Re: Logical Aggregate Functions (eg ANY()) |
| Previous Message | Merlin Moncure | 2011-12-15 17:56:31 | Re: CREATE OR REPLACE AGGREGATE |