Skip to content

Instantly share code, notes, and snippets.

@langner

langner/namedatalen-256.patch

Created October 21, 2014 17:29
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save langner/5c7bc1d74a8b957cab26 to your computer and use it in GitHub Desktop.
Save langner/5c7bc1d74a8b957cab26 to your computer and use it in GitHub Desktop.
Download ZIP
Patch that increases NAMEDATALEN to 256 in postgresql-9.1.14-0ubuntu0.12.04 (use with https://gist.github.com/langner/12a032a8793c2df80f5d)
Raw
namedatalen-256.patch
Index: postgresql-9.1-9.1.14/src/include/pg_config_manual.h
===================================================================
--- postgresql-9.1-9.1.14.orig/src/include/pg_config_manual.h 2014-10-14 16:55:38.000000000 -0400
+++ postgresql-9.1-9.1.14/src/include/pg_config_manual.h 2014-10-14 16:56:01.598940653 -0400
@@ -17,7 +17,7 @@
*
* Changing this requires an initdb.
*/
-#define NAMEDATALEN 64
+#define NAMEDATALEN 256
/*
* Maximum number of arguments to a function.
Index: postgresql-9.1-9.1.14/src/test/regress/expected/enum.out
===================================================================
--- postgresql-9.1-9.1.14.orig/src/test/regress/expected/enum.out 2014-07-21 15:14:13.000000000 -0400
+++ postgresql-9.1-9.1.14/src/test/regress/expected/enum.out 2014-10-14 16:56:01.598940653 -0400
@@ -90,9 +90,9 @@
-- errors for adding labels
ALTER TYPE planets ADD VALUE
- 'plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto';
-ERROR: invalid enum label "plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto"
-DETAIL: Labels must be 63 characters or less.
+ 'plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto';
+ERROR: invalid enum label "plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto"
+DETAIL: Labels must be 255 characters or less.
ALTER TYPE planets ADD VALUE 'pluto' AFTER 'zeus';
ERROR: "zeus" is not an existing enum label
--
Index: postgresql-9.1-9.1.14/src/test/regress/sql/enum.sql
===================================================================
--- postgresql-9.1-9.1.14.orig/src/test/regress/sql/enum.sql 2014-07-21 15:14:13.000000000 -0400
+++ postgresql-9.1-9.1.14/src/test/regress/sql/enum.sql 2014-10-14 16:56:01.602940653 -0400
@@ -50,7 +50,7 @@
-- errors for adding labels
ALTER TYPE planets ADD VALUE
- 'plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto';
+ 'plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto';
ALTER TYPE planets ADD VALUE 'pluto' AFTER 'zeus';
Index: postgresql-9.1-9.1.14/src/test/regress/expected/name.out
===================================================================
--- postgresql-9.1-9.1.14.orig/src/test/regress/expected/name.out 2014-07-21 15:14:13.000000000 -0400
+++ postgresql-9.1-9.1.14/src/test/regress/expected/name.out 2014-10-14 17:20:37.586971200 -0400
@@ -29,31 +29,31 @@
SELECT '' AS seven, * FROM NAME_TBL;
- seven | f1
--------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ seven | f1
+-------+--------------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| asdfghjkl;
| 343f%2a
| d34aaasdf
|
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
(7 rows)
SELECT '' AS six, c.f1 FROM NAME_TBL c WHERE c.f1 <> '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
- six | f1
------+-----------------------------------------------------------------
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ six | f1
+-----+--------------------------------------------------------------------------
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| asdfghjkl;
| 343f%2a
| d34aaasdf
|
-(5 rows)
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
+(6 rows)
SELECT '' AS one, c.f1 FROM NAME_TBL c WHERE c.f1 = '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
- one | f1
------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
-(2 rows)
+ one | f1
+-----+------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
+(1 row)
SELECT '' AS three, c.f1 FROM NAME_TBL c WHERE c.f1 < '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
three | f1
@@ -64,41 +64,41 @@
SELECT '' AS four, c.f1 FROM NAME_TBL c WHERE c.f1 <= '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
- four | f1
-------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
+ four | f1
+------+------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
|
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
-(3 rows)
+(2 rows)
SELECT '' AS three, c.f1 FROM NAME_TBL c WHERE c.f1 > '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
- three | f1
--------+-----------------------------------------------------------------
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ three | f1
+-------+--------------------------------------------------------------------------
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| asdfghjkl;
| 343f%2a
| d34aaasdf
-(4 rows)
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
+(5 rows)
SELECT '' AS four, c.f1 FROM NAME_TBL c WHERE c.f1 >= '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR';
- four | f1
-------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ four | f1
+------+--------------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| asdfghjkl;
| 343f%2a
| d34aaasdf
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
(6 rows)
SELECT '' AS seven, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*';
- seven | f1
--------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ seven | f1
+-------+--------------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| asdfghjkl;
| 343f%2a
| d34aaasdf
|
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
(7 rows)
SELECT '' AS zero, c.f1 FROM NAME_TBL c WHERE c.f1 !~ '.*';
@@ -109,11 +109,11 @@
SELECT '' AS three, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '[0-9]';
- three | f1
--------+-----------------------------------------------------------------
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
- | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopq
+ three | f1
+-------+--------------------------------------------------------------------------
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQR
+ | 1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqr
| 343f%2a
| d34aaasdf
- | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQ
+ | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
(5 rows)
SELECT '' AS two, c.f1 FROM NAME_TBL c WHERE c.f1 ~ '.*asdf.*';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment