Hi all!
well, can somebody tell me how to move a DB (e.g. I have a DB named NET in
PC1 under pg6.5.3 and I want to put it in PC2 under pg7.0)
should I copy just the data/base/NET/ directory and the paste it in the
data/base of the PC2...
which are the exactly steps...
:o) thanx
Rocael
___
Suppose that I have created a LOB, written a bunch of data to it, and
committed.
Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC)
or ftruncate(...) on a LOB?
Or am I forced to delete the exis
Fabrice Scemama <[EMAIL PROTECTED]> writes:
> No core dump could be found within the data/base/* directories.
Hm. When I've seen a backend crash without leaving a core file,
it's usually because the backend ran up against the system's
per-process memory limit. (Many kernels seem to choose not t
Hi,
Anyone know if Postgresql can replicate this Oracle nested sub-select query
(it uses the Oracle CURSOR operator)
SELECT deptname,
CURSOR (SELECT Empname, Sal
FROM emp
WHERE emp.deptno=department.deptno) AS Employees
FROM department
Where deptno=x
I want
Is there any easy way to find out the number of rows updated by a update
or insert statement in pl/pgsql? I searched the mailing list archives and
didn't come up with anything. Oh and BTW doing an insert/update combined
with select following won't exactly work as it is possible for this table
to
Oops, ignore that first post :)
I am unable to get the following query to use an index scan, any
suggestions?
Query
-
SELECT username, acctsessiontime, acctinputoctets, acctoutputoctets FROM
radacct WHERE ((tstamp >= '06-04-2000 00:00:00-04') AND (tstamp <
'06-05-2000 00:00:00-04') AND (acct
No core dump could be found within the data/base/*
directories. The cron is executed by user root,
but on my system root is a PostgreSQL superuser.
Tom Lane wrote:
>
> Fabrice Scemama <[EMAIL PROTECTED]> writes:
> > [ vacuum appears to be coredumping ]
>
> That's odd ... not so much that vacuum
Hi,
Instead of using
select car_name
from car_table
where car_property[1]='1995'; (*)
Can I use
where car_property['year']='1995';
in Postgres?? I want to use a more descriptive name than just using
index for the array (not just during insertion but as well as to specify
it i
Thanks very much everyone!
> BTW, this *is* covered in the FAQ, see
> http://www.postgresql.org/docs/faq-english.html#4.22
Ahh, but I did look at a FAQ! I just went back and checked the date, I guess
I shouldn't have just skimmed down the page: Last updated: Mon Oct 14
08:05:23 EDT 1996.
Fabrice Scemama <[EMAIL PROTECTED]> writes:
> [ vacuum appears to be coredumping ]
That's odd ... not so much that vacuum could be failing, which is
probably a garden-variety bug; but it sounds like the postmaster is
failing to do the system restart that it should do after one of the
backends fai
Hi people.
For a few days, i've been experiencing some problems.
There's a cron-scheduled vacuum, performed every night.
But, on the morning, my DBs can't be accessed. Error
message says "DB busy, too many connected" (about so).
And, ps ax|grep post shows a lot of backends, waiting
for an unlock
Kovacs Zoltan Sandor <[EMAIL PROTECTED]> writes:
> There is a function "function_y(...)" which returns int4; a table z and
> two functions:
> CREATE FUNCTION function_x1() RETURNS int4 AS '
> select function_y(any_of_fields_of_table_z) from z;
> ' LANGUAGE 'SQL';
> This calls function_y(...) onl
Tom Lane wrote:
>
> "Rob S." <[EMAIL PROTECTED]> writes:
> > ...but I still don't see how to have the default value of a timestamp to be
> > the time at which the individual record is inserted. I just get the time I
> > created the table.
> Versions before 7.0 are not entirely consistent abou
Allan Kelly <[EMAIL PROTECTED]> writes:
> The intranet mirror for the client later grabs the file from the ISP
> and attempts the same 'psql -f' but appears to stop after a few
> inserts.
"Appears to stop" is hardly enough of a problem description to allow
useful advice to be given. Does the pro
"Rob S." <[EMAIL PROTECTED]> writes:
> ...but I still don't see how to have the default value of a timestamp to be
> the time at which the individual record is inserted. I just get the time I
> created the table. Specifically, what to put where the '?' is at.
> ... "TimeDate" TIMESTAMP DEFAULT
I am running PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66.
I have currently a table like the following:
TABA:
a|start|finish
-+-+--
R|4| 8
S|6|10
I want the output a table with start incremented by 1, and fininsh as the maximum of
fininish in all r
Hello,
I know this is off topic but I thought you might like to know that
the following book explains how to compile, install and secure
postgresql.
It can be purchased from http://www.linuxports.com/ (just click on the
books) and 20% goes back to the OpenSource Documentation Fund.
THe Origina
Hi, I have mirrored our Web site to a client's intranet, using tried and tested
techniques. Every day I generate a new file containing some table drops, some
table creates and about 7000 insert statements. This is ftp'd up to our ISP,
where a cronjob uses 'psql -f' to update the Website data. Grea
I realized the following facts using SQL language functions:
There is a function "function_y(...)" which returns int4; a table z and
two functions:
CREATE FUNCTION function_x1() RETURNS int4 AS '
select function_y(any_of_fields_of_table_z) from z;
' LANGUAGE 'SQL';
This calls function_y(...) on
"Rob S." wrote:
>
> As a precursor to this question, I read:
>
> CREATE TABLE
> Date/Time Types (and corresponding input/output)
> Date/Time Functions
>
> ...but I still don't see how to have the default value of a timestamp to be
> the time at which the individual recor
As a precursor to this question, I read:
CREATE TABLE
Date/Time Types (and corresponding input/output)
Date/Time Functions
...but I still don't see how to have the default value of a timestamp to be
the time at which the individual record is inserted. I just get the time
21 matches
Mail list logo
