On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote:
> Ls -la /var/lib/pgsql/9.6/data
>
> drwx--. 20 postgres postgres 4096 Abr 21 17:52 .
> drwx--. 4 root root51 Abr 21 06:33 ..
Ensure that the user 'postgres' has permissions to get to
this dir from / up. This may
On Tue, May 10, 2016 at 03:00:55PM +0200, Nicolas Paris wrote:
> > The way I want is :
> > csv -> binary -> postgresql
> >
> > Is this just to be quicker or are you going to add some business logic
> > while converting CSV data?
> > As you mentioned ETL, I assume the second, as I don't think that
>
On Tue, May 10, 2016 at 01:38:12PM +0200, Nicolas Paris wrote:
> The way I want is :
> csv -> binary -> postgresql
>
> And if possible, transforming csv to binary throught java.
>
> Use case is ETL process.
Not sure what the point would be tbh if the data is already in CSV.
You might aswell sub
On Mon, Aug 24, 2015 at 08:53:43PM -0400, Melvin Davidson wrote:
> You are right, he was probably talking about FK's. I was just so frustrated
> about people insisting that using "ID" as the primary key in every table is
> a "good" idea,
> I didn't bother to reply previously. I stand firm on my bel
On Mon, Aug 24, 2015 at 08:22:17PM -0400, Melvin Davidson wrote:
> On Mon, Aug 24, 2015 at 8:00 PM, Berend Tober wrote:
> >> 1) What happens if someone mis-types the account-id?
> >> To correct that, you also need to correct the FK field in the
> >> other dozen tables.
> >
> > ..
On Tue, Jul 28, 2015 at 01:31:29PM +0200, arnaud gaboury wrote:
> On Tue, Jul 28, 2015 at 1:26 PM, Francisco Olarte
> wrote:
>
> > Hi Arnaud...
> >
> > On Tue, Jul 28, 2015 at 12:13 PM, arnaud gaboury
> > wrote:
> > > On Fedora 22
> > ...
> > > Jul 28 11:49:57 poppy postgresql-ctl[307]: FATAL:
On Sun, Jul 04, 2010 at 03:10:36PM +0100, Andre Lopes wrote:
> Hi,
>
> I need to use an Forum Software. There is any Open Souce Forum Script using
> PostgreSQL?
phpBB3 off the top of my head.
--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Ru
On Sun, Apr 04, 2010 at 08:03:13PM -0700, Wang, Mary Y wrote:
> I still don't get it. I do want a zero for the subversion_flags to be stored
> in the table. But it returned an error because it didn't like
> subversion_flags='' in the UPDATE SQL statement.
>
> subversion_flags | integer
On Mon, Nov 02, 2009 at 10:52:40AM +, Jasen Betts wrote:
> what's the absolute value of '1month -30 days'::interval
>
> if I add it to the first of march it goes forwards if I add it to the
In march a month has 31 days.
> first of february if goes backwards. if I add it to the first of april
On Thu, May 07, 2009 at 09:45:30PM +0200, Anders Steinlein wrote:
> Has anyone done something like this, or is it simply A Bad Idea? How
> many schemas can a database contain, until one hits a (hard or soft)
> limit? Keep in mind that this is not a "regular" web-app with thousands
> of users,
On Wed, Mar 11, 2009 at 05:41:55PM -0700, Josh Berkus wrote:
> All,
>
> There *may* be a streaming presentation of PostgreSQL, Unison-DB and
> Genetech in 1/2 hour:
>
> http://cubic.org/sfpug.html
> 6:15 or 6:30pm PST/PDT, March 11th
>
> Join us and see if it works!
Will there be a saved version
On Tue, Jun 10, 2008 at 03:43:02PM +0200, Leif B. Kristensen wrote:
> On Tuesday 10. June 2008, Leif B. Kristensen wrote:
> >Hey, I told it not to be greedy, didn't I?
>
> Found it. I must make *both* atoms non-greedy:
That makes no sense. Take this bit of perl, which works as expected:
$str = '
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote:
> well its using the pgsql_replication_check.pl, which does:
>
> --
> use Pg;
...
> So I assume it's not getting past the use Pg line as although it's
> looking in /usr/lib/perl5 it's not going to look in
> /usr/lib/p
On Tue, Jan 29, 2008 at 04:45:48AM -0800, Glyn Astill wrote:
> Should the subdirectory DBD be in there? Perl was setup using apt.
How are you using it and what's your DBI db connect line?
I'm about to go to sleep so if I don't reply it'll be because I'm
unconcious. :)
--
"To the extent that
On Tue, Jan 29, 2008 at 04:24:05AM -0800, Glyn Astill wrote:
> I'm trying yo run a perl script that uses DBI (Slonys
> psql_replication_check.pl to be precise) and I'm getting the error:
>
> Can't locate Pg.pm in @INC
>
> Now I do have the file in /usr/lib/perl5/DBD/ but the script can't
> see it
On Mon, Jan 07, 2008 at 04:54:46PM -0800, Richard Broersma Jr wrote:
> > wrote:
> > > what is a botherboard?
> >
> > Brotherboard -- motherboard is a bit old.
>
> Maybe a Freudian slip? ;)
His brother is his mother?
Man... that's just weird.
--
"To the extent that we overreact, we proffer
On Sun, Oct 14, 2007 at 12:01:45AM -0600, Cesar Alvarez wrote:
> Hello
> im working in a proyect in ORACLE 10g and one of the things i like is
> using the INSERT RETURNING with the parameters, im not sure that i read
> about postgres 8.2 suporting this feature... if its true where can i
> read m
On Thu, Feb 22, 2007 at 01:08:04PM +1100, Chris wrote:
> In postgres, to stop an empty blank string:
>
> create table a(a text not null check (char_length(a) > 0));
What's wrrong with using
a <> ''
sd the check? Or is this just a flavour thing?
--
"To the extent that we overreact, we prof
On Thu, Feb 22, 2007 at 11:27:18AM +0100, Zoltan Boszormenyi wrote:
> >>I would do a CHECK (trim(a) <> '')
> >
> >Whitespaces are values too, you know.
>
> Yes, I know. But e.g. for a real people name, would you store
> accidentally entered spaces before or after the actual name, too?
> Which woul
On Thu, Feb 22, 2007 at 09:13:13AM +0100, Zoltan Boszormenyi wrote:
> Chris ?rta:
> >CaT wrote:
> >>On Thu, Feb 22, 2007 at 01:08:04PM +1100, Chris wrote:
> >>>create table a(a text not null check (char_length(a) > 0));
> >>
> >>What's w
On Sun, Jun 12, 2005 at 12:24:30PM +0900, Tatsuo Ishii wrote:
> Thank you for interested in PostgreSQL CE. There is a sample
> examination problems page:
>
> http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
>
> You could find some idea what the exam looks like.
My mind broke parsin
21 matches
Mail list logo