Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[DBD::Pg] Older versions of Postgres cannot do an ALTER TYPE inline.

0 views
Skip to first unread message

dbdpg-...@bucardo.org

unread,
Sep 30, 2015, 7:30:01 PM9/30/15
to dbd-pg-...@perl.org
Committed by Greg Sabino Mullane <gr...@endpoint.com>

Older versions of Postgres cannot do an ALTER TYPE inline.

---
t/03dbmethod.t | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/t/03dbmethod.t b/t/03dbmethod.t
index ac565ba..6955924 100644
--- a/t/03dbmethod.t
+++ b/t/03dbmethod.t
@@ -681,7 +681,7 @@ SKIP: {

$dbh->do( q{CREATE TYPE dbd_pg_enumerated AS ENUM ('foo', 'bar', 'baz', 'buz')} );
$dbh->do( q{CREATE TEMP TABLE dbd_pg_enum_test ( is_enum dbd_pg_enumerated NOT NULL )} );
- if ($pgversion >= 90100) {
+ if ($pgversion >= 90300) {
$dbh->do( q{ALTER TYPE dbd_pg_enumerated ADD VALUE 'first' BEFORE 'foo'} );
unshift @enumvalues, 'first';
}
--
1.8.4

0 new messages