Alban Hertroys writes:
> On 4 Feb 2012, at 9:46, hubert depesz lubaczewski wrote:
>> select 'depesz depeszx depesz' ~ E'^(.*)( \\1)+$';
> Apparently something odd is going on between the wildcard, the repetitive
> part and the back-reference. That could be just us not seeing what's wrong
> with
On 02/13/2012 02:45 PM, Jeff Davis wrote:
On Mon, 2012-02-13 at 17:30 -0500, Eliot Gable wrote:
Are postgres back end processes connection specific? In other words,
can we assume / trust that they will be terminated and cleaned up when
we close a connection and that they will not live on and be
On Mon, 2012-02-13 at 17:30 -0500, Eliot Gable wrote:
> Are postgres back end processes connection specific? In other words,
> can we assume / trust that they will be terminated and cleaned up when
> we close a connection and that they will not live on and be reused by
> other connections?
Yes, on
Are postgres back end processes connection specific? In other words, can we
assume / trust that they will be terminated and cleaned up when we close a
connection and that they will not live on and be reused by other
connections?
What is a good way to test this is the case which would account for
d
On 02/13/2012 02:13 PM, Merlin Moncure wrote:
On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts wrote:
On 2012-02-10, Steve Clark wrote:
Is there a way with psql to get column output to be
"data1","data2",...,"datan"
assuming you are trying to be compatible with CSV:
copy ( your_query_here )
On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts wrote:
> On 2012-02-10, Steve Clark wrote:
>
>> Is there a way with psql to get column output to be
>> "data1","data2",...,"datan"
>
> assuming you are trying to be compatible with CSV:
>
> copy ( your_query_here ) to stdout with csv header ;
yeah --
On Mon, Feb 13, 2012 at 11:42 AM, wrote:
>
> Thank you very much. This is most helpful.
>
you're welcome. Keep in mind hstore features you need start with
postgres 9.0 and it's an extension aka contrib you have to add to the
database. (also as Andreas noted, please try to keep responses
on-lis
On Wed, Feb 8, 2012 at 10:51 AM, Andreas Kretschmer
wrote:
> mgo...@isstrucksoftware.net wrote:
>
>> We need to ensure that our data is in upper case only in the db. Is there a
>> easy way to do this via a function without having to name each column
>> separately?
>
> You can define a TRIGGER fo
On vr, 2012-02-10 at 19:25 -0500, Bruce Momjian wrote:
> On Mon, Dec 12, 2011 at 07:15:12PM +0100, Wim Bertels wrote:
> > Hallo,
> >
> > psql latex output format needs to differentiate between a newline and a
> > tabularnewline.
> >
> > the problem arises when u have a field value that contains a
Mike Blackwell wrote:
> The following are the relevant log entries from a recent crash of v9.1.1
> running on an older RHEL
> Linux box. This is the first crash we've experienced in a lot of years of
> running Pg. Any assistance
> in how to determine what might have caused this is welcome.
>
>
On 2012-01-06, Phoenix Kiula wrote:
> On Fri, Jan 6, 2012 at 6:53 PM, Steve Crawford
> wrote:
> Thanks Steve.
>
> The file has 350 million lines. Sed, Awk etc are a little painful when
> the file is 18GB witht hat many lines.
On files of that size they're a lot nicer than an interactive editor
mgo...@isstrucksoftware.net wrote:
> We need to ensure that our data is in upper case only in the db. Is there a
> easy way to do this via a function without having to name each column
> separately?
usually I like to explain why it's not possible before giving the game
away, but I see that ot
On 2012-01-26, David W Noon wrote:
>
> Try using CURRENT_TIMESTAMP instead. In fact, CURRENT_TIMESTAMP is
> more traditional SQL than now(). I don't have an ANSI standard handy,
> so I cannot be certain when now() was added, if ever; but I have been
> using CURRENT TIMESTAMP (space instead of vi
On 2012-02-08, Carlos Mennens wrote:
> ALTER ROLE tom ENCRYPTED PASSWORD 'md5081bea17b5503506d29531af33cc6f4e';
>
> \password tom
>
> Is there a downside to using the \password psql command? Is it also
> encrypted like the statement above? How do you create roles and do you
> do it manually or ha
On 2012-01-26, David Johnston wrote:
> Is it possible to do the equivalent of let-bindings in a pure SQL function?
> I have a SELECT that invokes "now" multiple times. It would be nicer to do
> it only once and reuse the value. Something like this:
There is no need. now() is tagged as stable.
On 2012-02-03, garry wrote:
> This is a multi-part message in MIME format.
> --060709070909070009090305
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
>
> I have a table which holds a user name and their results in exams. There
> can be
On 2012-02-07, Dave Potts wrote:
>
>
> I am running Ubuntu 11.04, I have Postgres 8.4 and 9.1 installed.
>
> My default when I say psql it connects to postgres 8.4
>
> ie I set export PGCLUSTER=9.1/main
>
> it connects to 9.1
>
> Q. How can I connect to 9.1 by default without having to set PGCLUS
On 2012-02-10, Steve Clark wrote:
> Is there a way with psql to get column output to be
> "data1","data2",...,"datan"
assuming you are trying to be compatible with CSV:
copy ( your_query_here ) to stdout with csv header ;
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsq
18 matches
Mail list logo
