× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2008-05-02T23:19:11Z  · last modified 2008-05-09T21:25:47Z

Scripting Grant in PostgreSQL -- > org.postgresql.util.PSQLException


Priority Minor
Complexity Easy
Component App - Files Browser
Version 07.0

Server PostgreSQL 7.3.3 -72

open HELP --View LOG in ADS  to see the error log

Object table postgres.alter_table in database testdb

Right click on the Object  and Script to Object window as GRANT

In error log :::::::

org.postgresql.util.PSQLException: ERROR:  Function makeaclitem(integer, integer, integer, text, boolean) does not exist
 Unable to identify a function that satisfies the given argument types
 You may need to add explicit typecasts
 at org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecutorImpl.java:557)
 at org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:480)
 at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
 at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236)
 at nmfl.amC.a(Unknown Source)
 at nmfl.amC.a(Unknown Source)
 at nmfl.aeb.a(Unknown Source)
 at nmfl.aeb.a(Unknown Source)
 at nmfl.bg.a(Unknown Source)
 at nmfl.aHF.a(Unknown Source)
 at nmfl.agi.a(Unknown Source)
 at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
 at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
 at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
 at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
 at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
 at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
 at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
 at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
 at java.awt.Component.processMouseEvent(Component.java:6041)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
 at java.awt.Component.processEvent(Component.java:5806)
 at java.awt.Container.processEvent(Container.java:2058)
 at java.awt.Component.dispatchEventImpl(Component.java:4413)
 at java.awt.Container.dispatchEventImpl(Container.java:2116)
 at java.awt.Component.dispatchEvent(Component.java:4243)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
 at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
 at java.awt.Container.dispatchEventImpl(Container.java:2102)
 at java.awt.Window.dispatchEventImpl(Window.java:2440)
 at java.awt.Component.dispatchEvent(Component.java:4243)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

Issue #1354

Closed
Fixed
Resolved 2008-05-09T21:25:47Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017