> Hi Bruce,
>
> Ok. Sorry about the delay.
>
> I added the math.h but that doesn't seem to change the
> query plan output.
>
> I then dropped all the indices, made a new one on three of the
> variables and clustered:
>
> create index m_col on lmctot using btree (j_m, h_m, k_m);
> cluster m_co
Hi All...
I have been inserting records into a table using the SQL insert statement
via the perl5 Pg module. One of the field types is serial, and I have been
trying to figure out how to get the value that was assigned in the field as
a result of the insert. The serial typed field is the only
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> hello all
>
> normaly a UNIQUE PRIMARY KEY is unique but
> when you use a heritage, you can insert a duplicate key
I assume you mean inheritance.
Can you send us a little test sample please?
--
Bruce Momjian
Bruce Momjian wrote on Wed, 07 Jul 1999 12:29:13 EDT
>> Thanks, Bruce!
>>
>> Yes, I tried the latter query and it's the same:
>>
>> --
>>
>> lmc=> explain select count(*) from lmctot where j_m>3.4::float4 and j_m<3.5:
>:float4;
>> NOTICE: QUERY P
hello all
normaly a UNIQUE PRIMARY KEY is unique but
when you use a heritage, you can insert a duplicate key
I have what may be a fairly simple question for the group, but for the life
of me I missed it in the documentation.
In writing some perl cgi scripts for postgres, I found that I would get an
error message if a user without certain priveledges tried to do a select,
insert, delete or whatever.
Wh
On Thu, 8 Jul 1999, Albert Chen wrote:
> I know there is a ApacheMysql module. Has ApachePostgres module?
Do you mean postgres authentication module? It is called mod_auth_pgsql,
and you can hunt for this on http://modules.apache.org. Works pretty fine
for me.
> -Albert
Oleg.
Oleg
Hi,
I know there is a ApacheMysql module. Has ApachePostgres module?
-Albert
__
Get Your Private, Free Email at http://www.hotmail.com
