Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

Markus Wagner writes: > we need to control database changes within BEFORE triggers. > There is no problem with triggers called by update, but there is > a problem with triggers called by insert. > > We strongly need to know the oid of a newly inserted tuple. In this case, we > use tg_newtuple of

[SQL] Apache authentication with debian linux

  I have a problem with apache authentication. I recently upgrade to postgresql v7.1, upgrading debian distribution (to woody, testing distribution) and i discovered that  the pakage for apache authentication is no longer there. (may be they suggest to use PAM instead of old mod_auth_pgsql?) This

[SQL] Apache authentication and v7.1

  I have a problem with apache authentication. I recently upgrade to postgresql v7.1, upgrading debian distribution (to woody, testing distribution) and i discovered that  the pakage for apache authentication is no longer there. (may be they suggest to use PAM instead) This is really a problem fo

[SQL] Sql

Hi,   I'd like an information about the history of SQL. The similarities and differences between SQL1 and SQL2 and SQL3.Could you help me?   Thanks for your attention.   Marcia Cunha Belo Horizonte , Brasil.  

[SQL] Problem with sequences

Hi, I'm writing a script, which has to retrieve a next value from a sequnce. I use mod_perl, DBI and DBD::Pg version 0.98. I notice that when I execute "select nextval('sequence_name'::text) AS sname;", via DBI, the value of sequence is updated, but the mod_perl returns "DBD::Pg::st execute

[SQL] GRANT ALL ON TO GROUP failure

[Please keep CC] Can anyone suggest, what is wrong with the following sql file? SOmehow the semicolon causes error? Jari class=# \i pg-def-group-grant.sql Granting ALL to ROOT CHANGE Granting ALL to USER psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "

[SQL] HELP: Trend reporting

Hello newsgroup buddies, I am looking for information on trend reporting. We run Linux, PostreSQL, Apache and PHP4. We have a series of scripts that track customer usage through our sites, and give us similar information to what is found in the Apache logs, but with more data. I now find myself

[SQL] Re: DBD::Pg install error (freebsd)

Vivek Khera <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > "jj" == jake johnson <[EMAIL PROTECTED]> writes: > > jj> I'm trying to install (from source) DBD::Pg v1.01 after having > jj> installed (from source) DBI v1.19 on FreeBSD 4.3 (Release) and I > jj> encounter this

[SQL] Apache authentication with debian linux

I have a problem with apache authentication. I recently upgrade to postgresql v7.1, upgrading debian distribution (to woody, testing distribution) and i discovered that  the pakage for apache authentication is no longer there. (may be they suggest to use PAM instead of old mod_auth_pgsql?) This i

RE: [SQL] changes to table creation syntax in 7.1.2?

Jason, First of all, thanks for your response. I had given up that anyone was going to respond. After seeing your response I went back and found what was making the difference. The failing syntax below worked on 7.0.3 but not on the 7.1.2 version. Seeing your working example(unlike another respon

[SQL] Re: GRANT ALL ON TO GROUP failure

user is an SQL reserved word, use 'user' instead. You might like to have a look at the list of reserved words at http://www.postgresql.org/idocs/index.php?sql-keywords-appendix.html Jari Aalto+usenet wrote: > > [Please keep CC] > > Can anyone suggest, what is wrong with the following

[SQL] Create table syntax

Hi Entered below is the SQL create table syntax: CREATE TABLE lists ( [listid] [int] IDENTITY (1, 1) NOT NULL , [listname] [varchar] (200) NULL , [listcreator] [varchar] (200) NULL , [listdesc] [text] NULL) We need to know that this syntax will work properly in

[SQL] DBD::Pg install error (freebsd)

I'm trying to install (from source) DBD::Pg v1.01 after having installed (from source) DBI v1.19 on FreeBSD 4.3 (Release) and I encounter this error in the 'make test' step: dell_box# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/libdata/perl/5.00503/mach -I/usr/libdata/

[SQL] Help On Postgresql

Dear Friends   I am Jaydip Dewanji working as a Sr. Programmer for Ontrack Systems Ltd.   I have some questions regarding Postgresql which are listed below:   a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a Date/DateTime variable.       For Example : i> In Oracle to_

Re: [SQL] Problem with sequences

Vladimir, > I notice that when I execute "select nextval('sequence_name'::text) > AS > sname;", via DBI, the value of sequence is updated, but the mod_perl > returns > "DBD::Pg::st execute failed: ERROR: sequence_name.nextval: you don't > have > permissions to set sequence" Your issue is eit

[SQL] Re: Help On Postgresql

Jaydip wrote: > Dear Friends > > I am Jaydip Dewanji working as a Sr. Programmer for Ontrack Systems Ltd. > > I have some questions regarding Postgresql which are listed below: > > a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a Da= > te/DateTime variable. > > For

[SQL] Re: Create table syntax

satish rao wrote: > > Hi > > Entered below is the SQL create table syntax: > > CREATE TABLE lists ( > [listid] [int] IDENTITY (1, 1) NOT NULL , > [listname] [varchar] (200) NULL , > [listcreator] [varchar] (200) NULL , > [listdesc] [text] NULL) > > We need to kn

Re: [SQL] Where can I find the SQL Commands that I can use with ECPG

Ligia Pimentel wrote: > > Hello! > > I want to read about what I can do with ECPG, but I have just found a couple > of examples with SELECT statements. Is there a complete documentation of > this? Can you help me find it? A complete documentation of what: ecpg or SQL ? Actually you find everyth

Re: [SQL] Create table syntax

On 28 Aug 2001, satish rao wrote: > Entered below is the SQL create table syntax: > > CREATE TABLE lists ( > [listid] [int] IDENTITY (1, 1) NOT NULL , > [listname] [varchar] (200) NULL , > [listcreator] [varchar] (200) NULL , > [listdesc] [text] NULL) create table lists

Re: [SQL] Help On Postgresql

a)  Look at "Date/Time Functions" in the docs: specifically, listed under "Functions and Operators" in the Users Guide. b) "Serial" type will do this.  Look under "Numeric Types" , in the "Data Types" section of the Users Guide. - Original Message - From: Jaydip To: [EMAIL

Re: [SQL] Help On Postgresql

On Thu, 23 Aug 2001, Jaydip wrote: > a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a >Date/DateTime variable. > > For Example : i> In Oracle to_char(dt,'') - for extracting the year value >from a date variable dt > ii> In SqlServer datepart(hh,

[SQL] Re: [NOVICE] protected ON DELETE CASCADE

On Thu, 23 Aug 2001, Murray Hobbs wrote: > A <- B > A <- C <- D > > i want to maintain integrity so that if A is deleted from then so is > anything referencing from B and C - no problem ON DELETE CASCADE > > but if there are any D's that point back to A (through composite key in > C) i don't wa

Re: [SQL] Sql

For history, see the first chapter of my book. Also see appendix on non-standard feature. http://www.postgresql.org/docs/awbook.html > Hi, > > I'd like an information about the history of SQL. > The similarities and differences between SQL1 and SQL2 and SQL3. > > Could you help me? > > Than

Re: [SQL] Latin-2 sort order

> > You need to enable locale support. MB support does nothing with the > > sort order. > > I guess You mean: > > ./configure --enable-locale > export LANG=pl_PL > run postmaster Yes. > and now should I > > initdb > > or just simply browse the database as usual

Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

On Wed, Aug 29, 2001 at 11:15:08AM +0200, Markus Wagner wrote: > Hi, > > we need to control database changes within BEFORE triggers. > There is no problem with triggers called by update, but there is > a problem with triggers called by insert. > > We strongly need to know the oid of a newly inse