Am 08.08.2014 um 01:20 schrieb Tom Lane:
Andreas maps...@gmx.net writes:
When I checked the logfile of the local PG-9.3 server I found an error
on startup that complained it couldn't bind a IPv4 socket for 5432.
Another error says autovauum is not running.
It would help if you provided the
Sylvia Preuß wrote:
I’d like to create a database with ENCODING LATIN1 .
CREATE DATABASE z_latin1
WITH OWNER = admin
ENCODING = 'LATIN1'
TABLESPACE = pg_default
LC_COLLATE = 'German_Germany.1252'
LC_CTYPE = 'German_Germany.1252'
CONNECTION LIMIT = -1;
On 08/07/2014 10:23 PM, vpmm2007 wrote:
In reply to this post by vpmm2007
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
On Thu, Aug 7, 2014 at 3:43 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 08/07/2014 01:39 AM, Jorge Arevalo wrote:
What OS are you on?
Per:
http://www.postgresql.org/__docs/9.1/interactive/auth-__
methods.html#AUTH-PEER
I am not sure how to find the download file for PostgreSQL 9.4 on AIX 6. Would
someone point me to the correct location?
This email and any files transmitted with it are confidential, proprietary and
intended solely for the individual or entity to whom they are addressed. If you
have
On 8/8/2014 1:30 PM, Deb Brooks wrote:
I am not sure how to find the download file for PostgreSQL 9.4 on AIX
6. Would someone point me to the correct location?
AFAIK, you have to compile it yourself from source, and I'd recommend
using IBM XL C rather than GCC. At least, thats what I've
Thank you for the prompt reply and the advice.
This email and any files transmitted with it are confidential, proprietary and
intended solely for the individual or entity to whom they are addressed. If you
have received this email in error please delete it immediately.
I have a table as follows :
Year (numeric)
Factor (text)
Test_1 (numeric)
Test_2 (numeric)
Test_3 (numeric)
Test_4 (numeric)
unique index(year,factor) (i.e. each factor only appears once per year)
What I need to achieve is an ordered ranking of the factors for each test, e.g.
let's say I've
How to use one recursive query if there are may queries in WITH statement ?
I tried
with
a as ( select 1 as col1 ),
RECURSIVE t(n) AS (
VALUES (1)
UNION ALL
SELECT n+1 FROM t WHERE n 100
),
c as (select * from t)
select * from c
but got error
syntax error at or near t
at line
Andrus Moor wrote
How to use one recursive query if there are may queries in WITH statement
?
I tried
with
a as ( select 1 as col1 ),
RECURSIVE t(n) AS (
VALUES (1)
UNION ALL
SELECT n+1 FROM t WHERE n 100
),
c as (select * from t)
select * from c
but got error
Tim Smith wrote
I have a table as follows :
Year (numeric)
Factor (text)
Test_1 (numeric)
Test_2 (numeric)
Test_3 (numeric)
Test_4 (numeric)
unique index(year,factor) (i.e. each factor only appears once per year)
What I need to achieve is an ordered ranking of the factors for each
On 08/08/2014 01:45 PM, Deb Brooks wrote:
Thank you for the prompt reply and the advice.
If you are going to compile from source the following might come in handy:
http://www.postgresql.org/docs/9.4/static/installation-platform-notes.html#INSTALLATION-NOTES-AIX
--
Adrian Klaver
Hello,
Can you please confirm if PostgreSQL 9.2.4 is supported on AIX 7 platform? In
the following URL, it mentions support for AIX 6 (but not AIX 7) -
http://www.postgresql.org/docs/9.2/static/installation-platform-notes.html
As I understand from a different topic on this forum is that, we
On 8/8/2014 3:27 PM, Payal Shah wrote:
Can you please confirm if PostgreSQL 9.2.4 is supported on AIX 7
platform? In the following URL, it mentions support for AIX 6 (but not
AIX 7) -
http://www.postgresql.org/docs/9.2/static/installation-platform-notes.html
it should work fine, although
Hello John,
Thank you for your response. If you or someone can provide steps on how to
bundle PostgreSQL on AIX (using IBM XL C compiler), that would be great so I
can try it out to see if works for AIX 7 platform. I'm new to AIX platform and
appreciate any help that you can provide.
Thank
Payal Shah wrote
Can you please confirm if PostgreSQL 9.2.4 is supported on AIX 7 platform?
In the following URL, it mentions support for AIX 6 (but not AIX 7) -
http://www.postgresql.org/docs/9.2/static/installation-platform-notes.html
As I understand from a different topic on this forum is
Payal,
I think you completely ignored john r pierce...any reason you're using
9.2.4? Whoevers going to help you will want to be testing on what you're
eventually going to compile
Frank
On Fri, Aug 8, 2014 at 4:54 PM, Payal Shah payals...@fico.com wrote:
Hello John,
Thank you for your
Hello Frank, I apologize for missing version part. Currently we use 9.2.4 in
other platforms and that’s the reason we want to use same version for AIX as
well. I’ll follow up with my team to see when would be a good time to upgrade
to 9.2.9.
I need to install PostgreSQL on AIX 7 platform and
Hello,
We were planing to upgrade from 9.0 to to 9.3. While
investigating on the performance side, we stumbled upon a link which
says there may be performance degradation on 9.3:
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_CODE number(4));
NEED TO CONVERT THIS TO POSTGRES , ANYBODY PLS HELP ME I M NEW TO
Hi,
i want install pgcluu on postgres 9.3 and i'm putty tool to
connect pg database when i ran .
tar xzf pgcluu-2.0.tar.gz
cd pgcluu-2.0.tar/
perl Makefile.PL
make sudo make install
it's return like..
bash-4.1$ tar xzf pgcluu-2.0.tar.gz
tar
On 08/08/2014 06:40 AM, Ramesh T wrote:
Hi,
i want install pgcluu on postgres 9.3 and i'm putty tool to
connect pg database when i ran .
tar xzf pgcluu-2.0.tar.gz
cd pgcluu-2.0.tar/
perl Makefile.PL
make sudo make install
it's return
22 matches
Mail list logo