Ronald Pringadi's Technical Notes

  • About Me
  • Integer Array Casting in PostgreSQL


    -- Rule: "_DELETE" ON sometable
    -- DROP RULE "_DELETE" ON sometable;

    CREATE OR REPLACE RULE "_DELETE" AS
    ON DELETE TO sometable DO INSTEAD DELETE FROM _sometable
    WHERE _sometable.account_id = old.account_id AND (old.domain_id = ANY ((( SELECT get_visible_domains('DELETE'::text) AS get_visible_domains)::integer[])));

    August 24, 2011
  • Tracing PostgreSQL Error Log

    /pgsql/dev-db/tail -f postgresql.log

    August 24, 2011
  • Reset Sequence using PostgreSQL

    SELECT setval('YOUR_SEQUENCE_NAME', (SELECT MAX(id) FROM YOUR_TABLE_NAME));

    August 24, 2011
←Previous Page
1 … 9 10 11
  • Android (1)
  • C# (1)
  • Database (19)
    • MongoDB (1)
    • MySQL (3)
    • PostgreSQL (15)
  • docker (1)
  • Hardware (1)
    • Benchmark (1)
  • Investment (3)
    • Stock Market (3)
  • java (4)
  • LDAP and Active Directory (1)
  • Operating System (51)
    • DOS (2)
    • Linux (46)
      • Bash (9)
    • Ubuntu (11)
    • Version Control (2)
    • Windows 7 (2)
  • Python (1)
  • Uncategorized (12)
  • Visual Basic (1)
  • Web Development (12)
    • javascript (5)
      • Ext Js (1)
    • php (6)