[GENERAL] Re: Tuple is to big

2001-02-14 Thread Dan McGrath
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

[GENERAL] Re: Row ID and auto-increment?

2001-02-16 Thread Dan McGrath
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

Re: [GENERAL] Re: Anyone can create tables!

2001-03-11 Thread Dan McGrath
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 the internal pgsql tables