Re: [pgadmin-support] bigserial problem

[rich . morrison]

Thank you,

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

[EMAIL PROTECTED] wrote on 10/04/2005 01:33:06 PM:

> [EMAIL PROTECTED] wrote:
> >
> > pgAdmin reports a SQL error when attempting to add a bigserial column to
> > an existing table.
>
> I checked this, it works.

Are you using the same program version that I am? It fails on my computer with the previously stated error. I'm using the US English, Win32, verion 1.2.2.0 build installed with the msi installer.

>
> >
> > 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.

Nope. I copied the statement from the SQL tab from the properties dialog of a table I created earlier.

I copied this one from the same dialog as well:

CREATE SEQUENCE public.tbltest_s_seq;
ALTER TABLE tbltest
   ADD COLUMN s int8;
ALTER TABLE tbltest
   ALTER COLUMN s SET DEFAULT nextval('public.tbltest_s_seq'::text);
INSERT INTO pg_depend(classid, objid, objsubid, refclassid, refobjid, refobjsubid, deptype)
SELECT cl.oid, seq.oid, 0, cl.oid, 17474::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.relname='tbltest_s_seq'
  AND sn.nspname='public'
  ANDALTER TABLE tbltest
   ADD COLUMN test varchar(30);

Notice the 'ANDALTER'? Part of the previous query is definately missing.

Clicking ok on the dialog gives the error: ERROR:  syntax error at or near "ANDALTER" at character 509.

Running the SQL statement in the SQL window gives the error: ERROR:  syntax error at or near "ANDALTER" at character 521.



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