On Thu, Feb 10, 2011 at 12:03:49AM -0500, Tom Lane wrote:
> strk writes:
> > I've finally completed the debugging phase and have
> > a minimal self-contained testcase showing the problem.
> > It has to do with INITIALLY DEFERRED constraints.
>
> I looked into
On Mon, Feb 07, 2011 at 02:31:49PM +0100, Dimitri Fontaine wrote:
> strk writes:
> > Do you have an idea on how to further debug this ?
>
> That usually goes with providing a self-contained test case⦠that is a
> minimum script that creates the function(s) and calls t
edge)
REFERENCES edge_data(edge_id)
DEFERRABLE
INITIALLY DEFERRED
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscripti
I've handled to produce a small testcase:
http://strk.keybit.net/tmp/could_not_open_relation.sql
It still requires postgis (svn), but if anyone has that it might help.
Will try to go on with the reduction.
--strk;
On Mon, Feb 07, 2011 at 12:38:08PM +0100, strk wrote:
> Hi all,
>
ATILE.
Also, I can see traces of the DROP SCHEMA CASCADE being executed, till
the ERROR comes out (lots of traces for cascading objects).
This is :
PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu
4.4.3-4ubuntu5) 4.4.3, 64-bit
Do you have an idea on how to fur
using hstore for a table value too for
a form of "historic table". Just to say I'd also be happy with
it being core in pgsql :)
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Wed, Mar 10, 2010 at 07:50:16AM -0500, Andrew Dunstan wrote:
> Using an hstore in 9.0 it's not too bad,
Does it still have a limit of 65535 bytes per field ?
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
--
Sent via pgsql-hac
On Tue, Mar 09, 2010 at 06:59:31PM +0100, Pavel Stehule wrote:
> 2010/3/9 strk :
> > How can a pl/pgsql trigger change the
> > values of dynamic fields in NEW record ?
> >
> > By "dynamic" I mean that the field name
> > is a variable in the trigger cont
ncies.
Thanks in advance.
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ECT pg_advisory_lock(q.id) FROM
(
SELECT id FROM foo WHERE id > 12345 LIMIT 100;
) q; -- ok
Last statement seems bogus to me ...
--strk;
() Free GIS & Flash consultant/developer
/\ http://foo.keybit.net/~strk/services.html
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgres
ure newer versions of FreeBSD use ELF, and the link switches
> are different then.
Thank you, it's ELF_SYSTEM undefined.
We just copied Makefile.shlib, not Makefile.global.
We'll have to add a check for ELF_SYSTEM in our own configure script.
Wouldn't this be a prob
reSQL build works fine
(no -Bforcearchive flag used)
If I remove the -Bforcearchive flag from Makefile.shlib
everything seems to work fine.
I suppose (but didn't test) that this would also fail with
pgxs. Are there freebsd users around to test this ?
--strk;
---(end of
RAISE NOTICE ''called'';
return ''ret''::text;
END ' LANGUAGE 'plpgsql' IMMUTABLE STRICT;
PostgreSQL version 8.0.0
--strk;
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Missing info for the report:
win32
postgresql 8.0.3
maintenance_work_mem 512
btree index on oid works fine
--strk;
On Sat, Aug 13, 2005 at 01:12:30PM +0200, [EMAIL PROTECTED] wrote:
> Hi all.
> I've been reported memory limit hits
> during a
where is memory hold ?
Is there an index-specific memory context for use
to early release memory blocks allocated during
operations (didn't see any use of memory contexts
in the contrib/rtree_gist) ?
TIA
--strk;
---(end of broadcast)---
On Tue, Jun 28, 2005 at 08:12:16PM -0400, Bruce Momjian wrote:
> strk wrote:
> > The valure returned from pg_config --includedir-server
> > is broken as of CVS.
> >
> > It points to unexistent directory:
> > /home/extra/pgroot-cvs/include/server
> >
>
The valure returned from pg_config --includedir-server
is broken as of CVS.
It points to unexistent directory:
/home/extra/pgroot-cvs/include/server
Correct value would be:
/home/extra/pgroot-cvs/include/postgresql/server
--strk;
---(end of broadcast
On Mon, Jun 27, 2005 at 08:55:50AM -0400, Dave Cramer wrote:
> you can use show xxx to show configuration values
>
> http://www.postgresql.org/docs/7.4/interactive/sql-show.html
No direct interface for shared libs ?
--strk;
---(end of
Is it possible to access postgres configuration from
a C stored procedure ?
I need to leverage memory usage and I'd use postgres configuration
rather then a compile-time define.
Is there such a configuration, if access is possible ?
--strk;
---(end of broa
On Wed, Mar 23, 2005 at 02:49:53PM +, Richard Huxton wrote:
> strk wrote:
> >On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
> >
> >>strk wrote:
> >>
> >>>Hello.
> >>>A memory fault in a trigger left my database
>
On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
> strk wrote:
> >Hello.
> >A memory fault in a trigger left my database
> >in a corrupted state:
> >
>
> > - I can't create temporary tables anymore
> > (restart/vacuum full do
ymore
(restart/vacuum full don't help)
ERROR: cache lookup failed for relation 1250714
Any hint?
--strk;
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
It is embarassing for me, but I could not reproduce the bug. :(
Maybe I just ended up with a corrupted database (or I was just too tired).
Behaviour seems to be the same for both SQL and pl/pgsql functions on
a new database (and I got rid of the old one).
Sorry.
--strk;
On Thu, Mar 17, 2005 at
RETURN proj4text::text FROM spatial_ref_sys WHERE srid= $1;
END
' LANGUAGE 'plpgsql' IMMUTABLE STRICT;
Is this expected ?
--strk;
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I've tried with 7.4.3 - *good* results with both SQL and PL/PGSQL
(actually even less that best 8.0.1: 12Mb)
I think this makes it a bug...
--strk;
On Wed, Mar 16, 2005 at 01:58:44PM +0100, [EMAIL PROTECTED] wrote:
> I've tested with 8.0.1 and get same results.
>
> --strk;
I've tested with 8.0.1 and get same results.
--strk;
On Wed, Mar 16, 2005 at 01:04:03PM +0100, [EMAIL PROTECTED] wrote:
> On postgresql-8.0.0 I've faced a *really* weird behavior.
>
> A simple query (single table - simple function call - no index),
> makes postgres process
ch don't change output within a single query, isn't the shown one
a "single" query ?
Thanks in advance
--strk;
-- VOLATILE
update pg_proc set provolatile = 'v' where proname = 'find_srid';
UPDATE 1
explain analyze select * from input.geobit_5 where the_
; way to either:
- obtain OID of a given argument
- obtain OID of a given type by its name
By "easy" I mean not involving a query to the backend.
--strk;
For standing up against patentability of software,
Thank You, Poland!
Read the intervention:http://kwiki.ffii.org/ConsPolon
Sorry, my fault, just mistyped the function name
in PG_FUNCTION_INFO_V1() macro.
--strk;
On Wed, Dec 29, 2004 at 11:08:28AM +0100, strk wrote:
> I'm trying to implement a trigger within 8.0.0RC2.
> I get a segfault when the trigger is fired, valgrind
> reports an illegal read
gers be defined as Version 1 ?
TIA
--strk;
For standing up against patentability of software,
Thank You, Poland!
Read the intervention:http://kwiki.ffii.org/ConsPolon041221En
Send your thanks: thankyoupoland.info
Read/do more: http://www.noepatents.org/
-
tter.
>
> regards, tom lane
Doesn't JOINSEL have access to RESTRICTSEL output for REL1 and REL2 ?
--strk;
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
do with it? AFAICS you *should not* make
> the join selectivity depend on that.
So it should NOT depend on full number of rows either, is this right ?
--strk;
>
> regards, tom lane
>
> ---(end of broadcast)---
ndition filtering one of the tables.
Example:
test1 has 34 rows
test2 has 32 rows
a full join makes the estimate=1088 rows ( 34*32 )
a join with a filter on test2 makes estimate=34 ( 34*1 ? )
strk=# explain analyze select * from te
;s great
> news to hear there's actually work in this area.
Statistics in postgis have been available for a long time:
2002-10-12 00:52 dblasby
* postgis_estimate.c: New file with original estimation methods.
--strk;
>
> --
> greg
>
>
> ---
On Mon, Dec 13, 2004 at 03:04:01PM -, Mark Cave-Ayland wrote:
> Hi strk,
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: 13 December 2004 14:05
> > To: Mark Cave-Ayland
> > Cc: [EMAIL PROTECTED]
>
On Mon, Dec 13, 2004 at 10:16:09AM -, Mark Cave-Ayland wrote:
>
> > -Original Message-
> > From: strk [mailto:[EMAIL PROTECTED]
> > Sent: 10 December 2004 15:35
> > To: Mark Cave-Ayland
> > Cc: [EMAIL PROTECTED]
> > Subject: join selectiv
malloc'd or (recently) free'd
TIA
--strk;
---(end of broadcast)---
TIP 8: explain analyze is your friend
electivity is invoked twice and
> > JOIN selectivity is invoked once.
>
> Hm, are you testing in a context where both tables have indexes that are
> relevant to the && operator?
Single index relevant to the && operator makes 2 calls to RESTRICT.
Double index (one
On Tue, Sep 14, 2004 at 10:55:46AM -0400, Tom Lane wrote:
> strk <[EMAIL PROTECTED]> writes:
> > Trying to make minimal example I found out it's pg_dump too.
> > Example:
> > $ pg_dump template1
> > ...
> > Segmentation Fault
>
> You&
On Tue, Sep 14, 2004 at 10:45:16PM +1000, Philip Warner wrote:
> At 06:55 PM 14/09/2004, strk wrote:
> >Current pg_restore segfaults.
>
> You might need to give a little more information; does it only segfault for
> a specific DB? Does it segfault for a trivial empty DB? C
ws=26 width=81)
(actual time=0.39..19.22 rows=75 loop=1)
Total runtime: 19.37 msecs
--strk;
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTE
Current pg_restore segfaults.
Manually fault seems to happen at (*AH->ClosePtr) (AH)
in pg_backup_archiver.c/CloseArchive(Archive *)
--strk;
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
h
On Mon, Aug 23, 2004 at 03:20:09PM -0400, Tom Lane wrote:
> strk <[EMAIL PROTECTED]> writes:
> > Is returning a pointer to the input safe in every case ?
>
> You mean for returning *unmodified* input, don't you?
>
> Yes, that's safe. Scribbling on
Is returning a pointer to the input safe in every case ?
--strk;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, Aug 13, 2004 at 11:12:50PM +1000, Philip Warner wrote:
> At 10:30 PM 13/08/2004, strk wrote:
> >>From PG73:
> >552; 2663984 CAST bytea (public.wkb)
> >>From PG74:
> >547; 1915318 CAST CAST (public.wkb AS bytea)
> >
> >Since th
t
lines in the form:
>From PG73:
552; 2663984 CAST bytea (public.wkb)
>From PG74:
547; 1915318 CAST CAST (public.wkb AS bytea)
Since these two dumps have same file format version I asked..
--strk;
On Fri, Aug 13, 2004 at 10:05:09PM +1000, Philip Warner wrote:
> At 08:53 P
On Fri, Aug 13, 2004 at 08:42:44PM +1000, Philip Warner wrote:
> At 08:09 PM 13/08/2004, strk wrote:
> >What does 'Dump Version' refer to then ? Are these ToC output
> >changes encoded somehow ?
>
> The file format version of pg_dump; the actual contents depend
? Are these ToC output
changes encoded somehow ?
TIA
--strk;
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
time,
nor it is at vacuum time.
A currupted catalog set is probably be the reason.
Shouldn't pg_dump warn about that ?
Is there a catalog corruption detection app ?
TIA
--strk;
On Sun, Aug 08, 2004 at 01:40:40PM +0200, strk wrote:
> On Sun, Aug 08, 2004 at 12:50:43PM +0800, Christophe
rews are possible.
That someone is probably me, but I don't remember pg_dump
giving me any warning about this. Also I think I've run vacuum
on the db before dumping.
As before I'm not on the source computer so I can't send the
pg_dump -s, but if you want, I can send you the pg_rest
n pg_dump.
The only reason I can imagine for this is pg_dump taking
any sequence whose name ends in _seq as being associated
to a table, no matter if that table exists and has a 'serial'
field. Is this possible ? Shouldn't this kind of dependency
be coded somehow ?
TIA
--strk;
On Tue, Aug 03, 2004 at 05:17:27PM +0800, Christopher Kings-Lynne wrote:
> >--
> >-- TOC entry 537 (OID 2663955)
> >-- Name: ~=; Type: OPERATOR; Schema: public; Owner: strk
> >-- Data Pos: 0
> >--
> >
> >CREATE OPERATOR ~= (
> >PROC
aste that ascii from the dump?
--
-- TOC entry 537 (OID 2663955)
-- Name: ~=; Type: OPERATOR; Schema: public; Owner: strk
-- Data Pos: 0
--
CREATE OPERATOR ~= (
PROCEDURE = geometry_same,
LEFTARG = geometry,
RIGHTARG = geometry,
COMMUTATOR = 2663954,
RESTRICT = eqsel,
JOIN =
with what was probably it's oid instead.
Is this a bug in pg_dump ?
How do I tell which pg_dump version produced the dump ?
Is self commutation valid ?
TIA
--strk;
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
on test (a); drop index test_idx;
create index test_idx on test (a); drop index test_idx;
...
The size growth is reported by 'top' in the fields
SIZE, RSS and SHARE.
The database is a newly created one after first initdb
as of CVS 20040311.
Can it be a memory leak in postgres
Working with current CVS:
$ createlang plpgsql
createlang: language installation failed:
ERROR: could not load library "/pgroot-cvs/lib/postgresql/plpgsql.so":
/pgroot-cvs/lib/postgresql/plpgsql.so:
undefined symbol: downcase_truncate_identifier
--strk;
-
Is there a quick way to use the BYTE_ORDER define
as set by pgsql ? I can't find an "entry point"
include for it.
It's needed for postgis (problems with Solaris BYTE_ORDER).
--strk;
---(end of broadcast)---
TIP 1: subsc
7;t think we really need to generalize that.
As far as there are other means to gain the same result...
'string'::type(parameter) can be the "general" postgres version.
while varchar(2) 'string' can be the standard SQL version (not general).
--strk;
>
> > Wi
te on pg_class.
Where is this sequence-to-relation association stored so that
i can clean it up ?
NOTE: vacuum full does not solve this.
TIA
-strk;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
in
text->internal conversion and is showing heap corruption problems.
The question now is: what does that message mean ? Did a routine
try to create an index and left its work before finishing it ?
--strk;
JanWieck wrote:
> Christopher Kings-Lynne wrote:
>
> >> I couldn
tgl wrote:
> strk <[EMAIL PROTECTED]> writes:
> > gis=# reindex table pg_toast_8443892; -- this was an assuption I made
> > ERROR: Relation "pg_toast_8443892" does not exist
>
> If it's 7.3 or later you need to say
>
> reindex table pg_toast.pg_t
JanWieck wrote:
> strk wrote:
>
> > I get the following error when vacuuming a db or inserting
> > a big value in a column of a toastable datatype (GEOMETRY).
> >
> > ERROR: Index pg_toast_8443892_index is not a btree
> >
> > My last action has be
)
Do you have any hint about how to fix this ?
TIA
--strk;
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
tgl wrote:
> strk <[EMAIL PROTECTED]> writes:
> > Testing postgis support in PG7.4 (2003-11-11)
> > I've encountered to this problem:
> > ERROR: could not identify an ordering operator for type geometry
> > Previous PG versions does not show this
Does with(isStrict) still work ?
If not when did postgres drop its support ?
TIA
--strk;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
t seems that the build system is missing something
(make distclean made it work)
Thanks for you support
--strk;
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Running initdb:
creating template1 database in /pgroot-cvs/data/base/1 ... child process was
terminated by signal 11
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatype
~= | geometry| geometry
@ | geometry| geometry
~ | geometry| geometry
= | geometry| geometry
< | geometry| geometry
> | geometry| geometry
(11 rows)
Previous PG versions does not show this probl
I can't build postgresql from CVS. Any help ?
This is the message I get:
bison -y -d preproc.y
preproc.y:6275: fatal error: maximum table size (32767) exceeded
Bison version:
bison (GNU Bison) 1.35
TIA
.strk;
--
pallamondo.net <-- tak
tgl wrote:
> strk <[EMAIL PROTECTED]> writes:
> >> From whitin an aggregate sfunc I did:
> > oldcontext = MemoryContextSwitchTo(fcinfo->flinfo->fn_mcxt);
> > geom = (GEOMETRY *)PG_DETOAST_DATUM(datum);
> > MemoryContextSwitchTo(ol
fault!
What's wrong with it ?
NOTE that if I MemoryContextAllocate in fcinfo->flinfo->fn_mcxt and
memcopy DETOASTED geom, everything works (ar at least it seems to)
--strk;
strk wrote:
> Tom, thanks again for the quick answer and
> sorry for the lame question about memor
g the DETOASTed datum, I'd like to avoid one
copy.
TIA.
--strk;
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
on is: if I write in the "state" array
pointers to DETOASTED input args,
will I find them intact at finalfunc time ?
TIA
--strk;
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
r use ? To note also that the same identical calls keeps
making SIZE grow ...
PS: I'm working with postgres-7.3.2
TIA
--strk;
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Do I save memory using a cursor from a SPI-connected procedure ?
I'm working on a table containing geometric objects and I'd like
to keep a geometry in memory just for the time it is needed, and
one at time, otherwise my machine is in permanent swapping.
--strk;
-
75 matches
Mail list logo
