On Wed, Oct 5, 2011 at 1:24 AM, Dave Page wrote:
>
>
> On Wednesday, October 5, 2011, Thomas Kellerer wrote:
> > Dave Page, 04.10.2011 21:46:
>
> >>
> >> We updated our build system to use BitRock 7 today (for unrelated
> >> reasons) which has new features for ACL management. We're going to
> >>
On Thu, May 19, 2011 at 1:05 AM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> Georgi Ivanov wrote:
>
> > Hi,
> > I wander what is taking up my space on disk ...
> >
> > btv=# SELECT pg_size_pretty(pg_database_size('btv_good'));
> > pg_size_pretty
> >
> > 10 GB
> > (
On Fri, Apr 22, 2011 at 9:16 AM, Geoffrey Myers
wrote:
> Vick Khera wrote:
>
> The database's enforcement of the encoding should be the last layer that
>> does so. Your applications should be enforcing strict utf-8 encoding from
>> start to finish. Once this is done, and the old data already in
On Sun, Apr 3, 2011 at 12:49 PM, Glenn Maynard wrote:
> After dumping a database (pg_dump -F c database > dump), trying to restore
> it (pg_restore dump) gives:
>
> > pg_restore: [archiver (db)] Error from TOC entry 2463; 0 58451 TABLE DATA
> table user
> > pg_restore: [archiver (db)] COPY failed
On Thu, Jan 6, 2011 at 6:56 PM, Benjie Buluran <
benjie.bulu...@igentechnologies.com> wrote:
> Hi pgSQL peeps!
>
>
>
> I’m stumped on this question for over 3 days now.
>
>
>
> I need to run a stored function in Database A (“sf DBa”) which calls a
> stored function in Database B (“sf DBb”).
>
>
>
On Tue, Sep 28, 2010 at 4:07 PM, Jeff Davis wrote:
> On Tue, 2010-09-28 at 12:18 -0600, Eric McKeeth wrote:
>
> > This is ugly, but it does seem to enforce the constraint I need, of
> > non-overlapping dates where sharing an endpoint is not considered an
> > overlap.
>
On Fri, Sep 24, 2010 at 3:22 PM, Tom Lane wrote:
> Eric McKeeth writes:
> > why would I get the following error, since the period() function is in
> fact
> > declared as immutable?
>
> > test=# ALTER TABLE test3 ADD exclude using
> > gist(period(effe
I'm getting an error message that doesn't make sense to me. Using PostgreSQL
9.0.0 on CentOS 5.5.
Given the following table and function definitions
CREATE TABLE test3
(
test3_id serial NOT NULL,
fk_id integer,
data_3 text,
effect_date date NOT NULL,
expire_date date NOT NULL,
CONSTR
