You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by Jean-Philippe Courson <ju...@b2web.fr> on 2001/11/16 11:46:07 UTC

PostgreSQL supported !

Hi,

PostgreSQL is able to store slide's content using oid data type for blobs.

I have tested it and it works perfect.

Folows the PostgreSQL database creation script (the Oracle one with just
oid replacing blob)

I think it would be a good thing to add it to the JDBC Store Howto.

Jean-Philippe

create table objects(uri varchar(3200) primary key, classname varchar(4000));

create table children(uri varchar(4000), childuri varchar(4000));

create table links(link varchar(4000), linkto varchar(4000));

create table permissions(object varchar(4000), revisionnumber varchar(20), subject varchar(4000), action varchar(4000), inheritable int, negative int);

create table locks(id varchar(4000), object varchar(4000), subject varchar(4000), type varchar(4000), expirationdate varchar(15), inheritable int, xexclusive int);

create table revisions(uri varchar(3200) primary key, isversioned int, initialrevision varchar(10));

create table workingrevision(uri varchar(4000), baserevision varchar(20), xnumber varchar(20));

create table latestrevisions(uri varchar(4000), branchname varchar(4000), xnumber varchar(20));

create table branches(uri varchar(4000), xnumber varchar(20), childnumber varchar(20));

create table revision(uri varchar(4000), xnumber varchar(20), branchname varchar(4000));

create table label(uri varchar(4000), xnumber varchar(20), label varchar(4000));

create table property(uri varchar(4000), xnumber varchar(20), name varchar(4000), value varchar(4000), namespace varchar(4000), type varchar(100), protected int);

create table revisioncontent(uri varchar(4000), xnumber varchar(20), content oid);


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: PostgreSQL supported !

Posted by Jean-Philippe Courson <co...@noos.fr>.
----- Message d'origine -----
De : "Dirk Verbeeck" <di...@pandora.be>
À : "Slide Developers List" <sl...@jakarta.apache.org>
Envoyé : dimanche 18 novembre 2001 19:36
Objet : Re: PostgreSQL supported !
>
> Great news, another DB supported
>
and a very good one
>
> Thanks for testing,
> Dirk

Thanks JDBC !

and thanks for putting it in the Howto

Jean-Philippe

>
>
>
> Jean-Philippe Courson wrote:
> >
> > Hi,
> >
> > PostgreSQL is able to store slide's content using oid data type for
blobs.
> >
> > I have tested it and it works perfect.
> >
> > Folows the PostgreSQL database creation script (the Oracle one with just
> > oid replacing blob)
> >
> > I think it would be a good thing to add it to the JDBC Store Howto.
> >
> > Jean-Philippe
> >
> > create table objects(uri varchar(3200) primary key, classname
varchar(4000));
> >
> > create table children(uri varchar(4000), childuri varchar(4000));
> >
> > create table links(link varchar(4000), linkto varchar(4000));
> >
> > create table permissions(object varchar(4000), revisionnumber
varchar(20), subject varchar(4000), action varchar(4000), inheritable int,
negative int);
> >
> > create table locks(id varchar(4000), object varchar(4000), subject
varchar(4000), type varchar(4000), expirationdate varchar(15), inheritable
int, xexclusive int);
> >
> > create table revisions(uri varchar(3200) primary key, isversioned int,
initialrevision varchar(10));
> >
> > create table workingrevision(uri varchar(4000), baserevision
varchar(20), xnumber varchar(20));
> >
> > create table latestrevisions(uri varchar(4000), branchname
varchar(4000), xnumber varchar(20));
> >
> > create table branches(uri varchar(4000), xnumber varchar(20),
childnumber varchar(20));
> >
> > create table revision(uri varchar(4000), xnumber varchar(20), branchname
varchar(4000));
> >
> > create table label(uri varchar(4000), xnumber varchar(20), label
varchar(4000));
> >
> > create table property(uri varchar(4000), xnumber varchar(20), name
varchar(4000), value varchar(4000), namespace varchar(4000), type
varchar(100), protected int);
> >
> > create table revisioncontent(uri varchar(4000), xnumber varchar(20),
content oid);
> >
> > --
> > To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> > For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: PostgreSQL supported !

Posted by Dirk Verbeeck <di...@pandora.be>.
Great news, another DB supported


Thanks for testing,
Dirk



Jean-Philippe Courson wrote:
> 
> Hi,
> 
> PostgreSQL is able to store slide's content using oid data type for blobs.
> 
> I have tested it and it works perfect.
> 
> Folows the PostgreSQL database creation script (the Oracle one with just
> oid replacing blob)
> 
> I think it would be a good thing to add it to the JDBC Store Howto.
> 
> Jean-Philippe
> 
> create table objects(uri varchar(3200) primary key, classname varchar(4000));
> 
> create table children(uri varchar(4000), childuri varchar(4000));
> 
> create table links(link varchar(4000), linkto varchar(4000));
> 
> create table permissions(object varchar(4000), revisionnumber varchar(20), subject varchar(4000), action varchar(4000), inheritable int, negative int);
> 
> create table locks(id varchar(4000), object varchar(4000), subject varchar(4000), type varchar(4000), expirationdate varchar(15), inheritable int, xexclusive int);
> 
> create table revisions(uri varchar(3200) primary key, isversioned int, initialrevision varchar(10));
> 
> create table workingrevision(uri varchar(4000), baserevision varchar(20), xnumber varchar(20));
> 
> create table latestrevisions(uri varchar(4000), branchname varchar(4000), xnumber varchar(20));
> 
> create table branches(uri varchar(4000), xnumber varchar(20), childnumber varchar(20));
> 
> create table revision(uri varchar(4000), xnumber varchar(20), branchname varchar(4000));
> 
> create table label(uri varchar(4000), xnumber varchar(20), label varchar(4000));
> 
> create table property(uri varchar(4000), xnumber varchar(20), name varchar(4000), value varchar(4000), namespace varchar(4000), type varchar(100), protected int);
> 
> create table revisioncontent(uri varchar(4000), xnumber varchar(20), content oid);
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>