On 04/09/11 10:24 PM, to...@tuxteam.de wrote:
We have more than thousand electronic journals. I want to make a searchable
> database for easy access. Is there any light wight database available for
> that. Please provide me the details for the same.
Your question is just too general to make a
On Wed, Mar 09, 2011 at 10:52:25AM +, Michael Graham wrote:
> I have a database with a number of tables that are partitioned monthly,
> after that the tables are mostly read only (on rare occasions we may
> delete from a table but normally we just drop the partitions). Recently
> I've noticed
On Fri, Apr 01, 2011 at 04:09:00PM -0700, Doug Johnson wrote:
> I'm trying to partition a table that has a btyea field used to store pdf
> data. Basically the procedure filters by date, and creates a new table every
> month. I'm having problems with the executed sql string that moves the data
> int
I have a backup of a database from 8.2.x and I am trying to restore it
into 9.0.x
In 8.2.x I used the citext data type from pgfoundry (before it was part
of contrib) and it was put in the pg_catalog.
In 9.0 I am using the citext data type in contrib and it put it into the
public schema.
hi there
I wan to store a 10 digits integer in a column of table.
the data type does not need any arithmetic aperations (as of integers).
maybe its good to use bigint, but it is Postgres specific and is not part of
SQL standards
what is the best data type (fastest) to store it? any help would be
ap
On 04/10/2011 07:41 PM, Arash pajoohande wrote:
hi there
I wan to store a 10 digits integer in a column of table.
the data type does not need any arithmetic aperations (as of integers).
maybe its good to use bigint, but it is Postgres specific and is not
part of SQL standards
what is the best dat
You might want to check out these free open source library system solutions:
Evergreen:
http://www.open-ils.org/
Koha:
http://koha.org/
I am just not sure if these are "light weight" enough for what you need, but
they will provide a powerful search mechanism, a built-in front end and
other feat
I completely agree with Thomas.
If the world journal has the same meaning I give to it I suggest the OP
to give a look to Open Journal System:
http://pkp.sfu.ca/?q=ojs
Maybe it goes further than the OP wants.
I never used it wiht Postgres , because my customers wanted to use
MySQL :-(
But it sup
Craig Ringer writes:
> On 04/10/2011 07:41 PM, Arash pajoohande wrote:
>> I wan to store a 10 digits integer in a column of table.
>> the data type does not need any arithmetic aperations (as of integers).
>> maybe its good to use bigint, but it is Postgres specific and is not
>> part of SQL stand
there is no messageto send
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
11 matches
Mail list logo
