Robert Fitzpatrick wrote:
Can someone point me to some more information or perhaps show an example
of returning a recordset from a plpgsql function. I'd like to send an
argument or arguments to the function, do some queries to return a set
of records. I've done several functions that return one val
Tom Lane wrote:
Without taking a position on what the Windows installer ought to do ...
*whenever* you are restoring a pg_dump dump, you ought to do so into
an empty database cloned from template0. If the documentation doesn't
say that in enough places, suggest some more.
Right. If, as Tom say
Tom Lane wrote:
It looks to me like you have a bunch of stuff in template1, which is
being duplicated into your test_restored DB and then is interfering
with the restoration of similarly-named objects.
Create the empty database using template0 as template, instead, and
then the restore will work.
Peter Eisentraut wrote:
Tim Penhey wrote:
Are there any python drivers that work with the version 8 beta?
The version seven ones didn't.
Why?
Changed from using pyPgSQL to psycopg and things are working again...
Tim
---(end of broa
Scot L. Harris wrote:
>
> I just recently upgraded from 7.2.4 to 7.4.2 postgresql. What I did was
> a pg_dumpall to save my databases. Then after the upgrade I did a
> pg_restore using the saved dump file. Worked perfectly for me.
>
> After I installed the new version of postgresql I did a ini
Hi All,
I have a java web server (Tomcat) running a web application that uses PostgreSQL for
all
of the data. All of the management of the application is done through the web
application
and I would like to provide a backup and restore option for the user. Backup would
somehow get all of the d
