Re: [NOVICE] ERROR: expected one dependency record for TOASTtable, found 0 - Mailing list pgsql-novice

From Dean Montgomery
Subject Re: [NOVICE] ERROR: expected one dependency record for TOASTtable, found 0
Date
Msg-id 902315348.25959506.1511208736351.JavaMail.zimbra@zimbra.sd73.bc.ca
Whole thread Raw
In response to [NOVICE] ERROR: expected one dependency record for TOAST table, found 0  (Dean Montgomery <dmonty@sd73.bc.ca>)
List 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?


pgsql-novice by date:

Previous
From: Stephen Frost
Date:
Subject: Migration to PGLister - After
Next
From: Craig H
Date:
Subject: macOS ownership and premissions