Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    9

    Unhappy Unanswered: system tables : pg_class,pg_attribute

    hey all,
    I have added an attribute to pg_class system table and that attribute is visible in pg_class when i run 'select * from pg_class' but it is not visible in pg_attribute.
    Each & every attribute of every relation is entered in pg_attibute table. So all attributes of pg_class are visible in pg_attribute except the one i have entered.
    Can anyone help me ?? Plz reply asap.
    Regards,
    Aditi

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Never, ever change system tables directly. The only way to add a column is to use ALTER TABLE.

  3. #3
    Join Date
    Sep 2011
    Posts
    9
    Hey,

    I know what u r trying to say but I want to make some changes in system table which i have already done but they are not getting reflected when I run a query.

    Regards,
    Aditi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •