hello.
my database size is 5GB. what is the block size
recommend?
thanks
wilson
On Wed, 2003-08-06 at 09:22, The Hermit Hacker wrote:
> On Wed, 6 Aug 2003, Robert Treat wrote:
>
> > depends on what you mean by any. I believe that the standard tarball
> > will compile under windows, but to what extent it will actually run I
> > couldn't say. This release is not intended for n
I don't know if this is a postgresql bug or a problem with my
architecture but I thought I would post here about a strange bug I just
came across in my application.
I use OS X 10.2.6 as my development machine and FreeBSD 4.8 for my
production machines. All systems are running postgresql 7.3.3.
=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes:
> When I copy it into the console (psql) it runs well, but from function it
> sends an error:
> ERROR: cannot open multi-query plan as cursor
> What does it mean? Could anybody help me?
I think most likely it means you made a typo t
On 06/08/2003 10:43 [EMAIL PROTECTED] wrote:
I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system,
installed from rpms.
There seemed to be some files required for installation of tsearch
missing so I downloaded the src bundle too.
Tsearch2 then compiled ok but now the command:
psq
Tom,
I 'raise notice'd the whole query by the function (which was quoted in my
previous letter).
Actually I generate the query on the fly according to the given parameters.
I call it in a for R in execute Query statement.
As the function is a bit long I quote only a portion of it.
FieldLi
> I'd highly recommend against using postgresql with cygwin in production,
and further, very highly recommend against using it under win9x, due to
the stability issues on that platform. Can you just put it on a Win2K or
better a linux box and let the clients all connect to that machine?
I woul
Stephan Szabo wrote:
On Fri, 8 Aug 2003, Anthony Best wrote:
I've noticed that the SUM() seems to overflow under some situations.
The only difference is the order that the data is retrived from the
database.
Is amount a float type column (float4 or float8)? If so, you're probably
just ru
Why would you want to do that?
Why not do it an easier way and dump the database and restore it into
your new database?
There's got to be a lot of stuff to consider when doing something as
radical as renaming a database.
I am a developer of dental computer systems using Postgres within Red
Ha
while remove --enable-thread-safety everything ok.
what's the matter?
the error output:
---8<-
make[2]: Entering directory `/usr/laser/postgresql-7.4beta1/src/port'
gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-de
Culley,
> But on my production machine postgresql complained about the order by
> clause-- it wanted the table alias to be on last_name.
I believe this is because you used "u.last_name" earlier in the statement, and the
ORDER BY clause doesn't know that's what you mean.
That's a guess that doe
On Tue, 5 Aug 2003, Yudha Setiawan wrote:
> Dear expert,
>
> It's Urgent.
> How do I dump just for
> - Table Structure
> - Index
> - Constraint
> - Type
> - Function.
> Without
> - Create Trigger.
> - Data.
> i've tried with -X option, but it didn't works
> "pg_dump
When my RULE takes
the form of:
CREATE
RULE name AS ON INSERT TO table DO INSTEAD ( UPDATE query ; INSERT
query) ;
The INSERT query doesn't fire and
there is no error. Putting the INSERT first allows them to both fire. Can anyone
tell me why? I think it has something to do with *NEW* an
Hunter Hillegas <[EMAIL PROTECTED]> writes:
> I cannot determine what character is stored in a varchar...
> For instance:
> thedonnaholics=# select state from mailing_list where rec_num = 7;
> state
> ---
> (1 row)
I'd say it's either NULL or between one and five space characters.
To find
Ok... I don't think that it is null:
thedonnaholics=# select count(*) from mailing_list where state = null;
count
---
0
(1 row)
I ran the query you suggested but I don't know what it means:
thedonnaholics=# select '>' || state || '<' from mailing_list where rec_num
= 7;
?column?
-
Tom Jenkins <[EMAIL PROTECTED]> writes:
> that is what gets dumped via pg_dump. however if we take that statement
> and paste it into psql (as one long line) or through command line (ie
> psql dbname < inusecountrycode.schema) we get an error:
> 'ERROR: parser: parse error at or near "SELECT"'
>
16 matches
Mail list logo
