Hi,
I am using 7.3.2 on redhat linux 7.3.
I am getting this error during update. My update sql is,
test_pg=# update po_header set emp_name = a.user_name from users a where
emp_code = a.user_code and emp_name != a.user_name and a.user_name is not
null;
I referred the link,
http://archives.pos
Hi,
I am using pgsql 7.3.2.
If we change the deadlock_timeout value in postgresql.conf and say pg_ctl
reload, the new value is not taken affect. But any other changes like,
datestyle, log_connection, log_pid, etc are taken affect immediately when
we say pg_ctl reload. When we restart the server,
> Dear Sir,
> I have been using postgreSQL through PHP for last 7 days.
> it was working absolutely fine But today when i created
> new tables in the database, It dint allow me to insert
> records into it. though i can insert records into old
> tables which are in the same database.The error is
> I'm Using PostgreSQL v. 7.3.2 on FreeBSD 4.7-RELEASE-p7.
>
> I was unable to delete several rows :
>
> void=> select * from banners where banner is NULL;
> id | count | max | banner_group | banner
> +---+---+--+
> 25 | 2328 | 10008 |2 |
> 4 |
> I manage several databases PostgreSQL 7.3.1 and I have noticed a problem.
> When I delete many rows (with OID) the free space of disk doesn't changed !
> I make a vacuumdb, but I doesn't notice an increase of the free space disk.
> In a last step, I make a backup and a restoration but, it's the
> [Mahesh-Ss-Computer:~] ampleuser% createdb test
> psql: could not connect to server: No such file or
> directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/tmp/.s.PGSQL.5432"?
> createdb: database creation failed
I am not sure about mac,
