You might suffer from a deadlock.
On Tue, 17 Jul 2001, Ben-Nes Michael wrote:
> Hi All
>
> VACUUM ANALYZE;
>
> return me the next error:
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while proce
People, saying that it is easy to install Pg on NT
using Cygwin environment does not assume that *using*
Pg on win32 can be done the way a MS product is
-- that is, clicking on an icon and playing with the
toy without never ever reading any doc.
You must initb, then create your databases, etc. Do
Why don't you read the INSTALL file, included in
any pg distribution ?
On Tue, 27 Feb 2001, will trillich wrote:
> when upgrading from version X to version Y of postgres, the
> install appears to dump the data and schema, and then suck it
> back in with the new binaries.
>
> [i just tried going
su - postgres
chmod u+w ~/data/pg_hba.conf
vi ~/data/pg_hba.conf
chmod u-w ~/data/pg_hba.conf
Eric Webber wrote:
>
> users dont seem to need password in postgres 7 on red hat linux
> 6.2, compiled from source.
>
> I do an:
>
> alter user nsadmin with password 'whatever';
>
> And then when
Hello;
when running a daily vacuum, my cron regularly reports this
message from Pg (7.0 RC1 / RH5.2 with glibc2.1 / compiled
with gcc 2.5.2):
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
Does anyone know what it means exactly ?
The messag
have had to be modified:
i was doing "select distinct on my_field aaa, bbb, my_field ..."
which is not correct any more. Pg7 insists that you write
"select distinct on (my field) aaa, " instead. That's all
I've got to say about it, so far.
Thanks you everyone who coded it, for this smart new Pg release.
Fabrice Scemama
And yes, even with it, I come
across bad surprises, very often. So often that I've been
in the obligation to refuse that people send me Excel tables.
Access is the maximum I can tolerate (ODBC is ok at least).
Fabrice Scemama
Chris Carbaugh wrote:
>
> Can't you just export the excel
ay) {
print "$$> Code_Ag: [$row[1]]\n";
$sth_Bind->execute($row[0]);
}
$sth->finish;
print "\n\nOK?";;
$dbh->commit;
$dbh->disconnect;
--------cut
And this script will do the DELETE within less
than a minute.
Any ideas about a way to write a single query that fast ?
Fabrice Scemama
tuned and fastest database, and
could not afford them anyway. But we enjoy Postgres'
handling transactions so well.
We vacuum everything every day, and like Pg a lot.
Thanks to the developing community.
Go and use it with no fear!
Fabrice Scemama
Gesnet Consulting / Paris
Hi !
Is there a way to select only a range of rows from a table, using a command
like:
SELECT * FROM table WHERE where_statement LIMIT 50,100;
I've tried, and then read the doc, but found no information so far.
Thanks in advance.
Fabrice Scemama
10 matches
Mail list logo
