On 2013-03-13, Charl Roux charl.r...@hotmail.com wrote:
--_51d77859-0e03-4afa-bde6-853bee9c0a11_
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
appologies for the formatting, gmane did something to your email that
SLRN didn't like.
void __fastcall
On 2013-03-15, lender crlen...@gmail.com wrote:
Hello.
We are currently redesigning a medium/large office management web
application. There are 75 tables in our existing PostgreSQL database,
but that number is artificially low, due to some unfortunate design choices.
The main culprits are
On 16 March 2013 01:21, Steve Crawford scrawf...@pinpointresearch.comwrote:
On 03/15/2013 11:29 AM, Oleg Alexeev wrote:
We've faced with strange index problem.
At some moment index became bad and queries does not return any data.
For example, there are two tables - A (id, name) and B (id,
On 2013-03-13, Joe Van Dyk j...@tanga.com wrote:
--047d7b6226a405604904d7d09001
Content-Type: text/plain; charset=UTF-8
On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
On 03/12/2013 09:05 PM, Perry Smith wrote:
To all who replied:
Thank you. ...
On Mar 16, 2013, at 9:33, Oleg Alexeev oalex...@gmail.com wrote:
On 16 March 2013 01:21, Steve Crawford scrawf...@pinpointresearch.com wrote:
On 03/15/2013 11:29 AM, Oleg Alexeev wrote:
We've faced with strange index problem.
At some moment index became bad and queries does not return any
Hello List,
My colleagues and I have some interest in creating an automated
PG-Haskell bridge, that will read the PG catalog for a
particular namespace or namespaces and generate a Haskell module
with functions of appropriate types, creating functions for each
stored procedure and simple tuple
Alban Hertroys haram...@gmail.com writes:
If there's actually something wrong with the database; it looks a bit like
your tables and your indexes get out of sync somehow, which normally wouldn't
be possible. I'm mostly guessing, but perhaps one of the below has something
to do with it:
On 16 March 2013 14:32, Alban Hertroys haram...@gmail.com wrote:
On Mar 16, 2013, at 9:33, Oleg Alexeev oalex...@gmail.com wrote:
On 16 March 2013 01:21, Steve Crawford scrawf...@pinpointresearch.comwrote:
On 03/15/2013 11:29 AM, Oleg Alexeev wrote:
We've faced with strange index problem.
On 16 March 2013 19:10, Tom Lane t...@sss.pgh.pa.us wrote:
Alban Hertroys haram...@gmail.com writes:
If there's actually something wrong with the database; it looks a bit
like your tables and your indexes get out of sync somehow, which normally
wouldn't be possible. I'm mostly guessing, but
Hi,
I'm using postgresql 9.2.
I'm trying to figure out how can I use daterange type in my database
that is supposed to be a school calendar.
I did the followings at the postgresql command prompt:
create database schoolcalendar;
create table semester_1 ( schooldays daterange );
insert into
Oleg Alexeev oalex...@gmail.com writes:
* it is varchar columns, 256 and 32 symbols length
* encoding, collation and ctype: UTF8, en_US.utf8, en_US.utf8
* autovacuum, fsync off, full_page_writes = on, wal_writer_delay = 500ms,
commit_delay = 100, commit_siblings = 10, checkpoint_timeout =
2013/3/17 Csanyi Pal csanyi...@gmail.com:
Hi,
I'm using postgresql 9.2.
I'm trying to figure out how can I use daterange type in my database
that is supposed to be a school calendar.
I did the followings at the postgresql command prompt:
create database schoolcalendar;
create table
On Mar 16, 2013, at 2:05 PM, Csanyi Pal wrote:
So how can I use this table further eg. to get dates of the school days
but without Saturdays and Sundays?
You can't do that directly (that kind of calendar operation is outside of the
scope of a range type). You can, however, easily write
13 matches
Mail list logo