amy cheng wrote:
>
> hi, all experts there,
>
> I'm studying the example in postgresql-6.5.1/src/pl/plpgsql/test.
> I do not understand why we need "do delete/insert instead of update if name
> changes". Is it ONLY for the test, or, there is some
> reason for doing that in practical use?
>
> I
Mark Dalphin wrote:
>
> Hi,
>
> Is there a way to display user-defined functions? For example, if I define a
> function using PL/pgsql, what tables do I query and in what way to learn that
> the function exisits and further, what its defintion is? I can find functions
> that return known types
amy cheng wrote:
>
> hi, all experts there,
>
> it's me again :-)
oh well :)
> I'm studying the example in postgresql-6.5.1/src/pl/plpgsql/test.
> I have another question: why do we need to "Set backlink to empty string if
> NULL value given"? is it JUST a test, or, some reasons to
> do that in
> or you could use GNUstep's ( http://www.gnustep.org ) database library (
> aka Enterprise Objects Framework 1.x ), which provides an OO
> wrapper for database independent stuff. you dont have to deal with SQL;
> you deal with the objects.
been there, but couldn't find that Enerprise Objects Fr
Matthew Hixson wrote:
>
> Amy Cheng requested that I post her reply to me back to the list since she did
> not have a copy of it.
> -M@
>
> hi,
>
> search or browse "functions" and "PL/pgSQL" (and tcl and c/spi), "triggers".
> enough to start-up ;-)
> also, there is examples in the source's
Jelle Ruttenberg wrote:
>
> Hello all,
>
> I'm trying to connect from a NT via psqlODBC (6.40.0005) to a
> Linux-machine with PostgreSQL 6.5.1 up and running. The connection is
> refused and in the logfile on the Linux-machine is the following message:
>
> Unable to connect to Ident server on t
amy cheng wrote:
>
> hi, all experts there, greetings!
>
> Just minutes ago, my boss found out one of the attributes in a
> table is too short (varchar 64 for url), we need to make
> it wider to 85 A.S.A.P. Seems that alter table can not do it.
> So, I used pg_dump, (how to do it gracefully?) im
Sebestyen Zoltan wrote:
>
> Hi,
>
> I wrote an application that uses PgSQL as database backend. It ran for
> almost a year and now it's database directory grew to 85633Kbyte.
> Inspecting this directory, I found out that a file called oid_index grew
> to 84058112 bytes, i.e. 99% of the database
Michael wrote:
>
> > >
> > > So how do you store something in data type serial?
> > > I've created the column but everytime I attempt to do an update I get
> > > back the error message that I can't store a duplicate key.
> > >
> > > table_col_seq.last_value = 1
> > > increment = 1
> > > maxvalue
"Michal A. Kowalski" wrote:
>
> Hi,
>
> is there any way to change table structure without doing DROP and CREATE
> again?
nope, only if you rename (table|attr) name(s) or add an attribute.
--
CIMPOESU Teodor, Web Programmer
@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ [EM
10 matches
Mail list logo
