Re: Nonnumeric Primary Keys

Maybe it had to do with string comparisons being more expensive than
numeric comparisons? I think you can make whatever datatype you'd like
a primary key.

On Thu, 2008-07-03 at 13:41 -0400, Karen Hoofnagle wrote:
Hey, all I have a db in production that uses a whole lot of string
values as primary keys. (It's Oracle, FWIW) Does DBIX::Class care
what data type a primary key is? I *vaguely* remember hearing some
sort of remark in the Catalyst master class Jon Rockway taught at YAPC
that this is an issue, but I might have imagined it.

Thanks,
Karen


Attachment: signature.asc
Description: This is a digitally signed message part

Relevant Pages

  • Re: Autofill Table2 when new record created in Table1
    ... Fieldname <Primary Key> ... AnotherField <datatype> ...
    (microsoft.public.access.forms)
  • Re: Delete rows where PK = nvarchar?
    ... the length is part of the datatype. ... used invites garbage and will destroy your data quality. ... used a proprietary auto-numbering for a PRIMARY KEY. ... constraints, Declarative Referential Integrity, datatypes, etc. in your ...
    (microsoft.public.sqlserver.programming)
  • Re: 8-byte value as primary key?
    ... I believe you cannot use binary datatype as a primary key. ... > key into an ADO.NET DataTable, but he's getting exceptions thrown when he ... > This code will result in the exception being thrown. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Append query key violation
    ... There's a good chance that the problems resulted from the use of the lookup ... issues that were resolved by changing that datatype back to the type of the ... field and eliminated the primary key in its table, ... the only other thing i can think of is a forign key problem where you ...
    (microsoft.public.access.queries)
  • Re: Weird Design issue
    ... design flaw is common among beginners and is called an EAV design ... (loc_code INTEGER NOT NULL PRIMARY KEY, ... known datatype or domain!! ... This is foundations, not fancy SQL. ...
    (microsoft.public.sqlserver.programming)