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
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'
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
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
[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
"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
> --+---+---
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
"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
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
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
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
>
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
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
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
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
15 matches
Mail list logo
