Re: [SQL] date_part bug?

2001-03-31 Thread Richard Huxton
"Salvador Mainé" wrote: > > Hello: > > I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I > get wrong values. Ie: > and date_part('day', '1999-3-28')=27 > > and date_part('day', '2000-3-26')=25 > > Is it a bug? Is there any SQL equivalent function? I remember some issues

Re: [SQL] Function x returns opaque in error typeidTypeRelid

2001-03-31 Thread Richard Huxton
Sondaar Roelof wrote: > > Hello, > > I am a bit at a loss here. > If I create a function which returns something it works fine. > If it returns opaque I get the following: ERROR: typeidTypeRelid: Invalid > type - oid = 0 > What am I doing wrong ? > > dhcp=# create function lalala() returns op

Re: [SQL] Vacuum Error

2001-03-31 Thread Tom Lane
Tim Perdue <[EMAIL PROTECTED]> writes: > We recently upgraded sourceforge to 7.1b6 from our nice old stable november > cvs snapshot and we hit this error last nite: > NOTICE: FlushRelationBuffers(groups, 2140): block 2057 is referenced (private 0, >global 1) > Error: ERROR: VACUUM (repair_frag

RE: [HACKERS] Re: [SQL] possible row locking bug in 7.0.3 & 7.1

2001-03-31 Thread Mikheev, Vadim
> > > I doubt if it's a bug of SELECT. Well what > > > 'concurrent UPDATE then SELECT FOR UPDATE + > > > SELECT' return ? > > > > I'm going to add additional check to heapgettup and > > heap_fetch: > > SELECT seems to be able to return a different result > from that of preceding SELECT FOR UPDATE

[SQL] Library Management project

2001-03-31 Thread Sharmad Naik
Hi Everyone, Please bear with me.I am a final year student from India-Goa, and +developing a library management system which can be adopted by any University +(Hopefully). We are developing this project using PHP and PostgreSql.The good +thing that we appreciate is that this project is bas