On Mon, Sep 9, 2013 at 10:22 PM, patrick keshishian wrote:
>
> If printing inside the mug is too difficult, cost prohibitive, then stick
> with the smiling elephant at the outside bottom of the mug.
>
> This type of a design would be a good ice-breaker/conversation
> starter in office meetings, et
Hi,
I found following code:
create or replace function plpgsql_edit_distance(stra text, strb text)
returns integer as $$
declare
rows integer;
cols integer;
begin
rows := length(stra);
cols := length(strb);
IF rows = 0 THEN
return cols;
END IF;
IF co
Hello all,
I have sent below question months ago but I could not get any reply from you
experts. I will very appreciated if you can help.
PS: I have tried debug_pretty_print = off but I did not work.
Emre ÖZTÜRK
From: emreozt...@outlook.com
To: pgsql-general@postgresql.org
Subject: Sin
Hello,
Try changing the variable left to something other like left_val. It will
work.
Maybe the problem is because LEFT is a keyword.
Beena Emerson
Hi, any idea? can you please advise?
On 10 Sep 2013, at 3:22 AM, ascot.m...@gmail.com wrote:
> Hi,
>
> For special testing reason, I am trying to restore PG from a backup that the
> basebase is from Standby and WAL files are from Master. During recovery
> phase, for every WAL file process, i
Emre ÖZTÜRK wrote:
> I have sent below question months ago but I could not get any reply from you
> experts. I will very
> appreciated if you can help.
>
> PS: I have tried debug_pretty_print = off but I did not work.
> Is there a parameter to log any SQL query as a single line in audit logs? I
Il 10/09/2013 10:46, Beena Emerson ha scritto:
Hello,
Try changing the variable left to something other like left_val. It
will work.
Maybe the problem is because LEFT is a keyword.
Yes, left() is a function returning a 'text'. There's a conflict when
you define it as an 'integer'...
Giusepp
On 9 Sep 2013, at 21:03, Alvaro Herrera wrote:
> select string_agg(case when words like '*%*' then upper(btrim(words, '*'))
> else words end, ' ')
> from regexp_split_to_table('The *quick* *brown* fox jumped over the *lazy*
> dog', ' ') as words;
>
> string_agg
On Tue, Sep 10, 2013 at 5:51 AM, Oliver Kohll - Mailing Lists
wrote:
> On 9 Sep 2013, at 21:03, Alvaro Herrera wrote:
>
> select string_agg(case when words like '*%*' then upper(btrim(words, '*'))
> else words end, ' ')
> from regexp_split_to_table('The *quick* *brown* fox jumped over the *lazy*
Le lundi 09 septembre 2013 à 14:17 -0700, John R Pierce a écrit :
> On 9/9/2013 2:07 PM, Basil Bourque wrote:
> >
> > --> Lift the rounded-corner blue bar off the top of the
> > PostgreSQL.org web site:
> > http://www.postgresql.org/
> > and wrap around a white mug.
> >
> >
> > So, the left
On 10 September 2013 15:09, Vincent Veyron wrote:
> Le lundi 09 septembre 2013 à 14:17 -0700, John R Pierce a écrit :
> > On 9/9/2013 2:07 PM, Basil Bourque wrote:
>
> > >
> > > --> Lift the rounded-corner blue bar off the top of the
> > > PostgreSQL.org web site:
> > > http://www.postgresql.
From: Marcin Mańk [mailto:marcin.m...@gmail.com]
Sent: Monday, September 09, 2013 8:30 PM
To: Chris Curvey
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey
mailto:ccur...@zuckergoldberg.com>> wr
From: emreozt...@outlook.com
To: /pgsql-general@postgresql.org/
Subject: Single Line Query Logging
Date: Wed, 10 Jul 2013 13:16:13 +0300
Hello all,
Is there a parameter to log any SQL query as a single line in audit
logs? I have some problems in my SIEM application. If a DBA sends the
query as
On 09/10/2013 06:57 AM, Chris Curvey wrote:
*From:*Marcin Mańk [mailto:marcin.m...@gmail.com]
*Sent:* Monday, September 09, 2013 8:30 PM
*To:* Chris Curvey
*Cc:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Mon, Sep 9, 2013 at 4:00 P
> >
> > Good advice. I turned on –verbose, and got a ton of output, ending with:
> >
> > pg_restore: setting owner and privileges for FK CONSTRAINT
> > user_id_refs_id_7ceef80f
> >
> > pg_restore: setting owner and privileges for FK CONSTRAINT
> > user_id_refs_id_dfbab7d
> >
> > pg_restore: [archi
> ...I wonder how long it will be before we have mugs where you can
> actually tap the logo with a finger and get send to the website!
A QR code is as close as it gets these days.
Karsten Hilbert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
Howdy,
I want to link Postgresql client to my Qt project but I noticed that
C:/PostgreSQL/9.1/lib/libpq.lib points to dynamic libaray (libpq.dll) which
is not suiatble for static linking.
How can I link statically my application with Postgresql client?
P.S.
I'm using mingw48_32 not msvs; usually
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, September 10, 2013 1:26 PM
To: Chris Curvey
Cc: Marcin Mańk; pgsql-general@postgresql.org
Subject: Re: [GENERAL] help getting a backtrace from 9.2 on Ubuntu 13.04?
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey
mailto:ccur...@zuckergo
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey
wrote:
> From: Marcin Mańk [mailto:marcin.m...@gmail.com]
>
>
> > Is it crashing on a specific database object? pg_restore -v will tell
you
> > how far it went. Then try to restore only that object. Is it perhaps
> > crashing on a specific row?
> >
>
>
Sorry, I should have included that. The error occurred when an older
client running 8.3.7 (I know, ferreting and finishing upgrades on
clients with old libraries is in progress) on CentOS 5.3 (32-bit). Of
all the machines connecting to the server, this one pretty lightly
loaded and typically cr
On Mon, Sep 09, 2013, Jeff Davis wrote:
>
> You may have seen only partial information about that bug and the fix.
Yep, I totally glazed over the REINDEX. Giving it a go -- thank you!
--
Mahlon E. Smith
http://www.martini.nu/contact.html
pgpIXe1Uec5OO.pgp
Description: PGP signature
Hi,
I would like to know if there is a way to do what I need with
Postgress.
I have a table with logs and a table with a list of subnets.
Right now I do the following query in my table:
Select * From logs Where src_ip << '10.0.0.0/24' OR src_ip <<
'10.1.0.0/24' OR src_ip << '172.1
Steve Crawford wrote
> Sorry, I should have included that. The error occurred when an older
> client running 8.3.7 (I know, ferreting and finishing upgrades on
> clients with old libraries is in progress) on CentOS 5.3 (32-bit). Of
> all the machines connecting to the server, this one pretty lig
One more "cute" idea that came to me last night. Here is a very
poor attempt at it by yours truly; keep in mind I'm not a graphics
artist. This image is for illustration purposes only!
http://sidster.com/gallery/2013/09/10/elephant_paw.sml.jpg
Can you picture a bunch of these on a meeting
patrick keshishian wrote:
> One more "cute" idea that came to me last night. Here is a very
> poor attempt at it by yours truly; keep in mind I'm not a graphics
> artist. This image is for illustration purposes only!
>
> http://sidster.com/gallery/2013/09/10/elephant_paw.sml.jpg
>
> Can you
On 09/10/2013 10:37 AM, Chris Curvey wrote:
Another development (possibly unrelated): I tried **dumping** with
–no-privileges –no-tablespace –no-owner, and the restore went fine.
Probably has to do with whether you are dumping plain text or custom format:
http://www.postgresql.org/docs/9.2
Hi.
Is there any way to make postgres not abort the transaction on failed
select?
I have a system that uses ORM to retrieve data; ORM is very slow for some
cases, so there's a perf optimization that issues ANSI SQL queries directly
thru ORM's built-in passthru, and falls back to ORM if they fail.
Sergey Shelukhin wrote
> Hi.
> Is there any way to make postgres not abort the transaction on failed
> select?
>
> I have a system that uses ORM to retrieve data; ORM is very slow for some
> cases, so there's a perf optimization that issues ANSI SQL queries
> directly
> thru ORM's built-in passthr
ORM in this case doesn't execute the failing statements, we do. And
obviously we want to avoid implementing another "better ORM"
w/database-specific code for this "side path" if possible, so we just stick
to ANSI SQL (for now).
As for the question itself, I believe the relevant standard (that is S
Sergey Shelukhin wrote
> ORM in this case doesn't execute the failing statements, we do. And
> obviously we want to avoid implementing another "better ORM"
> w/database-specific code for this "side path" if possible, so we just
> stick
> to ANSI SQL (for now).
>
> As for the question itself, I bel
On Tue, Sep 10, 2013 at 7:02 PM, Sergey Shelukhin
wrote:
> Hi.
> Is there any way to make postgres not abort the transaction on failed
> select?
>
> I have a system that uses ORM to retrieve data; ORM is very slow for some
> cases, so there's a perf optimization that issues ANSI SQL queries direct
Hello all,
I have a table which makes use of pg_largeobjects. I am inserting rows into
the table as user1. If I connect to the database as user2 I can SELECT
data, but can not open the large object for reading (user1 can do this). I
don't want to set lo_compat_privileges as then user3 (who can't S
## Eric Lamer (eric.la...@intact.net):
> I can do something like:
>
>Select * From logs Where src_ip IN (Select ip from ip_table where zone
> = 'ZONE_a');
>
>Of course that does not work since it does not work with Inet type and
> I cannot use << because I have more than 1 row return
On 9/10/2013 9:49 PM, James Sewell wrote:
As an aside, is there any reason to use pg_largeobjects if I am
storing data under 1GB which doesn't require random reads any more? My
impression is no?
one good reason to use LO is so you can read the data like its a
file.me, I'd as soon use NF
The query suffers from the auto-lower-casing of unquoted table names, which
is not ANSI compliant. Technically we could add quotes (and stay ANSI), but
then MySQL would break without explicitly setting it to use ANSI mode, so
it's a lose-lose situation if we do not want to have DB-specific code.
So
35 matches
Mail list logo
