In a trigger function, I'm trying to refer to a column given by an argument
to the trigger function.
The trigger function fires on deletes and is responsible for deleting messages
that are referred to using foreign keys which are named differently in different
tables (thus the foreign key's column
On 7/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Thu, Jul 07, 2005 at 09:28:23PM +0200, BigSmoke wrote:
> >
> > In a trigger function, I'm trying to refer to a column given by an argument
> > to the trigger function.
>
> This comes up frequently -- s
I'm facing a particular task for which I need any procedural language
but PL/PgSQL. I can't use PL/PgSQL because it doesn't allow me to use
local variables such as new and old from a dynamic command.
However, I've been unable to find any useful information on the
stability of each particular proce
On Dec 7, 11:07 pm, [EMAIL PROTECTED] ("Merlin Moncure") wrote:
> On 7 Dec 2006 14:02:53 -0800, BigSmoke <[EMAIL PROTECTED]> wrote:
>
> > I'm facing a particular task for which I need any procedural language
> > but PL/PgSQL. I can't use PL/PgSQL
On Dec 7, 11:11 pm, [EMAIL PROTECTED] ("Joshua D. Drake") wrote:
> On Thu, 2006-12-07 at 14:02 -0800, BigSmoke wrote:
> > I'm facing a particular task for which I need any procedural language
> > but PL/PgSQL. I can't use PL/PgSQL because it doesn't allow m
On Dec 7, 11:42 pm, [EMAIL PROTECTED] (Tony Caduto)
wrote:
> BigSmoke wrote:
> > On Dec 7, 11:07 pm, [EMAIL PROTECTED] ("Merlin Moncure") wrote:
>
> >> On 7 Dec 2006 14:02:53 -0800, BigSmoke <[EMAIL PROTECTED]> wrote:
>
> >>> I'm facing a
I understand that due to a lack of nested transaction support, it is
not possible to use START TRANSACTION within a PL/PgSQL function. What
I, however, do not understand is why I can't use SAVEPOINT either. I'm
writing long test functions wherein, at the start of the function, I'd
like to define al
On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
> On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > I understand that due to a lack of nested transaction support, it is
> > not possible to use START TRANSACTION within a PL/P
On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
> On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
>
>
>
> > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > > I understand that due to a l
On Dec 19, 5:32 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
> On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
>
> > > On 19 Dec 2006 07:05:10 -0800, "B
On Dec 19, 7:03 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
> On 19 Dec 2006 08:37:01 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > What would solve my problem is if there was a
> > method to, at the end of a begin/end block,
> > rollback the changes
On Dec 20, 9:02 am, "Christian Maier" <[EMAIL PROTECTED]> wrote:
> Sorry I have not found a plperl group so I hope the useres of this
> group can help me.
>
> I have some csv data and some columns are in a bad format. this means
> that some float values are formatet as " ." if the are 0. So I h
On Dec 18, 1:10 pm, [EMAIL PROTECTED] (Sandro Dentella) wrote:
> Hi all,
>
> I'm starting a project in which I will use PostgreSQL in which I need to
> check permissions at different levels (eg.: status of a record, hierarchy
> and so on). The application needs to run with a web interface (si
Following up on recent experiences I had with unit tests, I've written
an article on unit testing in PostgreSQL. If anyone is interested, it
can be found at http://www.bigsmoke.us/postgresql-unit-testing/
Of course, comments and criticisms are ever welcome.
---(end of bro
Hi list,I have a table which is referenced with foreign keys from multiple other tables. Records in this table are deleted by on delete rules on those other tables. This means that if I want to drop one of the referencing tables, I first have to delete all records in that referencing table to ensur
15 matches
Mail list logo