bigserial problem

[rich(dot)morrison(at)atxinc(dot)com]

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!"