Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres DB recompilation

Postgres DB recompilation

From
WeNotStupid
Date:
Hi,

From some 7.0.2 literature,  it was said that one need to perform  a
Postgres Database recompilation  in order to have
greater than 8KB image files/objects (object data type) to be stored in
Postgres. Has anyone done this before ?
Would you be happy to share this knowledge ?

regards
James

Re: Postgres DB recompilation

From
Doug McNaught
Date:
WeNotStupid <WeNotStupid@NotStupid.com> writes:

> Hi,
>
> >From some 7.0.2 literature,  it was said that one need to perform  a
> Postgres Database recompilation  in order to have
> greater than 8KB image files/objects (object data type) to be stored in
> Postgres. Has anyone done this before ?
> Would you be happy to share this knowledge ?

Modern versions (7.1 and up) do not have this limit.

-Doug

Re: Postgres DB recompilation

From
Martijn van Oosterhout
Date:
On Mon, Jun 17, 2002 at 10:03:52AM +0800, WeNotStupid wrote:
> Hi,
>
> >From some 7.0.2 literature,  it was said that one need to perform  a
> Postgres Database recompilation  in order to have
> greater than 8KB image files/objects (object data type) to be stored in
> Postgres. Has anyone done this before ?
> Would you be happy to share this knowledge ?

If you upgrade to 7.2, then any field can hold practiacally unlimited data.

Prior to that, lerge things could only be stored within blobs.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

Re: Postgres DB recompilation

From
Tycho Fruru
Date:
On Mon, 2002-06-17 at 04:03, WeNotStupid wrote:
> Hi,
>
> >From some 7.0.2 literature,  it was said that one need to perform  a
> Postgres Database recompilation  in order to have
> greater than 8KB image files/objects (object data type) to be stored in
> Postgres. Has anyone done this before ?
> Would you be happy to share this knowledge ?

Why don't you just use 7.2, which handles these larger datatypes just
fine ?

Cheers,
Tycho

--
Tycho Fruru                            tycho@fruru.com
"Prediction is extremely difficult. Especially about the future."
  - Niels Bohr
Attachment

Re: Postgres DB recompilation

From
David A Dickson
Date:
I am trying to do an update using regular expressions. Is something
like this possible?

a=# select path from page where path ~ '/academic-staff/reports/(.*$)';
                path
--------------------------------------
 /academic-staff/reports/agriculture/
 /academic-staff/reports/arts/
 /academic-staff/reports/education/
 /academic-staff/reports/engineering/
 /academic-staff/reports/medicine/
 /academic-staff/reports/music/
 /academic-staff/reports/science/
 /academic-staff/reports/

a=# update page set path = '/academic-staff/fooreports/\1'
where path ~ '/academic-staff/reports/(.*$)';


What I'm trying to do is replace all occurances of
/academic-staff/reports/(.*$) with
/academic-staff/fooreports/\1
where \1 is everything that was matched by the .*$

can it be done? anyone know how?

--
David A Dickson
david.dickson@mail.mcgill.ca

Regualer expressions

From
David A Dickson
Date:
Sorry, messed up the subject.

On Mon, 17 Jun 2002, David A Dickson wrote:

I am trying to do an update using regular expressions. Is something
like this possible?

a=# select path from page where path ~ '/academic-staff/reports/(.*$)';
                path
 --------------------------------------
 /academic-staff/reports/agriculture/
 /academic-staff/reports/arts/
 /academic-staff/reports/education/
 /academic-staff/reports/engineering/
 /academic-staff/reports/medicine/
 /academic-staff/reports/music/
 /academic-staff/reports/science/
 /academic-staff/reports/

a=# update page set path = '/academic-staff/fooreports/\1'
where path ~ '/academic-staff/reports/(.*$)';


What I'm trying to do is replace all occurances of
/academic-staff/reports/(.*$) with
/academic-staff/fooreports/\1
where \1 is everything that was matched by the .*$

can it be done? anyone know how?

Re: Regualer expressions

From
Darren Ferguson
Date:
It can be done but i don't think you can do it pure SQL unless you want to
start using substr and all that.

You can useone of the built in languages such as pltcl or plperl.

These will help you achieve what you want.

Quick pltcl one

CREATE OR REPLACE FUNCTION sp_reports() RETURNS BOOLEAN AS '
  spi_exec -array C "SELECT path FROM page WHERE path LIKE
''/academic-staff/reports/%''" {
     foreach element [split $C(path) "/"] {
       if { $element == "reports" } {
          set element "fooreports"
       }
       append newpath "$element/"
     }
     lappend newpath_list [list "$C(path)" "$newpath"]
  }
  foreach element $newpath_list {
    foreach { oldpath newpath } $element {}
    spi_exec "UPDATE page SET path = ''$newpath'' WHERE path =
''$oldpath''"
  }
  RETURN 1
' LANGUAGE 'pltcl';

This is just a quick and dirty way to do it and i haven't even tested it
but it should work fine

HTH

Darren Ferguson

On Mon, 17 Jun 2002, David A Dickson wrote:

> Sorry, messed up the subject.
>
> On Mon, 17 Jun 2002, David A Dickson wrote:
>
> I am trying to do an update using regular expressions. Is something
> like this possible?
>
> a=# select path from page where path ~ '/academic-staff/reports/(.*$)';
>                 path
>  --------------------------------------
>  /academic-staff/reports/agriculture/
>  /academic-staff/reports/arts/
>  /academic-staff/reports/education/
>  /academic-staff/reports/engineering/
>  /academic-staff/reports/medicine/
>  /academic-staff/reports/music/
>  /academic-staff/reports/science/
>  /academic-staff/reports/
>
> a=# update page set path = '/academic-staff/fooreports/\1'
> where path ~ '/academic-staff/reports/(.*$)';
>
>
> What I'm trying to do is replace all occurances of
> /academic-staff/reports/(.*$) with
> /academic-staff/fooreports/\1
> where \1 is everything that was matched by the .*$
>
> can it be done? anyone know how?
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>