Hello all,
Due to bug (?) I can't trace insertions into
table with SERIAL. E.g., if a table contains column
of a type SERIAL with name 'id', when RULE activated
NEW.id equals X, but real 'id' of a inserted record is X+1.
(Here the RULE definition:
CREATE RULE log_orders AS ON INSERT TO orders
Please help with the following issue:
The postmaster process is being restarted automatically and I don't know
why.
Initially it appears as "/usr/bin/postmaster -i -D /var/lib/psql" in the PS
table.
When it is restarted the pid is different and the -i is no longer. It now
looks like this:
/usr
> psql mydb
connectDB() -- connect() failed: Connection refused
Is the postmaster running at 'localhost' and accepting connections on
Unix socket '5432'?
Everything ok set according to the rules, unix soket connection works OK
for awhile after restarting the postmaster but after it's been runnin
Hi, all:
PostgreSQL 7 Beta 5 on Red hat Linux 6.0
We have a a table which has a column col_a with 'timestamp' data type. When
insert time value to this column, we use format which is 'MM/DD/
HH24:MI:SS' (such as '05/01/2000 13:20:02'). Insertion is OK.
But when we try to read this column, t
I found a couple of pg_sorttemp* files in my database directory. Is it safe
to delete these? They're quite large (around 40MB each) and have a creation
date of a couple of days ago.
Brian
--
Brian Baquiran <[EMAIL PROTECTED]>
http://www.baquiran.com/
AIM: bbaquiran
Hi,
I am trying to run postgres on unixware2.1.2.
On starting the postmaster i am getting an error in shmget()...
IpcMemoryCreate: memKey=155356396 , size=760632 ,
permission=384IpcMemoryCreate: shmget(..., create, ...)
failed: Invalid argument
Postmaster only starts if st
