Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or others?
Thanks in advance,
Paolo
;
> Thanks in advance,
> Paolo Saudin
>
>
>
> ---(end of
> broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>
arguments to function
‘stringToQualifiedNameList’
make: *** [gevel.o] Error 1
We are running Postgresql 8.4.4, can you please help us?
Paolo & Waqas
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2855255.html
Sent from the PostgreSQL - gen
arguments to function
‘stringToQualifiedNameList’
make: *** [gevel.o] Error 1
We are running Postgresql 8.4.4, can you please help us?
Paolo & Waqas
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2855017.html
Sent from the PostgreSQL - gen
ng different versions of
postgresql.
Oleg Bartunov wrote:
>
> btw, have you seen http://www.sai.msu.su/~megera/wiki/Rtree_Index ?
>
This also helps.
Paolo Fogliaroni
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2857004.html
S
Is there a way to tell pgAdmin to auto disconnect from all databases?
Thanks
Paolo Saudin
Thank you very much,
I will try this approach
Paolo
2016-12-19 15:30 GMT+01:00 Melvin Davidson :
>
> On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin
> wrote:
>
>> Hi,
>>
>> I deployed pgAdmin4 on a server and I have a script that every day
>> restore a databas
Hi everyone,
my name is Paolo Bizzarri and I am a developer of PAFlow, an document
tracking and management system for public administrations.
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
As our application is rather complex (it includes
On 5/30/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> We use postgres as a backend, and we are experimenting some corruption
> problems on openoffice files.
1. How are you storing these files?
Files are stored as large objects. They are written with an lo_w
Hi everyone,
my name is Paolo Bizzarri and I am a developer of PAFlow, an document
tracking and management system for public administrations.
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
As our application is rather complex (it includes
On 5/30/07, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> my name is Paolo Bizzarri and I am a developer of PAFlow, an document
> tracking and management system for public administrations.
>
> We use postgres as a backend, and we are experi
DB;
- we give the file to the user, and he can modify at its wish the file;
- we store back the modified file on the DB;
- the last two points can happen several times.
Any hint?
Best regards.
Paolo Bizzarri
Icube S.r.l.
On 5/30/07, Purusothaman A <[EMAIL PROTECTED]> wrote:
Paolo Bi
Hi Tom,
as explained above, the problem seems quite random. So I need to
understand what we have to check.
Best regards.
Paolo Bizzarri
Icube S.r.l.
On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Paolo Bizzarri" <[EMAIL PROTECTED]> writes:
> Any hint?
Please pr
On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Paolo Bizzarri" <[EMAIL PROTECTED]> writes:
> On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Please provide a reproducible test case ...
> as explained above, the problem seems quite random. So I need to
Hi Scott,
in fact, we were using a 2.6.12 kernel. Can this be a problem?
Best regards.
Paolo Bizzarri
On 6/4/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Paolo Bizzarri" <[EMAIL PROTE
On 6/5/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Greg Smith wrote:
> On Tue, 5 Jun 2007, Paolo Bizzarri wrote:
>
>> On 6/4/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>>> http://lwn.net/Articles/215868/
>>> documents a bug in the 2.6 linux kernel
t to create a database that does not exist?
Thanks in advance,
~Paolo
ndexed
NOTICE: table "pg_rewrite" was reindexed
NOTICE: table "pg_trigger" was reindexed
NOTICE: table "pg_description" was reindexed
NOTICE: table "pg_cast" was reindexed
NOTICE: table "pg_namespace" was reindexed
NOTICE: table "pg_conversion&q
On 7/27/07, Paolo Victor <[EMAIL PROTECTED]> wrote:
>
> Ok, I found the problem: Permissions.
>
> Although I -do- have write/read/exec permission /usr/local/pgsql , some
> files couldn't be copied after the install, probably rendering PG a bit
> unstable =)
Er
irectory
Saindo do diretório = Leaving directory
*/
make[4]: Entrando no diretório `/home/paolo/Desktop/postgresql-8.2.4
/src/interfaces/ecpg/include'
cd ../../../.. && ./config.status src/interfaces/ecpg/include/ecpg_config.h
./config.status: line 91: conf20566.sh: Permission de
when I removed the package, all of pg's bin files
(createdb, initdb, etc) remained at /usr/bin , conflicting with the new ones
at /usr/local/pgsql/bin. After removing the dupe files...
[EMAIL PROTECTED]:~$ postgres -D /home/paolo/db -p 5435 -i
LOG: database system was shut down at 2007-07
ons would be:
1) Aside from preventing wraparounds, in what other circumstances does
autovacuum run?
2) Did changing the autovacuum config settings cause the autovacuums to
stop, if so, why, when autovacuum is set to 'off' the whole time?
Best Regards,
Paolo Saul
I had the same issue last week,
I installed the Active Perl 5.10 and all worked ok
Paolo Saudin
Da: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Per conto di Sachin Srivastava
Inviato: domenica 6 febbraio 2011 18:30
A: Robert Fitzpatrick
Cc: PostgreSQL
9.1,
while we have obviously started with the latest release.
Does anybody know how to compile orafce for 9.2 or if there is any other
solution to add some basic oracle functions (dual table, TRUNC, ecc...)??
Thanks a lot,
Paolo
Try to check the perl version against Postgres version at
http://forums.enterprisedb.com/posts/list/3295.page
paolo
On Wed, Apr 3, 2013 at 7:14 PM, Robert Fitzpatrick wrote:
> I have a Windows XP laptop I've loaded postgres on for dev purposes. When
> I try to create the plperl la
) pg_initdb
4) How do you perform VACUUM?
-
b) VACUUM - SQL command
c) autovacuum
Paolo Saudin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent
postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
I just installed Postgresql 8.3.1 on a fresh machine and in the step 'Enable
contrib modules', you can select plDebugger option to enable the debugger.
Paolo Saudin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
0,51
0,52
0,48
0,6
0,67
0,55
0,7
Thanks in advance
Paolo Saudin
09:04 CEST FATAL: the database system is starting up
2011-06-01 21:09:04 CEST LOG: database system is ready to accept
connections
2011-06-01 21:09:04 CEST LOG: autovacuum launcher started
Thanks,
paolo saudin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
State & vbCrLf & "Reported by: " & _
objError.Source & vbCrLf & "Help file: " &
objError.HelpFile & vbCrLf & "Help Context ID: " & _
objError.HelpContext
Next
GetODBCerrors = strError
End If
Exit Function
GetODBCerrors_ErrHandler:
GetODBCerrors = Err.Number & " " & Err.Source & " " & Err.Description
End Function
Paolo Saudin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ed_sl_val );
$stored_arr[$myid] = [ @stored_sl_val ];
# return calculated sliding mean or null
if ( $mean == - ) { return; }
return $mean;
$BODY$
LANGUAGE 'plperlu' VOLATILE;
COMMENT ON FUNCTION perl_sliding_mean(integer, real, integer, integer, bpchar,
bpchar) IS
>-Messaggio originale-
>Da: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] Per conto di Scara Maccai
>Inviato: lunedì 2 febbraio 2009 10.36
>A: Paolo Saudin; pgsql-general@postgresql.org
>Cc: pgsql-general
>Oggetto: Re: R: [GE
0) as s(a)
);
--
-- same data as table 1 -- MUST BE FOUND BY THE CKECK ROUTINE
insert into table3(select fulldate, id, meanvalue from table1);
Thank in advance,
Paolo Saudin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>-Messaggio originale-
>Da: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] Per conto di Adrian Klaver
>Inviato: giovedì 12 febbraio 2009 17.28
>A: pgsql-general@postgresql.org
>Cc: Paolo Saudin
>Oggetto: Re: [GENERAL] How to check if
>-Messaggio originale-
>Da: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] Per conto di Adrian Klaver
>Inviato: giovedì 12 febbraio 2009 18.57
>A: Paolo Saudin
>Cc: pgsql-general@postgresql.org
>Oggetto: Re: R: [GENERAL] How to chec
-Messaggio originale-
Da: Adrian Klaver [mailto:akla...@comcast.net]
Inviato: giovedì 12 febbraio 2009 23.22
A: Paolo Saudin
Cc: pgsql-general@postgresql.org
Oggetto: Re: R: R: [GENERAL] How to check if 2 series of data are equal
On Thursday 12 February 2009 11:37:37 am Paolo Saudin
en '2009-03-29 00:00:00' AND
'2009-03-29 00:59:59'
ORDER BY data
) foo
GROUP BY 1 ORDER BY 1
-- value = 1.3 NOT OK
-- test
select round(cast( (1.3 + 1.4)::real / 2 as numeric), 1);
-- value = 1.4 OK
Using PostgreSQL 8.3.7 on Windows Server 2008
Thank in advance,
Paolo Saudin
>Paolo Saudin wrote:
>Hi,
>
>I have a problem with a query wich simple aggregate values. In the sample
below I have two values, 1.3 and 1.4. Rounding their average with one
decimals, should give 1.4.
>The first query with - cast( tables_seb.tbl_arvier_chamencon.id_1 AS
nu
>>"Paolo Saudin" writes:
>> I have a problem with a query wich simple aggregate values. In the sample
>> below I have two values, 1.3 and 1.4. Rounding their average with one
>> decimals, should give 1.4.
>
>You seem way overoptimistic about float4 values
must specify the outer query's table reference inside the
subquery. I suspect the original intent was to use the outer query columns
in some processing inside the subquery, which is valid. I'm just wondering
why an explicit reference isn't required to distinguish the column. For
convenience, or part of the SQL spec?
Cheers!
--Paolo Saul
Thank you for clearing that up.
Regards,
Paolo Saul
> This behavior is required by the SQL standard. It's called an outer
> reference.
>
>regards, tom lane
>
I'd like to understand if it is possible to find a solution to the problem
that we have on ours DB in production.
I make an example simplified in order to explain itself better:
We have 2 table :
TABLE vendor (
group TEXT,
client TEXT,
vdr_venue_code CHAR(8),
vdr_location_code CHAR(8)
)
I'd like to understand if it is possible to find a
solution to the problem that we have on ours DB in production.
I make an example simplified in order to explain
itself better:
We have 2 table :
TABLE vendor ( group TEXT, client
TEXT, vdr_venue_code CHAR(8), vdr_location_code
CHAR(8))
=
myfloat4_sum, stype = float4);-- resultselect myagg2_sum(fld2) from
mytest; --> NOTHING ??? INSTEAD OF
6.73
What am
I doing wrong ??
Thank you very
much,
Paolo
Saudin
Italy
s didn't update correctly keeping the old maximum length.
I can see there's an optional USING clause for the ALTER TYPE, but is
not really clear to me what should i add in this case, since basically
I'd need no convertion...
Thanks
Paolo
---(end of broadcast)---
ing conversions ... child process exited with exit code 1
initdb: removing data directory "C:/Programmi/PostgreSQL/8.3-dev1/data"
Paolo Saudin
<>
ame as the other email
I then reset the virtual machine and installed the 8.2 with no problem. At
that point I tried to install the 8.3-dev with the account created by the
8.2 installation and I end up the same error.
Paolo
-Messaggio originale-
Da: Magnus Hagander [mailto:[EMAIL
sono parte
dell'evento: FATAL: could not load library
"C:/Programmi/PostgreSQL/8.3-dev1/lib/ascii_and_mic.dll": unknown error
14001
STATEMENT: CREATE OR REPLACE FUNCTION ascii_to_mic (INTEGER, INTEGER,
CSTRING, INTERNAL, INTEGER) RETURNS VOID AS '$libdir/ascii_and_mic&#x
SP2 (not
virtual machine) trying to set the above settings and the results were the
same. I added the postgres user to Administrators group, but doesnt work
either. On that machine there is a 8.2.4 version running
Paolo
-Messaggio originale-
Da: Dave Page [mailto:[EMAIL PROTECTED
the OS installed. Ill keep trying
!!
Thanks anyway,
Paolo
Da: Prashant Ranjalkar [mailto:[EMAIL PROTECTED]
Inviato: lunedì 7 maggio 2007 12.06
A: Paolo Saudin
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] Postgres 8.3-dev
Hello,
Remove Postgres directory from the your drive and
BEGIN
.. ... ...
.. ... ...
EXCEPTION WHEN OTHERS THEN
the_error := ERROR DESCRIPTION; ?
END;
Thanks,
Paolo
Hi.
I would want do a php script to access my postgres database from remote host. I
would like to know how I can do. Particularly, I would to know the default
directory where my database is located so that to be able to call it with my
php script.
---(end of broadcast)-
Hi, I'm new on postgres and I've just installed postgres 7.4.7 on a
debian sarge. I'm interested on using inheritance. I've tried a simple code:
CREATE TABLE t_main (
id serial primary key
);
CREATE TABLE t_derived1 (
field1 varchar(128)default NULL
) IN
Jebus scrisse in data 03/27/06 19:03:
I could be wrong but primary keys and other constraints are not inherited.
Thank you very much Jebus; in effect I've found in the mailing list
archives a 2003 thread "INHERITS and Foreign keys" that claim the same
problem. Someone (Stephan Szabo) answer
Richard Broersma Jr scrisse in data 03/28/06 15:18:
No it isn't. But I remember reading on one of the lists that it was on the to-do list for 8.2.
However, I do not know how high it is on the list of things to do. So I imagine that there is the
potential that it might not be added.
I'll wai
karthick muthu scrisse in data 04/06/06 07:54:
hello hai,
I am new to linux,now i have a job to maintain database using postgre
in debian,so i want to know the completebasic details about how to use
this.
thanking you
There are very useful manual online: http://www.postgresql.org/docs/
Hav
Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found a way to pass a password in a unattended way. So I have to
guess the only solution is to configure pg_hba.conf to use ident as
authenticat
Martijn van Oosterhout scrisse in data 04/13/06 10:47:
On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote:
Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found
Alle 16:54, mercoledì 10 marzo 2004, hai scritto:
> Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> > I have two query that they are different only for order of the tables
> > in FROM lclause , but give back different query plan :
>
> Hm, seems like the planner is ma
Alle 18:03, giovedì 11 marzo 2004, hai scritto:
> Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> > But the query plans are still various!!
>
> I think you made a copy-and-paste mistake, because the explain results
> you posted are exactly the same ...
>
>
Alle 19:40, mercoledì 10 marzo 2004, hai scritto:
> Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> > I have applied the procedure for fixing pg_statistic as you had said,
> > but the result is the same!
>
> Hm. It could be a planner bug. Can you reproduce the misbeha
Alle 20:14, giovedì 11 marzo 2004, hai scritto:
> On Thu, Mar 11, 2004 at 09:43:57 +0100,
>
> Paolo Tavalazzi <[EMAIL PROTECTED]> wrote:
> > Alle 19:12, mercoledì 10 marzo 2004, hai scritto:
> > > On Wed, Mar 10, 2004 at 18:33:41 +0100,
> > >
> >
Alle 18:53, giovedì 11 marzo 2004, hai scritto:
> Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> > [ query plans after updating to 7.4.2 ]
>
> Okay, they're certainly a lot closer than before, so I think I was right
> that you were getting bitten somehow by the pg_stati
I have 2 query that differ only for order by clause.
The time of execution of the two query is a lot of different.
1) explain analyze
select
tkstore.gruppo,tkstore.cassa,enabledcodes.sala,spettacoli.code
from
tkstore,enabledcodes,spettacoli
where
Hi everybody,
I have a little question about string types in PostgreSQL: it seems I don't
understood well how string data are stored in the database, from a recent
post by Tom Lane I feel encouraged to think that VARCHAR and TEXT are
treated the same way by PG, i.e. they occupy ony the space neede
hi there,
I've a big problem with my postgresql installation
I've postgresql 9.3 installed on docker; I start it via supervisord
I've never had issues with postgresql and I don't touched nothing (no
update, no changes)
this is my configuration
there's a file called postgresql.conf in /etc/supervi
wrote:
> Are you using docker on centos ? I had problem with
> centos/docker/postgresql because container size was (maybe still is)
> limited to 20GB on that specific OS. Maybe not related, but good to know
>
> 2015-10-03 0:03 GMT+02:00 John R Pierce :
>
>> On 10
15:19, Adrian Klaver wrote:
> On 10/03/2015 05:50 AM, Paolo De Michele wrote:
>
>> hi there,
>>
>> thanks a lot
>> so, I'm using docker on ubuntu 14.04
>> about permissions:
>>
>> # ls -la /var/lib/postgresql/9.3/main
>> total 72
>>
68 matches
Mail list logo
