Bug 118611
| Summary: | user() in core/sql/postgres/drop-all.sql | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Web Application Framework | Reporter: | Carsten Clasohm <clasohm> |
| Component: | installation | Assignee: | ccm-bugs-list |
| Status: | CLOSED WONTFIX | QA Contact: | Jon Orris <jorris> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 6.0 | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2006-07-12 09:09:27 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Closing old tickets. |
From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 Description of problem: With PostgreSQL 7.3.4, running the script core/sql/postgres/drop-all.sql gives the following error: parse error at or near "(" at character 21 That is because "user" is not a function. Changing the last line from select drop_all(user()); to select drop_all(user); fixes this. Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. Create a new PostgreSQL database and create language plpgsql. 2. \i core/sql/postgres/drop-all.sql 3. You will get the error: parse error at or near "(" at character 21 Actual Results: Nothing is dropped. Additional info: