[EMAIL PROTECTED] wrote:
pgAdmin reports a SQL error when attempting to add a bigserial column to
an existing table.
I checked this, it works.
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
Not quite. The resulting sql query can be taken from the SQL page of the
dialog. What you present here is probably what's logged in pgadmin.log,
which might get truncated to 1k (AFAIR) for technical reasons.
Regards,
Andresa
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
