Hi Thomas :
--- Thomas Kellerer <[EMAIL PROTECTED]> wrote:
> Ludwig Isaac Lim wrote on 15.08.2006 18:05:
> > Searching the web using google gives me the following
> > information about error 1063:
> > Error code 1063:
> ERROR_FAILED_SERVICE_CONTROLLER_CONNECT -
&
Hi:
I installed PostgreSQL 8.1.0 on my computer running on
Windows XP Service Pack 2 last April. It works fine (I
don't use the database everyday though). Today, after being
unable to connect to the server, I realized there must be
something wrong. Looking at the logs I found out that there
we
Hi:
Just a hunch:
What about adding an index to the field
etapes_lignes_commandes(code_etape). Assuming your database
uses C locales. This might work for your particular query
since your filter is something like code_etape~~'COMP%'.
What about increasing the settings of work_mem, etc (check
r the
> execution plan
> engine.
>
> Philippe
>
> -----Message d'origine-
> De : Ludwig Isaac Lim [mailto:[EMAIL PROTECTED]
> Envoy�: mercredi, 31. mai 2006 15:52
> �: Philippe Lang
> Cc : pgsql-general@postgresql.org
> Objet : Re: [GENERAL] PGSQL 7.4 ->
Hi :
Maybe you forget to run the "ANALYZE" command afterwards.
ludwig.
--- Philippe Lang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> For an unknown reason, I cannot post this message to the
> mailing-list!
>
> Here it is:
>
> http://www.attiksystem.ch/postgresql-general.txt
>
> Cheers,
>
> Phi
Hi :
How about creating a view that converts integer into
numeric?
create view as
select ::numeric as ,
select ::numeric as
...
and then query the view instead. This way your formula
doesn't need to use cast anymore.
ludwig lim
--- SunWuKung <[EMAIL PROTECTED]> wrote:
> I have equations s
Hi:
> You could order by "column 2" if you want to order on the
> results on
> your aggregate:
> Select a, aggregate(b)
> from c
> group by a
> order by a,2
>
another alternative is :
select a , aggregrate(b) as
from c
group by a
order by a,
e.g.
s
>
> Yes: the wraparound limit is for transactions
> cluster-wide, not per
> database. If you make 1 change in template1 and then 2
> billion
> changes in some other databases, template1 is broken
> unless it's
> been vacuumed meanwhile.
>
> regards, tom lane
>
So in pr
Hi :
Saw this post on BUGS mailing list :
"Olleg Samoylov" writes:
>> Opps, template1 must not be vacuumed.
>Says who?
>If we didn't vacuum template1 then it would be subject to
>XID wraparound
>problems, unless it had never been modified, which is
>something vacuumdb
>can't count on.
> rega
Hi:
I just upgraded my PostgreSQL from version 8.0.3 to
version 8.0.4. I noticed that the \dD command in psql does
not show the check constaint of a domain. I am surpised
becaused the archives stated that a patch for displaying
check constraint in \dD command has already been applied
(http://a
10 matches
Mail list logo
