Re: [BUGS] Can not compile --with-tcl ???

2003-07-19 Thread Tom Lane
"sam" <[EMAIL PROTECTED]> writes: > I have comiple tcl 8.3.2 and tk 8.3.2 complete > but I want to compile postgresql 7.1.3 with tcl > ./configure --with-tcl --with-tclconfig=3D/usr/local/tcl8.3.2/unix --with-t= > kconfig=3D/usr/local/tk8.3.2/unix > make=20 > gcc -pipe -O2 -Wall -

[BUGS] How can I unsubscribe the mail t list

2003-07-19 Thread yxy
  - Original Message - From: sam To: [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 12:08 AM Subject: [BUGS] Can not compile --with-tcl ??? Hello :         I  have  comiple  tcl 8.3.2  and  tk 8.3.2  complete but  I  want  to 

Re: [GENERAL] [BUGS] INSTEAD rule bug?

2003-07-19 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Dmitry Tkach <[EMAIL PROTECTED]> writes: >>> It would have saved a lot of trouble if it just complained about that >>> union thing right away and refuse to create the rule... >> >> That's what happens in CVS tip. >> > I thought you sa

Re: [GENERAL] [BUGS] INSTEAD rule bug?

2003-07-19 Thread Dmitry Tkach
Tom Lane wrote: Dmitry Tkach <[EMAIL PROTECTED]> writes: It would have saved a lot of trouble if it just complained about that union thing right away and refuse to create the rule... That's what happens in CVS tip. I thought you said it was only complaining about references to new and

[BUGS] Small problem in contrib/dbase/dbf2pg.c

2003-07-19 Thread Thomas Behr
Your name : Thomas Behr Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : ALL Operating System (example: Linux 2.0.26 ELF) : ALL PostgreSQL version (example: PostgreSQL-7.3.3): PostgreSQL

[BUGS] pg_dump handling of trim()

2003-07-19 Thread Troels Arvin
Hello, In a table, I have: create table foo( ..., id_alpha3 character(3) NOT NULL CHECK (character_length(trim(both ' ' from id_alpha3)) = 3), ... ); When I do a pg_dump, pg_dump translates it to: CREATE TABLE foo ( ... id_alpha3 character(3) NOT NULL, ... CONSTRAINT c

[BUGS] PL/PGSQL stat failed on file '$libdir/plpgsql'

2003-07-19 Thread cookfire
Hi, Since Linux Mandrake 9.1 came out, I have this problem with pl/pgsql: [EMAIL PROTECTED] jo]# su postgres bash-2.05b$ createdb test CREATE DATABASE bash-2.05b$ createlang plpgsql test ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation f

Re: [BUGS] PL/PGSQL stat failed on file '$libdir/plpgsql'

2003-07-19 Thread cookfire
After installing all these packages, it seems to work now: [EMAIL PROTECTED] win_e]# urpme postgres The following packages contain postgres: postgresql-7.3.2-5mdk postgresql-tcl-7.3.2-5mdk postgresql-test-7.3.2-5mdk postgresql-docs-7.3.2-5mdk postgresql-python-7.3.2-5mdk postgresql-devel-7.3.2

[BUGS] query regarding database installation

2003-07-19 Thread Deepanshu Garg
Hi, Could u please explain why database installation should not be done using a root user on Linux. What kind of security hole does it tamper? Regards, Deepanshu ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

[BUGS] Timestamp problem

2003-07-19 Thread Raymond Chui
I am use PostgreSQL 7.2.1 in Redhat Linux 7.2 Java 1.4.x When I do JDBC String sql = "SELECT datetime_column FROM mytable"; Timestamp ts = resultSet.getTimestamp(2); If the timestamp return format like 2003-07-15 13:20:00.20+00 then is OK. But if timestamp return like 2003-07-15 13:20:00.

Re: [GENERAL] [BUGS] INSTEAD rule bug?

2003-07-19 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > It would have saved a lot of trouble if it just complained about that > union thing right away and refuse to create the rule... That's what happens in CVS tip. > On a different note, I think there *is* a way to add a where clause to > the union - that'

Re: [GENERAL] [BUGS] INSTEAD rule bug?

2003-07-19 Thread Tom Lane
I said: > Dmitry Tkach <[EMAIL PROTECTED]> writes: >> I thought you said it was only complaining about references to new and >> old, not about *any* union clause... > I don't see a need to reject "any" union clause. AFAIK the cases that > don't work are just the ones where NEW or OLD are referen

[BUGS] Can not compile --with-tcl ???

2003-07-19 Thread sam
Hello :         I  have  comiple  tcl 8.3.2  and  tk 8.3.2  complete but  I  want  to  compile  postgresql 7.1.3  with  tcl   ./configure --with-tcl --with-tclconfig=/usr/local/tcl8.3.2/unix --with-tkconfig=/usr/local/tk8.3.2/unix make and  I  got    the  error       gcc -pipe -O2 -Wall -Wm