[HACKERS] anyone actively follow this group?

[Raoul Callaghan]

Title: anyone actively follow this group?



Can someone point me to an active postgres listing..

this one seems a bit “slow”(no offense intended)...

[HACKERS] "select for update" question....

[Raoul Callaghan]

Title: "select for update" question



Hello,

As I understand it:
Issuing a “select for update” within a transaction will prevent other users from modifying data. (exclusive lock)

I’m contemplating using the DBI interface as a permanent client to postgres for a group of users, and have a few questions.

Will the above procedure still exclusively lock the row, when using a browser to issue a “select for update”?
I’m confused about sth->finish; and will it finish the transaction, before the user re-submits the form data to update the row

Can anyone help me or offer some “howtos” to read regarding postgres and DBI?  

thanks.

Raoul.

[HACKERS] perlDBD::pg error! Please help (have all details in post)

[Raoul Callaghan]

Title: perlDBD::pg error! Please help (have all details in  post)



Have attempted  to install DBI and DBD, but DBD “make test” fails.
Below is my complete  procedure , starting from:

Accessing  PostgreSQL from the command line, (successful)
 creating  a database, populating. (successful)
Expanding  DBI and DBD. (successful)
Installing  DBI  (seemingly successful)
Set environments. (successful)
Install DBD.  (error occur on “test”)

So now I’m hoping someone can help me out

I think I have included all the version information throughout the procedure.  
if not please let me know.


Any assistance  would be greatly appreciated.




#LOG  OF TELNET SESSION##

Linux/PPC 2000 Q4
Packages current to December 25 2000
Kernel 2.2.18-4hpmac on a ppc
login: ausit
Password:
Last login: Sun Apr 29 06:15:07 from 192.168.168.50
[ausit@pivot ausit]$ su
Password:

#ACCESSING  POSTGRES##

[root@pivot ausit]# su postgres
bash-2.04$ psql -V
psql (PostgreSQL) 7.0.3
contains readline, history, multibyte support
Portions Copyright (c) 1996-2000, PostgreSQL, Inc
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
bash-2.04$ createdb post_demo
CREATE DATABASE
bash-2.04$ psql post_demo
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
   \h for help with SQL commands
   \? for help on internal slash commands
   \g or terminate with semicolon to execute query
   \q to quit

post_demo=# \d
No relations found.
post_demo=# create table test_class (yeh int4, nah text);
CREATE
post_demo=# insert into test_class (yeh, nah) values (123,'one_two_three');
INSERT 19082 1
post_demo=# select * from test_class ;
 yeh |  nah
-+---
 123 | one_two_three
(1 row)

post_demo=# \q
bash-2.04$ exit
exit
[root@pivot ausit]# exit
exit

#EXPANDING    DBI AND   DBD##

[ausit@pivot ausit]$ ls
Desktop  src
[ausit@pivot ausit]$ cd src
[ausit@pivot src]$ ll
total 3208
-rwxr-xr-x    1 ausit    ausit  174080 Apr 29 02:26 DBD-Pg-0.98.tar
-rwxr-xr-x    1 ausit    ausit  632320 Apr 29 02:26 DBI-1.15.tar
-rwxr-xr-x    1 ausit    ausit  456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm
-rwxr-xr-x    1 ausit    ausit  110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r
-rwxr-xr-x    1 ausit    ausit  473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc.
-rwxr-xr-x    1 ausit    ausit 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp
-rwxr-xr-x    1 ausit    ausit   18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r
drwxr-xr-x    4 ausit    ausit    4096 Apr 29 08:07 pg
-rw-r--r--    1 ausit    ausit  284204 Apr 29 02:52 tar-1.13.17-5.ppc.rpm
[ausit@pivot src]$ tar xvf DBD-Pg-0.98.tar
DBD-Pg-0.98/
DBD-Pg-0.98/eg/
DBD-Pg-0.98/eg/ApacheDBI.pl
DBD-Pg-0.98/Changes
DBD-Pg-0.98/MANIFEST
DBD-Pg-0.98/Makefile.PL
DBD-Pg-0.98/Pg.h
DBD-Pg-0.98/Pg.pm
DBD-Pg-0.98/Pg.xs
DBD-Pg-0.98/README
DBD-Pg-0.98/README.win32
DBD-Pg-0.98/dbd-pg.pod
DBD-Pg-0.98/dbdimp.c
DBD-Pg-0.98/dbdimp.h
DBD-Pg-0.98/test.pl
[ausit@pivot src]$ tar xvf DBI-1.15.tar
DBI-1.15/
DBI-1.15/lib/
DBI-1.15/lib/DBD/
DBI-1.15/lib/DBD/ExampleP.pm
DBI-1.15/lib/DBD/Proxy.pm
DBI-1.15/lib/DBD/NullP.pm
DBI-1.15/lib/DBD/Sponge.pm
DBI-1.15/lib/DBD/Multiplex.pm
DBI-1.15/lib/DBD/ADO.pm
DBI-1.15/lib/DBI/
DBI-1.15/lib/DBI/Shell.pm
DBI-1.15/lib/DBI/FAQ.pm
DBI-1.15/lib/DBI/ProxyServer.pm
DBI-1.15/lib/DBI/DBD.pm
DBI-1.15/lib/DBI/W32ODBC.pm
DBI-1.15/lib/DBI/Format.pm
DBI-1.15/lib/Bundle/
DBI-1.15/lib/Bundle/DBI.pm
DBI-1.15/lib/Win32/
DBI-1.15/lib/Win32/DBIODBC.pm
DBI-1.15/DBI.xs
DBI-1.15/t/
DBI-1.15/t/meta.t
DBI-1.15/t/dbidrv.t
DBI-1.15/t/examp.t
DBI-1.15/t/subclass.t
DBI-1.15/t/proxy.t
DBI-1.15/t/basics.t
DBI-1.15/t/shell.t
DBI-1.15/Perl.xs
DBI-1.15/DBIXS.h
DBI-1.15/MANIFEST
DBI-1.15/Driver.xst
DBI-1.15/Changes
DBI-1.15/dbipport.h
DBI-1.15/Makefile.PL
DBI-1.15/test.pl
DBI-1.15/README
DBI-1.15/dbd_xsh.h
DBI-1.15/dbish.PL
DBI-1.15/dbi_sql.h
DBI-1.15/ToDo
DBI-1.15/DBI.pm
DBI-1.15/dbiproxy.PL
[ausit@pivot src]$ ll
total 3216
drwxr-xr-x    3 ausit    ausit    4096 Apr 25 21:50 DBD-Pg-0.98
-rwxr-xr-x    1 ausit    ausit  174080 Apr 29 02:26 DBD-Pg-0.98.tar
drwxr-xr-x    4 ausit    ausit    4096 Mar 31 00:57 DBI-1.15
-rwxr-xr-x    1 ausit    ausit  632320 Apr 29 02:26 DBI-1.15.tar
-rwxr-xr-x    1 ausit    ausit  456331 Apr 29 02:26 apache-1.3.14-2.6.2.ppc.rpm
-rwxr-xr-x    1 ausit    ausit  110724 Apr 29 02:26 apache-devel-1.3.14-2.6.2.ppc.r
-rwxr-xr-x    1 ausit    ausit  473057 Apr 29 02:26 apache-manual-1.3.14-2.6.2.ppc.
-rwxr-xr-x    1 ausit    ausit 1083848 Apr 29 02:26 apache-ssl-1.3.12_1.40-1.ppc.rp
-rwxr-xr-x    1 ausit    ausit   18089 Apr 29 02:26 perl-Mail-Sendmail-0.77-6.ppc.r
drwxr-xr-x    4 ausit    ausit    4096 Apr 29 08:07 pg
-rw-r--r--    1 ausit    ausit  284204 Apr 29 02:52 tar-1.13