structured-errors.td 810 B

123456789101112131415161718192021222324252627
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. # Testing user-focused error messages
  10. > CREATE SECRET pgpass AS 'postgres'
  11. ! CREATE CONNECTION pg TO POSTGRES (
  12. HOST 'localhost',
  13. PORT 5433,
  14. DATABASE postgres,
  15. USER postgres,
  16. PASSWORD SECRET pgpass
  17. )
  18. contains:error connecting to server:
  19. > CREATE MATERIALIZED VIEW mv as SELECT 1;
  20. # test that `hint:` works!
  21. ! DROP VIEW mv
  22. contains:is not a view
  23. hint:Use DROP MATERIALIZED VIEW to remove a materialized view.