I know that using tablespaces I can create a vertical partition by
creating two tables with the same primary key wich stores different
columns in each table.
However, I need to do some horizontal partition that receives about
2,000,000 records per month.
What the best way to perform this horizont
On 4 fev, 18:13, "Andrus" <[EMAIL PROTECTED]> wrote:
> I need to perform case insensitive search by first some characters (ABC) of
> name like
>
> SELECT ...
> FROM customer
> WHERE upper(customername) like 'ABC%'
>
> My database cluster locale is non-C
> Database encoding is UTF-8
>
> Which index
On 13 fev, 12:19, Hermann Muster <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I encountered something I can't really explain. I use the following
> statement in my application:
>
> COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
>
> This returns "ERROR: syntax error at end of input"
>
> However, using the fol
How I can recover data (or replicate data to another) based on
postgresql logs?
Where they are, and how I do it?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
On 31 jan, 12:24, [EMAIL PROTECTED] ("Daniel Verite") wrote:
> T.J. Adami wrote:
>
> > I am also searching for a more 'professional' way to startup and
> > shutdown postgresql on ubuntu and debian systems.
>
> The source comes with a start
I'm trying to install PostgreSQL 8.3 RC2 for Windows on my Windows
Vista Home Premium (Brazillian Portuguese), and thus I'm getting an
error on 'initdb' after copy of all files into destination path.
The error is this:
"Failed to run initdb: 1!
Please see the logfile in 'C:\Program Files\PostgreS
On 29 jan, 18:42, cbmeeks <[EMAIL PROTECTED]> wrote:
> I love MySQL but I'm concerned about it's future. And, I'm always
> looking to learn something new. I love the licensing model of
> Postgres.
>
> Anyway, using online documentation, I've managed to get a server
> running but I find myself con
On 30 jan, 04:14, Jon Hancock <[EMAIL PROTECTED]> wrote:
> I have compiled postgres 8.3rc2 on ubuntu 7.04 and seem to a have
> working install.
> To start postgres, I do the following:
>
> > su postgres
> > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data &
>
> ok, that works for dev mode. B
On 22 jan, 05:02, [EMAIL PROTECTED] (Julio Cesar
Sánchez González) wrote:
> Jon Hancock wrote:
> > The INSTALL file for postgresql 8.3rc1 lists the following install
> > instructions:
>
> > ./configure
> > gmake
> > su
> > gmake install
> > adduser postgres
> > mkdir /usr/local/pgsql/data
> > chown
On 22 jan, 22:46, [EMAIL PROTECTED] ("Jamiil Abduqadir") wrote:
> I am trying to install PosgreSQL using postgresql-8.3-dev1 on my WindowsXP
> machine, but I get a message that reads
>
> Fail to create a temporary directory
>
> Does anyone know why I am getting this error message?
>
> Thank in adva
the others in
their vastness. For who will not be astounded at the fact that our body,
which a little while ago was imperceptible in the universe, itself
imperceptible in the bosom of the whole, is now a colossus, a world, or
rather a whole, in respect of the nothingness which we cannot reach? He w
shall be sprinkled on his
garments, so as to stain all his raiment. He will not only hate you, but
he will have you in the utmost contempt: no place shall be thought fit
for you, but under his feet to be trodden down as the mire of the
streets.
The misery you are exposed to is that which God wil
fervent with love. Princes abandoned
their pomp; maidens suffered martyrdom. Whence came this influence? The
Messiah was come. These were the effect and sign of His coming.
773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes
venient et adorabunt eum.156 Parum est ut,157 etc. Pos
with
extraordinary success in his ministry, in the conversion of many souls.
He had five harvests, as he called them. The first was about 57 years
ago; the second about 53; the third about 40; the fourth about 24; the
fifth and last about 18 years ago. Some of these times were much more
remarkable
On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote:
> > It's quite simple to have problems with pgAdmin's backup procedure.
>
> Hmm - shouldn't be, and if so then please let the pgAdmin people know!
> They're always working to improve the package and it's
>
I think the same. We (company I
On 14 jan, 09:08, [EMAIL PROTECTED] (Ashish Karalkar) wrote:
> Hello list members,
> I hav a table with 140M rows. While I am trying to select the count from the
> table
> I am getting following error
> ERROR: shared buffer hash table corrupted
> Can anybody please suggest me wht had gone wrong a
On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote:
> Having recently jumped ship from MSSQL to Postgres I'm finding it a
> little difficult getting onto the 'correct path.' Basically I have a
> live database and I want to take a copy of that and then restore it
> onto a backup server.
>
> Fi
On 14 jan, 17:02, "Andrus" <[EMAIL PROTECTED]> wrote:
> create temp table test (col char);
> select count(col) from test order by col;
>
> causes
>
> ERROR: column "test.col" must appear in the GROUP BY clause or be used in
> an aggregate function
> SQL state: 42803
>
> How to fix this ?
> This st
On Dec 19, 4:23 pm, [EMAIL PROTECTED] (Geoffrey) wrote:
> Joshua D. Drake wrote:
> > Geoffrey wrote:
> >> Johan van Zyl wrote:
> >>> Please elaborate! (Many a true word spoken in jest)
> >>> "That is until I can convince my new employer to realise the dark side
> >>> of Microsoft SQL Server."
>
> >
On 20 nov, 12:35, [EMAIL PROTECTED] (Reg Me Please) wrote:
> Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto:
>
>
>
> > I'm using Microsoft Visual Foxpro 9 developing an ERP application,
> > using PostgreSQL 8.2.5 and ODBC connection in version 7.
>
>
I'm using Microsoft Visual Foxpro 9 developing an ERP application,
using PostgreSQL 8.2.5 and ODBC connection in version 7.
If I upgrade my ODBC drivers to use "PostgreSQL ANSI", becomes an
error like this:
"function saldo_estoque("unknown", "unknown", "unknown", "unknown",
timestamp without time
I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
"createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252."
On PostgreSQL 8.2.5 I'm able to create data d
On 31 out, 11:00, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> The Amazon Dynamo framework is going to replace RDBMS?
>
> http://www.readwriteweb.com/archives/amazon_dynamo.php
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
On 31 out, 12:01, [EMAIL PROTECTED] (Craig White) wrote:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way t
On 31 out, 06:56, [EMAIL PROTECTED] (Joao Miguel
Ferreira) wrote:
> Hello all,
>
> I got surprised by this message:
>
> -
> The program "pg_dump" is needed by pg_dumpall but was not found in the
> same directory as "/usr/bin/pg_dumpall".
> Check your installation
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
These two databases do not have the same ER model. However, I want to
access tables on "company_a" there are in "company_b". I want to use
them as local tables (as other databases like Sybase allows, since you
have opened
On 31 out, 07:33, [EMAIL PROTECTED] (João Paulo Zavanela) wrote:
> Hi,
>
> How I configure password to postgres user in Linux?
> I'm using trust, but I needing configure password in database.
>
> Thanks!
>
> ---(end of broadcast)---
> TIP 9: In versio
27 matches
Mail list logo
