I think I have found a bug in version 7.1.3. (I have installed binary
rpms from postgres site on rh7.1)
Here is the DB and some sample entries.
CREATE TABLE "timetest" (
"id" serial primary key,
"timebegin" time,
"timeend" time
);
insert into timetest (timeb
I have the defaul installation of postgres 7.0.3 and on another machine
7.1.2 on redhat 7.1
I cannont get the date in correct form:
dbme=# select data_ar from equipment limit 5;
data_ar
2001-11-05
2001-05-17
2001-05-28
2001-05-28
2001-05-22
(5 rows)
then:
dbme=# set dat
On Mon, 30 Oct 2000, [EMAIL PROTECTED] wrote:
>Large objects are not dumped. It should be
>in the documentation for large objects.
>
>You need to write a script which writes them to
>disk and then imports them back in after you have
>installed your dbs.
>
>
>Troy
CREATE TABLE news -- {
I need to move a DB from Pg 6.5 to 7 haw can i export Large Object to the
new DB ?
Pg_dumpall seems non to export LArge Object.
Please Help
Alex
-- Forwarded message --
Date: Sat, 23 Sep 2000 15:58:06 +0200 (CEST)
From: Alessandro Rossi <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: timestamp difference in hours?
I found in a post from Jeff MacDonald the following example:
bignose=> \d foo
T
I would like to know is there is a specific way to speed up my query to
postgres.
I have a DB-MACHINE that I use just and only for postgres witch runs
linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs.
I run vacuum every hour, but there is something else I can do (compile
postgres in a spec
