RE: BUG

Hi Dave,

I look this problem but i d'not understand the code. In pgschema is not possible to specify the RetSet when add new function. It is an error or never has not been completed the adding function?

int retun sql definetion
Public Property Get SQL(Optional OrReplace As Boolean = False) As String
...

current
szSQL = szSQL & " RETURNS " & szReturns

new
szSQL = szSQL & " RETURNS "
if bRetSet then szSQL = szSQL & " SETOF "
szSQL = szSQL & szReturns

is correct this code?

> Hi,
>
> Unfortunately pgAdmin doesn't fully support set returning functions yet
> - in fact the latest versions only indicate that a function is an srf,
> they are not clev er enough to edit or create them correctly yet.
> Hopefully this will be fixed soon.
>
> Frank: Are you interested in looking at this?
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: Mendola Gaetano [mailto:mendola(at)bigfoot(dot)com]
> > Sent: 22 April 2003 14:30
> > To: pgadmin-support(at)postgresql(dot)org
> > Subject: [pgadmin-support] BUG
> >
> >
> > Hi all,
> > I'm using pgAdmin 1.4.12 and Postgres 7.3.2
> >
> > I create a function that return a SETOF:
> >
> > CREATE OR REPLACE FUNCTION foo ( )
> > RETURNS SETOF public.foo_type AS'
> > DECLARE
> > BEGIN
> >
> > RETURN ;
> > END;
> > ' LANGUAGE 'plpgsql';
> >
> >
> > if I try to edit this function inside pgAdmin the
> > redefinition fail, pgAdmin try to recreate this function in
> > the following way:
> >
> >
> > CREATE OR REPLACE FUNCTION public.foo( )
> > RETURNS public.foo_type AS '
> > DECLARE
> > BEGIN
> >
> > RETURN ;
> > END;
> > ' LANGUAGE 'plpgsql';
> >
> >
> > the SETOF is not there anymore
> >
> > and correctly postgres say that the new definition change
> > the return type.
> >
> >
> > Gaetano
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an
> > appropriate subscribe-nomail command to
> > majordomo(at)postgresql(dot)org so that your message can get through
> > to the mailing list cleanly
> >
>

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.2.1 (MingW32)

mQGiBD66J3ARBADIgi5fxoDGLtRXgQD0tM1QamddEkkwH7sAJ5AgQ350RXJNsxBD
4PIFpqyuuglhUzUbQX+LbBly5NqZV72HxmKjFW29Z2qJ/lrR0FPZQ6tp8HBQlYBj
JRwbU2CQWfpf98CIf1zHqXVJqza1kFStHPvLNc+4jZfmAQLvufr1e+ZVPwCgoFnm
CpoJR/aEnq5ywwaF19SC0OsEAItrjaznn1ilf2bfwwJ+vmrFg52y6lvuYZhlOxfb
HmkAJufPYaTulHKWvSjgmTJolJ6R2AVHUQyv4VGfXYqMtdcKyuxVyOrgQScjK9zi
ceKRyioo6dBU4RQpSOPf8Lxc0Ubpb/rqJvG3F4nCsh7b58fPu1mHdAlX3cmuQBs1
JxBRA/4i2foxL/3PPHUN8FmNMgcUiHE+5cJbnCmvJvJhaGBWkIHCOLwzweoFh89O
exa1CSUQgad+YIYxFsDSo6pn9qfe54l7sXiS36l3EmSlpN9GuDBsfcv7Y9lOMCcD
gKSF4ZuJjImGp2JmGTn2A8s/JOqrD1aWr6/dqBZgtO6yKspOQrQnRnJhbmsgTHVw
byAoV29sZikgPGZyYW5rX2x1cG9AZW1haWwuaXQ+iFkEExECABkFAj66J3AECwcD
AgMVAgMDFgIBAh4BAheAAAoJEHivslVddEQff+AAoJqtduPVMulXX9buahMX5LMn
OIU1AJ46xJcpe7TFykRyGTLVRUd6WCpKvLkBzQQ+uid6EAcAnuIuWe5woQosEVzC
ePVTeU37aOZTR1YAomA4gLlNX1e3yN+WDB4NOcD7vicYr5HwF9+D55Tljs6lEwkQ
g8+qcCBQKDmQ1jWsx2oAOa84YsWauKumHCH3z3UzaZ6qR1I2R1tFzm6loEm32ZRe
Z38n0rMvMuMj7Nkh+bvB7HS9H9LqoCY5cgfGCu4dAuAhIjz18TuutqeSx95yObA8
JPNk5foT8+gveIYX07pd7i19BaFtCkXp2Dsfl+iqrIJcUH1ik78zA43iH5J2jXc9
z1lccOnEIE6b9xfIp+usFoDM0FMAAwYG/Ao5s/GCmDjgnyqqf3IZjtDdhbNrlVZk
ooeHUK0j/1sxLZqty7f+Ks8zeIuBpMI7sByfqx171xtiRP0R1D4bjLRWVWbxqy8X
pYncRKeepb2cc6reGWHYCURsaRRv4ntcZQuowVsLSxkaGS3RVvQROVCClhX2SZ8z
HR1BIp7JVx3wGef0I7F42ao9kZkcq+2oQewKHrthPGpMwRcAlj1Te+K8j0vofzME
UHMYkffSvdpWVkqm0nx1zSw+nl64bDsUGsIo9EuvJOwOKQMlxxGmOOJ28fPY52Eo
KEBRPYl6iwAAiEYEGBECAAYFAj66J3oACgkQeK+yVV10RB960ACfcmNLdznfI46b
y+sRRUzy2t/BlkAAn19PjS5DAqRAX5YyyG/UeOeJIgQK
=40rU
-----END PGP PUBLIC KEY BLOCK-----

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Natsabe.it significa Natura, Salute e Bellezza ... ma non solo!
Vasta scelta di articoli da regalo. Belli e originali.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1306&d=8-5