pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade question - was Re: join and dynamic view
3+ messages / 3 participants
[nested] [flat]
* Upgrade question - was Re: join and dynamic view
@ 2002-12-17 14:57 Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Gary Stainburn @ 2002-12-17 14:57 UTC (permalink / raw)
To: Tomasz Myrta <jasiek@klaster.net>; +Cc: Christoph Haller <ch@rodos.fzk.de>; pgsql-sql
On Tuesday 17 Dec 2002 2:31 pm, Tomasz Myrta wrote:
> Gary Stainburn wrote:
> > I found that the compile error complaining about the 'OR' was on the
> >
> > CREATE OR REPLACE FUNCTION
> >
> > line. I removed the 'OR REPLACE' and everything worked fine.
>
> OR REPLACE is since postgres 7.2
That explains it - the server I'm developing on is quite old - I didn't
realise how old. I'm about to do an upgrade from 7.1.3 to 7.2.1-5 over
christmas in fact.
Will I need to dump/restore the database for this upgrade?
>
> > Also I had to change the returns to 'opaque' and 'return 0' to 'return
> > null'
>
> In this case it's ok to "return null", but if you create "before"
> trigger you shoud "return new", because "return null" forces postgres
> not to insert any data.
>
> Tomasz Myrta
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade question - was Re: join and dynamic view
@ 2002-12-17 15:09 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 1 reply; 3+ messages in thread
From: Christoph Haller @ 2002-12-17 15:09 UTC (permalink / raw)
To: gary.stainburn@ringways.co.uk; +Cc: pgsql-sql
>
> That explains it - the server I'm developing on is quite old - I
didn't
> realise how old. I'm about to do an upgrade from 7.1.3 to 7.2.1-5
over
> christmas in fact.
>
> Will I need to dump/restore the database for this upgrade?
>
I'm not sure. But I think it's never ever a bad idea to do a dump
before any kind of upgrade.
Regards, Christoph
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade question - was Re: join and dynamic view
@ 2002-12-17 15:23 Andreas Joseph Krogh <andreak@officenet.no>
parent: Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 3+ messages in thread
From: Andreas Joseph Krogh @ 2002-12-17 15:23 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; gary.stainburn@ringways.co.uk; +Cc: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tuesday 17 December 2002 16:09, Christoph Haller wrote:
> > That explains it - the server I'm developing on is quite old - I
>
> didn't
>
> > realise how old. I'm about to do an upgrade from 7.1.3 to 7.2.1-5
>
> over
>
> > christmas in fact.
> >
> > Will I need to dump/restore the database for this upgrade?
As allways when version-upgrading(and not patch-level), you need to
dump/restore as the binary on-disk format changes.
- --
Andreas Joseph Krogh <andreak@officenet.no>
The difference between insanity and genius is measured by success
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9/0GGUopImDh2gfQRAgJJAJ46UWmX4OBWogSHQOGOsO5w1+ZEDQCfcTFy
XpXZyDZfRZAAHs1i7lixKQQ=
=yI3q
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-12-17 15:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-17 14:57 Upgrade question - was Re: join and dynamic view Gary Stainburn <gary.stainburn@ringways.co.uk>
2002-12-17 15:09 Re: Upgrade question - was Re: join and dynamic view Christoph Haller <ch@rodos.fzk.de>
2002-12-17 15:23 ` Andreas Joseph Krogh <andreak@officenet.no>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox