Messages posted by: Anonymous

The code went into CVS last week. It differed from the downloadable source tar ball in that it had a somewhat different directory structure.

I just updated the original source tar ball to reflect these changes. If you previously downloaded the code, you might want to obtain this version, or better yet, get the source from CVS.

Thanks,

Mason

Setup stopped for me on debian etch 32bit at 49% without any usefull message. I installed termcap from the ubuntu libs, but did not manage to get it working.

I had to use a CentOS 5 setup to get the installer running.

testing message

the strangest thing is that there were no errors from the migration studio, the triggers were ignored!

CREATE OR REPLACE TRIGGER rrpi_LACLASSEV2_CREDITS
AFTER INSERT ON LACLASSEV2.CREDITS
--------------------------------------------------------
-- GENERATED BY EnterpriseDB Replicator
-- 2008-03-10 16:33:03 CET
-- DON'T MAKE CHANGES IN THE CODE.
--------------------------------------------------------

FOR EACH ROW
BEGIN
INSERT INTO RRST_LACLASSEV2_CREDITS
(rrep_sync_id, rrep_operation_type, id, lib, description, type, url, content_type, content_length, mail, date_modified, content_description, ordre_affichage)
VALUES (rrep_tx_seq.NEXTVAL, 'I', :NEW.ID, :NEW.LIB, :NEW.DESCRIPTION, :NEW.TYPE, :NEW.URL, :NEW.CONTENT_TYPE, :NEW.CONTENT_LENGTH, :NEW.MAIL, :NEW.DATE_MODIFIED, :NEW.CONTENT_DESCRIPTION, :NEW.ORDRE_AFFICHAGE);
END

1/ why there is no system catalogs viewed for my db like edb's one, in the migration studio?

2/ what about my packages that call schemas in sys one, like http_headers, dbf_reader, dbms_lob, dbms_standard, json, owa_util, use_clob, ..., dbms_obfuscation, and so on!

3/ so what about the dependencies between the different objects, after partial migration with edb migration studio?

best regards

hi
Thank you for ur response.,
i will try tht and will let you know if this resoleves the problem.

Nobody answer my question, I cant proceed to next phase which is test the 8.3 new features.

===========initdb_stderr.txt:
initdb: 无法为 locale "zh_CN.GB18030" 找到合适的编码
带 -E 选项重新运行 initdb.
请用 "initdb --help" 获取更多的信息.
===========

Now I know why EDB can't install!

Has any arguments on "edb-linux-x86_82412.bin" can change the locale?

Hello,

I'd hope EnterpriseDB to support COBOL, too. Many of our customers have assets written in COBOL.

And which AIX version that can EDB support now?
Which Solaris version that can EDB support now?

And which AIX version that can EDB support now?

I have exactly the same error on win 2003 server with Active Directory.

The windows db/client I installed is 8.3.0.8 and the linux box is 8.2.3.6.

Is the database you are trying to connect to an earlier version of EnterpriseDB?

Can you post an example of your package? The error is probably not with the VARCHAR2 reference but with something in the package close by.

Dear Farrukh,

Thanks for your reply.

I ran the query without date function.

it was success

Sudusinghe

Thank you Muhammad Farrukh, replace(columnName,E'\n') working fine.

pls give a reply

sorry. i found the answer

statics are below

for first query

Seq Scan on pawntransaction (cost=0.00..19862.18 rows=311648 width=21) (actual time=3.150..5942.468 rows=329124 loops=1)
Filter: (transactiondate >= to_date('2/1/2007'::character varying, 'dd/mm/yyyy'::character varying))
Total runtime: 6400.685 ms

for second query

Seq Scan on pawntransaction (cost=0.00..19862.18 rows=37 width=21) (actual time=4259.830..4845.209 rows=37485 loops=1)
Filter: (transactiondate >= to_date('2/1/2008'::character varying, 'dd/mm/yyyy'::character varying))
Total runtime: 4899.739 ms

how i take it ?

...
seems like no reply..
but i've gotten my answer..

after some search, i found some post stating that compiz does not goes well with java 6 or below...

in order to fix it, we need to set our environment at
/etc/profile or set at console
export AWT_TOOLKIT="MToolkit"

Hello Muhammad,

Yes, that's it !

Thanks a lot !
Best regards, Nico

I am also getting same error although i install into Windows Server 2003 with SP2...
regards,

Ok I have a lookup table named "Dept" with fields "Id", "Code", "Name", etc. The "Id" field is an autoincrement Tinyint (1 byte only) field since we know the no. of departments in the company would not exceed 255. The values in "Id" fields are the ones being stored in transaction or information tables and when the "Code" or "Name" is needed, a simple LEFT JOIN suffice.

Of course, I can use Smallint (2-bytes) here but I would like to use only the least storage possible (1 byte) as offered in MySQL or MS SQL Server.

Many of our lookup tables simply use "Id" and "Name" fields and these are stored and retrieved automatically by the user interface.

Instead of trying this from the Visual Explain tool, try it from the command line edb-psql.