Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: duplicate key violates unique constraint
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it>
- Cc: Teemu Torma <teemu(at)torma(dot)org>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: duplicate key violates unique constraint
- Date: Tue, 26 Feb 2008 14:03:25 -0300
Shavonne Marietta Wijesinghe wrote: > I wrote the query in the SQL windows provided by the pgadmin. That SQL window only executes SQL, so you can't use PL/pgSQL commands on it. PL/pgSQL can only be used in the context of a PL/pgSQL function, so you need to do CREATE FUNCTION to do that. If you want to use the SQL window you could use SAVEPOINT and ROLLBACK TO. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- References:
- duplicate key violates unique constraint
- From: Shavonne Marietta Wijesinghe
- Re: duplicate key violates unique constraint
- From: Shavonne Marietta Wijesinghe
- Re: duplicate key violates unique constraint
- From: Andrew Sullivan
- Re: duplicate key violates unique constraint
- From: Teemu Torma
- Re: duplicate key violates unique constraint
- From: Shavonne Marietta Wijesinghe
- duplicate key violates unique constraint
- Prev by Date: Re: Function returns error (view)
- Next by Date: Re: duplicate key violates unique constraint
- Previous by thread: Re: duplicate key violates unique constraint
- Next by thread: Re: duplicate key violates unique constraint
- Indexes: