Re: foreign key from array element - Mailing list pgsql-general

From Rafal Pietrak
Subject Re: foreign key from array element
Date
Msg-id 1348003835.21898.246.camel@localhost.localdomain
Whole thread Raw
In response to Re: foreign key from array element  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: foreign key from array element
List pgsql-general
On Tue, 2012-09-18 at 15:38 -0500, Kevin Grittner wrote:
> Rafal Pietrak <rafal@zorro.isa-geek.com> wrote:
> > where do I get current-v9.3 from?
>
> At this point 9.3 just means the HEAD of the master branch of the
> git repository, which is where development for the next major
> release of software is always done.  For details of the public git
> repository see:
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=summary
>

Oh. this is unexpected:

1. Got it by "git clone", the patch went-in cleanly,

2. "./configure" run just fine:
----------------
.
.
#define MEMSET_LOOP_LIMIT 1024
#define PG_VERSION_STR "PostgreSQL 9.3devel on i686-pc-linux-gnu,
compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit"
#define PG_VERSION_NUM 90300

configure: exit 0
----------------

3. But then make fails:
-----------------------
postmaster/postmaster.o: In function `PostmasterMain':^M
postmaster.c:(.text+0x4bc8): undefined reference to `optreset'^M
tcop/postgres.o: In function `process_postgres_switches':^M
postgres.c:(.text+0x1422): undefined reference to `optreset'^M
utils/misc/ps_status.o: In function `set_ps_display':^M
ps_status.c:(.text+0xd4): undefined reference to `setproctitle'^M
collect2: ld returned 1 exit status^M
make[2]: *** [postgres] Error 1^M
make[2]: Leaving directory `/home/rafal/work/postgresql/src/backend'^M
make[1]: *** [all-backend-recurse] Error 2^M
make[1]: Leaving directory `/home/rafal/work/postgresql/src'^M
make: *** [all-src-recurse] Error 2^M
-----------------------

which is interesting, because:

-----------------------
configure:22311: checking for optreset
configure:22337: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv  -D_GNU_SOURCE    conftest.c -lz -ledit -lcrypt -ldl -lm  >&5
configure:22344: $? = 0
configure:22364: result: yes
----------------------

while "setproctitle" was used despite being detected as missing:

----------------------
configure:7627: checking for library containing setproctitle
configure:7668: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv  -D_GNU_SOURCE    conftest.c -lm  >&5
/tmp/ccQn02qg.o: In function `main':
conftest.c:(.text+0x7): undefined reference to `setproctitle'
collect2: ld returned 1 exit status
configure:7675: $? = 1
-------------------------


-R



pgsql-general by date:

Previous
From: "Hall, Samuel L (Sam)"
Date:
Subject: Double types
Next
From: "Kevin Grittner"
Date:
Subject: Re: checkpoint_timeout and archive_timeout