Re: [GENERAL] Building PL/Perl procedural language without --with-perl configure flag

2017-01-15 Thread Tom Lane
postgres user writes: > I am trying to build PL/Perl procedural language to my PostgreSQL server > installation but I want to do it without passing --with-perl flag to the > configure script of PostgreSQL. Why? If you don't want to overwrite your existing installation, I'd suggest reconfigure wi

Re: [GENERAL] "make world" constantly throwing error on Ubuntu

2017-01-15 Thread Tom Lane
Ankit Sablok writes: > while running "make world" after the configure script I am constantly > receiving the following error and I am not able to find much help on web > regarding the same : > /bin/sh ../../../config/missing osx -D. -x lower -i include-xslt-index > postgres.sgml >postgres.xmltmp

Re: [GENERAL] "make world" constantly throwing error on Ubuntu

2017-01-15 Thread Adrian Klaver
On 01/15/2017 12:56 AM, Ankit Sablok wrote: Hi, I am trying to install PostgreSQL from git source repo on my Ubuntu box the details of which are as follows : Distributor ID:Ubuntu Description:Ubuntu 16.04.1 LTS Release:16.04 Codename:xenial while running "make world" after the configure script

Re: [GENERAL] "make world" constantly throwing error on Ubuntu

2017-01-15 Thread Adrian Klaver
On 01/15/2017 12:56 AM, Ankit Sablok wrote: Hi, I am trying to install PostgreSQL from git source repo on my Ubuntu box the details of which are as follows : Distributor ID:Ubuntu Description:Ubuntu 16.04.1 LTS Release:16.04 Codename:xenial while running "make world" after the configure script

Re: [GENERAL] Column Tetris Automatisation

2017-01-15 Thread Adam Brusselback
I for one would love having something like this available. I also know i've seen discussed in the past, divorcing the physical column order from the logical column order, which seems like it'd be useful here as well to not break the workflow of those who do use ordinal positions for columns.

Re: [GENERAL] Column Tetris Automatisation

2017-01-15 Thread Mike Sofen
|From: Nicolas Paris |Hello, |In postgresl order of columns does have an non negligeable impact on table |size[1]. |Table are in many cases dynamic, and new fields can appear in the database life. |I suspect re-ordering columns based on types would be an automatisable task | |Moreover, most client

Re: [GENERAL] Re: Building PL/Perl procedural language without --with-perl configure flag

2017-01-15 Thread Scott Mead
On Sun, Jan 15, 2017 at 6:35 AM, postgres user wrote: > The already installed Postgres edition was built using the same > installation procedure as mentioned in the docs, but without the use of > --with-perl flag. the point I ask the question is because I want to install > PL/Perl as a separate e

[GENERAL] Re: Building PL/Perl procedural language without --with-perl configure flag

2017-01-15 Thread postgres user
The already installed Postgres edition was built using the same installation procedure as mentioned in the docs, but without the use of --with-perl flag. the point I ask the question is because I want to install PL/Perl as a separate extension as one does with PostGIS and not along with Postgres in

Re: [GENERAL] Column Tetris Automatisation

2017-01-15 Thread Pavel Stehule
Hi 2017-01-15 10:58 GMT+01:00 Nicolas Paris : > Hello, > > In postgresl order of columns does have an non negligeable impact on table > size[1]. > Table are in many cases dynamic, and new fields can appear in the database > life. > I suspect re-ordering columns based on types would be an automati

[GENERAL] Column Tetris Automatisation

2017-01-15 Thread Nicolas Paris
Hello, In postgresl order of columns does have an non negligeable impact on table size[1]. Table are in many cases dynamic, and new fields can appear in the database life. I suspect re-ordering columns based on types would be an automatisable task would be feaseable such: ``` reorderTableWithTe

Re: [GENERAL] Building PL/Perl procedural language without --with-perl configure flag

2017-01-15 Thread John R Pierce
On 1/15/2017 1:15 AM, postgres user wrote: I am trying to build PL/Perl procedural language to my PostgreSQL server installation but I want to do it without passing --with-perl flag to the configure script of PostgreSQL. It would also help if someone can explain the meaning of --with-perl flag

[GENERAL] Building PL/Perl procedural language without --with-perl configure flag

2017-01-15 Thread postgres user
Hi, I am trying to build PL/Perl procedural language to my PostgreSQL server installation but I want to do it without passing --with-perl flag to the configure script of PostgreSQL. It would also help if someone can explain the meaning of --with-perl flag in a detailed fashion altogether as it mig

[GENERAL] "make world" constantly throwing error on Ubuntu

2017-01-15 Thread Ankit Sablok
Hi, I am trying to install PostgreSQL from git source repo on my Ubuntu box the details of which are as follows : Distributor ID: Ubuntu Description: Ubuntu 16.04.1 LTS Release: 16.04 Codename: xenial while running "make world" after the configure script I am constantly receiving the following e