On Mon, Sep 9, 2013 at 10:22 PM, patrick keshishian pkesh...@gmail.com 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
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
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:
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, it
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'...
On 9 Sep 2013, at 21:03, Alvaro Herrera alvhe...@2ndquadrant.com 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;
On Tue, Sep 10, 2013 at 5:51 AM, Oliver Kohll - Mailing Lists
oliver.li...@gtwm.co.uk wrote:
On 9 Sep 2013, at 21:03, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
select string_agg(case when words like '*%*' then upper(btrim(words, '*'))
else words end, ' ')
from regexp_split_to_table('The
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-handed see the
On 10 September 2013 15:09, Vincent Veyron vv.li...@wanadoo.fr 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:
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
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
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
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: [archiver (db)] could not
...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
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;
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
On Tue, Sep 10, 2013 at 6:57 AM, Chris Curvey ccur...@zuckergoldberg.com
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
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
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
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
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 pkesh...@gmail.com 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
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:
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
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
On Tue, Sep 10, 2013 at 7:02 PM, Sergey Shelukhin
ser...@hortonworks.com 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
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
## 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 from
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
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.
33 matches
Mail list logo
