[GENERAL] Advise on unit testing framework enhancement

s exist as physical files in a project directory. 3. Perhaps you want to plug in your own SQL libraries instead of pgTAP to write tests against? -Regards Sid

[GENERAL] PL/Perlu - list of columns

'rows' => [] } Is there any way to get structure similar to dbi : $stmt->{'TYPE'}? -- Best regards Sid

Re: [GENERAL] Problem with triggers

to the validation. > > With triggers. A question to the experts: Couldn't this, in theory, be > implememnted within the rules system? From what I understand they are run > right after the query is parsed; I'd expect data validation to come a bit > later. Not sure if this is right. > > cheers > -- vbi > > -- Best regards Sid

Re: [GENERAL] Problem with triggers

2010/6/16 Tom Lane > Adrian Klaver writes: > > On 06/15/2010 02:01 PM, Sid wrote: > >> I am writing trigger function for validating values inserted into table. > The > >> goal is to print user friendly messages when inserted value is wrong. > > >> My q

[GENERAL] Problem with triggers

ROW EXECUTE PROCEDURE portal.dynamic_trigger_validate(); Postgres 8.4.4 on Windows 7 32bit My question is: why do I get information about too long value before trigger fires? Can I change this behavior? -- Best regards Sid

Re: [GENERAL] Idle in transaction

> Yes, it should. Are you certain your app is using autocommit across the > board, though, and that something else (say, your connection pooler) > isn't "helping" you by turning it back off again? I re-checked the code and auto commit mode is not being turned on. So my b

Re: [GENERAL] Idle in transaction

ff, I still need to issue explicit commits or rollbacks? -Original Message- From: Bill Moran [mailto:wmo...@potentialtech.com] Sent: Friday, July 17, 2009 10:44 AM To: Sharma, Sid Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Idle in transaction In response to &qu

[GENERAL] Idle in transaction

responsive. It has been up for over 36 hours now without any issues. What is the significance of this state? Does this imply a transaction leak? Then why am I not noticing deadlocks, timeouts etc. Thanks Sid

Re: [GENERAL] Idle in transaction

Sorry. Forgot to mention the postgres version PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 From: Sharma, Sid Sent: Friday, July 17, 2009 10:05 AM To: pgsql-general@postgresql.org Subject: Idle in transaction Hi I'm a postgres newb

[GENERAL] Query question

as well with no luck. I have also added a GROUP BY clause with the HAVING as well with no luck. Any ideas? Thanks Sid

[GENERAL] Performance check using COPY commands

have no idea why is that so. Is it because of the sequence number or some thing else. Since copying data into other table which has relatively more columns is taking much much lesser time may be in the ratio 1:15 times i guess. Can some body suggest me what is happening there?   Regards Sid Do you

[GENERAL] Performance tuning using copy

only minimal gain. Is there any other mechanism by which we can do faster updations.   Regards, Sid Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'

Re: [GENERAL] Problem with the sequence

Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the

Re: [GENERAL] Problem with the sequence

Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the

[GENERAL] Problem with the sequence

HI   I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do   psql=# select * from foo_seq;  sequence_name   | last_value | increment_by |  max_value  | min_value | cache_value

Re: [GENERAL] Locking of auto generated sequence

auto increments and I get the value in my next run. Can you tell me why is it happening this way and is there any solution so that i use only copy commands to update the data.Richard Huxton wrote: sid tow wrote:> Hi All,> > Is there a way to stop a auto generated sequence from incremen

[GENERAL] Locking of auto generated sequence

Hi All,   Is there a way to stop a auto generated sequence from incrementing for some time and then activate it to do the increments.   Regards Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'

[GENERAL] Problem with Autogenerated sequence

QL?   Note: I referred man pages of create_sequence to get the information.   Regards, Sid     Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'

[GENERAL] How to get back the current count of a auto incrementing number.

hi How to get the current value of a auto incrementing number generated using CREATE SEQUENCE seqname START 1 Is there any way and if yes what is it. Can we run a select query and may be a inbuilt function which will return the current value of that number? Regards. _

[GENERAL] Problem with the copy command need help

hi, I am updating a database using COPY commands. If the commmand breaks in between updating the database, is there any way to find the log of the previous updation or which part or row the loading broke. Regards Sid __ Do you Yahoo

[GENERAL] How to lock or disable a trigger

command i cannot update columns of my choice, meaning all the columns of a table has to be loaded with a copy command. Can any one help me with this and clarify. These triggers are RI_ConstraintTriggers. Regards sid __ Do You Yahoo!? Tired of spam

[GENERAL] problem with the select query

Hi people,    this is my first mail to the group. i am having a problem with the select query. There are a few values in few columns of a table with some special characters like ~E and ~A and what all, and when i query the database with the select query then the ~E is getting converted into a new