Thread: [NOVICE] ERROR: expected one dependency record for TOAST table, found 0

I'm getting an error while trying to add a column to a table.

ALTER TABLE v_users ADD COLUMN ldap_id SERIAL UNIQUE;
ERROR:  expected one dependency record for TOAST table, found 0

Any ideas?

-- 


Dean Montgomery 
Network Support Tech./Programmer 
School District #73 


----This message appears to be signed.  Please press the [SD73 Verifier] button to confirm authenticity.----

$-$-%-$RGVhbiBNb250Z29tZXJ5OklUIFNlcnZpY2VzOlJWSlNUMUk2SUNCbGVIQmxZM1JsWkNCdmJtVWdaR1Z3Wlc1a1pXNWplU0J5WldOdmNtUWdabTl5SUZSUFFWTlVJSFJoWW14bExDQm1iM1Z1WkNBdzoyMDE3LTExLTE3$
24ccd961cfa79f250a12e7db5183d723%b703012e78c411d3e06fb3089442d375$-$-%-$
 
----Any part of the message that appears below this point is not guaranteed to be from the author of this message and
shouldbe IGNORED.----
 


-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Solved by dumping, dropping, then re-importing the table.

pg_dump -f v_users.sql -d fusionpbx -t v_users
DROP INDEX v_users_pkey;
DROP TABLE v_users;
cat v_users.sql | psql fusionpbx

----- Original Message -----
> I'm getting an error while trying to add a column to a table.
> 
> ALTER TABLE v_users ADD COLUMN ldap_id SERIAL UNIQUE;
> ERROR:  expected one dependency record for TOAST table, found 0
> 
> Any ideas?