Re: [HACKERS] ANALYZE sampling is too good

istribution dependend and statistic dependent. Cheers, Sergey PS I'm not a statistician, but I use statistics a lot *********** Sergey E. Koposov, PhD, Research Associate Institute of Astronomy, University of Cambridge Madingle

Re: [HACKERS] strange row number estimates in pg9.1rc1

ters with large tables... S ******* Sergey E. Koposov, PhD Institute for Astronomy, Cambridge/Sternberg Astronomical Institute Web: http://lnfm1.sai.msu.ru/~math E-mail: m...@sai.msu.ru -- Sent via pgsql-hackers mailing list

[HACKERS] strange row number estimates in pg9.1rc1

when I was using PG 8.4 for the same data, I was used to do explain select * to get the number of rows in the tables, instead of count(*) (my tables are very large), now it seems that there is a huge discrepancy between the numbers. Thanks, Sergey *

Re: [HACKERS] two index bitmap scan of a big table & hash_seq_search

ks all right. Do you think that this should be fixed ? Sergey *********** Sergey E. Koposov, PhD Institute for Astronomy, Cambridge/Sternberg Astronomical Institute Web: http://lnfm1.sai.msu.ru/~math E-mail: m...@sai.msu.ru -- Sent via pgsql-hack

[HACKERS] two index bitmap scan of a big table & hash_seq_search

work_mem| 1GB effective_io_concurrency | 0 shared_buffers | 4GB Any ideas what can be wrong? Any info I can provide ? Thanks in advance, Sergey *** Sergey E. Koposov, PhD Institute for Astronomy, Cambridge UK /Sternberg Astronomical

[HACKERS] WARNING: pgstat wait timeout

I did a manual vacuum of one of the tables in which the data is inserted. But I have no idea whether that's really a cause or just a coincidence. Regards, S. *** Sergey E. Koposov, PhD Institute for Astronomy, Cambridg

Re: [HACKERS] [COMMITTERS] pgsql: SQL/MED catalog manipulation facilities This doesn't do any

x600e3410 pid = 0 __func__ = "BackendStartup" #12 0x406d1700 in ServerLoop () at postmaster.c:1283 port = (Port *) 0x6000000e3d40 i = 0 rmask = {fds_bits = {16, 0 }} selres = 1 readmask = {fds_bits = {16, 0

Re: [HACKERS] failed assertion in toasting code

ergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(e

Re: [HACKERS] failed assertion in toasting code

| 0 (1 row) Regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.s

Re: [HACKERS] failed assertion in toasting code

/* fill the im->data ... */ PG_RETURN_POINTER(im); Regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute

[HACKERS] failed assertion in toasting code

nyone have ideas what could be the reason for the bug ? Thanks in advance. Regards, Sergey *************** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6

Re: [HACKERS] What is happening on buildfarm member dugong

rgey PS I'm sorry for the wrong information about anti-aliasing flags for ICC. I was obviously confused by the ICC docs. *********** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg

Re: [HACKERS] What is happening on buildfarm member dugong

n the very separate from the buildfarm place. That logs were mixed there. regards, Sergey ******* Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-5

Re: [HACKERS] What is happening on buildfarm member dugong

On Tue, 11 Sep 2007, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: On Tue, 11 Sep 2007, Tom Lane wrote: NOTICE: database "contrib_regression" does not exist, skipping ERROR: too many active hash_seq_search scans ERROR: too many active hash_seq_sea

Re: [HACKERS] What is happening on buildfarm member dugong

ests. regards, Sergey ******* Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [

Re: [HACKERS] What is happening on buildfarm member dugong

n't help... regards, Sergey *************** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math

Re: [HACKERS] What is happening on buildfarm member dugong

configure flags: ./configure --enable-cassert --enable-depend --enable-debug --enable-nls --enable-integer-datetimes --with-libxml LDFLAGS='-lirc -limf' --enable-depend --prefix=/home/math/cvs/install/ CC=ic Regards, Sergey ************

Re: [HACKERS] What is happening on buildfarm member dugong

and produce the same code as with '-fno-alias' flag (described in ICC manuals). regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical I

Re: [HACKERS] What is happening on buildfarm member dugong

e this bug(if it is ICC fault). But to do that, I need some advices/help, how to do it better... regards, Sergey ******* Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical

Re: [HACKERS] SOC & user quotas

On Thu, 1 Mar 2007, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: I still don't understand how FS quotas can help with DB quotas. .. All the FS quotas are setup for limiting the space for specific user and specific mount point. AFAIK They do not allow

Re: [HACKERS] SOC & user quotas

n one directory. And since all the PG tablespaces will be owned by postgres user, I dont think the FS quotas can do the job. regards, Sergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astr

Re: [HACKERS] SOC & user quotas

, Sergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED

Re: [HACKERS] SOC & user quotas

ql.org/pgsql-hackers/2004-07/msg00392.php I remember that thread, but I think there was no patch at all, at least I didn't see it. Sergey *************** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronom

Re: [HACKERS] SOC & user quotas

y little memory and/or shared memory. You can work, but you can easily hit these limits, and than something will not work... regards, Sergey ******* Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astr

Re: [HACKERS] SOC & user quotas

edit files, copy them etc... And that solution should be definitely better than the filesystem quota for the PostgreSQL user for example. regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Insti

Re: [HACKERS] SOC & user quotas

ergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end of broa

Re: [HACKERS] SOC & user quotas

On Wed, 28 Feb 2007, Joshua D. Drake wrote: Sergey E. Koposov wrote: On Wed, 28 Feb 2007, Joshua D. Drake wrote: Per user AND per database (as Tom noted). But I dont see what's odd in it... It exists in Oracle, and I need quotas in the project on which I'm working. And I rem

Re: [HACKERS] SOC & user quotas

rking. And I remember user requests for quotas in the mailing lists ... regards, Sergey ******* Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-62

Re: [HACKERS] SOC & user quotas

On Wed, 28 Feb 2007, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: 1) The main idea is to implement the per-user quota (not per tablespace for example). So, during the creation of the new user some quota can be specified, and after that the size of all the

[HACKERS] SOC & user quotas

, I'm not completely sure that refusing the call of the mdextend function in the case of quota excess won't lead to any corruption ? (in the case of Btree splits for example ). Any comments ? Thank you. Regards, Sergey *************

Re: [HACKERS] Column storage positions

ergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Cambridge Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end of broa

Re: [HACKERS] FailedAssertion() in 8.2beta1

On Sat, 7 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: And the java program crashing the backend is attached. (it is generally one prepared statement , which i didn't succeded to crash from psql) Right, because the bug was in exec_bind_mes

Re: [HACKERS] FailedAssertion() in 8.2beta1

On Sat, 7 Oct 2006, Sergey E. Koposov wrote: And the java program crashing the backend is attached. (it is generally one prepared statement , which i didn't succeded to crash from psql) (it's possible to rewrite it in C with libpq, but I cannot do that very easily). As I did befo

Re: [HACKERS] FailedAssertion() in 8.2beta1

On Sat, 7 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Will it be enough to provide the testcase for just that 'expain UPDATE' ? Whatever makes it crash ;-) So, the database schema with little data and a few functions is here htt

Re: [HACKERS] FailedAssertion() in 8.2beta1

On Sat, 7 Oct 2006, Sergey E. Koposov wrote: cas=# explain UPDATE table_list SET description = 'tag{image SRC="/vizier/new2.gif"}3rd release of DENIS (2005Sep)' WHERE id = cas_get_table_id ('cas_data_sega','b_denis_denis5' );

Re: [HACKERS] FailedAssertion() in 8.2beta1

On Sat, 7 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: I've found a bug with 8.2beta1: Can you put together a self-contained test case for this? The planner I'll try, but it will be quite hard. is evidently generating an incorrect

[HACKERS] FailedAssertion() in 8.2beta1

ng, table_name character varying | cas_admin | sql | SELECT id FROM table_list WHERE name = $2 AND catalog_id = cas_get_catalog_id($1) | (1 row) - 7) The query was executed from JDBC in large transaction 8) PG have been compiled with following flags: CONFIGURE = '--enable-cassert' '--with-perl' '--with-python' '--prefix=/opt/pgsql8.2' 'CFLAGS=-g' 9) the only change in the posgresql.conf was log_min_duration_statement -1 --> 0 Regards, Sergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] [PATCHES] 7.4, 8.0 branches @ itanium2 & icc

On Tue, 3 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Having recently tried to build 7.4, and 8.0 branches on Itanium2 with ICC 7.4 is not going to work with ICC anyway without considerably more extensive changes (eg, configure hacking). It mig

Re: [HACKERS] [PATCHES] 7.4, 8.0 branches @ itanium2 & icc

On Tue, 3 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Having recently tried to build 7.4, and 8.0 branches on Itanium2 with ICC 7.4 is not going to work with ICC anyway without considerably more extensive changes (eg, configure hacking). It mig

Re: [HACKERS] TM modificator don't work? to_char

ehaviour... Regards, Sergey *************** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---

Re: [HACKERS] src/tools/msvc usage instructions

is undefined. Regards, Sergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED

Re: [HACKERS] Faster StrNCpy

On Mon, 2 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to be quite different: What libc are you using exactly? Can you try it with the unrolled strlcpy I posted? glibc 2.3.5

Re: [HACKERS] Faster StrNCpy

[EMAIL PROTECTED]:~/test$ gcc -O3 -std=c99 -DSTRING='""' -DN="1" -o x x.c y.c strlcpy.c ; ./x NONE:937878 us MEMCPY: 3439101 us STRNCPY:3188791 us STRLCPY: 750437 us LENCPY: 2751238 us Regards, Sergey **

Re: [HACKERS] Draft release notes

input arguments (Tom) should be * Aggregate functions now support multiple input arguments (Sergey Koposov, Tom) instead Regards, Sergey *** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute

Re: [HACKERS] GIN FailedAssertions on Itanium2 with Intel compiler

e __OPTIMIZE__ preproc. symbol of icc doesn't allow to distinguish between different optimization levels. (only between -O0 and anything else). Regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/S

[HACKERS] GIN FailedAssertions on Itanium2 with Intel compiler

n (argc=3, argv=0x182) at postmaster.c:950 i=Info: symbol i is defined but not allocated (optimized away) opt=Info: symbol opt is defined but not allocated (optimized away) status=Info: symbol status is defined but not allocated (optimized away) u

Re: [HACKERS] segfault on rollback

On Sat, 12 Aug 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: I recently have seen the segfault with Postgres 8.1.4. I'm betting that portal->sourceText has already been deallocated when exec_execute_message tries to print the log message. Ge

[HACKERS] segfault on rollback

swd *) 0xb7f66cc0 pw_name_persist = 0xb7e6e000 "\\}\021" Any ideas ? Or I should try to narrower the problem ?... (it is not very easy for my application)... Initially I thought that the problem can be due to JDBC, but it doesn't seem so... In any case, since JDBC for PG

[HACKERS] problem with volatile functions in subselects ?

| 0.934251406665077 | 0.292522935332974 (2 rows) Is that a bug, or I'm missing something ? PG version is 8.1.4 or 8.2dev. Regards, Sergey *************** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute

Re: [HACKERS] Do we need multiple forms of the SQL2003 statistics

the functions unusable... Regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED]

Re: [HACKERS] Do we need multiple forms of the SQL2003 statistics

On Sat, 29 Jul 2006, Peter Eisentraut wrote: Sergey E. Koposov wrote: I think since we are supporting the numeric type as a special high-precision type, Postgres must have the high-precision versions of all computational functions. Just my opinion. Another way to look at it is whether you

Re: [HACKERS] Do we need multiple forms of the SQL2003 statistics

o do better tests, feel free... I will try to write some better tests and send a patch. Regards, Sergey *********** Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http

Re: [HACKERS] [PATCHES] patch implementing the multi-argument aggregates (SOC

On Mon, 24 Jul 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Since the feature freeze is in a few days, I'm sending the first iteration of my patch implementing the multi-argument aggregates (PolyArgAgg) (SOC project) This patch is nowhere near

[HACKERS] PG_RETURN_INT64 vs PointerGetDatum & ANALYZE

? Because I always used it in that function to return bigints (to not have the additional overhead of PG_RETURN_INT64), and that's the first time a see the bug due to that. Thank you in advance, Regards, Sergey **

Re: [HACKERS] two-argument aggregates and SQL 2003

On Thu, 13 Apr 2006, Tom Lane wrote: > "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > ... Nothing else and nothing internal need not to be changed to > > insert new two-arg. aggregate functions into the core. > > Am I right in this ? > > II

[HACKERS] two-argument aggregates and SQL 2003

possible to allow to do things like that : CREATE AGGREGATE new_2arg_agg ( BASETYPE = (int,int) , ) to create the two-arg. aggregates ? I'd like to hear any comments/advices/objections... Regards, Sergey * Sergey E. Koposo

Re: [HACKERS] Not so happy with psql's new multiline behavior

one line at a time. Ideally all > statements > would be saved like \e does. > > Sergey E. Koposov > > > Maybe it's just that I'm too used to the old behavior, but I don't like > anything about the way it works now. As an e

Re: [HACKERS] dropped columns, tupDesc

On Mon, 20 Feb 2006, Tom Lane wrote: > "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > I've recently proposed a patch > > http://archives.postgresql.org/pgsql-patches/2006-02/msg00165.php > > to fix an old problem with dropped columns, but recently

[HACKERS] dropped columns, tupDesc

patched version of compatible_tupdesc() which now take care of deleted columns). So, did I make the right conclusions ? What can be the right fix of that ? Comments ? Sorry if I was not very clear, it's the first time I'm looking so deeply in Postgres. Regards, Sergey **

Re: [HACKERS] FW: PGBuildfarm member snake Branch HEAD Status changed

gt; The specs of this machine are: > > OS: Windows / Server 2003 SP1 > > Arch: i686 > > Comp: gcc / 3.4.2 > > > > For more information, see > > http://www.pgbuildfarm.org/cgi-bin/show_history.pl?nm=snake&br=HEAD > > > > > > > &

[HACKERS] broken link in 8.1 docs

n.htm With Best Regards, Sergey * Sergey E. Koposov Max-Planck Institut fuer Astronomie Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end of broadcast)---

Re: [HACKERS] Call for port reports

Hello Tom, Slackware 10.0, kernel 2.6.12, x86, gcc 3.3.4 All 98 tests passed. Sergey * Sergey E. Koposov Max-Planck Institut fuer Astronomie Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end

[HACKERS] Postgres optimizer, repeated function calls

do so ? It should not be very difficult to optimize it to one call, isn't it ? With Best Regards, Sergey PS I tested this example with including in C code of test_func1 the static counter of calls. ************* Sergey E. Koposov Max-

Re: [HACKERS] 8.1beta, Subtle bug in COPY in Solaris systems

On Thu, 1 Sep 2005, Tom Lane wrote: > "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > 2660c2660 > > < if (isdigit(hex)) > > --- > > > if (isdigit((unsigned char)hex)) > > Sigh. We keep fixing these, and they keep creepi

[HACKERS] 8.1beta, Subtle bug in COPY in Solaris systems

by itself. >> \x3п >> \. test=# select length(xx) from test0; length 2 (1 row) I'm not sure that everybody will see that code properly due to encoding differences. But the idea is just feed postgres with "\x3" and one character with the code >128. Regards,

Re: [HACKERS] 8.1beta, SunOS and shmget

(passes all the regression tests) using both gcc (3.2.1), and sun compiler cc (Forte Developer 7 C 5.4). (despite SunOS is not supported platform following the documentation). With Best regards, Sergey ********* Sergey E. Koposov Max-Planck Inst

Re: [HACKERS] 8.1beta, SunOS and shmget

On Mon, 29 Aug 2005, Tom Lane wrote: > "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > So, are the shared memory requirements increased for 8.1 ? > > Yes; mostly from 2PC support I think. Try reducing > max_prepared_transactions. (We might want to debate wh

[HACKERS] 8.1beta, SunOS and shmget

tatus: linking ./src/include/port/solaris.h to src/include/pg_config_os config.status: linking ./src/makefiles/Makefile.solaris to src/Makefile.port ************* Sergey E. Koposov Max-Planck Institut fuer Astronomie Web: http://lnfm1.sai.msu.ru/~

Re: [HACKERS] performance of bitmap scans in nested loop joins

On Thu, 5 May 2005, Tom Lane wrote: > "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > And I coadded the "flat profiles" of first two (index scan) queries and > > compared it with the flat profile of bitmap scan: > > Thanks, I had been thi

Re: [HACKERS] performance of bitmap scans in nested loop joins

On Wed, 4 May 2005, Tom Lane wrote: > > I figured out part of the problem: I had made nodeBitmapIndexscan > re-open the index on each call, thinking that that would save amrescan > calls. But an amrescan is a whole lot cheaper than index open/close, > so that was a bad tradeoff. > > This seems

Re: [HACKERS] performance of bitmap scans in nested loop joins

On Fri, 29 Apr 2005, Tom Lane wrote: > >-> Index Scan using ipix_idx on q3c (cost=0.01..9686.37 rows=35 > > width=48) (actual time=0.006..0.006 rows=0 loops=300) > > Index Cond: ((q3c.ipix >= ("outer".ipix - 1000)) AND (q3c.ipix <= > > ("outer".ipix - 993))) > > >

[HACKERS] performance of bitmap scans in nested loop joins

pix - 1000)) AND (q3c.ipix <= ("outer".ipix - 993))) Total runtime: 76413.737 ms (12 rows) Last note: all those queries were run in fully cached regime on P4 2.8Ghz. I used the yesterday's CVS snapshot. Are those performance results expected for the bitmap index

[HACKERS] Tab-completion feature ?

TO TO I understand that this is a bit stupid and not very useful example, but still this is probably not an expected behaviour. With Best Regards, Sergey PS In Postgres 7.4.6 there is no such problem. -------- Sergey

[HACKERS] Strange postgres planner behaviour

.100060928.16 rows=316 width=48) -> Materialize (cost=12428.69..13568.41 rows=113972 width=48) -> Seq Scan on q3c_subset uu (cost=1.00..12314.72 rows=113972 width=48) (5 rows) I tried this queries on 7.4.6 and 8.0.1 and th

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

> "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > > LOOP > > FETCH cur into rec; > > RETURN NEXT rec; > > EXIT WHEN NOT FOUND; > > END LOOP; > > RETURN; > > Don't you think you should have the EXIT *ab

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

On Wed, 16 Feb 2005, Tom Lane wrote: > Richard Huxton writes: > > I seem to remember some subtle problems with dropped columns and plpgsql > > functions - could be one of those still left. > > It looks like the code that handles returning a RECORD variable doesn't > cope with dropped columns in

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

> Does starting a new backend session make the problem go away? No ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

On Wed, 16 Feb 2005, Richard Huxton wrote: > This is just a shot in the dark, but I don't suppose you've dropped or > modified any columns in "usno" have you? > > I seem to remember some subtle problems with dropped columns and plpgsql > functions - could be one of those still left. It'd look li

Re: [HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

> > For the real functions which I use, instead of > > > query = ''SELECT * FROM usno''; > > > I have > > > query = my_C_function(some_args); > > Oh? I'd make a small side bet that the underlying error is in your C > function --- possibly it's tromping on some data structure and the > damag

[HACKERS] Strange RETURN NEXT behaviour in Postgres 8.0

Sergey PS I have tried my code replacing the declaration "rec record;" by "rec TABLE_NAME%ROWTYPE", and it worked for both (big and small table), but I don't understand, why it doesn't work with the type "record". Sergey E. Koposov Sternb