Description:
Issues relating to INGRES products.
|
|
|
Table Size > 16 GB
|
| |
We’re working to an understanding that there is an absolute table
limitation of 8.3m pages (approximately 16Gb) .
we have a customer who is now very close to hitting the above limits on
a 2k page size .
although increasing page size is an option we would not want to do that
due to concurrency issues that might crop up .... more »
|
|
|
Ingres Dates using jdbc
|
| |
I am new to Ingres, I am sure this must be an old issue but I am having
trouble finding a solution. Using a 9.2 Legacy Ingres DB, I cannot get Squirrel to load 'blank'
dates as anything other than the epoch value '1-JAN-1970....'.
I have updated the iijdbc.properties in the ingresII/ingres/files... more »
|
|
|
Silly ESQL syntax quirk
|
| |
I just noticed that ESQLC insists that the (normally optional) keyword
TABLE is mandatory in COPY TABLE foo ( ...) FROM ....
i.e: E_EQ0070 Missing word 'TABLE' in COPY statement.
Has it always been like that? My mind is going.
(Version II 10.1.0 (int.w32/121))
-- Roy
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.... more »
|
|
|
FYI
|
| |
[link]
-- Roy
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012. The latest information is available from [link].
|
|
|
Effect of errors in a table procedure
|
| |
Hi All,
In a DEP if an error occurs then a certain set of events occur. Things like:
* no byref parameters are updated,
* a rollback of all statements upto the error occurs,
* execution recommences from the first statement after the one which produces the error.... more »
|
|
|
Suppressing error messages from a database procedure.
|
| |
Hi All,
Given a directly executed procedure has a possibility of executing code which will cause an error, how do I suppress the error message?
I still want to trap the error code, but I want to totally handle everything that ensues from the error point.
Example:
create procedure trial_date_cast(... more »
|
|
|
Table procedures and execute procedure
|
| |
Hi All,
Can table procedures (or row producing procedures) use the execute procedure statement?
Unless I'm doing something wrong (which is odds on) it appears that the procedure can be defined with an execute procedure call but the attempt to execute it will fail with:
E_QE0310 Unsupported procedure statement type: CALL... more »
|
|
|
FYI (Ingres Geospatial)
|
| |
I've recently been on the look-out for news about Ingres Geospatial
following the broad hints about the likely timeframe for delivery that
were given at the UK IUA conference in June.
[link]
-- Roy
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.... more »
|
|
|
E_OP0802 and SIGSEGV
|
| |
Hi All.
II 10.0.0 (a64.lnx/132)NPTL + p14200
This simple query generates a SIGSEGV in the errlog.
SELECT v.field_id,v.value,COUNT(v.val ue) AS num_vals
FROM val_int v, field f
WHERE f.field_id IN (20001,20002,20003,20004)
AND f.field_id = v.field_id
AND v.value NOT IN (
SELECT c.ivalue FROM code_int c WHERE c.encoding_id = f.encoding_id... more »
|
|
|
Ingres 9.2 - Why does Ingres think these are the same?
|
| |
The value for varchar colx in two different rows are
'AAA_BBB_12345' and 'AAA BBB 12345'.
Ingres 9.2.1 (a64.lnx/103)NPTL thinks these are the same, but Ingres 10 doesn't.
Ingres 9.2 wont allow this table to be created as btree unique on colx.
Is this a bug or am I missing something?
Thanks... more »
|
|
|
