[HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT) ENGINE = INNODB|BDB

2004-07-25 Thread Pierre Emmanuel Gros
In mysql, we can wrote a create table like CREATE TABLE t (i INT) ENGINE = INNODB||BDB|; where the storage engine is the innodb one. This allow to have differents kind of storage format, and allow to easly implements memory table or remote table. I try to make the same thing for postgresql but i

[HACKERS] storage manager

2004-07-09 Thread Pierre Emmanuel Gros
Hi, I would like to knwo how to extends the storage manager to other device ( i try to add remote device to postgres engine). I saw that i have to implement the interface f_smgr describe in smgr.c , but I do not know how to tell to postgres to use my new device . Is anyone could help me Thanks pi

Re: [HACKERS] constraint upon view

2004-06-20 Thread Pierre Emmanuel Gros
38 am, Pierre Emmanuel Gros wrote: > > >>Hi, >>I would like to know if i can add constraint and typed column upon a >>create view sentence. >>something like create view toto (a INTEGER primary key , b VARCHAR) as >>select . >>If it

[HACKERS] constraint upon view

2004-06-02 Thread Pierre Emmanuel Gros
Hi, I would like to know if i can add constraint and typed column upon a create view sentence. something like create view toto (a INTEGER primary key , b VARCHAR) as select . If it is not possible , what to have to change in the backend sources to obtain the result ??? Thank you Pierre