stability of pg library usage

Started by Markus Wagnerover 23 years ago4 messagesgeneral
Jump to latest
#1Markus Wagner
wagner@imbei.uni-mainz.de

Hi,

we developed some software using the C-library for pg 7.1.3 and distributed it
to users who are using pg 7.2.x. There was a problem when the program tried
to open 'template1' in order to execute a 'CREATE DATABASE'-statement. The
database 'template1' could not be opened. After installing pg 7.3.1 it
worked.

We are wondering what may have changed in the new version, and if there will
be some stability in the future, so that our software may be used with
different pg versions.

Thanks for replies,

Markus

#2Justin Clift
justin@postgresql.org
In reply to: Markus Wagner (#1)
Re: stability of pg library usage

Markus Wagner wrote:

Hi,

we developed some software using the C-library for pg 7.1.3 and distributed it
to users who are using pg 7.2.x. There was a problem when the program tried
to open 'template1' in order to execute a 'CREATE DATABASE'-statement. The
database 'template1' could not be opened. After installing pg 7.3.1 it
worked.

Hi Markus,

Out of curiosity, was "7.3.1" a typo? We haven't released that version
yet. The closest match would be "7.2.1" though it's not recommended due
to some bugs that were found (7.2.3 is the latest release, and it's
production worthy).

:-)

Regards and best wishes,

Justin Clift

We are wondering what may have changed in the new version, and if there will
be some stability in the future, so that our software may be used with
different pg versions.

Thanks for replies,

Markus

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

#3Medi Montaseri
medi.montaseri@intransa.com
In reply to: Markus Wagner (#1)
Re: stability of pg library usage

I'd say stay off of template0 and template1. Let the PG team abstract
this stuff and
use initdb(1), createdb(1), createuser(1) and pg_ctl(1).

If at some point the PG arch change and template2 becomes the template,
then your
C code is protected and similar arguments....

Markus Wagner wrote:

Show quoted text

Hi,

we developed some software using the C-library for pg 7.1.3 and distributed it
to users who are using pg 7.2.x. There was a problem when the program tried
to open 'template1' in order to execute a 'CREATE DATABASE'-statement. The
database 'template1' could not be opened. After installing pg 7.3.1 it
worked.

We are wondering what may have changed in the new version, and if there will
be some stability in the future, so that our software may be used with
different pg versions.

Thanks for replies,

Markus

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#4Markus Wagner
wagner@imbei.uni-mainz.de
In reply to: Justin Clift (#2)
Re: stability of pg library usage

Hi Justin!

Out of curiosity, was "7.3.1" a typo?

Sorry, I meant 7.1.3.

Markus