> 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
removed:
test=# \d te
>> 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
> 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
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
Holger Klawitter wrote:
>
> 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 :-(
> >
> > So only way is:
> > DROP TABLE and then again CREATE TABLE with all the fields
> > you
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
