[BUGS] problem with TRUNCATE TABLE in plpgsql function

Hi all I played with some own old plpgsql functions. I found "error" in plpgsql 7.3. When I use TRUNCATE TABLE in function I get TRUNCATE TABLE cannot be executed from a function. In 7.2.2. I can use this command. Why, now I can't use truncate table? Thank you Pavel Stehule -

Re: [BUGS] problem with TRUNCATE TABLE in plpgsql function

Pavel Stehule <[EMAIL PROTECTED]> writes: > I played with some own old plpgsql functions. I found "error" in plpgsql > 7.3. When I use TRUNCATE TABLE in function I get > TRUNCATE TABLE cannot be executed from a function. > In 7.2.2. I can use this command. Why, now I can't use truncate table? Thi

Re: [BUGS] hi-problem while installing postgressql 7.2 version

HI thanx, it's true. now this step is clear, but again in the next step postmaster it's giving problem. when i give pg_ctl -D ..., its giving the listed below prblem. can u help me please. thanx in advance once again. santosh kumar singh@SANTOSH /cygdrive/c/cygwin/usr/local/pgsql/bin $

[BUGS] hi-problem in creating database in postgresql 7.2.2

hi i have sucessfully installed postgresql. now while creating database it gives the following error. i'm running pgsqlserver on localhost. i give the command createdb -D /usr/local/share/data/data $ createdb -D /usr/local/share/data/data psql: could not connect to server: No such file or d

[BUGS] Bug with child tables referencing parent table?

POSTGRESQL BUG REPORT TEMPLATE I think I've found a bug (see below). If you think it's not a bug, I would be thankful fo

[BUGS] Fwd: hi-problem in creating database & user in postgresql

Note: forwarded message attached. Missed your favourite TV serial last night? Try the new, Yahoo! TV. visit http://in.tv.yahoo.com --- Begin Message --- hi while creating user in postgresql. i'm giving these comman

[BUGS] hi-problem in postgresql postmaster service

hi when i give the postmaster -D option it gives the error below. although i can start post master through pg_ctl command. but when i connect it through jdbc it gives whether your postmaster is running with -i option. i can't give -i option in pg_ctl. $ /usr/bin/postmaster -D /usr/local/saur

[BUGS] posgresql 7.3beta3 compile error in src/pl/plperl (perl extension)

Hi. I've got a compile-time error when trying to build postgresql 7.3beta3 with perl: ./configure --with-perl make make[4]: Entering directory `/usr/src/postgresql-7.3b3/src/pl/plpgsql/src' make[4]: Nothing to be done for `all'. make[4]: Leaving directory `/usr/src/postgresql-7.3b3/s

Re: [BUGS] posgresql 7.3beta3 compile error in src/pl/plperl (perl extension)

Igor Shevchenko <[EMAIL PROTECTED]> writes: > I've got a compile-time error when trying to build postgresql 7.3beta3 with > perl: > gcc -O2 -fpic -I. -I/usr/lib/perl5/5.8.0/i686-linux-thread-multi-64int-ld/CORE > -I../../../src/include -c -o plperl.o plperl.c > In file included from > /usr/lib

Re: [BUGS] Bug with child tables referencing parent table?

On Thu, 31 Oct 2002, Stefan Schwarzer wrote: > I think I've found a bug (see below). If you think it's not a bug, I > would be thankful for a workaround. I tried omitting the foreign key > constraint. That works but is unsatisfactory. Foreign key constraints reference only the table named in the

Re: [BUGS] hi-problem in creating database in postgresql 7.2.2

PostgreSQL running under Cygwin does not operate with Unix sockets. You need to start the postmaster with TCP/IP sockets. Simply edit your "postgresql.conf" file (it should be in your postgres data directory) and add the line "tcpip_socket = true", and restart your postmaster. All your postgres com

Re: [BUGS] Wrong order of rows in result during regression test.

I have since fixed this in CVS. Would you please retest? --- Magnus Enbom wrote: > > POSTGRESQL BUG REPORT TEMPLATE >

Re: [BUGS] Bug #805: pg_dump examines all tables even with -t "table_name"

We are thinking of adding a per-schema dump option in 7.4. Would that help? --- Vitaliy Fuks wrote: > Hello, > > Could there potentially be an option in addition to -t "table_name", to > either: > > a) Examine all relati

Re: [BUGS] [ADMIN] PostgreSQL Installation on SCO

Have you read the SCO FAQ? http://www.us.postgresql.org/users-lounge/docs/faq.html Also, we are about to release 7.3. Would you please try 7.3beta3 and let us know how that works? --- Shibashish wrote: > Dear Sir,