Re: [SQL] psql: FATAL 1: IDENT authentication failed for user error - Urgent pls

2004-03-19 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > El Vie 19 Mar 2004 09:39, Kumar escribió: >> My pg_hba.conf file looks like below >> >> # TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD >> >> local all all trust >> host a

Re: [SQL] triggers on commit

2004-03-19 Thread Erik Thiele
On Fri, 19 Mar 2004 10:13:56 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Erik Thiele <[EMAIL PROTECTED]> writes: > > now. what i wanted to do is ensure that this is done correctly and > > otherwise abort the transaction. > > of course this check needs to be done at the commit time, because if > >

Re: [SQL] triggers on commit

2004-03-19 Thread Tom Lane
Erik Thiele <[EMAIL PROTECTED]> writes: > now. what i wanted to do is ensure that this is done correctly and > otherwise abort the transaction. > of course this check needs to be done at the commit time, because if i > do it on statement level, it cannot work, since i cannot change two > tables at

Re: [SQL] inverse of "day of year"

2004-03-19 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > Martin Marques <[EMAIL PROTECTED]> confessed: >> Is there a function that would give me the date for a given day of year? > Something like: > select date_trunc( 'year', now() ) + (extract( doy from now() ) - 1) * > '1day'::interval; timestamp + interv

Re: [SQL] psql: FATAL 1: IDENT authentication failed for user error

2004-03-19 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 19 Mar 2004, Kumar wrote: > I have installed Linux Fedore and wanted to work with the default installed postgres > 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the following > error messag

Re: [SQL] inverse of "day of year"

2004-03-19 Thread Robert Creager
When grilled further on (Fri, 19 Mar 2004 09:06:17 -0300), Martin Marques <[EMAIL PROTECTED]> confessed: > Is there a function that would give me the date for a given day of year? > > Something like the inverse of "EXTRACT(doy FROM date)"? > Something like: select date_trunc( 'year', now() ) +

Re: [SQL] psql: FATAL 1: IDENT authentication failed for user error - Urgent pls

2004-03-19 Thread Martin Marques
El Vie 19 Mar 2004 09:39, Kumar escribió: > Dear Friends, > > I have installed Linux Fedore and wanted to work with the default installed > postgres 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the > following error message psql: FATAL 1: IDENT authenti

[SQL] triggers on commit

2004-03-19 Thread Erik Thiele
Hi! I am having a probably stupid question, but anyway I can't find it's solution. it should be a novice question, but lets see :)) I have 2 tables. calendar: person_id INTEGER when DATE type TEXT holiday: person_id INTEGER assigned_to DATE last_possible_assignment DATE the idea he

[SQL] psql: FATAL 1: IDENT authentication failed for user error - Urgent pls

2004-03-19 Thread Kumar
Dear Friends,   I have installed Linux Fedore and wanted to work with the default installed postgres 7.3.4 database.   I could able to create to create user, but while try to connect, I got the following error message psql: FATAL 1: IDENT authentication failed for user   My pg_hba.conf file l

[SQL] inverse of "day of year"

2004-03-19 Thread Martin Marques
Is there a function that would give me the date for a given day of year? Something like the inverse of "EXTRACT(doy FROM date)"? -- 09:04:02 up 10 days, 13:35, 4 users, load average: 0.42, 0.29, 0.33 - Martín Marqués| sel