Craig Ringer wrote on 04.08.2012 03:39:
Hi all
On Stack Overflow I was following the efforts of a user who was
unable to install Pg.
http://stackoverflow.com/questions/11656410/postgresql-installation-issue#comment15679519_11656410
They've just come back to let me know they found a solution t
Jeff Davis wrote:
> On Fri, 2012-08-03 at 17:06 +0200, Andreas Kretschmer wrote:
> > Hi all,
> > great feature, but i can't find a TIMERANGE, i want to store time-ranges,
> > for
> > instance [10:00:00,16:00:00), how can i do that?
>
> CREATE TYPE timerange AS RANGE ( subtype = time );
Thx.
On 2012-07-25, Steve Crawford wrote:
>
> How are your determining the space used by a table?
>
> Why are you assuming 7 bytes for a 3-character value? (Character values
> up to 126 characters long only have 1-character overhead.)
character values upto 127 octets long only have one octet overhea
On 08/04/2012 03:08 PM, Thomas Kellerer wrote:
Craig Ringer wrote on 04.08.2012 03:39:
Hi all
On Stack Overflow I was following the efforts of a user who was
unable to install Pg.
http://stackoverflow.com/questions/11656410/postgresql-installation-issue#comment15679519_11656410
They've ju
Anybody?
On Jul 27, 2012, at 10:00 AM, Ben Chobot wrote:
> We make heavy use of streaming replication on PG 9.1 and it's been great for
> us. We do have one issue with it, though, and that's when we switch master
> nodes - currently, the documentation says that you must run pg_basebackup on
>
The following page:
http://www.postgresql.org/about/
mentions some limits but not the following:
[1] maximum number of databases per database server instance
[2] maximum number of schemas per database
Is there empirical information on whether both these values can be as high
as a few hundreds?
On 08/03/2012 08:06 AM, Andreas Kretschmer wrote:
Hi all,
great feature, but i can't find a TIMERANGE, i want to store time-ranges, for
instance [10:00:00,16:00:00), how can i do that?
Regards, Andreas
Time ranges could be more complicated than you realize. You'd have
problems if you wante
I searched the archives and didn't find the answer as to how to add
foreign keys to a table using pgadminIII v1.14.2. I am very familiar with
relational databases and foreign keys, indices, etc., but I am a newbie to
postgresql. For instance, say I have two tables, "address" and
"addresstype", bot
On 08/04/2012 01:10 PM, Mary F. Masterson wrote:
I searched the archives and didn't find the answer as to how to add
foreign keys to a table using pgadminIII v1.14.2. I am very familiar with
relational databases and foreign keys, indices, etc., but I am a newbie to
postgresql. For instance, say
Thank you Adrian!! I was missing step two, selecting the table to reference.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Menelaos PerdikeasSemantix writes:
> The following page:
> http://www.postgresql.org/about/
> mentions some limits but not the following:
> [1] maximum number of databases per database server instance
> [2] maximum number of schemas per database
> Is there empirical information on whether both
First off, I've posted this question on StackOverflow in case anyone
wants to answer it:
http://stackoverflow.com/questions/11814132/postgresql-smallint-overflowing-when-creating-index-on-multiple-columns-is-th
The repro can be found here: http://sqlfiddle.com/#!1/734d7/1
I'm happy to log this a
12 matches
Mail list logo
