If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 1 of 1
  1. #1
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Maryland, US
    Member #
    21 times
    PostgreSQL compiles views. That makes sense for performance reasons (why constantly reinterpret the same SQL so many times), but it's brutal for maintenance because decompiling the view, at least as done with SQL Manager 2005 for PostgreSQL, results in completely different SQL than what was used to create the view.

    For example, if you have:
    CREATE OR REPLACE VIEW something AS SELECT * FROM some_table;
    ...and compile and then re-edit it, that * gets expanded to every single column. It gets very ugly when it decompiles a view that contains joins.

    So, is there a way to keep the original SQL within the database, so editing the view is much easier?
    filburt1, Web Design founder
    Site of the Month contest: submit your site or vote for the winner!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
All times are GMT -6. The time now is 01:43 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: