wrote:
> At 10:12 PM 3/10/01 -0500, Dan McGrath wrote:
> >Thanks Tom. Actually its kinda holding me off really bad. I would like to
> >switch to mysql, but I still feel confident in pgsql to stay. One fellow on
> >irc I talked with mentioned the possibilty of creating a trigger on
Ok, the type your looking for to auto create a sequence and increment by
one is called SERIAL (an int4 field). And yes, pgsql has oid's. Heres
what your table would look like with serial type's:
CREATE TABLE tablename (
item_idSERIAL,
name VARCHAR(10)
);
The serial type will im
Actually, you should take a look in the documentation. It specifically
states that the maximum size for any tuple is 8k (unless compiled
otherwise). If you want to store something larger, consider using the large
objects feature.
Dan
Bodoni Endre wrote:
> I have a little trouble with my Postgre
