On Apr 25, 2009, at 5:19 AM, pavunkumar wrote:
Dear Friend
Whatever your saying right , But why the function
not saying error ?
that is my doubt... this is what I want to
clarify!
Because it's a valid comparison, just not the one you wanted.
Alban
Hi Filip,
Thanks a lot for your kind help. Selecting only once did the trick. Dropping
to 2 seconds for select instead of 50 IS an improvement indeed :)
Indexes on columns already existed, and just out of curiosity I've tested
char columns instead of varchars, with no significant positive changes.
On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin wrote:
> I've been asked to put together a list of reasons to upgrade a db
> from 8.1 to 8.3 and I've looked over the changelog, but they want a
> bullet list of 4-5 top things. I'm curious what others would say the
> most 5 important updates from 8.1
On Fri, Apr 24, 2009 at 12:15 PM, Sam Mason wrote:
> On Fri, Apr 24, 2009 at 11:55:48AM -0400, Tom Lane wrote:
>> pavunkumar writes:
>> > create or replace function newd(id integer ) returns void as $$
>> > delete from testing where id=$1;
>>
>> Don't use the same name for a parameter as you use
Merlin Moncure writes:
> On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin
> wrote:
>> Sorry this is so vague, I'm frustrated with this request as I figured
>> just the amount of bug-fixes alone would be adequate reasoning.
> It's not. There are probably more people using 8.1 than 8.3 and 8.1
> ha
My noob understanding is that deleteing one of these:
CREATE TABLE provider_input.file_load
(
sid serial NOT NULL,
file_name_full text,
file_name text,
file_creation_date text,
load_universal_time numeric,
headers text,
date timestamp without time zone DEFAULT now(),
CONSTRAINT fi
On Sat, Apr 25, 2009 at 11:28 AM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Fri, Apr 24, 2009 at 1:01 PM, Josh Trutwin
>> wrote:
>>> Sorry this is so vague, I'm frustrated with this request as I figured
>>> just the amount of bug-fixes alone would be adequate reasoning.
>
>> It's not. The
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
> Given constraint:
>
> ALTER TABLE provider_input.common
> ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
> (pin_file_load_sid)
> REFERENCES provider_input.file_load (sid) MATCH FULL
> ON UPDATE NO ACTION ON
Joshua Tolley wrote:
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
Given constraint:
ALTER TABLE provider_input.common
ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
(pin_file_load_sid)
REFERENCES provider_input.file_load (sid) MATCH FULL
ON UPDATE
On Sat, Apr 25, 2009 at 04:21:06PM -0400, Kenneth Tilton wrote:
> But I am "inheriting" from the parent, so everything about the parent
> should be true for me unless overridden. I mean in the usual sense of
> inherit I know from OO.
This is from the current docs
(http://www.postgresql.org/doc
I want to know vacuumdb's advantages and fault. Although it could be nice
when I use vacuumdb command about database efficiency . But when some of
database would updating every day, just like online game. The game's
database could updating data 24 hrthen I want to
know, may I use vacuumdb com
On Sat, Apr 25, 2009 at 9:27 PM, Wang Kuo-Ying wrote:
>
>
> I want to know vacuumdb's advantages and fault. Although it could be nice
> when I use vacuumdb command about database efficiency . But when some of
> database would updating every day, just like online game. The game's
> database could
12 matches
Mail list logo
