RE: BUG - Mailing list pgadmin-support
| From | frank_lupo |
|---|---|
| Subject | RE: BUG |
| Date | |
| Msg-id | HEKP5L$19529F4D0C5076195B3C2BA392563034@email.it Whole thread Raw |
| List | pgadmin-support |
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
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@bigfoot.com]
> > Sent: 22 April 2003 14:30
> > To: pgadmin-support@postgresql.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@postgresql.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: clicca qui
Sponsor:
Natsabe.it significa Natura, Salute e Bellezza ... ma non solo!
Vasta scelta di articoli da regalo. Belli e originali.
Clicca qui
pgadmin-support by date: