WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

AGNALDO

Delphi Developer

Tue, 28 Jun 2005 19:27:29 GMT

WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

I GET THIS ERROR

This operation is not defined for system tables.
facassada atualiza??o do metadata.
key size too big for index RDB$PRIMARY6.

I'D LIKE TO KNOW WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

Bill Tod

Delphi Developer

Tue, 28 Jun 2005 22:42:52 GMT

Re:WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

See Appendix B in the Operations Guide

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Craig Stuntz [TeamB

Delphi Developer

Tue, 28 Jun 2005 22:53:53 GMT

Re:WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

In article <3e1ea...@newsgroups.borland.com>, AGNA...@TQS.COM.BR says...

Quote

> I GET THIS ERROR

> This operation is not defined for system tables.
> facassada atualiza??o do metadata.
> key size too big for index RDB$PRIMARY6.

> I'D LIKE TO KNOW WHAT'S THE LARGER SIZE STRING TO USE IN A PRIMARY KEY

Indices in IB can be up to about 254 bytes. How big of a VARCHAR
can fit into 254 bytes depends upon the charset and collation you are
using.

That said, I can't imagine why you'd want to use a char field that
long for a PK.

-Craig

--
Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Other Threads

1. Primary key or not primary key.........

2. large numbered primary keys

3. Primary key corrupt with large filesizes (>375 MB)

4. Interbase 6.0 key size too big for index RDB$PRIMARY

5. How to adjust the field size of a primary key

6. Primary Key: string vs integer, what to choose?

7. Large Paradox database - What 'block size'?

8. Interbase - Can't add primary key to table

9. RegenIndexes doesn't works with Primary Keys

10. Sorting a PDox Table that doesn't have a primary key