Re: [GENERAL] Trigger Problems?

ete these triggers or if this is a bug.  Either way, I learned something new.   Thanks, Darrin -Original Message-From: Darrin Ladd <[EMAIL PROTECTED]>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>Date: Wednesday, December 06, 2000 12:03 PMSubject: [GENERAL]

Re: [GENERAL] dump vs dumpall

Thanks! That worked perfectly!! -Original Message- From: Peter Eisentraut <[EMAIL PROTECTED]> To: Darrin Ladd <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, October 16, 2000 1:41 PM Subject: Re: [GENERAL] dump vs dumpall >Darrin Ladd

[GENERAL] dump vs dumpall

Howdy, I am in the process of moving my postgres dbs from an Alpha to a Pentium box and I can't seem to get pg_dumpall to work. I have password authentication enabled and am using the -u option on pg_dumpall, but it never actually asks me for a userid or password, it just writes out that the pas

Re: [GENERAL] reldesc does not exit

timestamp, added_dte timestamp, CONSTRAINT pk_foo PRIMARY KEY (bar) ); -Original Message- From: Tom Lane <[EMAIL PROTECTED]> To: Darrin Ladd <[EMAIL PROTECTED]> Cc: PGSQL General <[EMAIL PROTECTED]> Date: Friday, September 29, 2000 12:40 AM Subject: Re: [GENERAL

[GENERAL] reldesc does not exit

Howdy! I continually get the following error when I truncate a very large table in my db: NOTICE: trying to delete a reldesc that does not exist Is this something that I should be concerned about? Thanks for the help! Darrin

Re: [GENERAL] Table Alias

Thanks, that makes sense. Although, I'd much rather have an error then the wrong data. :( Cheers, Darrin >From: Stephan Szabo <[EMAIL PROTECTED]> >To: Darrin Ladd <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: [GENERAL] Table Alias >Date: Tue,

[GENERAL] User security on tuple level

Hi, I need to implement security on the tuple level, so that certain "users" only have access to certain rows within a table. When I was working with Oracle I implemented this type of security by creating a logon trigger which called a function. This function set a context (Oracle object som

[GENERAL] Foreign key to all inherited tables

Hi, I was wondering if there is a way to have a foreign key reference to the primary key column of all tables throughout an inheritance tree. For example, I have a parent_table with a unique_id (type serial) and a child table which inherits the parent_table (inheriting the unique_id). I woul

Re: [GENERAL] PG 7.0.2 Install

;From: [EMAIL PROTECTED] (Trond Eivind Glomsrød) >To: "Darrin Ladd" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: [GENERAL] PG 7.0.2 Install >Date: 18 Aug 2000 16:50:22 -0400 > >"Darrin Ladd" <[EMAIL PROTECTED]> writes: > > > I am

[GENERAL] PG 7.0.2 Install

Hi, I am trying to install 7.0.2 on an alpha box running Red Hat Linux 6.2. I was told that the 7.0.2 rpm's have an alpha patch in them and that would be the best bet for success. Yet, I have run into a little problem. When I try to install the rpm (rpm -i postgresql-7_0_2-2_i386.rpm) I get

[GENERAL] [General]Postgres Upgrade

Hi, I have been having serious problems with upgrading from 6.5.3 to 7.0.2. I currently have 6.5.3 running in what was the default locations for the RPMS (I am running it on an Alpha box with Red Hat Linux 6.2). I wanted to keep that going and configure 7.0.2 so that it is located in a diffe

[GENERAL]regression test failure on initdb

Hi, I am having a little trouble with the runcheck regression testing of the compilation that I just performed. I am running on a Linux Red-Hat 6.2 OS and currently have Postgres 6.5.3 running in non-default directories and on a non-default port. I wanted to install Postgres 7.0.2 in the def