[Info-ingres] More on indexes for a specific table...

DATABASE

    Sponsored Links

    Next

  • 1. Ingres R3/2006 ODBC driver wiithout IngresNet?
    Hi all, excerpt from Ingres 2006 Connectivity Guide: ---- The Ingres ODBC driver (subsequently referred to as the ODBC driver) enables ODBC-enabled applications to access Ingres, Enterprise Access, and EDBC databases. The driver is installed as part of a standard Ingres client installation or as a stand-alone product. ---- I wonder what is meant by "as a stand-alone product". Does this mean I do not need an IngresNet installation to use ODBC applications? Regards Gerhard
  • 2. Rookie + Ingres + Script
    Hi I have little problem with sql script`s. I have an sql script with about 120 000 records. I would like to inseret that records to my database and here is my problem, I do not know how to do it. I was trying to do it in Ingres Visual SQL, but I could not, when I trying to run my script Visaul SQL always not responding or buffer is too small. So my question is how to run scripts in Ingres, maybe you know some sql command which do it. Thanks a lot for a help Regards Radoslaw Witkowicki

[Info-ingres] Re: More on indexes for a specific table...

Postby Karl & Betty Schendel » Sat, 22 Apr 2006 08:07:01 GMT



What version of Ingres is this?

If I create a table with a primary key (and no constraint-WITH clause)
in ingres r3/2006, I get an index named:
"$table  _u00001e5000000000" or something similar.  I'm pretty sure it
was the same in earlier versions.  I could possibly believe that OI 1.2
did something different, but it really sounds like a user created
index.  Did someone perhaps do:

create table accounts(thing .... primary key with index=$pk_accounts,...)




There has to be more to it somewhere.  I assume you're running a DDL
script of some kind.  Look for "alter table accounts add constraint
xxx primary key with index=$pk_accounts".

The table given not only will not have an index $pk_accounts, it will have
no index at all, and no primary key either.

Karl

Similar Threads:

1.[Info-ingres] More on indexes for a specific table...

At 3:25 PM -0700 4/20/2006,  XXXX@XXXXX.COM  wrote:
>I'm seeing an index called k_(table_name). For instance the accounts
>table has an index called k_accounts. Since I didn't create this index,
>I assume it is an Ingres system index? Is that correct?

Nope, sorry.  Anything Ingres creates without you knowing either has
an ii prefix, or is a garishly ugly construct with spaces and dollar
signs and hex poop in it.  Or both.  Certainly not k_whatever.

Must be one of yours, somehow.

-- 
Karl R. Schendel, Jr.          XXXX@XXXXX.COM 
Ingres Corp
Ingres Server Development

2.More on indexes for a specific table...

I'm seeing an index called k_(table_name). For instance the accounts
table has an index called k_accounts. Since I didn't create this index,
I assume it is an Ingres system index? Is that correct?

Anyone know what the k stands for? :)

Jared

3.[Info-ingres] Listing the columns and indexes for a given table

At 11:06 PM +0000 4/19/06, Jared Richardson wrote:
>Hi all,
>
>I'm using the Open API interface access Ingres and I need to get the
>list of all the columns in a table (for one call) and then all the indexes
>for another.
>At the moment I'm planning executing a select first 1 from table_name
>and then getting the column names from the descriptors... but it occurs to
>me that both operations might have a "right way". :)

You could retrieve column names from iicolumns and index names
from iiindexes.

Karl

4.[Info-ingres] SV: [Info-ingres] Disabling index for batch

5.[Info-ingres] FW: [Info-ingres] ODBC access to Ingres database - how do I exclude specific tables?

6. [Info-ingres] RES: [Info-ingres] Copy table options ?

7. [Info-ingres] RES: [Info-ingres] temporary table

8. [Info-ingres] RES: RES: [Info-ingres] temporary table



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 31 guest