[SQL] ERROR: duplicate key violates unique constraint

2007-03-20 Thread remco lengers
Hi List, Its been a while since I worked with databases and I am running into the following which I have not been able to find the root cause for: I have the follow SQL statement: INSERT INTO reference VALUES (DEFAULT,'123','2',1); Which generates the following error: "ERROR: duplicate key v

[SQL] unsubscribe

2007-03-20 Thread Stefan Ionita
unsubscribe _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ---(end of broadcast)--- TIP 4: Have you sear

Re: [SQL] ERROR: duplicate key violates unique constraint

2007-03-20 Thread Bart Degryse
Use INSERT INTO reference(reference_text, reference_type, Topic_Id) VALUES (DEFAULT,'123','2',1); instead. Since referencelist_nr is a serial PostgreSQL will provide the next free integer itself. >>> "remco lengers" <[EMAIL PROTECTED]> 2007-03-20 10:11 >>> Hi List, Its been a while since I wo

[SQL] unsubscribe

2007-03-20 Thread Stefan Ionita
unsubscribe [EMAIL PROTECTED] _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)---

Re: [SQL] ERROR: duplicate key violates unique constraint

2007-03-20 Thread Richard Huxton
remco lengers wrote: Hi List, Its been a while since I worked with databases and I am running into the following which I have not been able to find the root cause for: I have the follow SQL statement: INSERT INTO reference VALUES (DEFAULT,'123','2',1); Which generates the following error: "E

[SQL] Select and Count

2007-03-20 Thread Shavonne Marietta Wijesinghe
Hello I have a postgresql table and i do a select via ASP strSQL = "SELECT * FROM " & MioTabella & " WHERE TRIM(date_inserted) >= '" & datainizio & "' AND TRIM(date_inserted) <= '" & datafine & "'" oRs.open strSQL,oConn,3 schede = oRs.RecordCount Do until oRs.EOF sch_sin = cint(sch_sin) + cin

Re: [SQL] Select and Count

2007-03-20 Thread Martin Marques
On Tue, 20 Mar 2007, Shavonne Marietta Wijesinghe wrote: Hello I have a postgresql table and i do a select via ASP strSQL = "SELECT * FROM " & MioTabella & " WHERE TRIM(date_inserted) >= '" & datainizio & "' AND TRIM(date_inserted) <= '" & datafine & "'" oRs.open strSQL,oConn,3 schede = oRs.

Re: [SQL] unsubscribe

2007-03-20 Thread Alvaro Herrera
Stefan Ionita wrote: > unsubscribe Marc, I would think that these list don't have the "administrativia" flag set in the configuration. This is in the "moderation" class. The help for this option is: If the administrivia setting is set to "yes", posted messages which match the patterns in th

Re: [SQL] Select and Count

2007-03-20 Thread Bart Degryse
Don't know any ASP but maybe Response.Write only accepts strings. In that case you would need to do something like <% Response.Write cStr(sch_sin) %> Maybe you can let the database do the summing: <% option explicit %> <% Dim strSQL Dim oRs Dim oConn oConn = ... 'Fill t

[SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

2007-03-20 Thread Karthikeyan Sundaram
Hi, I am using postgres 8.2.3. I have recently converted my database from sql-ascii to UTF8. I have a portal which calls a perl program to insert the data into the database. While inserting, I am getting an error message DBD::Pg::st execute failed: ERROR: invalid byte sequence for en

Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

2007-03-20 Thread Claus Guttesen
I am using postgres 8.2.3. I have recently converted my database from sql-ascii to UTF8. I have a portal which calls a perl program to insert the data into the database. While inserting, I am getting an error message DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding

[SQL] Substitute

2007-03-20 Thread Judith
Hello everybody somebody knows, how I can substitute in a query if a field contains a character that I want to be shown with other character? for example if I have a \n I want to shows me a ~ in the result of the select thanks in advanced!! ---(end of broadcast

Re: [SQL] Substitute

2007-03-20 Thread Milen A. Radev
Judith написа: > Hello everybody > > somebody knows, how I can substitute in a query if a field contains a > character that I want to be shown with other character? > > for example if I have a \n I want to shows me a ~ in the result of the > select > Look for 'replace' here - http://www.pos

Re: [SQL] Substitute

2007-03-20 Thread Michael Fuhr
On Tue, Mar 20, 2007 at 05:54:47PM -0600, Judith wrote: > somebody knows, how I can substitute in a query if a field contains a > character that I want to be shown with other character? > > for example if I have a \n I want to shows me a ~ in the result of the > select One way is with translate

Re: [ADMIN] [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

2007-03-20 Thread Michael Fuhr
On Tue, Mar 20, 2007 at 09:06:25PM +0100, Claus Guttesen wrote: > >DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding > >"UTF8": 0x92 > >[for Statement "INSERT INTO longdescs (bug_id, who, bug_when, thetext, > >isprivate) > > Try to modify client_encoding in postgresql.conf to

[SQL] unsubscribe

2007-03-20 Thread Stefan
unsubscribe Stefan Ionita ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

[SQL] unsubscribe

2007-03-20 Thread Piotr Dabrowski
unsubscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster