Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-29 Thread Hans-Jürgen Schönig
Pierre Emmanuel Gros wrote: 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 sam

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-26 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Sun, 2004-07-25 at 22:23, Tom Lane wrote: >> I don't think >> it's either practical or interesting to try to introduce an equivalent >> layering into Postgres. > I can possibly see a use for a row locking storage system, i.e. non MVCC > for some app

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Scott Marlowe
On Sun, 2004-07-25 at 22:23, Tom Lane wrote: > I don't think > it's either practical or interesting to try to introduce an equivalent > layering into Postgres. I can possibly see a use for a row locking storage system, i.e. non MVCC for some applications. But I can't see it being worth the amount

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Gavin Sherry
On Mon, 26 Jul 2004, Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Postgres was, however, one of the systems that in fact pioneered > > pluggable storage managers. So we could say we're already one > > generation ahead of everyone else: we had switchable storage managers, > >

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Postgres was, however, one of the systems that in fact pioneered > pluggable storage managers. So we could say we're already one > generation ahead of everyone else: we had switchable storage managers, > realized we didn't need them, and got rid of

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Peter Eisentraut
Gaetano Mendola wrote: > We have only one engine: the full transactional one. If the OP need > to have for example the MEMORY one the he can easily create a RAM > disk and with the tablespaces support he can create tables or index > or whatever objects in memory. Well, it certainly could make sens

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Gaetano Mendola
Andreas Pflug wrote: Pierre Emmanuel Gros wrote: 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. MySQL needs this because they have a weird understanding of RDBMS. This could be true, but the answer doesn't make

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT) ENGINE

2004-07-25 Thread Bruce Momjian
Pierre Emmanuel Gros wrote: > 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 mak

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

2004-07-25 Thread Andreas Pflug
Pierre Emmanuel Gros wrote: 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. MySQL needs this because they have a weird understanding of RDBMS. There's absolutely no sense in trying to transfer this stuff into Po

[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