Postgres Pro
Downloads
Home   >   mailing lists

Thread: 7.3.4 upgrade

7.3.4 upgrade

From
Carl Youngblood
Date:
I've got 7.3.3 working just fine in cygwin now.  If I merely install the
latest 7.3.4 postgres package with the cygwin setup will it work?  Or do
I need to change other things too?

Thanks,
Carl Youngblood
Attachment

Re: 7.3.4 upgrade

From
Claudio Natoli
Date:
> I've got 7.3.3 working just fine in cygwin now.  If I merely install the
> latest 7.3.4 postgres package with the cygwin setup will it work?  Or do
> I need to change other things too?

7.3.4 will work just fine in place of 7.3.3.

Cheers,
Claudio

---
WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS:
THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041
TEL: +61 2 9555 1544 FAX: +61 2 9555 6911
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html

Problem with functions

From
"Richard Sydney-Smith"
Date:
I have used pgadminII to create a series of functions. However it appears that they are all all given array parameters. ( see the definition shown below) If I create the function manually with a return type of "bool" instead of "bool[]" all is ok. However if I use pgadmin then I get a horrible error
 
ERROR:  array_in: Need to specify dimension
 
I am happily using a number of procedure in SYBASE SQL Anywhere and am trying to port the database to postgresql. but this error now means I will have to edit them all!
 
Is there a way to change the behaviour of pgadmin or does everyone enter their functions as pure SQL?
 
thanks
 
Richard.
 
Error Message is :
 
ERROR:  array_in: Need to specify dimension
 
The attempt to activate the procedure is given as :
 
select test_fn();
 
and the function definition itself is:
 

-- Function: public.test_fn()

CREATE FUNCTION public.test_fn() RETURNS bool[] AS 'begin

.......

return true;

end;' LANGUAGE 'plpgsql' VOLATILE;

 

Re: 7.3.4 upgrade

From
Carl Youngblood
Date:
Shame on you!

I just installed Postgres 7.3.4 using the cygwin setup program and now
the postmaster service can't start.  In /var/log/postmaster.log it says:

LOG:  FindExec: invalid binary "/usr/bin/postgres"
FATAL:  /usr/bin/postmaster: could not locate executable, bailing out...

Remember, I asked you if I could just install on top of the old one.
This obviously didn't work.  Does anyone know what I need to do to fix this?

Thanks,
Carl Youngblood

Claudio Natoli wrote:

>>I've got 7.3.3 working just fine in cygwin now.  If I merely install the
>>latest 7.3.4 postgres package with the cygwin setup will it work?  Or do
>>I need to change other things too?
>>
>>
>
>7.3.4 will work just fine in place of 7.3.3.
>
>Cheers,
>Claudio
>
>---
>WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS:
>THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041
>TEL: +61 2 9555 1544 FAX: +61 2 9555 6911
>Certain disclaimers and policies apply to all email sent from Memetrics.
>For the full text of these disclaimers and policies see
>http://www.memetrics.com/emailpolicy.html
>
>
>
Attachment

Re: 7.3.4 upgrade

From
Jason Tishler
Date:
Carl,

On Tue, Aug 26, 2003 at 08:54:55AM -0600, Carl Youngblood wrote:
> Shame on you!

Shame on you for not searching the web before posting.

> Does anyone know what I need to do to fix this?

See the following:

    http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=postmaster+locate+executable&btnG=Google+Search

(Hint: hit #5)

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: Problem with functions

From
"George Weaver"
Date:
Hi Richard,
 
When you're creating types in pgAdminII you have to scroll down the list of types to get past the array types which list first.  You should find bool further down the list from bool[], and obviously you want the former.
 
You might find it easier for debugging and updating to write your function scripts in a text editor and load them into pgAdminII using the query editor.
 
Your query is off topic for this list, which deals with issues for Cygwin.  You should address queries specific to pgAdminII to the pgadmin-support list, and queries concerning SQL and related topics (functions, etc.) to the pgsql-sql list.
 
HTH,
George
----- Original Message -----
Sent: Tuesday, August 26, 2003 9:00 AM
Subject: [CYGWIN] Problem with functions

I have used pgadminII to create a series of functions. However it appears that they are all all given array parameters. ( see the definition shown below) If I create the function manually with a return type of "bool" instead of "bool[]" all is ok. However if I use pgadmin then I get a horrible error
 
ERROR:  array_in: Need to specify dimension
 
I am happily using a number of procedure in SYBASE SQL Anywhere and am trying to port the database to postgresql. but this error now means I will have to edit them all!
 
Is there a way to change the behaviour of pgadmin or does everyone enter their functions as pure SQL?
 
thanks
 
Richard.
 
Error Message is :
 
ERROR:  array_in: Need to specify dimension
 
The attempt to activate the procedure is given as :
 
select test_fn();
 
and the function definition itself is:
 

-- Function: public.test_fn()

CREATE FUNCTION public.test_fn() RETURNS bool[] AS 'begin

.......

return true;

end;' LANGUAGE 'plpgsql' VOLATILE;

 

Re: 7.3.4 upgrade

From
Claudio Natoli
Date:
> Shame on you!

Worked for me.


> I just installed Postgres 7.3.4 using the cygwin setup
> program and now
> the postmaster service can't start.  In
> /var/log/postmaster.log it says:
>
> LOG:  FindExec: invalid binary "/usr/bin/postgres"
> FATAL:  /usr/bin/postmaster: could not locate executable,
> bailing out...
>
> Remember, I asked you if I could just install on top of the old one.
> This obviously didn't work.  Does anyone know what I need to
> do to fix this?

Looks like your installation failed. Either it didn't install, or installed
with the wrong permissions (if so, chmod to 755 to correct).

Cheers,
Claudio

---
WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS:
THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041
TEL: +61 2 9555 1544 FAX: +61 2 9555 6911
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html

Re: 7.3.4 upgrade

From
Carl Youngblood
Date:
I'm sorry if I sounded overly upset.  My "shame on you" was really just
a joking "tisk tisk" kind of a complaint.  I was referring specifically
to the person who said that no other steps were required for
installation besides just upgrading to the newer version with the cygwin
setup.

Anyway, thanks for the info.  In my defense, I did do investigation
prior to upgrading.  I investigated with the cygwin-postgres community.
Having been told I could upgrade without running into problems, I
naturally assumed that something out of the ordinary had occurred when I
actually ran into a problem, and defaulted to the obvious solution of
consulting the person who told me I wouldn't run into problems in the
first place.

On a somewhat related note, have you considered setting up a
cygwin-postgres wiki where most of the installation-related problems
could be resolved without constant regurgitation on your part?  I'm very
appreciative of your willingness to help postgres users out, but I
imagine it may get somewhat annoying after a while. (especially with
pesky people like myself.)

Thanks,
Carl

Jason Tishler wrote:

>Carl,
>
>On Tue, Aug 26, 2003 at 08:54:55AM -0600, Carl Youngblood wrote:
>
>
>>Shame on you!
>>
>>
>
>Shame on you for not searching the web before posting.
>
>
>
>>Does anyone know what I need to do to fix this?
>>
>>
>
>See the following:
>
>    http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=postmaster+locate+executable&btnG=Google+Search
>
>(Hint: hit #5)
>
>Jason
>
>
>
Attachment

Re: 7.3.4 upgrade

From
Claudio Natoli
Date:

> I'm sorry if I sounded overly upset.  My "shame on you" was
> really just a joking "tisk tisk" kind of a complaint.  I was referring
> specifically to the person who said that no other steps were required for
> installation besides just upgrading to the newer version with
> the cygwin  setup.

Actually, the "person" said no such thing. He said: "7.3.4 will work just
fine in place of 7.3.3." Which I maintain is absolutely true (and is
independent of whether or not you have minor permission problems due to
ntsec issues or otherwise).

In any case, good to see you're up and running. ;-)

Cheers,
Claudio

---
WE HAVE MOVED - PLEASE NOTE OUR NEW CONTACT DETAILS:
THE BASEMENT, 33 EWELL STREET, BALMAIN NSW 2041
TEL: +61 2 9555 1544 FAX: +61 2 9555 6911
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html

Re: 7.3.4 upgrade

From
Jason Tishler
Date:
Carl,

On Tue, Aug 26, 2003 at 04:54:39PM -0600, Carl Youngblood wrote:
> On a somewhat related note, have you considered setting up a
> cygwin-postgres wiki where most of the installation-related problems
> could be resolved without constant regurgitation on your part?

No.  Sorry to be cynical, but if people don't read READMEs, search the
web, post instead of sending private email, etc., why would they find
and use a wiki?  On the other hand, if I did a better job capturing
these problems, then I could just point people to a URL instead of
having to compose a more elaborate email response.

> I'm very appreciative of your willingness to help postgres users out,

Thanks.

> but I imagine it may get somewhat annoying after a while.

Yes.

> (especially with pesky people like myself.)

No need to worry -- I would not classify you as pesky.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6