Hrm still no luck.
I created a snapshot of the database, moved it onto another server so
i could play with it...
Ive tried using just prepare on the console using the query that fails:
prepare worker (bigint, bigint) as select w.worker_id, w.worker_id as
printerid, w.worker, w.alias, coalesce(w.
On Wed, Mar 12, 2008 at 1:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Alex Hunsaker" <[EMAIL PROTECTED]> writes:
>
> > Perhaps my simple updates are not enough for analyze to
> > invalidate the query plan? Should I be doing inserts/deletes or just
>
err that should be (forgot the username, password placeholders)
> my $db = DBI->connect('dbi:Pg:dbname=test;', '', '', {'pg_server_prepare'=>1,
> 'pg_prepare_now'=>1}) || die "could not connect: $!";
> $db->do('create table junk (junk text, junk_id int);');
> $db->do('create sequence junk_seq;'
On Wed, Mar 12, 2008 at 1:59 PM, Alex Hunsaker <[EMAIL PROTECTED]> wrote:
> $db->do("create or replace function junk_func(int) returns integer as
> 'select junk_id from junk where junk_id = \$1;' language 'sql' stable
> strict;");
>
Another
On Wed, Mar 12, 2008 at 6:00 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> This patch should fix it ...
>
> regards, tom lane
Excellent seems to have fixed the problem. Thanks!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscripti
On Fri, Mar 28, 2008 at 4:07 AM, NikhilS <[EMAIL PROTECTED]> wrote:
> Hi Alex,
>
>
> On Fri, Mar 28, 2008 at 4:58 AM, Alex Hunsaker <[EMAIL PROTECTED]> wrote:
> > Attached is a WIP patch I have been playing with in my spare time. It
> > should take care
[Mahesh-Ss-Computer:~] ampleuser%
/Library/PostgresqL/bin/pg_ctl -D
/users/ampleuser/data -l logfile start
postmaster successfully started
Postgres will actually be spitting the error to a file called
"logfile", while saying it was successful to STDOUT. Your error is in
there.
Ale
POSTGRESQL BUG REPORT TEMPLATE
Your name : Alexey Rodin
Your email address : [EMAIL PRO
Hello, i have a problem related to the partition
memory where postgres is installed, this has increased so much that the
partition is full and postgres can not start up. The message postmaster
sends when i want to restart is insuficient disk space. Do you know if postgres
uses some disk spac
ould mention that I am
running postgres 7.3 on AMD-64 hardware with kernel 2.4.25.
deleting the indexes from the table did not help. Is there a tool or
method that that I could use to simply skip the bad data and at least
recover
dd bs=8192 skip=57880 seek=57880 if=309928249 of=out
mv out 309928249
Many thanks to Tom for his quick reply & Good luck to all others.
Thanks,
-Alex
On Thu, 26 Feb 2004, Tom Lane wrote:
> Alex Derbes <[EMAIL PROTECTED]> writes:
> > deleting the indexes from the table did
conf file.
Thanks!
Alex Koh
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 02, 2004 11:48 AM
To: Alex Koh
Cc: [EMAIL PROTECTED]
Subject: Re: [BUGS] BUG #1302: Vacuumdb and vacuumlo should disable
statement_timeout
"PostgreSQL Bugs List&quo
The following bug has been logged online:
Bug reference: 2264
Logged by: Alex Kostyshin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.x
Operating system: Windows XP/SP2, Windows XP x64
Description:bad work with cyrillic encoding
Details:
1. Wrong sorting
The following bug has been logged online:
Bug reference: 2380
Logged by: Alex Fomin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Ubuntu Linux
Description:Sequence problem
Details:
While using the following function:
---
nextval
On Tue, May 25, 2010 at 10:39, Vlad Romascanu wrote:
> The following reproducibly crashes Postgres 8.4.3 (segfault) inside
> int84eq() on both Windows and Linux, but works just fine in 8.3.4:
Hrm... Both work for me (8.4.3 and 8.4.4).
--
=> SELECT col1, col2 FROM t1 WHERE col1 IN ( SELECT * FRO
On Tue, May 25, 2010 at 11:26, Alex Hunsaker wrote:
> On Tue, May 25, 2010 at 10:39, Vlad Romascanu wrote:
>
>> The following reproducibly crashes Postgres 8.4.3 (segfault) inside
>> int84eq() on both Windows and Linux, but works just fine in 8.3.4:
>
> Hrm... Both work
On Thu, Jul 22, 2010 at 06:13, Denise Kanyuh wrote:
> PostgreSQL version: 8.0.15
[ BTW the latest version of 8.0 is 8.0.25, also note 8.0 is getting
EOL'ed within the next month or so, see
http://www.postgresql.org/about/news.1214 ]
> When trying to test our product which incorporates postgress
On Thu, Jul 22, 2010 at 11:51, Denise Kanyuh wrote:
>
> Alex,
> Yes -- I am aware that we are on an old release --
>
> when you say - my hunch is
>
> they do not ship binaries for AIX (7.1).
>
>
> what binaries are you taking about --- we use the same installer
On Thu, Jul 22, 2010 at 11:21, Chris Browne wrote:
> 2. PostgreSQL Version 8.1 was the first version where AIX became
> sufficiently supported to allow it to be tested on a regular
> basis on the PostgreSQL Build Farm.
> http://pgbuildfarm.org/cgi-bin/show_status.pl
>
> There
On Fri, Jul 23, 2010 at 10:17, Milen wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5570
> Logged by: Milen
> Email address: m...@avangardsolutions.com
> PostgreSQL version: v9.0beta2
> Operating system: Linux
> Description: global hash %_SHARED
On Fri, Jul 16, 2010 at 18:04, Daniel Grace wrote:
> However, in some circumstances Postgres will fail
How exactly?
this is what I get:
=> SELECT STRING_AGG(DISTINCT t::text order by t::text) FROM foo;
string_agg
abc
(1 row)
=> SELECT STRING_AGG(DISTINCT t::text order by t::text
On Fri, Jul 23, 2010 at 12:19, Daniel Grace wrote:
> Please see BUG #5564 -- I accidentally submitted this one before I was
> finished typing the details.
Ahh, sorry for the noise. I was just trolling for bug reports that
had no replys yet :-)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@po
On Mon, Jul 26, 2010 at 03:58, mile wrote:
> To reproduce this use the following function:
>
> create or replace function perl_shared() returns void as $$
> use strict;
> elog(INFO, $_SHARED{'stuff'});
> $_SHARED{'stuff'} = '1';
> for my $k (keys %_SHARED)
> {
> elog(INFO, $k);
> }
> $$ languag
On Thu, Jul 29, 2010 at 20:01, yhou wrote:
> Operating system: windows 2000
> My program will use postgresal database, after start my program ,I find it
> hangs always, so I check the db log,and find these exception:
>
> 2010-07-27 14:08:22 EDT LOG: loaded library
> "$libdir/plugins/plugin_deb
On Sun, Aug 1, 2010 at 00:08, Karl Denninger wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5585
> Logged by: Karl Denninger
> Email address: k...@denninger.net
> PostgreSQL version: 8.4.4
> Operating system: FreeBSD 8.0
> Description: SSL probl
On Sun, Aug 1, 2010 at 14:02, Karl Denninger wrote:
> (Whether Postgress 9's internal replication will solve this for me when it
> is released is something I'm not sure about - I think the answer is "no",
> since if I'm reading the docs correctly Postgres 9 requires that both master
> and slave b
On Wed, Aug 4, 2010 at 10:42, Robert Haas wrote:
> On Wed, Aug 4, 2010 at 10:53 AM, Shine wrote:
>> We would like to know if there is a workaround built into postgres by
>> setting some kind of COMPATIBILITY variable (similar to SQL SERVER 2005 /
>> 2008)...
>
> Sorry, there is no such mode...
H
On Wed, Aug 4, 2010 at 11:04, Tom Lane wrote:
> If we were a bit earlier in the 9.0 cycle I would suggest that this
> confusion is a sufficient reason to drop the one-argument form of
> string_agg. It's too late now though.
FWIW I think we can still change it. Isn't this type of issue part
of
On Wed, Aug 4, 2010 at 13:11, Tom Lane wrote:
> Alex Hunsaker writes:
>> On Wed, Aug 4, 2010 at 11:04, Tom Lane wrote:
>>> If we were a bit earlier in the 9.0 cycle I would suggest that this
>>> confusion is a sufficient reason to drop the one-argument form of
>&g
On Wed, Aug 4, 2010 at 13:42, Tom Lane wrote:
> Robert Haas writes:
>> On Wed, Aug 4, 2010 at 3:25 PM, Alex Hunsaker wrote:
>>> I think forcing an initdb might be more trouble than this wart is worth.
>
>> +1. I would not make this change unless we have to force
On Wed, Aug 4, 2010 at 16:33, Thom Brown wrote:
> I was afraid that the function would be pulled completely, but from
> looking at the patch, you're only removing the function with a
> single-parameter signature, which is quite innocuous. So I'm "for"
> now.
Ahh, Now I see why you were worried
On Wed, Aug 4, 2010 at 17:07, Tom Lane wrote:
> Alex Hunsaker writes:
>> I dunno about anyone else but (a, ',' order by a) just looks weird.
>
> I suppose, but aren't you just focusing on the argument being constant?
Yes.
>> Or in other words, any tho
On Thu, Aug 5, 2010 at 00:13, Rene Novotny wrote:
>
> The following bug has been logged online:
> PostgreSQL version: 9.0 beta 4
> Operating system: Win 7 64 bit
> Description: cannot create language plperl;
> Details:
>
> ERROR: Could not load library
> c:/Program Files/PostgreSQL/9.0/li
On Thu, Aug 5, 2010 at 12:25, Tom Lane wrote:
> regression=# select string_agg(f1 order by f1, ',') from text_tbl;
> ERROR: function string_agg(text) does not exist
> LINE 1: select string_agg(f1 order by f1, ',') from text_tbl;
> ^
> HINT: No function matches the given name and ar
On Fri, Aug 6, 2010 at 02:12, Adam Radlowski
wrote:
> PostgreSQL version: 8.4.4
> Operating system: Gentoo 64 bit (PSQL 8.4.4), Fedora 12 32 bit (PSQL
> 8.4.1)
> select round(any_numeric_field*something,2) from any_table;
> I get information, that the function dos not exist.
Can we get the exa
On Mon, Aug 9, 2010 at 01:30, Rene Novotny wrote:
> Thank's a lot
>
> with Activestate 64 bit perl 5.10 it works.
>
> It would be very desirable for plperl supporter to to add some plperl release
> notes with Postgresql
> production release for users to know , with what PERL distribution it work
ns. bbox_dup is a geometry
column containing a polygon.
- alex
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
3576E5424016FBCBEEC9995EC0B6F3FDD478E5424088A2409FC8995EC0B6F3FDD478E5424088A2409FC8995EC09A42E73576E5424016FBCBEEC9995EC09A42E73576E54240'::geometry AS geom_intersect;
period_intersect | geom_intersect
--+
t | t
(1 row)
Another thing I stumble
Tom Lane wrote:
Alex Zepeda writes:
If I try to manually add the constraint on the table I get:
blockface=# alter table bus_positions add constraint "exclude_time_buffer" EXCLUDE USING gist
(vehicle WITH =, buffer_time WITH &&, bbox_dup WITH &&);
NOTICE: ALTER TABLE
Tom Lane wrote:
Alex Zepeda writes:
I'd be happy to provide someone with a copy of the dump...
but it's ~70MB bzip'd.
I'd be willing to take a look ... but if my WAG is right, the insertion
order would be critical information to reproduce the problem. Is it
possible to
hanks for doing all of that leg work. Whinging has commenced.
- alex
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Mon, Oct 4, 2010 at 11:59, V.J. wrote:
> * Starting PostgreSQL 8.4 database server
> * The PostgreSQL server failed to start. Please check
> the log output:
> 2010-10-04 19:58:40 CEST FATAL: konnte auf private Schl?sseldatei
>>>server.key<< nicht zugreifen: No such file o
On Wed, Oct 13, 2010 at 10:34, Robert Haas wrote:
> On Mon, Oct 11, 2010 at 4:24 PM, Igor wrote:
>> PostgreSQL version: 8.1
>> Operating system: CentOs 5
>> Description: not correct restrictions plperlu
>> Details:
>>
>> rights of functions on plperlu
>> lower than the user postgres
>>
On Thu, Oct 21, 2010 at 03:05, KOTAPATI.KRISHNAIAH
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5719
> Logged by: KOTAPATI.KRISHNAIAH
> Email address: kotapati.kris...@hotmail.com
> PostgreSQL version: PostgreSQL8.3.1
> Operating system: Microsoft Wi
On Thu, Oct 21, 2010 at 12:03, Alex Hunsaker wrote:
> Or if you just want the not null constraints:
> create table kittu1 (like kota1 including constraints);
Correction, the above should read: "Or, if you want check
constraints". Not null constraints are always copied, and inclu
On Thu, Jan 13, 2011 at 06:57, Julien Demoor wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5835
> Logged by: Julien Demoor
> Email address: jdem...@gmail.com
> PostgreSQL version: 9.0.2
> Operating system: Ubuntu Linux
> Description: PL/Python
The following bug has been logged online:
Bug reference: 5941
Logged by: GIMENEZ alex
Email address: parabuenara...@hotmail.com
PostgreSQL version: 8.4
Operating system: windows 7
Description:i don t understand
Details:
hello
i have a probleme to install poker
database_name -f master_ip -p 5432
From master server, I can connect from master to slave by the following
command.
psql database_name -f slave_ip -p 5432
I have no idea why I keep getting the message:\
could not connect to the primary server: FATAL:
no pg_hba.conf entry for replication conne
Fujii Masao wrote:
On Wed, Mar 23, 2011 at 9:07 PM, Alex Lai wrote:
I have no idea why I keep getting the message:\
could not connect to the primary server: FATAL: no pg_hba.conf entry for
replication connection from host "slave_server_ip", user
"my_super_user_name"
We are moving from PGAdmin III 1.10 on Windows XP Pro 32 bit to PG Admin
III on Windows 7 Enterprise 64-bit. PG Admin III installed without issue
and the computer is running all other database programs normally.
When we open up PG Admin III and click Server-Add, we are entering
exactly the same
On Tue, May 3, 2011 at 17:40, Greg Sabino Mullane wrote:
> This works in 9.0 but not in git/9.1 beta:
>
> CREATE FUNCTION wheredidmytdgo()
> RETURNS TRIGGER
> LANGUAGE plperlu
> AS
> $bc$
> use strict; use warnings;
> my $new = $_TD->{new};
> return;
> $bc$;
>
> The error is:
>
> ERROR:
On Wed, May 4, 2011 at 16:20, Alex Hunsaker wrote:
>
> This seems to be broken by
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commit;h=ef19dc6d39dd2490ff61489da55d95d6941140bf
> (Set up PLPerl trigger data using C code instead of Perl code.)
>
> Im not sure wha
On Thu, May 5, 2011 at 06:51, Alvaro Herrera wrote:
> Excerpts from Alex Hunsaker's message of mié may 04 23:53:34 -0300 2011:
>
>> After playing with it a bit more I see 2 clear options:
>> 1) make $_TD global like %_SHARED. This should not cause any problems
>> as w
...@gmail.com]
Sent: Monday, May 09, 2011 7:39 PM
To: Bryant, Alex
Cc: pgsql-bugs@postgresql.org; Lowe, Doug
Subject: Re: [BUGS] Upgrading from 1.10 to 1.12 - cannot set up server
On Fri, Apr 22, 2011 at 3:29 PM, Bryant, Alex wrote:
> We are moving from PGAdmin III 1.10 on Windows XP Pro 32 bit to
On Sun, May 15, 2011 at 14:02, Robert Haas wrote:
>> Fixed in the attached plus added regression tests for both issues (use
>> strict; && Global symbol "$_TD" requires explicit package name, test
>> recursive trigger calls). Although Ill admit, given the point we are
>> in the release I could see
On Mon, May 23, 2011 at 14:59, Greg Sabino Mullane wrote:
> I've not been able to duplicate this in a standalone script yet,
> but in the guts of Bucardo is a trigger function called validate_goat()
> that is giving this error on 9.1 HEAD, but not on previous versions:
>
> "Failed to add table "pu
On Mon, May 23, 2011 at 20:08, Greg Sabino Mullane wrote:
> On Mon, May 23, 2011 at 05:04:40PM -0600, Alex Hunsaker wrote:
> ...
>> Greg, can you confirm the attached fixes it for you?
>
> Yes, seems to have done the job, thank you.
Thanks for testing!
[ Does a little dance to
On Mon, May 30, 2011 at 11:02, Alvaro Herrera
wrote:
> Excerpts from Alvaro Herrera's message of sáb may 28 01:06:42 -0400 2011:
>> Excerpts from Alex Hunsaker's message of vie may 27 12:14:25 -0400 2011:
>> > On Mon, May 23, 2011 at 20:08, Greg Sabino Mullane
>&
The following bug has been logged online:
Bug reference: 6138
Logged by: Alex Dragojlovic
Email address: aleksandar.dragojlo...@gmail.com
PostgreSQL version: 8.4
Operating system: OSX Lion
Description:Install failed
Details:
I cannot install PostgreSql on my laptop
On Tue, Aug 2, 2011 at 00:25, Hitoshi Harada wrote:
> db1=# select * from test_xy order by x LIMIT 9223372036854775807 OFFSET 6;
[ ...]
> db1=# select * from test_xy order by x LIMIT pow(2, 63);
> ERROR: bigint out of range
> ERROR: bigint out of range
>
> Maybe a parser converts literal unexp
The following bug has been logged online:
Bug reference: 6166
Logged by: Alex Soto
Email address: aps...@gmail.com
PostgreSQL version: 9.0.4
Operating system: Linux (CentOS release 5.0 (Final))
Description:configure from source fails with 'This platform is not
t
On Sun, Sep 4, 2011 at 13:48, init-po fails for plperl due to invalid
xsubpp path wrote:
>
> Description: init-po fails for plperl due to invalid xsubpp path
> (contains ExtUtils)
> Details:
>
> When I try to prepare a fresh .pot file for plpgsql, it fails like this
>
> $ ./configure --ena
On Sun, Sep 4, 2011 at 16:57, Tomas Vondra wrote:
> On 5 Září 2011, 0:27, Alex Hunsaker wrote:
>> On Sun, Sep 4, 2011 at 13:48, init-po fails for plperl due to invalid
>> xsubpp path wrote:
> So yes, it's almost the same as your results.
>
>
> Aha
On Wed, Sep 14, 2011 at 03:15, pasman wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6204
> Logged by: pasman
> Email address: pasma...@gmail.com
> PostgreSQL version: 9.1.0
> Operating system: WinXP sp3
> Description: Using plperl functions gen
On Fri, Oct 14, 2011 at 21:43, Rachael wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6256
> Logged by: Rachael
> Email address: rulonr...@gmail.com
> PostgreSQL version: 9.11
> Operating system: Arch Linux
> Description: loading small file eat
On Sat, Oct 15, 2011 at 13:40, Rachael Nelson wrote:
> When I run this it does the same:
>
> psql test dev < postgres.sql
>
> the db is named test, connecting with the dev user.
I assume you meant to hit reply all :-)
If you can provide a self contained test case ideally in the form of
an .sql f
On Sat, Oct 15, 2011 at 14:16, Rachael Nelson wrote:
> Attached is a tiny bit of top output (top.txt), the file being imported
> (postgres.sql.gz - about 32MB), and the perl module script that generates
Thanks. So the problem here seems to be postgres does not handle a
multi-hundred megabyte sing
On Fri, Oct 28, 2011 at 16:42, Mischa POSLAWSKY wrote:
> Composite types are converted to and from Perl hashes since commit
> REL9_1_ALPHA4~146 (Convert Postgres arrays to Perl arrays on PL/perl input
> arguments; 2011-02-17), but are not stringified as claimed by the commit
> message and release
On Fri, Nov 18, 2011 at 14:31, Tigran Mkrtchyan
wrote:
>
> On Fri, Nov 18, 2011 at 9:52 PM, Tomas Vondra wrote:
> > Anyway this definitely is not a bug,
>
> Still not convinced.
You are unlikely to convince anyone here otherwise... Its works that
way by design.
> [...] I don't think you will
On Sun, Dec 18, 2011 at 01:25, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6344
> Logged by: Kirill
> Email address: k_deni...@inbox.ru
> PostgreSQL version: 9.1.2
> Operating system: Linux Debian
> Description:
>
> plperl function:
> open(FI
rchiveset on filemeta_archiveset a (cost=0.00..5.21 rows=1
width=4) (actual time=0.011..0.011 rows=0 loops=108)
Index Cond: ((a.fileid = b.fileid)
AND (a.archiveset = 61000))
-> Index Scan using pk_filemeta_l3 on filemeta_l3 b
(cost=0.00..3.37
Andrew Schetinin wrote:
Hi Alex,
Thank you. I played with subqueries, but in this case I did not see a
good enough improvement.
In my specific case, what I've seen from the query execution plans, is
that without LIMIT the query uses Hash Joins, but once I add LIMIT, it
starts using N
On Sat, Mar 3, 2012 at 12:19, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6511
> Logged by: Mark Murawski
> Email address: ma...@kobaz.net
> PostgreSQL version: 9.1.3
> Operating system: Linux - Debian Squeeze postgres 9.1 from backports
> De
On Thu, Mar 15, 2012 at 16:13, Bruce Momjian wrote:
> On Tue, Mar 06, 2012 at 09:08:25PM -0700, Alex Hunsaker wrote:
>> [ Calling a plperl trigger function from a plperl function ]
>>
>> Yeah, there were some optimization done for 9.1 to try and make calls
>> a bit fa
On Mon, Mar 19, 2012 at 14:40, Alvaro Herrera
wrote:
>
> Excerpts from Alex Hunsaker's message of mié mar 07 01:08:25 -0300 2012:
>> The attached fixes it for me, It would be great if you could confirm that.
>
> Thanks -- applied to 9.1 and master.
Thanks!
--
Sent via
quiet large, usually
several megabytes.
Alex
On 4/2/2012 11:49 PM, Heikki Linnakangas wrote:
On 03.04.2012 02:23, amatzin...@experts-exchange.com wrote:
On a hot standby database, while the primary is being updated,
Postgres will
randomly kill a process which is performing a "Select 1"
Dropping the BEGIN has cleared up the issue. Thank you.
On 4/3/2012 9:50 AM, John R Pierce wrote:
On 04/03/12 9:40 AM, Tom Lane wrote:
Alex Matzinger writes:
> The connection that is executing the SELECT 1 are generally open
for 1-5
> hours before they are killed. The sp
On Sat, Apr 28, 2012 at 17:20, Ryan Kelly wrote:
> I don't think any language supports the empty key edge case in this way.
> The only language I know of that will let you get away with it is Perl,
> and in that case you get undef, not the empty string, and it's a warning
> if you have warnings o
On Wed, May 16, 2012 at 10:47 AM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6645
> Logged by: Evna Carroll
> Email address: m...@evancarroll.com
> PostgreSQL version: 9.1.2
> Operating system: Linux
> Description:
>
> This is a cross post f
On Wed, May 16, 2012 at 11:53 AM, Tom Lane wrote:
> Alex Hunsaker writes:
>> That being said it seems we failed to take any magic (aka string
>> overloads) that a blessed reference might have. Ill see about
>> submitting a patch for 9.3 (9.2 just entered beta). Anyone have
The following bug has been logged on the website:
Bug reference: 7781
Logged by: Alexander Shniperson
Email address: alex.shniper...@gmail.com
PostgreSQL version: 9.1.7
Operating system: osx lion 10.7.5
Description:
Hi.
Just installed last PostgreSQL 9.1.7 and instal
The following bug has been logged on the website:
Bug reference: 7783
Logged by: Alexander Shniperson
Email address: alex.shniper...@gmail.com
PostgreSQL version: 9.1.7
Operating system: osx lion 10.7.5
Description:
Hi.
I have problem at my project, try to do simple
URNS text as $$
my $sql = "";
my $status = "";
my $r = "";
$sql = 'SELECT exist_column from a_table limit 1';
eval { spi_exec_query($sql);};
if ($@) {
$status = 'invalid: '.$@;
elog(ERROR, $status);
return '123'
On Wed, Jul 10, 2013 at 2:36 PM, Alex Lai wrote:
> Dear all,
>
> I have a situation. I am unable to pass control back to the function once
> it hit the "undefined_column" error code.
> I am not sure there's a way to return '123' instead exit from the fun
On Mon, Jul 15, 2013 at 5:56 AM, Ming Lai wrote:
> I know how elog works. elog only show the status, but it does not allow me
> to execute another query when the current query fails because one of the
> invalid column was specified.
Hrm? Im not sure what you mean. If you elog(ERROR) outside of
The following bug has been logged online:
Bug reference: 5422
Logged by: Alex Soto Paez
Email address: alejandro.soto...@gmail.com
PostgreSQL version: 8.4
Operating system: linux
Description:problems installing postgresql-8.4 deleted folder /
.s.PGSQL.lock not
The following bug has been logged online:
Bug reference: 5423
Logged by: Alex Soto Paez
Email address: alejandro.soto...@gmail.com
PostgreSQL version: 8.4
Operating system: linux 9.10
Description:problems installing postgresql-8.4 deleted folder /
.s.PGSQL.lock not
Hi,
I´m trying to install pgcluster 1.7 on Aix 5.3 and I´m having problems, when I
run "./configure --enable-thread-safety" I receive the msg bellow and when a
try to do make make install I got a error about libpg
Could someone help me please ?
Thanks in advance
checking for sys/s
On Tue, Mar 09, 2004 at 07:33:31PM -0500, Alex J. Avriette wrote:
> the postgres distribution. Additionally, this really isn't a question
> for [EMAIL PROTECTED]
Meep, my apologies, this wasn't sent to [EMAIL PROTECTED]
--
[EMAIL PROTECTED]
Alex J. Avriette, Solaris Sy
lly, this really isn't a question
for [EMAIL PROTECTED]
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
The Emperor Wears No Clothes.
http://www.drugsense.org/wodclock.htm
---(end of broadcast)---
TIP 5: Have yo
And if you are concerned about the query's cost vs its actual output
(you weren't clear in your original message), there is the 'iscachable'
pragma for functions.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
Liberty in your lifetime: http://www.freestateproj
eful. This allows indices to be built upon the results of functions. In
one case this proved to be tremendously fast compared to using lower(foo)
dynamically. lower(foo) will always return the same value, as would the
original poster's.
But I digress.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriett
I'm seeing this problem too, so I might be able to shed some light on it.
Here's exactly what I did:
> cd /usr/src/postgresql-9.0.2
> tar -xjvf postgresql-9.0.2.tar.bz2
> mv postgresql-9.0.2 src
> mkdir obj-x86_64
> cd obj-x86_64
> /usr/src/postgresql-9.0.2/src/configure
> '--prefix=/usr/local/p
101 - 193 of 193 matches
Mail list logo
