Hello all,
I'm using a COPY statement to load data into a PostGIS. The issue I am
facing is that if I define fields with the REAL type, the COPY will only
preserve 4 decimals which is not sufficient for my application.
Here is the commands I'm running and a sample of the results :
CREATE TA
every child. To my great surprise, the
insert below failed with a message saying that NULLs are not allowed in the
modificationdate column.
INSERT INTO observation
(dataset, station, method, startdate, duration, value)
VALUES (9, 2, 128, '2014-01-01 00:00:00', '24 hours', 42)
On 2014-02-18 14:25:59 Adrian Klaver wrote:
> On 02/18/2014 02:10 PM, Samuel Gilbert wrote:
> > I have data warehousing DB 2 fairly big tables : one contains about 200
> > million rows and the other one contains about 4 billion rows. Some
> > queries
> > are now takin
h of my post as short as
possible.
As Tom Lane pointed out, it's hard to get help without a complete self-
contained example. I will work on writing that up tomorrow.
Cheers!
On 2014-02-18 15:02:41 Adrian Klaver wrote:
> On 02/18/2014 02:42 PM, Samuel Gilbert wrote:
> > On 2014-02-18 14
On 2014-02-18 17:59:35 Tom Lane wrote:
> Samuel Gilbert writes:
> > All of this was done on PostgreSQL 9.2.0 64-bit compiled from the official
>
> > source. Significant changes in postgresql.conf :
> Why in the world are you using 9.2.0? You're missing a year and a
INTO child_split1 (split, happiness) VALUES (1, 42);
-- NOTICE: NEW row is now : (1, 42, 2014-02-19 16:37:27.134194)
-- INSERT 0 1
So, we clearly see that trigger_insert_00 is called in both cases. I don't
understand why the query fails on the parent, but works when the INSERT
targets the chil
-+--
00042 | 10 | " 00042"
Is there a reason why to_char adds a leading space? Is this a bug? I can
easily fix this with trim(leading ' ' from to_char(num, '0')), but,
being of a curious nature, I'd like ton know why
00' (fill mode, doesn't leave an
> extra space for sign)
>
> On Fri, Oct 26, 2012 at 2:50 PM, Samuel Gilbert
wrote:
> > Hello,
> >
> > I've encountered an unexpected behavior when converting a number to
> >
> > char. I
> > need to m
Hello,
I have encountered a problem with inserts failing because of permissions
issues when the table in which I try to insert has foreign key constraints to
tables for which UPDATE has been revoked.
The script bellow show how to reproduce the problem with a bare-bones test
case. Reproducib
er role.
In the end, I got mixed up and sent the wrong version of the test script to
the list. However, even if it is not the right user, the problem remains.
Samuel
On Saturday, July 24, 2010 06:08:23 Alban Hertroys wrote:
> On 23 Jul 2010, at 20:39, Samuel Gilbert wrote:
> > Hel
10 matches
Mail list logo
