[GENERAL]

2011-04-10 Thread abd...@onvol.net
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

Re: [GENERAL] what data type to store fixed size integer?

2011-04-10 Thread Tom Lane
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

Re: [GENERAL] searchable database

2011-04-10 Thread Ivano Luberti
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

Re: [GENERAL] searchable database

2011-04-10 Thread Robert Soulliere
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

[GENERAL] list

2011-04-10 Thread kilfdc

Re: [GENERAL] what data type to store fixed size integer?

2011-04-10 Thread Craig Ringer
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

[GENERAL] what data type to store fixed size integer?

2011-04-10 Thread Arash pajoohande
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

[GENERAL] pg_restore problem with type

2011-04-10 Thread Sim Zacks
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.

Re: [GENERAL] Handling bytea field in partition trigger function

2011-04-10 Thread Noah Misch
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

Re: [GENERAL] Transaction wraparound vacuum synchronicity

2011-04-10 Thread Noah Misch
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

Re: [GENERAL] searchable database

2011-04-10 Thread John R Pierce
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