) but this time the On insert do nothing rule
did affect and no insert was done to the child table...
Note: I did not have any on insert do nothing rule on the master table.
Regards,
Talha Amjad
On 6/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
On Jun 20, 2007, at 12:53 PM, Talha Khan w
) but this time the On insert do nothing rule
did affect and no insert was done to the child table...
Note: I did not have any on insert do nothing rule on the master table.
Regards,
Talha Amjad
On 6/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
On Jun 20, 2007, at 12:53 PM, Talha Khan w
Hi Guyz,
I need some help in an inheritance issue .
The scenario is as follows :
THE SAMPLE DDL:
CREATE TABLE account_login
(
account_id int4 NOT NULL,
account_login_time timestamptz NOT NULL DEFAULT now(),
ip_address varchar(32) NOT NULL,
originating_source varchar(32) NOT NULL DEFAUL
Hi Ed,In order to get which entities are responsible for the lock that you have try using the following query. select loc.pid , cls.relname,loc.granted as lock_status from pg_locks loc , pg_class cls where
loc.locktype like '%sharelock%' and cls.oid=loc.relation and loc.pid in(pids of the process
Hi Ed,I don't think its pgsql thats sending the SIGKILL its being done by the OS. The reason can only be confirmed after looking at your log files but the probability is that your OS ran out of memory and in order to protect itself it had to kill the processes that were taking a lot of memory thus
Hi Ed,You need to look through the log files for details.RegardsTalha KhanOn 11/8/06, Ed L. <
[EMAIL PROTECTED]> wrote:One of our 8.1.2 postmasters on HPUX 11.23 ia64 just received a
SIGKILL signal from unknown origins. After reviewing allcommand history files for the DBA and root, I do not believ
Hi Mathew,whats happening here in your case is that when you
use the concatenation operator || and an element in your command is
NULL the whole concat chain ends up being NULL so the execute command
runs as
EXECUTE NULLwhat you can do is to write your command as such:cmd := 'INSERT INTO test (
Hi Reece,You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that database in an environmental variable . Now you can run psql by connecting to a database through
Hi Km,
The shmmax setting is in *BYTES*.
Regards
Talha Khan
On 10/6/06, Talha Khan <[EMAIL PROTECTED]> wrote:
Hi Km,
The shmmax setting is in bits.
For knowing the details about the shared_buffer settings and other configuration features follow the link given below:
physical RAM. Yes! you can set shmmax to half of your RAM but it all depends upon how you use your system .I would recommend setting it to 2/3 of your
RAM.You can set the value in sysctl.conf file. and then reflect the setting by using sysctl -p switch.
Regards
Talha Khan
On 10/6/06, km <[EM
You can save your transactions in an sql file and then run that file whenever you need to run those transactions.
Regards
Talha Khan
On 10/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,I've been studying the whole evening and don't seem to find an answer:
You should also consider using connection pooling inorder to attain better performance.
Regards
Talha Khan
On 9/20/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apa
12 matches
Mail list logo
