Re: [GENERAL] intarray internals

On May 06 12:46, Volkan YAZICI wrote: > I'm reading through the source code of intarray contrib module. Despite > being at the beginning, I've some questions to ask. I'd be so > appreciated if anybody can help. Sorry, I forgot one: [4] In the inner_int_contains() function of _int_tool.c, there's

Re: [GENERAL] intarray internals

On Sat, May 06, 2006 at 12:46:01AM +0300, Volkan YAZICI wrote: > [1] > What's the function of execute() in _int_bool.c? As far as I can > understand, some other functions (eg. execconsistent()) calling > execute() with specific check methods (like checkcondition_bit()) but > I still couldn't figure

[GENERAL] How to tune function plpgsql

Hi, Recently, I've decided to simplify the code of an application, to do that, I migrate complex part to plpgsql function. I'd like to tune those functions, how can I do that ? How can I get the executed SQL inside a function ?? Thanks in advance, D. ---(end of broadc

Re: [GENERAL] intarray internals

Hi, First, thanks so much for your response. On May 06 12:13, Martijn van Oosterhout wrote: > On Sat, May 06, 2006 at 12:46:01AM +0300, Volkan YAZICI wrote: > > [1] > > What's the function of execute() in _int_bool.c? As far as I can > > understand, some other functions (eg. execconsistent()) cal

Re: [GENERAL] Composite types and NULL within PL/pgSQL

David J N Begley <[EMAIL PROTECTED]> writes: > So... why can I assign NULL to a composite type column in a table but not to a > composite type variable in PL/pgSQL? Is there any way to force that "out" > composite type variable to be NULL? In general the distinction between a true null composite

Re: [GENERAL] EnterpriseDB

It is my understanding that EnterpriseDB has many extensions built on top of PostgreSQL 8.1, and I doubt that an EnterpriseDB backup could be restored into the open source version of PostgreSQL. It would probably error out once it tried to create a stored procedure with the oracle compatib

[GENERAL] i need perl help for gborg project about mysql conversion

hello, i couldn't find a more appropriate list, and it is *generally* about pgsql http://gborg.postgresql.org/project/mysql2psql/projdisplay.php i tweaked it to convert [ from mysql to pgsql ] SET datatypes as well as ENUMS, and changed it to create an index when it sees a UNIQUE KEY or KEY.

Re: [GENERAL] intarray internals

On May 06 05:38, Volkan YAZICI wrote: > g_int_compress(): > if (integer array length > constant limit) > { > Transfrom {A, B, C, ..., Z} array into > {A, A, B, B, ..., Z, Z} > > while (integer array length > constant limit) > { > Select two couples whose difference is min

Re: [GENERAL] intarray internals

On Sat, May 06, 2006 at 05:38:24PM +0300, Volkan YAZICI wrote: > > Well, it's probably trying to undo whatever g_int_compress. If you can > > explain the algorithm used it will probably be clearer. > > Actually, algorithms used in the g_int_compress() and g_int_decompress() > methods are quite awe

[GENERAL] help debugging hung process

I'm having problems with hanging apache processes that seem to be stuck in pqSocketPoll. I'm running postgresql 7.4.11 on CentOS 3 (upgraded from 7.4.5 that was also having this problem; haven't upgraded to 7.4.12 because I haven't found RPMs yet). Using Apache 1.3.35 with mod_perl. I haven't be

[GENERAL] Can't Figure Out Where Rows Are Going

Hello, I am running 8.1.3, built from source, on RHEL4/x64. I have a Web application that uses this database to sell products. We have an order table and an order lines table with a one to many relationship between them. For the past few months I have had a strange problem where sometimes (about

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Just to be sure Any error msg in log? Maybe you can run this query in psql and see if it return any error msg Best regards Rodrigo HH wrote: Hello, I am running 8.1.3, built from source, on RHEL4/x64. I have a Web application that uses this database to sell products. We have an order t

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Is there an chance the rows are being inserted in a transaction that fails and rolls back? Maybe look at all the lines that were inserted with that order, and try them manually in psql, character for character, and see if an error pops up for any of the lines? Terry Fielder [EMAIL PROTECTED]

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Thanks for replying. The only logfile I have is the 'serverlog' file that I have. Looking at that file, I don't see any indications that there was an error. The INSERT does return successfully in psql. Any other possibilities? > From: Rodrigo Gonzalez <[EMAIL PROTECTED]> > Date: Sat, 06 May 200

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Thanks for taking the time to reply. If that was occurring, would the log show it? I don't see any sign of a roll-back occurring in the log and when I run the queries in psql, they seem to complete properly. > From: Terry Fielder <[EMAIL PROTECTED]> > Date: Sat, 06 May 2006 19:43:19 -0400 > To:

Re: [GENERAL] help debugging hung process

[EMAIL PROTECTED] writes: > I'm having problems with hanging apache processes that seem > to be stuck in pqSocketPoll. You sure it's not just waiting for a query? What is the connected database server process doing? regards, tom lane ---(end of br

Re: [GENERAL] Can't Figure Out Where Rows Are Going

HH <[EMAIL PROTECTED]> writes: > I can't figure out where this row went and why it disappeared! Is it getting > deleted some other way that wouldn't be logged? Am I missing something > rudimentary? Aside from the suggestion already made that the inserting transaction got rolled back instead of com

Re: [GENERAL] Composite types and NULL within PL/pgSQL

Tom Lane <[EMAIL PROTECTED]> writes: > you cannot enter such a thing as a row of a table, for example, and that is > the basic property that any rowtype ought to have no? Well that logic would apply equally to any SQL datatype. You can't perform arithmetic on NULL and that's the basic property an