PROTECTED] wrote:
> Isaac <[EMAIL PROTECTED]> writes:
>> ERROR: getattproperties: no attribute tuple 1259 -2
>
> Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is
> a typical symptom of being compiled with higher optimization settings.
> Unfortuna
hello,
has anyone converted files from filemaker to postgres? I'm figuring I'll
just export everything into tabbed text files and then use the perl
extensions to parse it out into INSERT queries. If anyone has any experience
(or code!) to share on this process, it would be great to hear about it.
Hello,
I asked this a while back but didn't get a reply, so I'm trying again
(hopefully explaining my question better, too).
I'm setting up a basic "document manager" system that stores various short
text documents which are flagged for display on certain sections of our
website. That's the easy
Hi,
I'm trying to create a table with 20,000 columns of type int2, but I
keep getting the error message that the limit is 1600. According to
this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php
it can be increased, but only up to about 6400. Can anyone tell me
how to get
data available in a master table to do analysis on. After
the analysis I hope to derive subsets of much lower dimensionality.
IB
Isaac Ben Jeppsen
On 1/25/07, David Brain <[EMAIL PROTECTED]> wrote:
Hi,
Seeing as how no one has asked this question yet - I have to ask, why do
you need 20,000 c
On 1/26/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Thu, Jan 25, 2007 at 10:47:50 -0700,
Isaac Ben <[EMAIL PROTECTED]> wrote:
>
> The data is gene expression data with 20,000 dimensions. Part of the
> project I'm working on is to discover what dimensions are tru
o get 20,000 columns?
Thanks,
IB
Isaac Ben Jeppsen
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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
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
>
> 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:
> 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
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 :
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
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:
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
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 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 -
&
17 matches
Mail list logo
