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

2004-06-09 Thread Paulovi Michal
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

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 AU

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

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);

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

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