> Hello i start yesterday afternoon a COPY command into a table.
> the file is 15 Mb
> i've set triggers before and after insert on the table
> the before trigger just perform data check.
> the after trigger update a 10 000 rows linked table.
>
> the COPY command runs all the night ad has not yet
I got the file <<.patch>> and tried to upgrade postgres
sous FreeBSD with the command patch from the version 6.5.2 to
the version 6.5.3 but it doesn't work. Could somebody
explain to me how to upgrade postgres on my server.
Thank's for your help
__
Matthias
J. Roeleveld" a écrit :
> > Hello i start yesterday afternoon a COPY command into a table.
> > the file is 15 Mb
> > i've set triggers before and after insert on the table
> > the before trigger just perform data check.
> > the after trigger update a 10 000 rows linked table.
> >
> > the COPY com
> I had a similar thing once, while compiling a program, it took the
computer
> 28 hours to complete. (on a P200)
>
> My best guess is is that it's still running, make a quick check that the
> main
> process is still running. The action you are doing requires not just alot
of
> CPU-power, but also
Marc Tardif wrote:
> Now I'm back to square one, looking for a storage solution for my
> postgresql db. More specifically, something scallable and very fast. In my
...
> of hardware raid out there. But the question remains, how can all this be
> scallable, ie how can I expand on existing storage
Hi,
during execution of block of commands like
BEGIN
INSERT INTO...
INSERT INTO...
.
INSERT INTO...
COMMIT
sometimes receive the error
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the
Arnaud FLORENT writes:
> Hello i start yesterday afternoon a COPY command into a table.
> the file is 15 Mb
> i've set triggers before and after insert on the table
> the before trigger just perform data check.
> the after trigger update a 10 000 rows linked table.
>
> the COPY command run
create table tablename ( field1 text, field2 text);
CREATE
insert into tablename values('bottom','yes');
INSERT 2282464 1
insert into tablename values('top','no');
INSERT 2282465 1
select field1,field2 from tablename order by (field1||'-top');
field1|field2
--+--
bottom|yes
top |no
(2 r
-BEGIN PGP SIGNED MESSAGE-
Hmm well it definitely doesn't work for me, so I guess I need to
upgrade from version 6.3.2 in order for it to work (unless there's
some other workaround). Thanks...
- --
JEREMY MALCOLM [EMAIL PROTECTED] http://malcolm.wattle.id.au
SIG of the day: [x] Contact
A view is a table with a rule SELECT
For excample if you have a table named my_table
and you create a rule like:
CREATE RULE "_RETmy_table"
AS ON SELECT TO "my_table"
DO INSTEAD
SELECT * FROM your_table;
In this way you your table my_table
became a view.
José
Marc Tardif wrote:
> When lis
Under FreeBSD, you should be using the ports. In this case, you could
simply use the following commands in the postgresql port directory:
make
pkg_delete postgresql-6.5.2
make install
Though the procedure was simple, there was a little gotcha. You need to:
psql template1
select oid,* from pg_data
Hello,
I'd like to know if there is a way to use pg_connect() with a
different host than « localhost ».
I tried to put an IP address or a server name but it didn't work. Has
anybody ever used pg_connect with something else than localhost ?
Thank you
C
I would like more info about the pgtcl commands, too. In the
"Integrated Document" on the postgres web page, there's a list of
commands (chapter 49), but not detailed information. When I enter
pgtclsh, I can get a list of options. For pg_connect, I get this:
% pg_connect
pg_connect: database n
Dear Cecile,
You can do this with a connection string:
pg_connect -conninfo $string
...or directly, dos/unix style, as in
pg_connect $database -host $host -port $portNumber
Cheers
Rob
C
écile DESNOYERS <[EMAIL PROTECTED]> on 01/26/2000 12:48:14 PM
To: [EMAIL PROTECTED]
cc:(bcc:
On 2000-01-25, Marc Tardif mentioned:
> When listing my tables and indices in psql, I see a "view?" in type. What
> is this type? Where can I read about it in the manual?
CREATE VIEW
>
> The table listed as "view?" use to be listed as "table" but suddently
> changed when I added rules. Do rule
I would like to know if anyone has tips on scheduling daily backups of
PostgreSQL databases, scheduling daily vacuum's, or any other ongoing
maintenance hints about PostgreSQL. The documentation seems fairly thin in
this area, and I am sure a lot of people would benefit by this being
discussed.
D
Another thing that I cannot seem to figure out how to do is this, and I
would appreciate any help: How does one create a GROUP, add users to it, and
grant access to the group? CREATE USER doesn't seem to understand "IN GROUP
~" nor does GRANT seem to understand "TO GROUP ~". Am I doing somethin
Hello all,
I am using libpq++, and I cannot find the format for the connect string
passed as parameter to the PgDatabase constructor. Right now, I am forced to
use environment variables. Can anyone educate me?
Thanks,
Don Dade
__
Get Your Pr
Hi,
I'm surprised about how long certain things are taking. Here's what
I'm doing:
1. create a temp_table which is 5-7 columns by 1e4 - 1e5 rows.
This part is pretty quick.
2. when its done, copy it into the big table which is 7 columns by
about 5e7 rows.
What I'm surprised about is that the
I am running postgres 6.5.3 on an IRIX6.5. In psql, I can't
describe any table I create. I am able to select contents. Is this
a bug?
psql mydb
mydb=> \d
Database= bcams
+--+--+--+
| Owner | Relation
"Scott V. McGuire" wrote:
>
> I'm surprised about how long certain things are taking...
>
> What I'm surprised about is that the 10,000 row copies take < 1
> minute while the 5 row copies take > 10 minutes.
See http://www.deja.com/getdoc.xp?AN=563958392
I suspect vacuum also would have a d
This is really an OS question, but I'm posting here as it is caused by
pgsql backends and I suspect some of you have already dealt with it...
My combination of apache and postgresql is quickly exceeding the
maximum number of open files (4096) under linux RH6.1. In digging
around for how to up th
On Wed, Jan 26, 2000 at 04:51:26PM -0600, Ed Loehr wrote:
> See http://www.deja.com/getdoc.xp?AN=563958392
>
> I suspect vacuum also would have a dramatic impact on performance in
> your test case.
>
> Cheers,
> Ed Loehr
>
Ok, well there's at least two things I should have said. I am running
I need to sort the domains of email addresses from right to left, so that
all similar domains are grouped together. For instance, all .ca's will be
in the same batch.
I think I should be writing a trigger for this, using a secondary table
for the reverse domain name, then using a query like:
sele
>
> This is really an OS question, but I'm posting here as it is caused by
> pgsql backends and I suspect some of you have already dealt with it...
>
> My combination of apache and postgresql is quickly exceeding the
> maximum number of open files (4096) under linux RH6.1. In digging
> around for
"Scott V. McGuire" wrote:
>
> > See http://www.deja.com/getdoc.xp?AN=563958392
> >
> > I suspect vacuum also would have a dramatic impact on performance in
> > your test case.
>
> Ok, well there's at least two things I should have said. I am running
> with -F and I did a vacuum analyze last nig
I've been trying to see the limit for entering data in a text field using
the following commands:
copy test_table from '/my/file';
delete from test_table;
Suddenly, after a successful delte, I got:
ERROR: heap_delete: (am)invalid tid
What does this mean? Is it a bug or have I done something wron
> Dear Cecile,
>
> You can do this with a connection string:
>
> pg_connect -conninfo $string
>
> ...or directly, dos/unix style, as in
>
> pg_connect $database -host $host -port $portNumber
PS : port number can be found in /tmp/socket file
28 matches
Mail list logo
