Hi.
Please see,
http://www.pgadmin.org/docs/1.6/backup.html
pg_dump does not support all options for all backup file formats. Particularly, to backup
blobs the PLAIN format can not be used. Also, a PLAIN file can not be interpreted, and
can not be restored using pgAdmin. The PLAIN format will
You must set the type of column to be serial or bigserial.
Regards.
Quan
On Mon, 2 Apr 2007 10:50:26 +0530
"Rohit Khare" <[EMAIL PROTECTED]> wrote:
> I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns
> to a table from pgAdmin front-end, an option appears "sequence" wi
I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns
to a table from pgAdmin front-end, an option appears "sequence" with a
drop-down box on the column creation window, but it remains disabled. I have
already created a sequence but want to connect that sequence with this
co
I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain"
option from pgAdmin 1.6. When I am trying to restore it to a new machine
having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore
Backup Window" remains disabled. Why?