Re: [ADMIN] cannot create new user in postgres

2001-03-06 Thread Anatoly K. Lasareff
> "j" == joydip <[EMAIL PROTECTED]> writes: j> Hi all j> I have tried to configure the pg_hba.conf with j> localall j> trust j> host all 127.0.0.1 255.255.255.255 trust j> then i tried to run j> psql -h localhost template1 j> but any of my domain

Re: [ADMIN] There is error at the examples in PL/pgSQL

2001-03-06 Thread Jie Liang
what's version psql you working on?? I pasted your example, it works fine. you might miss something... Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.stbernard.com www.ipinc.com On Mon, 5 Mar 2001, Lu Raymond

[ADMIN] Re: createdb fails - Newbie

2001-03-06 Thread Christian Anton
Found a solution, Copied file libpq.so.2.1 to /var/lib C. Anton "Christian Anton" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Good day all, > > I'm a newbie running latest distro on Linux (RH 7.0, 2.2). I used the RH > supplied RPM's at first and had no pr

Re: [ADMIN] There is error at the examples in PL/pgSQL

2001-03-06 Thread Stephan Szabo
You probably copied it from a machine that uses CR/LF rather than LF as newline. I think 7.1 handles this but earlier ones will fail. Trim the CR characters and it should work. On Mon, 5 Mar 2001, Lu Raymond wrote: > Secondly, I execute exam.sql and the postgress can create the table emp, >

Re: [ADMIN] gmake in /usr/local/src/postgresql-7.1beta5/doc/srcreturn error

2001-03-06 Thread Peter Eisentraut
Grigoriy G. Vovk writes: > Dos anybody know, why I have an error when try to do gmake in the doc/src > directory? You don't have the DocBook 3.1 DTD installed at a place where jade can find it. It might be that you don't have it at all or that the catalog files aren't set up correctly. The Dev

[ADMIN] There is error at the examples in PL/pgSQL

2001-03-06 Thread Lu Raymond
Hello,all I use your a example of PL/pgSQL, but there are some errors when I execute these codes. The details are followings, First, I create a exam.sql that includes these codes as followings, CREATE TABLE emp ( empname text, salary int4, last_date datetime, last_user name); CREA

[ADMIN] cannot create new user in postgres

2001-03-06 Thread joydip
Hi all I have tried to configure the pg_hba.conf with localall trust host all 127.0.0.1 255.255.255.255 trust then i tried to run psql -h localhost template1 but any of my

[ADMIN] Table Size

2001-03-06 Thread Karthikeyan Shanmuganathan
Dear Sir, I would like to know how can I find the size of a table in Oracle. regards, Karthik.S. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] determining DST in TimeZones

2001-03-06 Thread Marc Wrubleski
I have to determine whether the the local time to my users has Daylight Savings Time applied or not, given their timezone (eg MST) and the current timestamp. Is there any way to determine this? So far, I have been able to determine their local time given the timezone and timestamp, but I cannot

Re: [ADMIN] mysql vs postgresql

2001-03-06 Thread Bruce Momjian
> May be faster, but is really faster for multi-access to data (more session > in one time)? > > > Is there any good compares between mysql/postgres and maybe ms-sql or > > something? > > Yes, see postgreSQL.org mailing lists archive or greatbridge.com -- this > is very popular theme :-) >

[ADMIN] gmake in /usr/local/src/postgresql-7.1beta5/doc/src return error

2001-03-06 Thread Grigoriy G. Vovk
Dos anybody know, why I have an error when try to do gmake in the doc/src directory? - Grigoriy G. Vovk out.gz ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "

[ADMIN] error executing plpgsql function

2001-03-06 Thread Salvador Mainé
Hello, I'm using postgresql 6.4. I can define a plpgsql function, but when I execute it I get the following error: dbchse=> select rango (0); ERROR: fmgr_info: function 5410395: cache lookup failed The language is properly defined, and the function works fine with another machine running pos

[ADMIN] createdb fails - Newbie

2001-03-06 Thread Christian Anton
Good day all, I'm a newbie running latest distro on Linux (RH 7.0, 2.2). I used the RH supplied RPM's at first and had no problems excpet a need to identify data directory. Then after reading an interesting article comparing GNU DBMS's (http://www.linuxplanet.com/linuxplanet/tutorials/1224/2/ )

Re: [ADMIN] mysql vs postgresql

2001-03-06 Thread Karel Zak
On Tue, Mar 06, 2001 at 03:34:21PM +0100, Johan Segernäs wrote: > We're going to build up some dynamic pages here, and right now we're using > postgresql > and som php that a consult made for us. > > My question and wonders are; > They say here and there that MySQL i _alot_ faster than PostgreS

[ADMIN] mysql vs postgresql

2001-03-06 Thread Johan Segernäs
Title: mysql vs postgresql We're going to build up some dynamic pages here, and right now we're using postgresql and som php that a consult made for us. My question and wonders are; They say here and there that MySQL i _alot_ faster than PostgreSQL on SELECT-queries. Convince it isn't. Or