On 28/06/17 10:17, Adrian Klaver wrote:
On 06/28/2017 05:06 AM, marcelo wrote:
Hi
Today I installed postgresql 9.4 on Lubuntu 15.04 from the
EnterpriseDB's package.
I modified pg_hba.conf to accept connections from the local network,
and tried to start the backend. It do not; looking the
On 06/28/2017 05:06 AM, marcelo wrote:
Hi
Today I installed postgresql 9.4 on Lubuntu 15.04 from the
EnterpriseDB's package.
I modified pg_hba.conf to accept connections from the local network, and
tried to start the backend. It do not; looking the log, I can see the
message I copied to the
Ramesh T schrieb am 24.02.2015 um 19:08:
> CREATE AGGREGATE group_concat(text) (
> SFUNC = _group_concat,
> STYPE = text
> );
> is it availabe in oracle..?
https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030
--
Sent via pgsql-general mailing list (pgsql-g
- Original Message -
Purely out of curiosity ...
All support for Windows XP was dropped in April of last year ... and this
was many years after mainstream support was dropped (2009).
What possible reason could you have for still running Windows XP?
Furthermore, do you actually expec
: Bill Moran [mailto:wmo...@potentialtech.com]
Sent: 13 February 2015 14:28
To: George Weaver
Cc: Bald, Glenn; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unknown error while running <>
postgresql_installer_dc46cfee2c\getlocales.exe
Purely out of curiosity ...
All support for Wind
Purely out of curiosity ...
All support for Windows XP was dropped in April of last year ... and this
was many years after mainstream support was dropped (2009).
What possible reason could you have for still running Windows XP?
Furthermore, do you actually expect application vendors to still sup
Hi Glenn,
No, and neither did I receive any responses.
I did find the following reference that 9.4 is officially not supported on
XP, Server 2003 or Vista, however I have not seen anything "official" on the
PostgreSQL or Enterprise DB sites.
http://www.postgresql.org/message-id/canfyu97_wyax
Oliver Dizon schrieb am 27.01.2015 um 11:46:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where ta
Oliver Dizon schrieb am 27.01.2015 um 11:46:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where ta
On 06/11/2014 11:35 AM, Tom Lane wrote:
Steve Crawford writes:
I am getting the error following errors trying to install pg_repack via
pgxn on Ubuntu server 12.04.4 with all PostgreSQL packages from pgdg:
/usr/include/postgresql/libpq-fe.h:547:1: error: unknown type name
‘pg_int64’
That type n
Steve Crawford writes:
> I am getting the error following errors trying to install pg_repack via
> pgxn on Ubuntu server 12.04.4 with all PostgreSQL packages from pgdg:
> /usr/include/postgresql/libpq-fe.h:547:1: error: unknown type name
> pg_int64
That type name ought to be defined in postgr
On 13/04/10 21:15, Jaiswal Dhaval Sudhirkumar wrote:
Is there any other server running over the same system ?
Is there any firewall or anti-virus software installed?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
Is there any other server running over the same system ?
Have you killed any processes from OS level ?
What is the message showing when you are trying to start the pg server ?
--
Thanks
Dhaval
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@pos
Cyril VELTER wrote:
De : mailto:[EMAIL PROTECTED]
Cyril VELTER wrote:
Is length() supposed to return the very high length in case of corruption
?
You'd have thought it would. The odd thing (if it is data corruption) is
that you would expect to see something in the server logs about a
failur
De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> >
> > Is length() supposed to return the very high length in case of
> > corruption
?
>
> You'd have thought it would. The odd thing (if it is data corruption) is
> that you would expect to see something in the server logs about a
> fa
Cyril VELTER wrote:
I have run the following query to get all record with one field over
10MB :
select
p2,length(p18155),length(p18154),length(p4065),length(p4083),length(p4020),lengt
h(p4074),length(p3857),length(p32402),length(p5512),length(p18175) from c2674
where length(p18155)>1
De : mailto:[EMAIL PROTECTED]
> "Cyril VELTER" <[EMAIL PROTECTED]> writes:
> > The server have 4G of ram. But doing a search in the source code it
> > does
not
> > seem that these values are used during a copy operation.
>
> They aren't. The "out of memory" complaint sounds more like it m
"Cyril VELTER" <[EMAIL PROTECTED]> writes:
> The server have 4G of ram. But doing a search in the source code it
> does not
> seem that these values are used during a copy operation.
They aren't. The "out of memory" complaint sounds more like it might be
due to corrupt data, ie the olde s
Cyril VELTER wrote:
It's just that 8.2.4 has a fix that says:
Allow pg_dump to do binary backups larger than two gigabytes on Windows
(Magnus)
Now, whether that will affect you I'm not sure, since you said you were
dumping from Linux, with the server on Windows.
I don't think so. The dump
De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> >
> > maintenance_work_mem and work_mem are set to their default value (16M /
1M).
> > Does Copy use any of these values ? The doc only state sort operations for
> > work_mem and vacuum / create index / alter table add foreing key for
Cyril VELTER wrote:
I recently upgraded a 8.0 database to 8.2 (server is running windows 2003
server) and now I cannot dump the database any more.
At some point in the dump, pg_dump (run on a centos 3 linux) return :
pg_dump: Dumping the contents of table "c2674" failed: PQgetCopyData()
On Mon, 2006-07-24 at 14:54 -0400, Tom Lane wrote:
> Right offhand the only way that I could see for the tuple to disappear
> before the trigger fires is if a concurrent VACUUM removed it, which
> should not happen for a tuple inserted by a still-active transaction.
> If you've got autovacuum runni
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> Sorry, I was unclear: luckily the error is easily reproducible. The
> problem is just to cut unnecessary parts and to come up with a small
> test case. I'll give it a try tomorrow.
> As far as VACUUM is concerned: I run this data-loading script jus
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> in the mean time I've traced the problem down to a 'CONSTRAINT' declared
> as 'DEFERRABLE INITIALLY DEFERED'. As soon as I remove that constraint
> the transaction commits nicely. BTW: I'm running in ISOLATION LEVEL
> SERIALIZABLE, if that matter
Hello Tom,
in the mean time I've traced the problem down to a 'CONSTRAINT' declared
as 'DEFERRABLE INITIALLY DEFERED'. As soon as I remove that constraint
the transaction commits nicely. BTW: I'm running in ISOLATION LEVEL
SERIALIZABLE, if that matters.
Has something changed so that it's wor
Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> I'm getting the following error from my python script, which tries to
> insert lots of data in one transaction:
> libpq.OperationalError: ERROR: failed to fetch new tuple for AFTER trigger
That's not supposed to happen. Can you provide a test ca
--- chris markiewicz <[EMAIL PROTECTED]> wrote:
> Unknown Response Type
> at org.postgresql.Connection.ExecSQL(Connection.java:420)
> at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
> at
> org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
>
> does a
> > > Hey folks, still looking for a little help on this. I can insert data
> > > and (obviously create tables). Further, I've discovered PHP with pg
> > > support yields an unknown symbol 'lo_unlink' when Apache tries to load
> > > it. Any help/pointers would be really appreciated.
> >
> > Wha
Tatsuo Ishii wrote:
> Subject changed.
>
> > Hey folks, still looking for a little help on this. I can insert data
> > and (obviously create tables). Further, I've discovered PHP with pg
> > support yields an unknown symbol 'lo_unlink' when Apache tries to load
> > it. Any help/pointers would
29 matches
Mail list logo
