[Maypole] Maypole and PostgreSQL

[Markus Spring]

This is a multi-part message in MIME format.
--------------060801060504040909070108
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Jan,

finally got my patches working (they originate from Hank Moseley's mail
but had to be reformatted - seems that the listserver munches the patch
format), please find them attached.

First one is the multifield-primarykey patch for Class::DBI::Pg, second
is a patch to Class::DBI::Loader::Pg.pm to induce examination of public
tables only (and thus omitting pg_catalog ones) - quite similar to your
solution, Jan.

Now browsing the beerdb works fine, but not so updating according to
apaches error log:

[Sun May 16 14:42:51 2004] [error] Can't insert new BeerDB::Beer:
DBD::Pg::st execute failed: ERROR:  duplicate key violates unique
constraint "beer_pkey" [for Statement "INSERT INTO beer (name,
id)\nVALUES (?, ?)\n"] at
/usr/local/lib/perl5/site_perl/5.8.4/DBIx/ContextualFetch.pm line 51.\n
at /usr/local/lib/perl5/site_perl/5.8.4/Class/DBI/FromCGI.pm line 246\n

I have explicitly given the web user all privileges for the sequence
table too (see the attached .sql file), otherwise the program would have
stopped one step back trying to find out the value for the key.

So I am stuck again, as a read only database is not *exactly* what I
wanted to achieve with Maypole ;-)

Kind regards

Markus
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAp2X2xxUzQSse11ARAgHcAJ9KndSmrR27bEbXxr7E3BxVZE1e/wCgg2g8
l564BIlwnsEaaxWlfyYPAbE=
=1noz
-----END PGP SIGNATURE-----

--------------060801060504040909070108
Content-Type: application/gzip;
 name="CDBI-Loader-Pg.patch.gz"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="CDBI-Loader-Pg.patch.gz"

H4sICMVip0AAA0NEQkktTG9hZGVyLVBnLnBhdGNoAG1SXU/bMBR9pr/iqlRq0jZxmqaMBVGx
AQ9IaGKCt3WL3OSm8UiTYjsDVHW/fbbTtAFmJZJ9fc7x/TiDwQBIJTjJy5jmJGcLskaeT4lg
EiO9JVP31A3IZU6FIFdfb8htSRPk5G7prldHvuf5jnfq+Ccw9kJvEgae6zULhp667ziOA3t0
4HhTZ6zQQRichOPJB/Tg7dJnBR75HpijFtPHz6B2TgdAVAuIcpVTFOsUUcBGRfVavUJPYJ7C
OYiMpfKsFU8WmQqrcpxZXBYFxtK62Bi0M4sSKqkoKx7j1oaSQxTzkj5aPQUPQ+RcSG6fdYZ7
sfUy+oNcsLJQmjuRQ8yqX7Ob59OSI40zw5R0kaOl752Z2QtbpT+Enbhex3CZYfyoaaqL8MkN
3BdzkBkKbAOP4SGjsi/gdyWkvoYmq5v+CirBiuUIRAlFCSxBCiyFNUetCAVigoniMNFSVADr
TXWzc4Ouc2yvAl8kVIXKX+yKgvO/QNbVImfx3LXcod0jZ+9IDRB64/bVVtcPcKT7Y0Z6aGpk
GL6JWjXdtPVIlaSGwmIJfY6p6JvgxaZbC8zD8Ob+S3erhJ6eLePkMDTDvFsq/v8c509Hk5bj
JsFo6jeOM7mbkSVM7NyjH9yqX+WuDdnq2aZllKacnR0PF7UdP4SF1OH6LTWqNeVode+vb68v
H5rZWnZ370WNd2b4gnEl8aBj9RQ20qY1ndSYFGWc8fI5opzT17f8lBVMZO/ohrqT0aNdkV93
pZBLjvffb8H6MU/m7s/NZGvvp8xRVrwwJB3a1q6uZzvW7VJfFF1/u4qizj8FU68IhgQAAA==
--------------060801060504040909070108
Content-Type: application/gzip;
 name="CDBI-Pg.patch.gz"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="CDBI-Pg.patch.gz"

H4sICExip0AAA0NEQkktUGcucGF0Y2gAzVRbT9swFH4uv+LQZJC0TZzeGC2idBekTdoD2x72
QEplUpdGOBfsZKNC3W+f7cZZoGODDaT5oYqPv3POdy5fG40GoJwzRJMAU0TDc5QSRvuIhxmZ
yk/Ud/fdHnpDMefo7ev36OTCTaNax/O6jjdw2h54g2F/MOx5rqcPND3xvuU4DpTonuP1nfYe
tNvDfnfY3UQ3bh95h0631RmAugJ8eXf86RgYoTGOCBzCkS2Mnz9+EL/ymDxbOCNyTYI8I5aZ
4XNK7IOtbfUYLcFMWRjnkXBcI+ckCxYs+TbFjOHlwa0o8zAO+ULaCrMBwjQDTCkECc2jmKvq
BL+uB+LL+Qd+xgMJlpW8KIERTuEGzCkcjqANq+LOUxpmgHzeRML2NNX+ajq9/dbenp7Ob0qE
grhlxuQ6+4rplGfMftQgtssQnFzlJA6I8q/Eg8PvEKGzwuJbu/Uj6/Ssvjtp2vWj3eEwEw++
jVSVZbSxKI+3VOcjzJYl13nCCA4WaioCYo3Nog823AhIzQB+GaYwY0maklnRJFc61yQBCOfK
zxmdehNJDJ35bjO98N3Cw3f9WVOYTMWnluZ8AZqL9pNFr6PlMSWcl/uxs6NB7QmQK21XeF2J
bE4ZSI91VRQ+DViCL636ekCwwBziBLTnJVnW7WpOaS2nEsj/AWekPO+KTD8WvbJONJfRZofv
Yl+JXRM41YQNkJ55dfqyxfom8SslyN6g9bKnBfncK2k82U4+2XoXkeSRDaoEKBZfc97c/Lui
GP+vojAeqwrjPln8bNY6WYGq5FOk15FuKvFXBxVJGX+tqUfLcVxxVWkZyXIW62drY2b36tV4
uGD/KG6dFZ5T3T8Ax8qR4KoIAAA=
--------------060801060504040909070108
Content-Type: application/gzip;
 name="beer.sql.gz"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="beer.sql.gz"

H4sICIdhp0AAA2JlZXIuc3FsAKWV227aQBCGr/FTzGWQLFOnh4vmyga3QnFs5DiVkCJFPmxh
FWLc3TWUt+8ebALOxqxShGRpdmc8//cPwyyJF5B6fhhA3eQbXDg5QuTGmiaBlwbtiQjBlQX8
g0ugiOBsA1GcQvQQhraM5wTtETkArhhaIaKClB026DxUZS8IinVGsoLxoruMHHC1uvr8aazO
G7LRHLvX3TkttqRXsia40NV0r9ucLN/pjruS1ZYhCgz9Zdb4xvqZeFEKXhhCHJ3KT2PY7/cU
UYq3lfbaCb8nXD5R9KefNI0XyxYmLu2Oma042ZKNLQjYSqatpNlCgK3aHMOPJL7jCSXm9dyR
O3qMRjFZZRUuwEeUgY8ZVynC6vvFEXesR8fywjRI2l7jKFSdSALebAbTOLpPE2/OVUkF9TM6
wCKZ33nJEm6DpWiZ47FmbwdGyejPTDsQw2PzsXH4am5d24W5eyph0MBOmfDwxDOtQfcMFoj3
TsFXaaM1Y/X3yYSXdSir5Vlb0Sm2TvM8edcudUvrWNu1uWly5HqWqZ/rhwz7ZuyIeomxH/L6
kBtt069eaGzQ0ZR5OpbqjeYk11lV1s1L3YPZhS/tTbENztdZk3cBgTAJfsW3wTmbY20pcvHg
h/OpFuLxojHvLmMI+as0ucW4Alukv91NrpZ8l66Df3y9OX/+6KEXBP9vii/9C12cctGCMXP+
GMIt5ZjsmrQhvyHNdohUavlr8fNyOvKiiXeg/wPdfOrSJAgAAA==
--------------060801060504040909070108--