Re: [GENERAL] Table with Field Serial - Problem

2013-11-02 Thread Adrian Klaver
On 11/02/2013 04:58 AM, Francisco Olarte wrote: On Thu, Oct 31, 2013 at 5:13 PM, Adrian Klaver wrote: Table1 Column | Type| Modifiers --+---__+-__--__-- id | integer

Re: [GENERAL] Table with Field Serial - Problem

2013-11-02 Thread Francisco Olarte
On Thu, Oct 31, 2013 at 5:13 PM, Adrian Klaver wrote: >> Table1 >> Column | Type| Modifiers >> >> --+---__+-__--__-- >> >> id | integer | not null default >> next

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Adrian Klaver
On 10/31/2013 11:12 AM, Yostin Vargas wrote: i really dont need a number generator, only a unique PK. but i want that this PK be generate automatically for example i have a Category calling Computer in English but i have the same Category in Spanish (Computadora) i assigned the ID->1 for both

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Yostin Vargas
i really dont need a number generator, only a unique PK. but i want that this PK be generate automatically for example i have a Category calling Computer in English but i have the same Category in Spanish (Computadora) i assigned the ID->1 for both So if i put the Pk ID in the table2 number i h

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Adrian Klaver
On 10/31/2013 09:32 AM, David Johnston wrote: Adrian Klaver-3 wrote Table1 Column | Type| Modifiers --+---__+-__--__-- id | integer | not null default nextval

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Yostin Vargas
yes i can put other field for identifier , but i think that whit the name of the table i can know it 2013/10/31 David Johnston > Adrian Klaver-3 wrote > >> Table1 > >> Column | Type| Modifiers > >> > --+---__+---

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread David Johnston
Adrian Klaver-3 wrote >> Table1 >> Column | Type| Modifiers >> --+---__+-__--__-- >> id | integer | not null default >> nextval('test_table_id_fld___seq'::regclass

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Adrian Klaver
On 10/31/2013 08:23 AM, Yostin Vargas wrote: 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 --+---__+---

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Yostin Vargas
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 --+---**+-** --**--

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Adrian Klaver
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('t

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Yostin Vargas
My table is like this Column | Type| Modifiers --+---**+-** --**-- id_fld | integer | not null default nextval('test_table_id_fld_ **seq'::regclass) im using Yi

Re: [GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Adrian Klaver
On 10/31/2013 07:31 AM, Yostin Vargas wrote: I have a table with only one Field ID type Serial Autonumeric and is a PK, i want insert a new record but it show me error Not null violation, but if i put a value the first INSERT work correctly but the next Insert it Show me error Unique violati

[GENERAL] Table with Field Serial - Problem

2013-10-31 Thread Yostin Vargas
I have a table with only one Field ID type Serial Autonumeric and is a PK, i want insert a new record but it show me error Not null violation, but if i put a value the first INSERT work correctly but the next Insert it Show me error Unique violation, So i try adding a new field in this table