Re: Table with Field Serial - Problem

From: Yostin Vargas <yostinv(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table with Field Serial - Problem
Date: 2013-10-31 15:23:36
Message-ID: CAPMdYjAAFOXOsF=2CNTtbO=YPhz3QkyhxgX-1O1WhzVoTRFwaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes i have a single field because is related to another table that
contains, the name

it's for to do multilanguage

Example

Table1
Column | Type | Modifiers
----------+-------------------**+-----------------------------**
------------------------------**--
id | integer | not null default nextval('test_table_id_fld_**
seq'::regclass)

Table2
Column | Type | related
----------+-------------------**+-----------------------------**
------------------------------**--
id_table1 | integer | FK of Table1.id
id_lang | integer | FK of lang.id
name | varchar

I solve it doin it " $model->id=new CDbExpression('DEFAULT'); "

Thanks for your Helps

2013/10/31 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

> On 10/31/2013 07:55 AM, Yostin Vargas wrote:
>
>> My table is like this
>>
>> Column | Type | Modifiers
>> ----------+-------------------**__+---------------------------**
>> --__--------------------------**----__--
>>
>> id_fld | integer | not null default
>> nextval('test_table_id_fld___**seq'::regclass)
>>
>
> So you have a single field table, what is the purpose?
>
>
>
>>
>> im using Yii Framework, How i can Put VALUES (DEFAULT) if i put
>> "DEFAULT" is like a string
>>
>
>
> That would seem to be a question for the Yii mailing list/forum.
>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-10-31 15:32:45 Re: GSSAPI server side on Linux, SSPI client side on Windows
Previous Message Adrian Klaver 2013-10-31 15:08:42 Re: Table with Field Serial - Problem