[GENERAL] Re: "alter table...if exists... add bigserial "still adds extra sequence

> On 25 Sep 2017, at 09:51 , hvjunk wrote: > > Good day, > > See the sequence below, Postgresql 9.6.5 on Debian using the postgresql > repository. > > Question: Is this expected behaviour? I guess it might be, but the “bug” is that the excessive/unused sequence isn’t

[GENERAL] Re: ALTER TABLE ADD CONSTRAINT

I am generating scripts from MSSQL Server and converting them to create objects in PostgreSQL. It is suprisingly easy. However, I think I may have hit a rock. It appears that PostgreSQL does not support listing constraints to be added as in the following syntax: I don't know why it won't

Re: [GENERAL] Re: ALTER TABLE ADD CONSTRAINT

Also, I see that alter table add constraint does not work for defaults. Is this something that is going to be added? That I do hope will be added since the only way to replicate the functionality is to drop, readd and repopulate a table. Greg I am not sure specifically what you are

Re: [GENERAL] Re: alter table

On Sun, Mar 12, 2000 at 05:57:50PM +0200, Raigo Lukk wrote: Hi alter table tmp add column last text; I had this same problem, turned out that PostgreSQL don't have this feature :-( Upgrade: ALTER TABLE tablename ADD COLUMN columnname columntype Has been a feature since version

[GENERAL] Re: alter table

Hi alter table tmp add column last text; I had this same problem, turned out that PostgreSQL don't have this feature :-( So only way is: DROP TABLE and then again CREATE TABLE with all the fields you need. Raigo