Re: [pgadmin-support] Problem restoring backup file

2007-04-01 Thread Hiroshi Saito
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

Re: [pgadmin-support] Connecting sequence to table column

2007-04-01 Thread Quan Zongliang(Gmail)
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

[pgadmin-support] Connecting sequence to table column

2007-04-01 Thread Rohit Khare
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

[pgadmin-support] Problem restoring backup file

2007-04-01 Thread Rohit Khare
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?