Description:
Issues relating to INGRES products.
|
|
|
Identify Lock
|
| |
Guys, Sometimes my users call me and tell me that the system is slow, then I open IPM and I see a lot of users in WAIT state, then I have to identify who is the responsable for the lock and I kill him. ;-) (kill the session lol...). Is there a way to identify this locks before my users call me ? One... more »
|
|
|
join using syntax versus join on syntax
|
| |
Hi Everyone, I have two queries which are identical save for the from clause, one uses the 'join using' syntax the other uses the 'join on' syntax. In 9.0.4 (a64.lnx) they produce different query plans and the 'join using' plan produces the poorer results ( by a factor of 4). In 9.1.1 (a64.lnx) they produce identical plans.... more »
|
|
|
Ingres PHP Driver
|
| |
What are the plans for the Ingres PHP driver? Will I be able to use it with web apps like media wiki, joomla, oscommerce, and wordpress? would be cool!
|
|
|
table checkpoint on partitioned table
|
| |
Hi Everyone, II 9.1.1 (a64.lnx/103)NPTL + patch13001 I've just tried to table level checkpoint a partitioned table and had it explode. Try this...and let me know how you get on... Martin Bowes 1. createdb bowtest; ckpdb +j bowtest 2. sql bowtest << SQL_END \r set autocommit on; \p\g create table test_blob_backup(a integer, b long varchar)... more »
|
|
|
underscore and ingres 2006
|
| |
We use Ingres a64.lnx 9.1.1 (it's 2006 release 2 service pack 1 and patch 12855) and I have a problem with underscore: select * from tmp where text like 'a_' - returns no rows select * from tmp where text like 'a\_' escape '\' - returns 1 row select * from tmp where text = 'a1' - returns 1 row select * from tmp where text like 'a%' - returns 6 rows... more »
|
|
|
Videos from Interpreted programming osbootcamp posted
|
| |
Hi Everyone, The videos from Thursday's osbootcamp covering interpreted programming languages are posted. Talks included Perl, Python, and Ruby. We've also posted a video from a celebration of the Ingres CAFÉ LinuxWorld award for Best application development tool. Speakers at that event include: Ian Graham ([link])... more »
|
|
|
problem accessing webex archive
|
| |
I downloaded DisasterRecoveryWithReplicatio n.arf from here: [link] The webex network player says unknown file format. I've been to webex to make sure I have the latest software. Is anyone else having a problem with this presentation? Thanks in advance Paul... more »
|
|
|
FW: How to insert control characters intovarcharcolumn
|
| |
2008/8/28 Paul White <pwh...@peercore.com.au> ...Actually it does but it's perhaps not readily apparent ;) In a regular (codepage 850) DOS window if you do this: copy con: file.txt É (using alt-0201) ^Z then look at file.txt in a hex editor you should see that that char is... more »
|
|
|
Mutex: DCB iidbdb
|
| |
Hi everyone, I'm running II 9.1.1 (a64.lnx/103)NPTL + patch13001 on Red Hat Enterprise Linux Server release 5 (Tikanga). About once a week my servers freeze up and new connections stall in Mutex: DCB iidbdb This sucks big time. I've checked on the Ingres Tech support site and there are three old... more »
|
|
|
How to insert control characters into varchar column
|
| |
Hi, I need to reproduce a problem that is occurring in a database. I think that stray control characters are being added to a varchar column. Can anyone tell me how to insert control characters using terminal monitor or qbf so I can test my theory? TIA.
|
|
|
