[HACKERS] Where are the ERROR: Messages

2001-09-19 Thread Haller Christoph

[HACKERS] Where are the ERROR:  Messages
I'm converting from a C based program 
to PostgreSQL. There are some DBMS 
specific errors caught, i.e. deadlocks. 
Not only for this reason, but also from 
general curiosity I'd like to know what 
kinds of ERRORS PostgreSQL is dealing with. 
Which source code/header file is hiding 
this infromation? 
Regards, Christoph 


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



[HACKERS] Large object help requierd

2001-09-19 Thread Shridhar Daithankar

Hi,

I am trying to store some large object in database. 

I print the number of bytes returned by lo_write. It's
greater than zero. However sometime later, I start
getting errors for lo_closelike invalid object
descriptor fd=0 where df is variable I used for large
object fd.

Actually after lo_write is done lo_close is called. I
wonder why it takes time between these two.

I also found that the error values for many functions
are not properly documented. e.g. lo_open.

One more thing I am not sure of. Am I suppose to
commit after I call lo_creat but before I can call
lo_open?

I am experimenting. I will let you know the results.

 Shridhar

__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread Marc G. Fournier




:pserver:[EMAIL PROTECTED]:/projects/cvsroot


On 18 Sep 2001, Gunnar [iso-8859-1] Rønning wrote:

 * Marc G. Fournier [EMAIL PROTECTED] wrote:
 |
 | anoncvs.postgresql.org is going to be out of sync until, most likely,
 | tomorrow, for anyone trying to use that ... anoncvs is *no longer*
 | available through the main cvs repository either ...

 Is anoncvs.postgresql.org working yet ?

 I just tried :

 # cvs -d :pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login

 and

 # cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login

 with postgresql as password. In both cases the response was this :


 cvs [login aborted]: authorization failed: server anoncvs.postgresql.org rejected 
access

 regards,

 Gunnar

 --
 Gunnar Rønning - [EMAIL PROTECTED]
 Senior Consultant, Polygnosis AS, http://www.polygnosis.com/



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread Patrick Welche

On Wed, Sep 19, 2001 at 10:14:44AM -0400, Marc G. Fournier wrote:
 
 :pserver:[EMAIL PROTECTED]:/projects/cvsroot

While trying a cvs update, I get

? ChangeLogs/libecpg.so.3.1.1
? ChangeLogs/HTML
? ChangeLogs/GTAGS
? ChangeLogs/GPATH
? ChangeLogs/GRTAGS
? ChangeLogs/GSYMS
? ChangeLogs/libpqpp.h
cannot create_adm_p /tmp/cvs-serv27285/ChangeLogs


Cheers,

Patrick

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[HACKERS] Case sensitive file names

2001-09-19 Thread Peter Bierman

While checking out TOT pgsql today onto an HFS+ file system (case-preserving, 
case-insensitive), I hit the following CVS conflict:

pgsql/src/backend/utils/mb/Unicode/utf8_to_alt.map 
pgsql/src/backend/utils/mb/Unicode/utf8_to_ALT.map

HFS+ can not store two differerent files in a path that differs only by case.

Mac OS X users will be grateful if you can find a way to rename one of these files.

-pmb



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Case sensitive file names

2001-09-19 Thread Serguei Mokhov

- Original Message -
From: Peter Bierman [EMAIL PROTECTED]
Sent: Wednesday, September 19, 2001 3:41 PM

 While checking out TOT pgsql today onto an HFS+ file system (case-preserving, 
case-insensitive), I hit the following CVS conflict:

 pgsql/src/backend/utils/mb/Unicode/utf8_to_alt.map 
pgsql/src/backend/utils/mb/Unicode/utf8_to_ALT.map

I thought the latter was supposed to go (it was supposed to be renamed to the former, 
wasn't it?)

S.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: CVS vs anoncvs (was Re: [HACKERS] Case sensitive file names)

2001-09-19 Thread Marc G. Fournier


should be four hours, but I haven't had a chance, with the newest
worm/virus going around right now having killed our core router yesterday,
to redirect the sync'ag with the new server ... will do that first thing
tomorrow ...

On Wed, 19 Sep 2001, Tom Lane wrote:

 Peter Bierman [EMAIL PROTECTED] writes:
  If it's already been fixed (yay!), the fix isn't at anoncvs yet.

 I think there is some lag between the master CVS and anoncvs now.
 Marc, is that correct?  How much lag?

   regards, tom lane



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



CVS vs anoncvs (was Re: [HACKERS] Case sensitive file names)

2001-09-19 Thread Tom Lane

Peter Bierman [EMAIL PROTECTED] writes:
 If it's already been fixed (yay!), the fix isn't at anoncvs yet.

I think there is some lag between the master CVS and anoncvs now.
Marc, is that correct?  How much lag?

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] FOREIGN KEY taking write locks on parent.

2001-09-19 Thread Rachit Siamwalla


I sent a message a while back on this list on why an insert onto a table A
which has a foreign key constraint to table B obtains a write (exclusive)
lock on that row on table B (basically does a select for update). The answer
was there is no SQL construct to obtain read (shared) locks on a particular
row, therefore it took a write lock.

I was just wondering, isn't the fact that FOREIGN KEY takes a write lock on
its parent a bug? I was just wondering whether this is being worked on, and
if anyone has any ideas where to start in case I want to work on it, or can
I create my own function / constraint which will just emulate a shared lock
behavior for a FOREIGN KEY constrant. This is making it tough to sanely
handle concurrent long-running transactions, even if I use the INITIALLY
DEFERRED for the foreign key constrant.

Thanx a lot, and thanx for this wonderful DB.

-rchit


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] FOREIGN KEY taking write locks on parent.

2001-09-19 Thread Tom Lane

Rachit Siamwalla [EMAIL PROTECTED] writes:
 I was just wondering, isn't the fact that FOREIGN KEY takes a write lock on
 its parent a bug?

Yes, I think so.  Fixing it is not trivial (else we'd have done it right
to start with) ... but if you want to step up to the plate to fix it,
we're all ears ...

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Beta time

2001-09-19 Thread Tom Lane

Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 Attached is the CONSTR_PRIMARY switch block from command.c.  I've marked the
 problem test with '@@'.

Hmmm  this code has got a number of problems, but I don't see why
*that* would fail.  Anyone?

What I do see:

1. Should not break out of loop over indexes after detecting a
matching non-primary-key index.  This allows detection of the NOTICE
condition to distract you from detecting the ERROR condition on a
later index.  I'd suggest issuing the NOTICE inside the loop, actually,
and not breaking at all.  (See also #4)

2. What's with the if (keyno  0)?  That breaks detection of
everything on indexes on system columns, eg OID.  (Of course, the
rel_attrs[keyno - 1] reference doesn't work for system columns,
but sticking your head in the sand is no answer.)

3. pfree'ing iname at the bottom doesn't strike me as a good
idea; isn't that possibly part of your input querytree?

4. If you're going to be so pedantic as to issue a warning notice about
a duplicate non-primary index, it'd be polite to give the name of that
index.  Else how shall I know which index you think I should drop?

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Beta time

2001-09-19 Thread Christopher Kings-Lynne

 1. Should not break out of loop over indexes after detecting a
 matching non-primary-key index.  This allows detection of the NOTICE
 condition to distract you from detecting the ERROR condition on a
 later index.  I'd suggest issuing the NOTICE inside the loop, actually,
 and not breaking at all.  (See also #4)

OK.

 2. What's with the if (keyno  0)?  That breaks detection of
 everything on indexes on system columns, eg OID.  (Of course, the
 rel_attrs[keyno - 1] reference doesn't work for system columns,
 but sticking your head in the sand is no answer.)

This is code that I've borrowed from elsewhere.  I'll have a good look at it
tho.

 3. pfree'ing iname at the bottom doesn't strike me as a good
 idea; isn't that possibly part of your input querytree?

Hmmm.  OK.  What about in the case where iname is null and I give it a
makeObjectName?

 4. If you're going to be so pedantic as to issue a warning notice about
 a duplicate non-primary index, it'd be polite to give the name of that
 index.  Else how shall I know which index you think I should drop?

I'll improve the messages.  As for me being pedantic - that's a result of
what you specified as the best behaviour should be when I posted on the
list!

You may also want to look at the CONSTR_UNIQUE block that's already been
committed, as it may also have similar issues.  Any fixes I make to PRIMARY,
I will also fix in UNIQUE...

Cheers,

Chris


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Putting timestamps in PostgreSQL log

2001-09-19 Thread Martín Marqués

On Lun 17 Sep 2001 23:28, Christopher Kings-Lynne wrote:
 Would it be an idea to add timestamps to the PostgreSQL error/debug/notice
 log?

 Sometimes I would really like to know when an event has occurred!

Use syslog and you'll get timestamps in your log.

Saludos... :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-
Martín Marqués  |[EMAIL PROTECTED]
Programador, Administrador, DBA |   Centro de Telematica
   Universidad Nacional
del Litoral
-

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] slow UNIONing

2001-09-19 Thread Zeugswetter Andreas SB SD


 I experienced that UNIONs in 7.1.1 are rather slow:
 
 tir=# explain (select nev from cikk) union (select 
 tevekenyseg from log);
 NOTICE:  QUERY PLAN:
 
 Unique  (cost=667.63..687.18 rows=782 width=12)
   -  Sort  (cost=667.63..667.63 rows=7817 width=12)
 -  Append  (cost=0.00..162.17 rows=7817 width=12)
   -  Subquery Scan *SELECT* 1  (cost=0.00..28.16 
 rows=1316 width=12)
 -  Seq Scan on cikk  (cost=0.00..28.16 
 rows=1316 width=12)
   -  Subquery Scan *SELECT* 2  
 (cost=0.00..134.01 rows=6501 width=12)
 -  Seq Scan on log  (cost=0.00..134.01 
 rows=6501 width=12)
 
 Of course a simple SELECT is fast:
 
 tir=# explain select nev from cikk;
 NOTICE:  QUERY PLAN:
 
 Seq Scan on cikk  (cost=0.00..28.16 rows=1316 width=12)
 
 
 For me it seems to be slow due to the sorting. Is this right?
 Is this normal at all? Is it possible to make it faster?

If you know, that your result does not produce duplicates
(which are filtered away with union) you can use a 
union all which should be substantially faster, since it does 
not need to sort.

Andreas

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Large objects and ecpg

2001-09-19 Thread Michael Meskes

On Wed, Sep 19, 2001 at 12:46:03AM +0530, Chamanya wrote:
 Can I use ecpg with large objects? All examples in documentation are for 
 libpq.

Yes and no. Since ECPG uses libpq it should not be too difficult to use the
lo functions too. But there is no way to use them via some EXEC SQL
statements.

Any idea how these statements should look like? Would be a good idea to
implement.

Michael
-- 
Michael Meskes
[EMAIL PROTECTED]
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] slow UNIONing

2001-09-19 Thread Peter Eisentraut

Kovacs Zoltan writes:

 I experienced that UNIONs in 7.1.1 are rather slow:

 tir=# explain (select nev from cikk) union (select tevekenyseg from log);

Try UNION ALL.  Plain UNION will eliminate duplicates, so it becomes
slower.

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Beta time

2001-09-19 Thread Tom Lane

Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 3. pfree'ing iname at the bottom doesn't strike me as a good
 idea; isn't that possibly part of your input querytree?

 Hmmm.  OK.  What about in the case where iname is null and I give it a
 makeObjectName?

Don't worry about it.  palloc'd space will be recovered anyway at end of
statement.  It's really not worth the code space to pfree every little
bit of space you might use, except in routines that could be executed
many times in a single query.

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread Marc G. Fournier


can you ssh into cvs.postgresql.org?

On Tue, 18 Sep 2001, D'Arcy J.M. Cain wrote:

 Thus spake Marc G. Fournier
  This will most likely screw some ppl up, and fix others ...
 
  CVSROOT has now moved to the new machine, finally ... and I've cleaned up
  pathing ... and CVS_RSH=ssh now works again too ...
 
  So, now CVSROOT is accessible as:
 
  :pserver:userid@cvs.postgresql.org:/cvsroot
 
  -or-
 
  :ext:userid@cvs.postgresql.org:/cvsroot
 
  - where CVS_RSH is set to ssh

 None of this helps me.  I still can't get into that system.  Can you
 please check this and get me back in.  If I can't get in I will have
 to move PyGreSQL back to my own CVS repository and I think it is good
 for both projects to leave it where it is.  Will you be in today?  I
 can call you later to discuss this and hopefully resolve it.

 --
 D'Arcy J.M. Cain darcy@{druid|vex}.net   |  Democracy is three wolves
 http://www.druid.net/darcy/|  and a sheep voting on
 +1 416 425 1212 (DoD#0082)(eNTP)   |  what's for dinner.



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



[HACKERS] CVSup Server has the time bug, needs to be upgraded

2001-09-19 Thread Otto Hirr

Please note that as of 07:24PST, 09-19
the cvsup server is old and needs to be
upgraded, the following is what I now
get when trying to sync:

Parsing supfile cvsup_config
Connecting to postgresql.org
Connected to postgresql.org
Server software version: REL_16_1
Server postgresql.org has the S1G bug
See http://www.polstra.com/projects/freeware/CVSup/s1g/ for details
Please notify the maintainer of postgresql.org
Refusing update from server with S1G bug

When might the server be upgraded?

The above page gives a good reason:

Outdated clients create a heavy load on the servers,
so upgrading to SNAP_16_1e is strongly recommended.

Best regards,

.. Otto

Otto Hirr
OLAB Inc
503.617.6595
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] [Fwd: [Fwd: [tao-users] FW: HEADS UP: CVSup timestamp bug]]

2001-09-19 Thread Thomas Lockhart

 Right now, we have:

OK, these are three *physically distinct* machines with some aliases
attached to them? Or are virtual hosts involved too?? I need a site map
from someone since nothing but my home directory is in the place they
used to be (actually, even that moved but I *do* know how to find my
home directory ;). I've found some stuff, but no doc areas and no ftp
areas.

Help!! (At your convenience, of course; I *know* you are doing a lot of
work on this ;)

 - Thomas

golem host cvsup.postgresql.org
cvsup.postgresql.org is a nickname for rs.PostgreSQL.org
rs.PostgreSQL.org has address 64.39.15.238
rs.PostgreSQL.org has address 64.39.15.238
golem host anoncvs.postgresql.org
anoncvs.postgresql.org is a nickname for rs.PostgreSQL.org
rs.PostgreSQL.org has address 64.39.15.238
rs.PostgreSQL.org has address 64.39.15.238
golem host cvs.postgresql.org
cvs.postgresql.org is a nickname for mail.postgresql.org
mail.postgresql.org has address 216.126.85.28
mail.postgresql.org has address 216.126.85.28
golem host mail.postgresql.org
mail.postgresql.org has address 216.126.85.28
golem host www.postgresql.org
www.postgresql.org is a nickname for rs.postgresql.org
rs.postgresql.org has address 64.39.15.238
rs.postgresql.org has address 64.39.15.238
golem host ftp.postgresql.org
ftp.postgresql.org is a nickname for postgresql.org
postgresql.org has address 216.126.84.28
postgresql.org has address 216.126.84.28
golem host rsync.postgresql.org
rsync.postgresql.org is a nickname for rs.postgresql.org
rs.postgresql.org has address 64.39.15.238
rs.postgresql.org has address 64.39.15.238

 anoncvs.postgresql.org
 == cvsup.postgresql.org
 - same machine, brand new
 cvs.postgresql.org
 == www.postgresql.org
 == mail.postgresql.org
 == ssh/login server
 - same machine
 
 rsync.postgresql.org
 == ftp.postgresql.org
 == primary www server
 - old server, slowly being migrated between the above two
   machines (rsync - anoncvs, ftp/primary - cvs)

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[HACKERS] Status of greatbridge.org

2001-09-19 Thread Tom Lane

I am advised by the (few remaining) Great Bridge folk that they will be
shutting down their webservers very shortly, like tomorrow.  This will
take the project pages at greatbridge.org offline.

All the data at greatbridge.org has been transferred to a hub.org server
at http://gborg.postgresql.org/.  Project URLs will be the same except
for the change of site name.   Please note that while the data is there,
not all of the site functionality is up yet.  Chris Ryan is working
hard to make the necessary adjustments, and the glitches should be
smoothed out over the next few days.

On behalf of the PG core committee, I'd like to thank the Great Bridge
people and particularly Chris Ryan for their efforts to continue support
for the projects that were hosted at greatbridge.org.  Also, of course,
thanks to Marc and hub.org for picking up the service.

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] Returning NULL from functions

2001-09-19 Thread Thomas Lockhart

I am working on date/time stuff, and in the spirit of cleaning up
interesting but marginally useful features I've dropped support for
invalid for the timestamp and timestamptz types. 

To help with upgrading, I thought that I'd map it to a NULL value, and
see the following in the regression tests:

-- Obsolete special values
INSERT INTO TIMESTAMP_TBL VALUES ('invalid');
ERROR:  OidFunctionCall3: function 1150 returned NULL

Is this error message a feature of all returns of NULL, particular to
input routines, or can I somehow mark routines as being allowed to
return NULL values?

Comments?

- Thomas

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



[HACKERS] type casting troubles

2001-09-19 Thread Thomas Lockhart

I have split the timestamp data type into two types to better match
SQL9x specs. I've implemented them as timestamp and timestamptz (the
latter corresponding to the implementation in recent releases), and have
implemented conversion routines between the two types. However, I expect
to be able to cast one to the other, but am crashing the server deep
down in the executor when phrasing a query using the CAST() syntax,
whereas an explicit call to the conversion routine seems to work fine.

I thought that I understood the mechanisms for this casting (I'd done
the original implementation, after all ;) but the code has evolved since
then, presumably for the better. Any hints on what could be happening?

 - Thomas

thomas=# select timestamp without time zone 'now',
 timestamptz(timestamp without time zone 'now');
+---
 2001-09-19 19:05:07.81 | 2001-09-19 19:05:07.81-07
(1 row)

thomas=# select cast(timestamp without time zone 'now' as timestamptz);
server closed the connection unexpectedly

backend select cast(timestamp without time zone 'now' as timestamptz);

Program received signal SIGSEGV, Segmentation fault.
0x401286f6 in strncpy () from /lib/libc.so.6
(gdb) where
#0  0x401286f6 in strncpy () from /lib/libc.so.6
#1  0x819fc77 in namestrcpy (name=0x82d6340, str=0x1f8 Address 0x1f8
out of bounds) at name.c:175
#2  0x806cb34 in TupleDescInitEntry (desc=0x82d6304, attributeNumber=1, 
attributeName=0x1f8 Address 0x1f8 out of bounds, oidtypeid=1184,
typmod=-1, attdim=0, 
attisset=0 '\000') at tupdesc.c:365
#3  0x810d309 in ExecTypeFromTL (targetList=0x82d60a8) at
execTuples.c:594
#4  0x810d63d in ExecAssignResultTypeFromTL (node=0x82d60c4,
commonstate=0x82d628c) at execUtils.c:288
#5  0x8115072 in ExecInitResult (node=0x82d60c4, estate=0x82d616c,
parent=0x0) at nodeResult.c:227
#6  0x8109334 in ExecInitNode (node=0x82d60c4, estate=0x82d616c,
parent=0x0) at execProcnode.c:140
#7  0x8107570 in InitPlan (operation=CMD_SELECT, parseTree=0x82d23cc,
plan=0x82d60c4, estate=0x82d616c)
at execMain.c:628
#8  0x8106c5e in ExecutorStart (queryDesc=0x82d6150, estate=0x82d616c)
at execMain.c:135
#9  0x817e719 in ProcessQuery (parsetree=0x82d23cc, plan=0x82d60c4,
dest=Debug) at pquery.c:257
#10 0x817cbf2 in pg_exec_query_string (
query_string=0x82d2008 select cast(timestamp without time zone
'now' as timestamptz);\n, dest=Debug, 
parse_context=0x82a5e94) at postgres.c:812
#11 0x817e0c1 in PostgresMain (argc=2, argv=0xb6f4, real_argc=2,
real_argv=0xb6f4, 
username=0x828f6d8 thomas) at postgres.c:1963
#12 0x81236e5 in main (argc=2, argv=0xb6f4) at main.c:203
#13 0x400e9cbe in __libc_start_main () from /lib/libc.so.6

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Returning NULL from functions

2001-09-19 Thread Tom Lane

Thomas Lockhart [EMAIL PROTECTED] writes:
 ERROR:  OidFunctionCall3: function 1150 returned NULL

 Is this error message a feature of all returns of NULL, particular to
 input routines, or can I somehow mark routines as being allowed to
 return NULL values?

It's a feature for all places that invoke SQL functions via the
FooFunctionCallN routines.  The API for those routines offers no way
to handle passing or returning NULL, so they have little choice but to
raise elog(ERROR) if they see the called function return NULL.

Those routines are intended for use in places where a NULL result is
nonsensical anyway, and so extending their API to allow NULL would just
create useless notational clutter.  If you want to cope with NULLs then
you have to set up and inspect a FunctionCallInfoData structure for
yourself.  See the comments in backend/utils/fmgr/fmgr.c.

Offhand I see no good reason why a datatype input routine should return
NULL.  Either return a valid value of the type, or elog(ERROR).  IMHO,
NULL is (and should be) an out-of-band value handled by
datatype-independent logic.

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] type casting troubles

2001-09-19 Thread Tom Lane

Thomas Lockhart [EMAIL PROTECTED] writes:
 #2  0x806cb34 in TupleDescInitEntry (desc=0x82d6304, attributeNumber=1, 
 attributeName=0x1f8 Address 0x1f8 out of bounds, oidtypeid=1184,
 typmod=-1, attdim=0, 
 attisset=0 '\000') at tupdesc.c:365

This appears to indicate that you have a Resdom node with an invalid
resname field.  Seems like that wouldn't be a datatype-specific issue
at all.  Have you changed the handling of cast() nodes?

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread D'Arcy J.M. Cain

Thus spake Marc G. Fournier
 can you ssh into cvs.postgresql.org?

Yes!  I could not do that before.  Did you fix something?

I will be sending some PyGreSQL changes over shortly.  Thanks.

-- 
D'Arcy J.M. Cain darcy@{druid|vex}.net   |  Democracy is three wolves
http://www.druid.net/darcy/|  and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP)   |  what's for dinner.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Case sensitive file names

2001-09-19 Thread Peter Eisentraut

Peter Bierman writes:

 While checking out TOT pgsql today onto an HFS+ file system (case-preserving, 
case-insensitive), I hit the following CVS conflict:

 pgsql/src/backend/utils/mb/Unicode/utf8_to_alt.map 
pgsql/src/backend/utils/mb/Unicode/utf8_to_ALT.map

 HFS+ can not store two differerent files in a path that differs only by case.

Remove both of these files and update again.  The files were recently
renamed to have a consistent case-ness.

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Case sensitive file names

2001-09-19 Thread Peter Eisentraut

Peter Bierman writes:

 At 10:47 PM +0200 9/19/01, Peter Eisentraut wrote:
 Peter Bierman writes:
 
  While checking out TOT pgsql today onto an HFS+ file system (case-preserving, 
case-insensitive), I hit the following CVS conflict:
 
  pgsql/src/backend/utils/mb/Unicode/utf8_to_alt.map 
pgsql/src/backend/utils/mb/Unicode/utf8_to_ALT.map
 
  HFS+ can not store two differerent files in a path that differs only by case.
 
 Remove both of these files and update again.  The files were recently
 renamed to have a consistent case-ness.


 This was from an anoncvs HEAD/TOT checkout I did into an empty directory less than 
an hour ago.

Indeed, someone forgot to remove the old file.  I just removed it a second
ago, so you should be fine now.

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org