Re: Sequence name with SERIAL type - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Sequence name with SERIAL type
Date
Msg-id 20031217021933.A4037@quality.qadas.com
Whole thread Raw
In response to Sequence name with SERIAL type  (Marek Lewczuk <newsy@lewczuk.com>)
List 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/

pgsql-general by date:

Previous
From: Miso Hlavac
Date:
Subject: md5 function
Next
From: Tom Lane
Date:
Subject: Re: Sequence name with SERIAL type