I noticed another issue with default parameters which I didn't see listed.
I see it in 1.14 at any rate not sure it is an issue in lower versions.
That is if I write a function like this:
CREATE OR REPLACE FUNCTION test_defaults(test text DEFAULT '')
RETURNS text AS
$$
SELECT 'hello'::t
On 11/22/2011 04:18 PM, John Fabiani wrote:
On Tuesday, November 22, 2011 11:57:38 AM Colin Beckingham wrote:
On 11/22/2011 11:26 AM, John Fabiani wrote:
FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise
that
the upgrade took me from my Postgresql 9.0 to 9.1. From 9.1 I could
On Tue, 2011-11-22 at 13:18 -0800, John Fabiani wrote:
> On Tuesday, November 22, 2011 11:57:38 AM Colin Beckingham wrote:
> > On 11/22/2011 11:26 AM, John Fabiani wrote:
> > >> FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise
> > >> that
> > >> the upgrade took me from my Postgre
On Mon, 2011-11-21 at 17:55 -0500, Paragon Corporation wrote:
> We discovered a recent issue on PostGIS dev which we think is a pgAdmin
> issue. We have reproduced on 1.14 and 1.10
>
> That is when we create a function like this:
>
> CREATE OR REPLACE FUNCTION test_regprocedure(
>
> fu
On Tuesday, November 22, 2011 11:57:38 AM Colin Beckingham wrote:
> On 11/22/2011 11:26 AM, John Fabiani wrote:
> >> FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise
> >> that
> >> the upgrade took me from my Postgresql 9.0 to 9.1. From 9.1 I could
> >> not
> >> access my old data
On 11/22/2011 11:26 AM, John Fabiani wrote:
FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise that
the upgrade took me from my Postgresql 9.0 to 9.1. From 9.1 I could not
access my old data files from the previous 9.0. Fortunately I had a
backup and was secure in the knowled
On Monday, November 21, 2011 12:53:31 PM John Fabiani wrote:
> Hi,
> openSUSE 12.1
> pgadmin version 1.14.0(Oct 30, 2011) REl-1_14_0
> Postgres 8.4
>
> I installed pgadmin using Yast.
>
> First I'm new to this interface and it could be that I'm doing something
> wrong. I have used earlier versio
