Re: [SQL] Change a field to sequence (serial)

2007-02-24 Thread Rodrigo De León
On 2/24/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: Hi lists, Is there possible to change a bigint field (primary key) to a serial ? If yes how it is possible ? I was trying to do that but the pgadmin don't enable the change to sequence. What is the problem my friends ? Regards

[SQL] Change a field to sequence (serial)

2007-02-24 Thread Ezequias Rodrigues da Rocha
Hi lists, Is there possible to change a bigint field (primary key) to a serial ? If yes how it is possible ? I was trying to do that but the pgadmin don't enable the change to sequence. What is the problem my friends ? Regards Ezequias http://ezequiasrocha.blogspot.com/ --

Re: [SQL] change a field

2003-09-15 Thread Bruno Wolff III
On Wed, Sep 10, 2003 at 22:12:45 +0200, Patrick Meylemans <[EMAIL PROTECTED]> wrote: > > What is the best way to solve this problem ? The best way is probably with a view. ---(end of broadcast)--- TIP 7: don't forget to increase your free space m

Re: [SQL] change a field

2003-09-14 Thread A.Bhuvaneswaran
> I want to change a field of a record after the modification of another > field of the same record or during an insert of a new record. You can easily accomplish this in a BEFORE trigger. It is applicable for both insert & update. regards, bhuvaneswaran ---(end of bro

Re: [SQL] change a field

2003-09-14 Thread Peter Eisentraut
Patrick Meylemans writes: > What is the best way to solve this problem ? Show us your code. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregist

[SQL] change a field

2003-09-14 Thread Patrick Meylemans
Dear, I want to change a field of a record after the modification of another field of the same record or during an insert of a new record. Suppose the following table field | type -- id | serial sign| integer value | i