If you went from a dual processor box running windows to a single
processor box running windows, I wouldn't be surprised to see a slow
down. I'd recommend switching from Windows to Linux/BSD over a hardware
upgrade any day.
Robert Treat
On Wed, 2003-08-06 at 18:04, Maksim Likharev wrote:
> What
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 06 August 2003 08:18, Stef wrote:
>
> Can anybody help, or give some links to good
> help resources?
>
Try the performance list.
Attach the create statements used to create the tables, the query you are
running, and the different explai
hello all
When i tried ´pg_dump -v -f dump.dmp dtbtransporte´ I got
the error:
pg_dump: restoring data for table tbdmovimento
pg_dump: dumping out the contents of table tbdmovimento
pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value
6935693
pg_dump: lost synchronization
For all french people in this list :
I search books about postgresql in French
with explanations of tree structure functions,
optimisation of install
not novice books
Thx a lot
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaste
Hi all,
I suppose this must be easy to figure out, but I can't find it anywhere in
the documentation.
How do I call a function that takes a rowtype for an argument as in:
CREATE FUNCTION myfunc(mytablename) RETURNS INT AS '
BEGIN
-- Do stuff
RETURN val;
END;
' LANGUAGE 'plpgsql'
I have to duplicate a table to save different instances of datas.
Structure de la table "spectacle"
*/
CREATE TABLE "spectacle" (
id_spectacle SERIAL,
"id_membre_adherent" INTEGER NOT NULL,
"id_genre_festival" INTEGER,
"id_fes
Alexandre,
> It´s very difficult to change the behaviour of a duplicate PK, from
> "error" to "warning"?
That would be a very bad idea because then the duplicate row would be inserted
anyway. And you'd have to hack the source code.
> It´s possible, in a future release, to have an exception-ha
