dbTalk Databases Forums  

Sponsored Links


comp.databases.ingres comp.databases.ingres


Discuss in the comp.databases.ingres forum.



Post New Thread
Threads in Forum : comp.databases.ingres Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi All, I'm trying to do the following update... update holding_3 h from tiny_int_speed t set field3 = case when field3 is null and t.field_id = 3...
Martin Bowes
02-03-2011 01:53 PM
Martin Bowes Go to last post
2 40
Adrian, I presume that hacking of the client image would be your preferred solution as it is the single point of the problem and would against...
Ian Kirkham
02-03-2011 08:55 AM
Ingres Forums Go to last post
1 50
Peter, I did this quite awhile ago when few people realised this. Ingres eventually pointed this out after a week of dealing with my issue. Maybe...
Ingres Forums
02-03-2011 04:16 AM
Roy Hann Go to last post
10 77
rhill (AT) hillconsult (DOT) com wrote: Roger! Long time. Nice to hear from you. WireShark is a tool I rate and keep handy on my key-ring flash...
Roy Hann
02-01-2011 08:55 AM
Ingres Forums Go to last post
18 73
Hi, Odd query. In mysql I can run a dtrace script as follows to list all sql statements being executed by the mysql process #!/usr/sbin/dtrace...
Zfs..
01-27-2011 11:04 AM
Zfs.. Go to last post
8 52
Hi All, It's a mild peeve.... If I create a table where a column defaults to a sequence.nextval, and grant insert on the table to a bunch of users,...
Martin Bowes
01-26-2011 02:42 AM
Roy Hann Go to last post
1 45
On 25/01/11 08:21, nikosv_ wrote: NFC with the createdb "-i" flag. See http://bit.ly/Ingres92createdb for more info. g -- Grant Croker, Ingres...
Martin Bowes
01-25-2011 02:55 AM
Grant Croker Go to last post
5 59
I havenít used database events before and I have a situation that at the first day of every month an inventory check has to been done which will...
nikosv
01-20-2011 02:57 PM
Ingres Forums Go to last post
5 54
as far as IP logging is concered I will re-direct you to this post "does security auditing log user...
nikosv
01-18-2011 04:11 AM
Ray Fan Go to last post
2 50
Hi All. I'm trying to trace a user who keeps stufffing up their username and password. Sadly this isn't as easy as it seems.... The errlog is...
Martin Bowes
01-17-2011 08:59 AM
Martin Bowes Go to last post
2 42
Hi All, How do I set the float format when connecting to a database with perl DBI? I'm looking for smething which would be equivalent ot the...
Martin Bowes
01-04-2011 05:44 AM
Ingres Forums Go to last post
7 38
Hi All, I'm upgrading to Ingres10 on an installation with lots of distributed databases. First gotcha was that upgradedb -all really bitched at the...
Martin Bowes
12-30-2010 04:38 AM
Roy Hann Go to last post
8 39
Friday, December 24, 2010, 8:19:09 PM, you wrote: Nope, you can claim the privileges of only one group at at time. Roy -- UK Ingres Users...
Martin Bowes
12-24-2010 03:50 PM
Roy Hann Go to last post
4 42
it's look like ... -- Jean-Pierre Zuate La Fage Conseil +33(0)6 11 40 11 09 jean-pierre.zuate (AT) lafageconseil (DOT) fr http://lafageconseil.fr/
Jean-Pierre Zuate, La Fage Conseil
12-07-2010 09:58 AM
Jean-Pierre Zuate, La Fage Conseil Go to last post
2 46
I have a rather annoying little problem thanks to the way SQL treats nulls in aggregate functions. Normally nulls are ignored in aggregates, like...
Roy Hann
11-19-2010 10:00 AM
Roy Hann Go to last post
4 45
Is it possible for the security auditing to log the user IP or terminal? I guess it could be since he uses a socket to connect to the dbms server?
nikosv
11-15-2010 11:23 AM
nikosv Go to last post
4 42
This is one of many articles trumpeting basically the same...
Roy Hann
11-10-2010 09:09 AM
Ingres Forums Go to last post
2 45
Hi all, has anybody tried out Ingres on those modern non-mechanical "disks"? What are your experiences? Regards Gerhard
Gerhard Hofmann
11-08-2010 09:32 AM
Ingres Forums Go to last post
1 41
Martin - The team looked at this and they indicated we are handling START databases correctly as follows: When you create a STAR database...
Pamela Fowler
11-04-2010 04:39 AM
Paul Mason Go to last post
2 51
Hi, I'm using Ingres 9.0.4 and have the following table (I've simplified this to make it easier to explain): create table students (student_id ...
Simon Roust
11-03-2010 12:12 PM
Simon Roust Go to last post
2 50
Hi All, I hope one day to develop a backbone... I have a user request to make an OME function which mimics the quasi base64 encoding they are...
Martin Bowes
11-02-2010 02:34 AM
Martin Bowes Go to last post
6 44
May I ask what this has to do with Ingres? Does this... yellowfin use Ingres as a database backend? -- dejan
Ingres Forums
10-29-2010 02:20 PM
Ingres Forums Go to last post
2 51
Before I log a call, anyone out there know what the above error means? I know it's probably something to do with the optimizer. And it's a...
Gareth Williams
10-28-2010 06:26 AM
Ingres Forums Go to last post
5 113
We have a commercial of the shelf application accessed via Citrix and fat clients. Citrix Users have reported that when the GBP currency symbol,...
Ingres Forums
10-26-2010 02:29 PM
Ingres Forums Go to last post
3 40
Hi all, are the IUA 2010 conference papers available for download? Can't find them on www.iua.org.uk. Regards Gerhard
Gerhard Hofmann
10-25-2010 03:29 AM
Roy Hann Go to last post
1 46
Hi All, Is there any good reason why I can't install a security_alarm on a view? It came as quite a surprise to me that this is not...
Martin Bowes
10-18-2010 02:48 AM
nikosv Go to last post
1 49
FYI Ingres 10.1.0-2 with geospatial support available. Includes: Bug fixes, .deb packages for Ubuntu, and more. Download links, videos, screencasts...
Andrew Ross
10-15-2010 05:22 AM
Ingres Forums Go to last post
1 54
Hi all, Is it possible to replicate a Ingres database on a Unix server to a Ingres database on a Windows server? Regards Gregory Wilding
Greg Wilding
10-11-2010 03:55 AM
Steve Sheil Go to last post
2 42
Hi Alex, Definitly ESQLC is doing something which OpenAPI is not....perhaps an internal conversion from UTF-32 to UTF-16? To load the data using...
Martin Bowes
10-07-2010 07:07 AM
Martin Bowes Go to last post
7 32
Thanks Paul - worked well. One more tick on the To-Do/To-Fix List. Regards, Andy On 30/09/2010 10:55 PM, Paul Mason wrote:
Pamela Fowler
09-30-2010 08:34 AM
Andy Go to last post
12 87
Hi All, I have a database which I'm keeping incrementally recovered to a host running II 9.2.1 (a64.lnx/103)NPTL +patch 13869. I have found that...
Martin Bowes
09-28-2010 08:54 AM
Paul Mason Go to last post
5 40
Hi All, I'm running on II 9.2.1 (a64.lnx/103)NPTL + 13904. This also occurs on II 10.0.0 (a64.lnx/127)NPTL I've just been developed a test case for...
Martin Bowes
09-28-2010 05:47 AM
Martin Bowes Go to last post
3 45
On Sep 24, 2010, at 6:38 AM, Karl Schendel wrote: Friday's on comp.databases.ingres are always so riveting. I'm just glad nobody brought up the...
Roy Hann
09-24-2010 11:29 AM
Ingres Forums Go to last post
9 38
I am urgently looking for an Ingres Openroad Developer for my client based in Newport, Wales. The contract will be initially for 40days with...
bipasha.batheja@steria.co.uk
09-17-2010 02:07 PM
michaelnewport@yahoo.com Go to last post
1 45
Also try doing the load after issuing the statement: set session with on_logfull=commit; Martin Bowes -----Original Message----- From: Michael Dyer...
Ingres Forums
09-16-2010 01:56 AM
Roy Hann Go to last post
6 47
Is there any information in IMA about when a query started? It would be nice to be able to detect long-running...
Robert Allely
09-14-2010 02:09 AM
Roy Hann Go to last post
16 54
Hi All, On II 9.2.0 (a64.lnx/143)NPTL + 13556... How do you make a database private using an SQL command? Or an OS command? And here's an...
Martin Bowes
09-13-2010 07:53 AM
Paul Mason Go to last post
3 38
I wonder if theres a way of setting the session description for optimizedb ? Robert Confidentiality/Privilege Notice: This communication is...
Robert Allely
09-09-2010 05:00 PM
Robert Allely Go to last post
1 35
E_GC4005_SEQUENCING "New request made before prior request completed." Can anyone shed light on this one? I have a java application connecting to...
Martin Bowes
09-08-2010 11:42 AM
Ingres Forums Go to last post
1 33
Does anyone know the dates for Ingres beta or GA on Ingres on OpenVMSItanium thanks Allan
allanb4@iname.com
08-27-2010 11:30 AM
Ingres Forums Go to last post
5 132
Hi All, Having recently upgraded a host to 9.2.1, I was somewhat astounded to see my users break their application on startup. It seems that in...
Martin Bowes
08-26-2010 05:38 AM
rthdavid Go to last post
3 46
Hi All, I have a 9.1.1 (a64.lnx/103)NPTL + p13001 installation. On one database of the many we find a persistent set of files in the data area...
Martin Bowes
08-24-2010 02:38 AM
Martin Bowes Go to last post
2 36
Hi All, I'm trying to load the date data from a standard ingres table into a Vectorwise equivalent. The standard ingres table uses ingresdate. ...
Martin Bowes
08-13-2010 03:06 AM
John Smedley Go to last post
4 41
Hi All, I'm assuming I've missed something very simple...but, how do I trap who raised a database event? I'm looking at inquire_sql() and I see...
Martin Bowes
08-09-2010 01:10 PM
Chris Go to last post
2 48
Hi All, I'm running on II 9.1.1 (a64.lnx/103)NPTL +p13001. Recently we have found a strange problem with verifydb that looks a lot like bug 115634...
Martin Bowes
08-02-2010 09:35 AM
Martin Bowes Go to last post
3 35
OK, it's not ingres-specific, but ingres people seem to do a lot of this SQL stuff.. ;-) Every day oreilly offers a $10 e-book for download. Today...
On net
07-28-2010 12:46 AM
nikosv Go to last post
2 40
I have two queries which when run standalone produce the correct results but when unioned produce extra rows. query 1 : select aa_qeshs=...
nikosv
07-24-2010 07:41 AM
nikosv Go to last post
2 58
What may be happening is the extra columns might reveal that you have eliminated rows in the original union. Try running the union with UNION ALL...
Ian Kirkham
07-22-2010 06:20 AM
nikosv Go to last post
2 35
Hi all, I've been experimenting with C2 security auditing and - thanks to some good KB documentation - have got it working very well. Now I am...
Paul White
07-21-2010 01:37 AM
Roy Hann Go to last post
1 35
On Jul 16, 2010, at 5:35 AM, Martin Bowes wrote: No, the IVW ingres-side code is a sort of pre-release 10 that is rather older. The beta level 10...
Ingres Forums
07-16-2010 10:35 AM
Ingres Forums Go to last post
6 252
Post New Thread

Display Options
Showing threads 351 to 400 of 2536
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.