[pgadmin-support] bigserial problem

[rich . morrison]

pgAdmin reports a SQL error when attempting to add a bigserial column to an existing table.


server: CentOS 4.1 and Postgre 7.4
client: XP Sp 2 and pgAdmin 1.2.2

Adding the column produces this SQL statement:

CREATE SEQUENCE public.tblenglish_in_trnas_id_seq;
ALTER TABLE tblenglish_in
   ADD COLUMN trnas_id int8;
ALTER TABLE tblenglish_in
   ALTER COLUMN trnas_id SET DEFAULT nextval('public.tblenglish_in_trnas_id_seq'::text);
INSERT INTO pg_depend(classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype)
SELECT cl.oid, seq.oid, 0, cl.oid, 17154::oid, attnum, 'i'
  FROM pg_class cl, pg_attribute, pg_class seq
  JOIN pg_namespace sn ON sn.OID=seq.relnamespace
 WHERE cl.relname='pg_class'
  AND seq.rel

and results in this error:

ERROR:  column seq.rel does not exist


If there is a comment, a differene error results:

CREATE SEQUENCE public.tblenglish_in_trans_id_seq;
ALTER TABLE tblenglish_in
   ADD COLUMN trans_id int8;
ALTER TABLE tblenglish_in
   ALTER COLUMN trans_id SET DEFAULT nextval('public.tblenglish_in_trans_id_seq'::text);
INSERT INTO pg_depend(classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype)
SELECT cl.oid, seq.oid, 0, cl.oid, 17154::oid, attnum, 'i'
  FROM pg_class cl, pg_attribute, pg_class seq
  JOIN pg_namespace sn ON sn.OID=seq.relnamespace
 WHERE cl.relname='pg_class'
  AND seq.relCOMMENT ON COLUMN tblenglish_in.trans_id IS 'id of transmission';


ERROR:  syntax error at or near "ON" at character 530


It appears that the SQL that pgAdmin is building is cut off. Maybe the buffer being written to is too small?

Here's the SQL for creating a table with a bigserial:
CREATE TABLE test
(
   test bigserial
) WITHOUT OIDS;

This is much shorter than the otherer SQL statement.


Thank you,

Richard Morrison
Sr. Software Engineer
ATX II, LLC
"In Rich We Trust!"