Re: SERIAL type - auto-increment grouped by other field
От | Paulovič Michal |
---|---|
Тема | Re: SERIAL type - auto-increment grouped by other field |
Дата | |
Msg-id | 4043A879.4070508@paulovic.sk обсуждение исходный текст |
Ответ на | Re: SERIAL type - auto-increment grouped by other field (elein <elein@varlena.com>) |
Список | pgsql-general |
:(( sorry At server ther is istalled pgsql 7.1.2 but creatlang works from 7.2.X and upper version :( do you have any other ideas?? elein wrote: > You just need to define 'plpgsql' as a language in > your database. At the shell, to define the language use: > > createlang 'plpgsql' <dbname>; > > After you do the createlang, you can write functions > using plpgsql. > > Let me know if you are still having trouble. > >--elein > > >>On Mon, Mar 01, 2004 at 09:52:33PM +0100, Paulovi?? Michal wrote: >> >> >>>tnx a lot, >>> >>>but i am using PostgreSQL 7.1.2 and your script result errors: >>>------- >>>ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. >>> Recognized languages are sql, C, internal, and created procedural languages. >>>------- >>> >>>elein wrote: >>> >>> >>> >>>>One possible implementation of a two level numbering outline >>>>will be published in PostgreSQL GeneralBits Issue #64 due >>>>out Monday morning, 3/1. http://www.varlena.com/GeneralBits/ >>>> >>>>elein >>>>============================================================ >>>>elein@varlena.com Varlena, LLC www.varlena.com >>>> 1-866-VARLENA >>>> PostgreSQL Consulting, Support & Training >>>> >>>>PostgreSQL General Bits http://www.varlena.com/GeneralBits/ >>>>============================================================= >>>>Its a doggy dog world out there. >>>> >>>> >>>>On Sun, Feb 29, 2004 at 02:44:01AM +0100, Paulovi? Michal wrote: >>>> >>>> >>>> >>>> >>>>>hi all, >>>>> >>>>>I have problem with SERIAL field type (or sequence functionality). >>>>>I have table with three columns - ID, IDS, NAME. >>>>>I want auto-increment IDS grouped by ID. >>>>>Example: >>>>>1, 1, Ferdo >>>>>1, 2, John >>>>>2, 1, Martin >>>>>1, 3, Elvira >>>>>2, 2, Georgia >>>>> >>>>>but... >>>>>when I use IDS - SERIAL and when I create UNIQUE (ID, IDS) result is: >>>>>1, 1, Ferdo >>>>>1, 2, John >>>>>2, 3, Martin >>>>>1, 4, Elvira >>>>>2, 5, Georgia >>>>> >>>>>where i make misstake??? how can i do it??? in documentation there is >>>>>description only for one auto-increment column. I didn't find auto >>>>>increment as >>>>>I described upper. Do you have any idea how can I do it??? >>>>> >>>>>tnx a lot >>>>> >>>>> >>>>>________ Information from NOD32 ________ >>>>>This message was checked by NOD32 Antivirus System for Linux Mail Server. >>>>>http://www.nod32.com >>>>> >>>>>---------------------------(end of broadcast)--------------------------- >>>>>TIP 2: you can get off all lists at once with the unregister command >>>>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >>>>> >>>>> >>>>> >>>>> >>>>________ Information from NOD32 ________ >>>>This message was checked by NOD32 Antivirus System for Linux Mail Server. >>>>http://www.nod32.com >>>> >>>> >>>> >>>> >>>> > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > >________ Information from NOD32 ________ >This message was checked by NOD32 Antivirus System for Linux Mail Server. >http://www.nod32.com > > >
В списке pgsql-general по дате отправления: