[GENERAL] Value of serial data type after insert.

2004-11-13 Thread Ernest Kim
I was wondering if there was a way to get the value of serial data type after an insert. For example, you have the following table: create table my_names ( id serial unique, name varchar(10) ); And then you do the following: insert into my_names values ('Ernie'); How

[GENERAL] BTree max row size?

2004-12-17 Thread Ernest Kim
Hi all. I'm getting the following error message when I try to update a row in a table: ERROR: 54000: index row size 2720 exceeds btree maximum, 2713 Does anyone know how to to change the btree maximum row size? How did it come up with 2713 as a max row size? Thanks. -Ernie -

Re: [GENERAL] BTree max row size?

2004-12-24 Thread Ernest Kim
e aside from re-compiling or recoding the indexes? -Ernie On Sat, Dec 18, 2004 at 12:20:29PM -0300, Alvaro Herrera wrote: > On Thu, Dec 16, 2004 at 06:20:57PM -0500, Ernest Kim wrote: > > Hi, > > > I'm getting the following error message when I try to update a row in > > a t