Messages posted by: Anonymous

Do you truly have 255 1 byte ints in the row? There is a boolean datatype that is stored as a bit which could save on the storage. Perhaps if you explained your needs further we can come up with another alternative for you.

Thanks Muhammad

Thanks for the reply... What I really need is a 1-byte equivalent...

In our MySQL database, we have a table which stores only 1-byte (only) integer values which can accomodate a maximum of 255 lookup values. With this technique, we were able to decrease the size of each record by at least 100 bytes. For more than 1 million records, this means 100 million bytes savings on our (low-cost) server... Faster processing was also achieved...

I wish the 1-byte it will be supported by Postgresql/EnterpriseDB in the future...

Version: EnterpriseDB 8.1.4.19 on i686-pc-linux-gnu

Version:
EnterpriseDB 8.1.4.19 on i686-pc-linux-gnu

There is a smallint that uses 2 bytes.

Try running it from the command line in edb-psql. What version are you using?

Hi,

When I execute the above query , getting the below error!

ERROR: unrecognized node type: 339

Pls Explain me.
Thanks,

Please send the "explain analyze" for this query.

Yelena,
This is due to the fact that in EnterpriseDB DDL is transactional. While running the script with edb-psql each DDL statement is run individually, so any errors are self contained, but while running it through JDBC, everything is run in a single transaction. This causes any errors like a table not existing to put the transaction into an error state that needs to be properly handled.

Hi,

How to create the below fuction as a immutable.
Pls advise me

-----------------
CREATE OR REPLACE FUNCTION fn_checkForMgr(
ip_subjectPersonId IN BIGINT,
ip_raterPersonId IN BIGINT,
ip_mgrTypeCodeValueId IN BIGINT
) RETURN BOOLEAN
AS
v_orgunitpersonid bigint;
v_orgPersonTypeCodeValueId bigint;
v_checkForExistingMgr int;
v_checkForExistingDirMgr int;
v_checkForExistingNonDirMgr int;
BEGIN
SELECT orgunitpersonid,orgPersonTypeCodeValueId
INTO v_orgunitpersonid,v_orgPersonTypeCodeValueId
FROM org_unit_person
WHERE personid =ip_subjectPersonId;

SELECT COUNT(sno)
INTO v_checkForExistingMgr
FROM ORG_UNIT_PERSON_MANAGER_RELATIONSHIP
WHERE orgunitpersonid = v_orgunitpersonid
--AND managerpersonid = ip_raterPersonId
AND managerpersonrelationshiptypecodevalueid =ip_mgrTypeCodeValueId;

SELECT COUNT(sno)
INTO v_checkForExistingNonDirMgr
FROM ORG_UNIT_PERSON_MANAGER_RELATIONSHIP
WHERE orgunitpersonid = v_orgunitpersonid
--AND managerpersonid = ip_raterPersonId
AND managerpersonrelationshiptypecodevalueid != 900;

SELECT COUNT(sno)
INTO v_checkForExistingDirMgr
FROM ORG_UNIT_PERSON_MANAGER_RELATIONSHIP
WHERE orgunitpersonid = v_orgunitpersonid
--AND managerpersonid = ip_raterPersonId
AND managerpersonrelationshiptypecodevalueid =900;

IF ( v_checkForExistingMgr = 0 AND v_checkForExistingNonDirMgr <= 1 AND ip_mgrTypeCodeValueId = 900 )
OR ( v_checkForExistingMgr = 0 AND v_checkForExistingNonDirMgr = 0 AND ip_mgrTypeCodeValueId != 900 )
THEN
RETURN TRUE;
ELSE
RETURN FALSE;

END IF;

END;

Thanks,

Thanks for the information.. i am able to connect it now

thanks for yr reply

Hello, Craig-san

Thank you.

I could see the drop down menus by using the mouse.
However, it's difficult to accept the UI that assumes the use of mouse. Visually impaired people do not use the mouse but the keyboard. For example, when using Internet Explorer, they press Tab to navigate to the desired link or button, and press Enter instead of clicking it. Screen reader software like JAWS does not seem to read the drop down menus that EDB employs. Oracle Enterprise Manager (OEM) does not use such a menu. OEM constructs pages by using standard HTML tags (links, buttons, etc.)
I strongly wish you to improve the usability so that various people can use the GUI without difficulty. The only problem I saw so far is the drop down menu. I think it's better to use standard HTML links rather than the dynamic drop down menu with OnMouseOver event. OEM does so (though OEM is not complete in that it uses many images without attaching alternative text to the alt attribute of the <img> tag).

Regards

Hello,

Thank you for your quick reply.
I guessed that the uninstaller was in uninst/. But that is a mere guess. Users cannot be sure about what is not documented.
I hope you document things related to installation/uninstallation, including silent operations, in the near future.

Check out the COPY command:
http://www.enterprisedb.com/documentation/8.2/tutorial-populate.html

i meant i've installed latest jre (not test) and still the same issue with blank popup...

Hi,

I too got the same error as described above in log.txt while trying to install 8.2.4.12 version. the install logs are as follows :

initdb_stderr
-------------
The program "edb-postgres" is needed by initdb but was not found in the
same directory as "C:/EnterpriseDB/8.2/dbserver/bin/initdb".
Check your installation.

initerr
-------

CPAU V01.10.00cpp Joe Richards (joe@joeware.net) October 2004

initdb_stdout
-------------

nothing ... just empty

init_out
--------

Adjusting rights for current user to impersonate(required for Windows 2000 based systems)...
Granting SeTcbPrivilege to CEREBRALSYSTEMS\rskw ... successful
Calling initdb as user enterprisedb...
Process Created...

The command completed successfully.

Done!

Pls let me know the solution.

Thanks.

Thanks Craig. I'll have a look

Dear Shawn,

Please visit the following link to see a tutorial on PG Instant Rails.

http://tutorials.enterprisedb.com/

I hope this helps.

Thank you,

Same Problem. I've tried using a character above 128 <ALT>+132(ä) but receive a 'must use single character' error message on import. The data is not importing.

There error message is:

"There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.

ERROR [HY000] Error while executing the query'
ERROR: relation "bizserv.comm_codes" does not exist"

My SQL statement is "select * from bizserv.comm_codes".

Bobby

Hi Fahd Najmi,

Just wanted to say THANKS! This solve the problem.

Jim,

A Happy New Year to you and thanks for your feedback.
Could you comment on the "PRAGMA RESTRICT_REFERENCES" issue too? Much appreciated.

Regards,

JB

Welcome,
I have same problem, but also on windows 2000 professional, windows 2000 server and Debian (from Debian.org iso image, kernel 2.6.1

. Also, same massage is generated on many hardware platforms (I checked on 3 systems on W2k Prof and on VMware Debian and Windows 2k server).

Here is compressed all I get after the installation on W2k Prof: http://www.speedyshare.com/674291945.html log.txt from main folder and files from install_logs folder.

Could anyone help?

Also, I tried both 8.2 and 8.3 EDB. Both wit the same result!

Regards and happy New Year!

Hello Fahd,

Pls help me out in this..

Regards,
Anshuman