Re: [SQL] Bouncing replies

On Feb 11, 2008 5:06 AM, Dean Gibson (DB Administrator) <[EMAIL PROTECTED]> wrote: > If mail to my list address doesn't come from one of your list > servers (and those seems to change much more often than any other list I > belong to), it gets rejected. Those must be some *really* long-lived lists

Re: [SQL] Usage of UUID with 8.3 (Windows)

[EMAIL PROTECTED] writes: > Now, what do I have to do in order to generate a valid UUID (or the 5 > different versions as implemented by the RFC) under Windows? Figure out how to build ossp-uuid on Windows ... regards, tom lane ---(end of broadcas

Re: [SQL] Check before INSERT INTO

"Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> writes: > Thanks for the reply Grogory. I am trying to do a INSERT INTO. > > Here is my table. n_gen, n_sheet, tot_n_sheet are defined as Primary Key > (Serial not null) > id | n_gen | n_sheet | tot_n_sheet > --+---+---

Re: [SQL] Check before INSERT INTO

Thanks for the reply Grogory. I am trying to do a INSERT INTO. Here is my table. n_gen, n_sheet, tot_n_sheet are defined as Primary Key (Serial not null) id | n_gen | n_sheet | tot_n_sheet --+---+---+- a| 1| 1 | 1

[SQL] PostgreSQL does not support updateable cursors

Dear All,   I got error message 'ERROR: column "ctid" does not exist; Error while executing the query'  when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.   I found some information o

Re: [SQL] Usage of UUID with 8.3 (Windows)

Tom Lane wrote: > [EMAIL PROTECTED] writes: > > Now, what do I have to do in order to generate a valid UUID (or the 5 > > different versions as implemented by the RFC) under Windows? > > Figure out how to build ossp-uuid on Windows ... I think Windows has its own UUID generator, so the best bet

Re: [SQL] Check before INSERT INTO

T_N_SHEET='" & tot_n_sheet & "'") if (not SQLN_GEN.eof) then * set n_gen + 1 else * leave n_gen the way it is end if conn.Execute strSQL But how can i ask it to change the n_gen value??? (The part with the *) Th

Re: [SQL] Bouncing replies

On Feb 11, 2008 9:30 AM, Dean Gibson (DB Administrator) <[EMAIL PROTECTED]> wrote: > > PostgreSQL list serve output has not been connecting from > mail.postgresql.org for a LONG time (see the headers below). Currently > they've been connecting from various hosts at the hub.org domain, but there >

Re: [SQL] Serial not nulla

Thanks alot Shane..Just what I wanted.. Didn't think of a solution with 3 primary keys. Have a nice day ^___^ Shavonne Wijesinghe www.studioform.it - Original Message - From: "Shane Ambler" <[EMAIL PROTECTED]> To: "Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> Cc: Sent: Friday

[SQL] Usage of UUID with 8.3 (Windows)

Hello list, the UUID datatype in the recent version is a feature we intend to use in the near future. To generate a UUID in the database, the Linux release includes contrib modules which can be used for that (together with the uuid lib). Now, what do I have to do in order to generate a valid UU

Re: [SQL] Bouncing replies

PostgreSQL list serve output has not been connecting from mail.postgresql.org for a LONG time (see the headers below). Currently they've been connecting from various hosts at the hub.org domain, but there have several other non-postgresql.org connecting domains in the past. Whenever I stop ge

Re: [SQL] Usage of UUID with 8.3 (Windows)

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Figure out how to build ossp-uuid on Windows ... > I think Windows has its own UUID generator, so the best bet would be to > make that work. Only if it can be made to present the same SQL-level API as we have for OSSP. Otherwise we'

Re: [SQL] Check before INSERT INTO

Shavonne Marietta Wijesinghe wrote: > Thanks for the reply Grogory. I am trying to do a INSERT INTO. > > Here is my table. n_gen, n_sheet, tot_n_sheet are defined as Primary Key > (Serial not null) That is sure confusing. What could a DDL saying INTEGER n_gen SERIAL NOT NULL; INTEGER n_she

Re: [SQL] Check before INSERT INTO

"Shavonne Marietta Wijesinghe" <[EMAIL PROTECTED]> writes: > The user updates the DB via ASP. When 2 users click on the submit button at > the > same time, only 1 record is inserted. (ERROR: duplicate key violates unique > constraint "my_shevi_pkey") > > For example they both send a string like b

[SQL] Check before INSERT INTO

My table structure CREATE TABLE my_shevi ( id text, n_gen serial NOT NULL, n_sheet serial NOT NULL, tot_sheet serial NOT NULL, CONSTRAINT my_shevi_pkey PRIMARY KEY (n_gen, n_sheet, tot_sheet) ) WITH OIDS; ALTER TABLE my_shevi OWNER TO postgres; The user updates the DB via ASP. When 2 u