> 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
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
"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
>
> 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
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
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
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
"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
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
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
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
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
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
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
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:
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
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
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
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
-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
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
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
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
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
> 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
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 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
> 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
28 matches
Mail list logo
