Columns defined not matching pg_attibute

From: Justin Arnold <jharnold81(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Columns defined not matching pg_attibute
Date: 2012-12-12 15:46:16
Message-ID: CAMr08oC5sva0FBSAv1eD7S_bY5DcgnGSzJvrqEPeYcMVqE5k4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey guys, having a bizarre issue I have not seen before and couldn't locate
anything via Google (though I might not be choosing the correct phrasing).
We have a table being dumped via pg_dumpall that is receiving the error...

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: column "raic_state_opt_switch"
of relation "rai_control" does not exist
pg_dump: The command was: COPY public.rai_control (raic_arid, raic_fed_num,
raic_raifac_id, raic_nat_prov_id, raic_fac_name, raic_fac_addr1,
raic_fac_addr2, raic_fac_city, raic_fac_state, raic_fac_zip,
raic_cms_cert_num, raic_fac_contact, raic_fac_phone, raic_fac_ext,
raic_mdsv3_dt, raic_nh_pattype1, raic_nh_pattype2, raic_nh_pattype3,
raic_nh_pattype4, raic_nh_pattype5, raic_nh_provnum1, raic_nh_provnum2,
raic_nh_provnum3, raic_nh_provnum4, raic_nh_provnum5, raic_tickler_fmt,
raic_mds_locking, raic_st_auth, raic_allres_cc_rsm, raic_care_plan_prompt,
raic_use_mult_ltc_dept, raic_dept, raic_dept_fac_id, raic_dept_fed_num,
raic_dept_fac_name, raic_dept_provnum, raic_dept_natprovid,
raic_fed_rate_table, raic_fed_calc_type, raic_state_rug_code,
raic_state_calc_type, raic_state_opt_switch, raic_state_prov_num) TO stdout;
pg_dumpall: pg_dump failed on database "site", exiting.

A "\d" on said table returns...

Table "public.rai_control"
Column | Type | Modifiers
------------------------+-------------------------+-----------
raic_arid | numeric(4,0) | not null
raic_fed_num | character varying(12) |
raic_raifac_id | character varying(16) |
raic_nat_prov_id | character varying(10) |
raic_fac_name | character varying(30) |
raic_fac_addr1 | character varying(30) |
raic_fac_addr2 | character varying(30) |
raic_fac_city | character varying(20) |
raic_fac_state | character varying(2) |
raic_fac_zip | character varying(11) |
raic_cms_cert_num | character varying(12) |
raic_fac_contact | character varying(30) |
raic_fac_phone | character varying(10) |
raic_fac_ext | character varying(5) |
raic_mdsv3_dt | date |
raic_nh_pattype1 | character varying(1) |
raic_nh_pattype2 | character varying(1) |
raic_nh_pattype3 | character varying(1) |
raic_nh_pattype4 | character varying(1) |
raic_nh_pattype5 | character varying(1) |
raic_nh_provnum1 | character varying(15) |
raic_nh_provnum2 | character varying(15) |
raic_nh_provnum3 | character varying(15) |
raic_nh_provnum4 | character varying(15) |
raic_nh_provnum5 | character varying(15) |
raic_tickler_fmt | character varying(1) |
raic_mds_locking | character varying(1) |
raic_st_auth | character varying(1) |
raic_allres_cc_rsm | character varying(1) |
raic_care_plan_prompt | character varying(1) |
raic_use_mult_ltc_dept | character varying(1) |
raic_dept | numeric(3,0)[] |
raic_dept_fac_id | character varying(16)[] |
raic_dept_fed_num | character varying(12)[] |
raic_dept_fac_name | character varying(30)[] |
raic_dept_provnum | character varying(14)[] |
raic_dept_natprovid | character varying(10)[] |
raic_fed_rate_table | character varying(1) |
raic_fed_calc_type | character varying(1) |
raic_state_rug_code | character varying(2) |
raic_state_calc_type | character varying(1) |
raic_state_opt_switch | character varying(1) |
raic_state_prov_num | character varying(15) |
Indexes:
"raic_pkey" PRIMARY KEY, btree (raic_arid)

and "SELECT * FROM pg_attribute WHERE attrelid IN (SELECT oid FROM pg_class
WHERE relname = 'rai_control');" returns...

attrelid | attname | atttypid | attstattarget | attlen |
attnum | attndims | attcacheoff | attt
ypmod | attbyval | attstorage | attalign | attnotnull | atthasdef |
attisdropped | attislocal | attinhcount
----------+------------------------+----------+---------------+--------+--------+----------+-------------+-----
------+----------+------------+----------+------------+-----------+--------------+------------+-------------
21198 | tableoid | 26 | 0 | 4 |
-7 | 0 | -1 |
-1 | t | p | i | t | f | f
| t | 0
21198 | cmax | 29 | 0 | 4 |
-6 | 0 | -1 |
-1 | t | p | i | t | f | f
| t | 0
21198 | xmax | 28 | 0 | 4 |
-5 | 0 | -1 |
-1 | t | p | i | t | f | f
| t | 0
21198 | cmin | 29 | 0 | 4 |
-4 | 0 | -1 |
-1 | t | p | i | t | f | f
| t | 0
21198 | xmin | 28 | 0 | 4 |
-3 | 0 | -1 |
-1 | t | p | i | t | f | f
| t | 0
21198 | ctid | 27 | 0 | 6 |
-1 | 0 | -1 |
-1 | f | p | s | t | f | f
| t | 0
21198 | raic_arid | 1700 | -1 | -1 |
1 | 0 | -1 | 2
62148 | f | m | i | t | f | f
| t | 0
21198 | raic_fed_num | 1043 | -1 | -1 |
2 | 0 | -1 |
16 | f | x | i | f | f | f
| t | 0
21198 | raic_raifac_id | 1043 | -1 | -1 |
3 | 0 | -1 |
20 | f | x | i | f | f | f
| t | 0
21198 | raic_nat_prov_id | 1043 | -1 | -1 |
4 | 0 | -1 |
14 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_name | 1043 | -1 | -1 |
5 | 0 | -1 |
34 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_addr1 | 1043 | -1 | -1 |
6 | 0 | -1 |
34 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_addr2 | 1043 | -1 | -1 |
7 | 0 | -1 |
34 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_city | 1043 | -1 | -1 |
8 | 0 | -1 |
24 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_state | 1043 | -1 | -1 |
9 | 0 | -1 |
6 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_zip | 1043 | -1 | -1 |
10 | 0 | -1 |
15 | f | x | i | f | f | f
| t | 0
21198 | raic_cms_cert_num | 1043 | -1 | -1 |
11 | 0 | -1 |
16 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_contact | 1043 | -1 | -1 |
12 | 0 | -1 |
34 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_phone | 1043 | -1 | -1 |
13 | 0 | -1 |
14 | f | x | i | f | f | f
| t | 0
21198 | raic_fac_ext | 1043 | -1 | -1 |
14 | 0 | -1 |
9 | f | x | i | f | f | f
| t | 0
21198 | raic_mdsv3_dt | 1082 | -1 | 4 |
15 | 0 | -1 |
-1 | t | p | i | f | f | f
| t | 0
21198 | raic_nh_pattype1 | 1043 | -1 | -1 |
16 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_pattype2 | 1043 | -1 | -1 |
17 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_pattype3 | 1043 | -1 | -1 |
18 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_pattype4 | 1043 | -1 | -1 |
19 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_pattype5 | 1043 | -1 | -1 |
20 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_provnum1 | 1043 | -1 | -1 |
21 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_provnum2 | 1043 | -1 | -1 |
22 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_provnum3 | 1043 | -1 | -1 |
23 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_provnum4 | 1043 | -1 | -1 |
24 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
21198 | raic_nh_provnum5 | 1043 | -1 | -1 |
25 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
21198 | raic_tickler_fmt | 1043 | -1 | -1 |
26 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_mds_locking | 1043 | -1 | -1 |
27 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_st_auth | 1043 | -1 | -1 |
28 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_allres_cc_rsm | 1043 | -1 | -1 |
29 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_care_plan_prompt | 1043 | -1 | -1 |
30 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_use_mult_ltc_dept | 1043 | -1 | -1 |
31 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_dept | 1231 | -1 | -1 |
32 | 1 | -1 | 1
96612 | f | x | i | f | f | f
| t | 0
21198 | raic_dept_fac_id | 1015 | -1 | -1 |
33 | 1 | -1 |
20 | f | x | i | f | f | f
| t | 0
21198 | raic_dept_fed_num | 1015 | -1 | -1 |
34 | 1 | -1 |
16 | f | x | i | f | f | f
| t | 0
21198 | raic_dept_fac_name | 1015 | -1 | -1 |
35 | 1 | -1 |
34 | f | x | i | f | f | f
| t | 0
21198 | raic_dept_provnum | 1015 | -1 | -1 |
36 | 1 | -1 |
18 | f | x | i | f | f | f
| t | 0
21198 | raic_dept_natprovid | 1015 | -1 | -1 |
37 | 1 | -1 |
14 | f | x | i | f | f | f
| t | 0
21198 | raic_fed_rate_table | 1043 | -1 | -1 |
38 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_fed_calc_type | 1043 | -1 | -1 |
39 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_state_rug_code | 1043 | -1 | -1 |
40 | 0 | -1 |
6 | f | x | i | f | f | f
| t | 0
21198 | raic_state_calc_type | 1043 | -1 | -1 |
41 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_state_opt_switch | 1043 | -1 | -1 |
42 | 0 | -1 |
5 | f | x | i | f | f | f
| t | 0
21198 | raic_state_prov_num | 1043 | -1 | -1 |
43 | 0 | -1 |
19 | f | x | i | f | f | f
| t | 0
(49 rows)

yet when I run "SELECT * FROM rai_control;" I get the header of...

raic_arid | raic_fed_num | raic_raifac_id | raic_nat_prov_id |
raic_fac_name | raic_fac_addr1 | raic_fac_addr2 | raic_fac_city |
raic_fac_state | raic_fac_zip | raic_cms_cert_num | raic_fac_contact |
raic_fac_phone | raic_fac_ext | raic_mdsv3_dt | raic_nh_pattype1 |
raic_nh_pattype2 | raic_nh_pattype3 | raic_nh_pattype4 | raic_nh_pattype5 |
raic_nh_provnum1 | raic_nh_provnum2 | raic_nh_provnum3 | raic_nh_provnum4 |
raic_nh_provnum5 | raic_tickler_fmt | raic_mds_locking | raic_st_auth |
raic_allres_cc_rsm | raic_care_plan_prompt | raic_use_mult_ltc_dept |
raic_dept | raic_dept_fac_id | raic_dept_fed_num |
raic_dept_fac_name | raic_dept_provnum | raic_dept_natprovid |
raic_fed_rate_table | raic_fed_calc_type | raic_state_rug_code |
raic_state_calc_type
-----------+--------------+----------------+------------------+----------------------+-----------------+----------------+---------------+----------------+--------------+-------------------+------------------+----------------+--------------+---------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+--------------+--------------------+-----------------------+------------------------+---------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+--------------------+---------------------+----------------------

which is missing the last 2 columns defined by pg_attribute and \d.
Any ideas on what I can look at or do to correct this problem (if it can be
corrected)?

We are running postgres 8.3.4 on 64 bit Red Hat kernel
release 2.6.18-164.el5

Thanks for the help!

- Justin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2012-12-12 16:17:31 JDBC to load UTF8@psql to latin1@mysql
Previous Message Martin French 2012-12-12 15:37:55 Re: C Function Memory Management