Re: [GENERAL] SERIAL type - auto-increment grouped by other field

2004-06-09 Thread Paulovič Michal
:(( 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' ; After you do

Re: [GENERAL] Moving from MySQL to PGSQL....some questions (multilevel

2004-03-03 Thread Paulovič Michal
Bruno Wolff III wrote: On Wed, Mar 03, 2004 at 18:12:18 +0100, Paulovi?? Michal <[EMAIL PROTECTED]> wrote: You don't build secent level unique You have to create uniqe index under both levels (first and second) together. But in MySQL there is no problem. I alredy have table with mulitlevel au

Re: [GENERAL] Moving from MySQL to PGSQL....some questions (multilevel

2004-03-03 Thread Paulovič Michal
Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, "scott.marlowe" <[EMAIL PROTECTED]> writes: On Tue, 2 Mar 2004, [UTF-8] PauloviÃÂ Michal wrote: how you solve the problem with multilevel autoicrement? In MySQL you create table with col1, col2. Col 2 is AUTOICRE

Re: [GENERAL] max table size

2004-03-02 Thread Paulovič Michal
sorry wrong link at erlier response. here is correct http://www.postgresql.org/docs/faqs/FAQ.html#4.5 Alan Carbutt wrote: Hi all, I'm running a data warehouse in Postgres and I was wondering what the max table size is column-wise and row-wise. I tried to search the lists and documentation on the

Re: [GENERAL] max table size

2004-03-02 Thread Paulovič Michal
Oficial answer in FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.6 Alan Carbutt wrote: Hi all, I'm running a data warehouse in Postgres and I was wondering what the max table size is column-wise and row-wise. I tried to search the lists and documentation on the http://www.postgresql.org and

Re: [GENERAL] Moving from MySQL to PGSQL....some questions (multilevel

2004-03-02 Thread Paulovič Michal
how you solve the problem with multilevel autoicrement? In MySQL you create table with col1, col2. Col 2 is AUTOICREMENT and you have to create UNIQUE INDEX (Col1, Col2). If you insert to this table for col1 volume 1, col2 automaticaly increase by one. Example: Insert into table values (1); Ins