in reply to Re: Working with Postgresql serial data type in Perl
in thread Working with Postgresql serial data type in Perl

the integer that gets used doesn't matter to me it just has to be unique for each entry. I have not thought about not passing anything to anything to that column in the database.

  • Comment on Re^2: Working with Postgresql serial data type in Perl

Replies are listed 'Best First'.
Re^3: Working with Postgresql serial data type in Perl
by erix (Prior) on Dec 18, 2010 at 21:34 UTC

    It's all in the excellent manual: datatype serial (also available in PDF )

    Note that:

    Prior to PostgreSQL 7.3, serial implied UNIQUE. This is no longer automatic. If you wish a serial column to have a unique constraint or be a primary key, it must now be specified, just like any other data type.

    (Btw: a hint regarding the database name: call it postgresql, postgres, or even Pg, but calling it 'Postgre' makes the same impression as writing PERL instead of Perl).

[reply]

      Thanks for the help and also thanks for that hint, I will try to keep it in mind in the future.

[reply]

In Section Seekers of Perl Wisdom