I have the strange scenario where one of my tables has a primary key with a
datatype of varchar, and one record in that table has an empty string key i.e.
create table test (
id VARCHAR(255) NOT NULL,
test TEXT,
PRIMARY KEY (id)
) WITHOUT OIDS;
INSERT INTO test (id,test) VALUES ('',
Hi developers! Hi Dave!
Testing pgAdmin III v1.6.3 rev: 5941, client Win XP, host: Debian Sarge,
PG 8.1.8.
I have noted a peculiarity with seuqences.
If I change the "Current value" in the properties dialogue of a sequence
to a new value (111 in my example) pgAdmin sends this SQL statement t
Mateus wrote:
> log de erro pgAgent:
>
> $ pgagent -f host=127.0.0.1 dbname=bd user=scott -l 2
> DEBUG: Creating primary connection
> DEBUG: Creating DB connection: host=127.0.0.1 dbname=bd user=scott
> DEBUG: Database sanity check
> DEBUG: Clearing zombies
> DEBUG: Checking for jobs to run
log de erro pgAgent:
$ pgagent -f host=127.0.0.1 dbname=bd user=scott -l 2
DEBUG: Creating primary connection
DEBUG: Creating DB connection: host=127.0.0.1 dbname=bd user=scott
DEBUG: Database sanity check
DEBUG: Clearing zombies
DEBUG: Checking for jobs to run
DEBUG: Creating job thread f
The pgAdmin Development Team are pleased to announce the release of
pgAdmin 1.6.3, the Open Source graphical PostgreSQL administration tool
for Windows, Linux, FreeBSD , Mac OS X and Solaris, now available for
download in source and a variety of binary formats from:
http://www.pgadmin.org/down
