Re: Sequence name with SERIAL type

From: Michael Fuhr <mfuhr+pgsql-general(at)fuhr(dot)org>
To: Marek Lewczuk <newsy(at)lewczuk(dot)com>
Cc: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequence name with SERIAL type
Date: 2003-12-17 09:19:33
Message-ID: 20031217021933.A4037@quality.qadas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 17, 2003 at 08:59:03AM +0100, Marek Lewczuk wrote:
> I'm curious if the default scheme for sequence name (which is created
> with SERIAL data type) can be changed -- currently all sequences are
> named like this: <table_name>_<field_name>_seq -- can it be changed for
> e.g. <table_name>__<field_name>__seq ???

You'd have to hack the source code. See the transformColumnDefinition()
and makeObjectName() functions in src/backend/parser/analyze.c.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-17 09:23:00 Re: Sequence name with SERIAL type
Previous Message Miso Hlavac 2003-12-17 08:47:01 md5 function