Skip Menu | will be shut down on March 1st, 2021.

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 105979
Status: new
Priority: 0/
Queue: DBIx-Class

Owner: Nobody in particular
Requestors: mca [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

MIME-Version: 1.0
X-Spam-Status: No, score=-3.843 tagged_above=-99.9 required=10 tests=[AWL=0.367, BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01] autolearn=ham
Content-Disposition: inline
X-Spam-Flag: NO
content-type: text/plain; charset="utf-8"
Message-ID: <20150720150454.GB16819 [...]>
X-Virus-Scanned: Debian amavisd-new at
X-Spam-Score: -3.843
Received: from localhost (localhost []) by (Postfix) with ESMTP id 4B941240516 for <cpan-bug+DBIx-Class [...]>; Mon, 20 Jul 2015 11:05:15 -0400 (EDT)
Received: from ([]) by localhost ( []) (amavisd-new, port 10024) with ESMTP id W+Ib-MyNPGfX for <cpan-bug+DBIx-Class [...]>; Mon, 20 Jul 2015 11:05:14 -0400 (EDT)
Received: from ( []) by (Postfix) with SMTP id AE1B12403C1 for <bug-DBIx-Class [...]>; Mon, 20 Jul 2015 11:05:13 -0400 (EDT)
Received: (qmail 20154 invoked by alias); 20 Jul 2015 15:05:12 -0000
Received: from (HELO ( by (qpsmtpd/0.28) with ESMTP; Mon, 20 Jul 2015 08:05:02 -0700
Received: from ([]) by with esmtps (TLSv1:AES256-SHA:256) (Exim 4.80.1) (envelope-from <mca [...]>) id 1ZHCcg-0009v8-Us for bug-DBIx-Class [...]; Mon, 20 Jul 2015 16:04:55 +0100
Received: from mca by with local (Exim 4.69) (envelope-from <mca [...]>) id 1ZHCcg-0002pI-JK for bug-DBIx-Class [...]; Mon, 20 Jul 2015 16:04:54 +0100
Delivered-To: cpan-bug+DBIx-Class [...]
User-Agent: Mutt/1.5.18 (2008-05-17)
Subject: Suggest FAQ addition: valid data_types, specifically enum
Return-Path: <mca [...]>
X-RT-Mail-Extension: dbix-class
X-Original-To: cpan-bug+DBIx-Class [...]
Date: Mon, 20 Jul 2015 16:04:54 +0100
To: bug-DBIx-Class [...]
From: Matthew Astley <mca [...]>
X-RT-Original-Encoding: ascii
X-RT-Interface: Email
Content-Length: 872
Download (untitled) / with headers
text/plain 872b
Hi maintainers of marvellous tool, Could the FAQ include some pointers to finding out the valid $source->add_columns(foo => { data_types => ??? }) please? I realise it is a complex one because it depends on the Storage, but it would save time if there were answers for the common backends, plus how to find out for the others. Specifically I was looking for how to set up an enum field. I found this works (for Oracle and PostgreSQL anyway), stype => { data_type => 'enum', extra => { list => [ @STYPE ] }, ... } Hoping this helps the next person / me in a few years when I forget again, -- Matthew -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to