sql-ledger-users

[SL] Upgrade problem

[Robert I. <ri...@ra...>]

Hi

Upgraded to 2.4 from 2.2.5. Have similar problem to others, but can't 
find a fix that works.

On first load of the upgrade, it looks to upgrade the db and I get the 
error:

Error!
...............
return NULL;
end;
' language 'plpgsql';

ERROR: language "plpgsql" does not exist

On entering:   psql template1 -U postgres -l

I get
          List of databases
    Name    |   Owner    | Encoding
-----------+------------+-----------
  Standard  | sql-ledger | SQL_ASCII
  template0 | postgres   | SQL_ASCII
  template1 | postgres   | SQL_ASCII
  test      | sql-ledger | SQL_ASCII
(4 rows)

but trying to run any of the following results in:

root@barnum sql-ledger # createlang plpgsql test
createlang: could not connect to database test: FATAL:  user "root" does 
not exist
root@barnum sql-ledger # createlang plpgsql Standard
createlang: could not connect to database Standard: FATAL:  user "root" 
does not exist
root@barnum sql-ledger # createlang plpgsql template1
createlang: could not connect to database template1: FATAL:  user "root" 
does not exist
root@barnum sql-ledger # createlang plpgsql template1
createlang: could not connect to database template1: FATAL:  user "root" 
does not exist

So I tried:

root@barnum sql-ledger # dropuser sql-ledger
dropuser: could not connect to database template1: FATAL:  user "root" 
does not exist

I am loathe to try "dropdb" as this will presumably remove all previous 
data?

Appreciate any help

Robert

[SL] Upgrade problem

[Adrian B. <adr...@ie...>]

I was forced to do an upgrade and now have the following error:

DBD::Pg::st execute failed: ERROR: column o.oid does not exist
.
.
.

ERROR: column o.oid does not exist


The FAQ has the following :Drop the tables and rebuild WITH OIDS

I have my O'Reilly " Practical PostgreSQL" handy, but still do not understand how to "Drop the tables and rebuild WITH OIDS"

Adrian
-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Upgrade problem

[Dieter S. <dsi...@sq...>]

edit the backup you made with SQL-Ledger,
change the tables orderitems, inventory and assembly and add 'WITH OIDS'
(see the FAQ)
restore the backup with psql

psql -U sql-ledger dbname < backup.sql

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Tue, 28 Nov 2006, Adrian Blake wrote:

> I was forced to do an upgrade and now have the following error:
>
> DBD::Pg::st execute failed: ERROR: column o.oid does not exist
> .
> .
> .
>
> ERROR: column o.oid does not exist
>
>
> The FAQ has the following :Drop the tables and rebuild WITH OIDS
>
> I have my O'Reilly " Practical PostgreSQL" handy, but still do not understand how to "Drop the tables and rebuild WITH OIDS"
>
> Adrian
>

Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Progress:

the error is now:

DBD::Pg::st execute failed: ERROR: column t.validto does not exist
.
.
.

ERROR: column t.validto does not exist

I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
postgres 7.? to 8.1.?

Adrian

Dieter Simader wrote:
> edit the backup you made with SQL-Ledger,
> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
> (see the FAQ)
> restore the backup with psql
> 
> psql -U sql-ledger dbname < backup.sql
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Upgrade problem

[Paul T. <pt...@wa...>]

Adrian Blake schreef:
> Progress:
>
> the error is now:
>
> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
> .
> .
> .
>
> ERROR: column t.validto does not exist
>
> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
> postgres 7.? to 8.1.?
>
> Adrian
>
> Dieter Simader wrote:
>   
>> edit the backup you made with SQL-Ledger,
>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>> (see the FAQ)
>> restore the backup with psql
>>
>> psql -U sql-ledger dbname < backup.sql
>>
>>     
>
>   
Had the same here some time ago, the SQL-Ledger internal backup (you did 
make one I hope) was my rescue.
Clean install of System on a new computer, including latest of 
everything, then unzip the sql-ledger backed up file.
Look at version, install latest SQL-Ledger and carefully read any 
remarks about uodating from older versions.
Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
Rather then hacking in files I suggest using some of the update scripts 
in the tar-balls.
You should be up and running that way in half a day..

BTW, this is also a good way to transfer complete set of accounts from 
say customer to bookkeeper.
If customer uses SQL-Ledger and bookkeeper is at least able to do the 
same that is.
Add any needed year end corrections, like salary journal entries and 
some amortisation.
Do yearend report and return to customer.

Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Problem was solved by installing postgres 7.3 and pointing to the old data files. Upgrade sql-ledger to latest. backup sql-ledger 
& pg_dumpall. Stopping old postgres. start postgres 8.1. edit data, i.e. output file pg_dumpall. restore database data.

Now it all works.

Thanks for assistance.

Adrian

Paul Tammes wrote:
> Adrian Blake schreef:
>> Progress:
>>
>> the error is now:
>>
>> DBD::Pg::st execute failed: ERROR: column t.validto does not exist
>> .
>> .
>> .
>>
>> ERROR: column t.validto does not exist
>>
>> I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
>> postgres 7.? to 8.1.?
>>
>> Adrian
>>
>> Dieter Simader wrote:
>>   
>>> edit the backup you made with SQL-Ledger,
>>> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
>>> (see the FAQ)
>>> restore the backup with psql
>>>
>>> psql -U sql-ledger dbname < backup.sql
>>>
>>>     
>>   
> Had the same here some time ago, the SQL-Ledger internal backup (you did 
> make one I hope) was my rescue.
> Clean install of System on a new computer, including latest of 
> everything, then unzip the sql-ledger backed up file.
> Look at version, install latest SQL-Ledger and carefully read any 
> remarks about uodating from older versions.
> Sounds like you not only uograded PostgreSQL from 7 to 8 to me.
> Rather then hacking in files I suggest using some of the update scripts 
> in the tar-balls.
> You should be up and running that way in half a day..
> 
> BTW, this is also a good way to transfer complete set of accounts from 
> say customer to bookkeeper.
> If customer uses SQL-Ledger and bookkeeper is at least able to do the 
> same that is.
> Add any needed year end corrections, like salary journal entries and 
> some amortisation.
> Do yearend report and return to customer.
> 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Upgrade problem

[Roy W P. <arc...@mt...>]

Unfortunately Createlang does not allow you to specify the postgresql username 
so it uses the username you are logged in as. In your case.... root.
Since root is not a postgresql user in your configuration, you get the error.


You have 2 choices.

Either install the plpgsql language handler  manually as explained in the 
postgresql docs.

or

when logged in as root...

"su  postgres" 


and then use the 
"createlang plpgsql template1"
"createlang plpgsql Standard"
"createlang plpgsql test"

An import note that some people don't realize is that the template1 database 
is exactly that..... a template.
Anytime you create a new database, postgresql makes a copy of the  template1 
database.


Cheers,
Roy 

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[ms m. l. <ms-...@sk...>]

I have the same problem,  but get an additional error:

su postgres
createlang -L/usr/lib/pgsql  plpgsql  template1
ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or 
directory
createlang: language installation failed

In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking 
in that directory I see a bunch of "*.so" files, but "plpgsql.so" file 
is missing - I  believe this is the file that createlang is looking 
for.  Where can I get this file or am I on the wrong track.  Using  
postgresql 7.3.4,  that came with mandrake.

Michael S.

Roy W Pennington wrote:

>Unfortunately Createlang does not allow you to specify the postgresql username 
>so it uses the username you are logged in as. In your case.... root.
>Since root is not a postgresql user in your configuration, you get the error.
>
>
>You have 2 choices.
>
>Either install the plpgsql language handler  manually as explained in the 
>postgresql docs.
>
>or
>
>when logged in as root...
>
>"su  postgres" 
>
>
>and then use the 
>"createlang plpgsql template1"
>"createlang plpgsql Standard"
>"createlang plpgsql test"
>
>An import note that some people don't realize is that the template1 database 
>is exactly that..... a template.
>Anytime you create a new database, postgresql makes a copy of the  template1 
>database.
>
>
>Cheers,
>Roy 
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>_______________________________________________
>sql-ledger-users mailing list
>sql...@sq...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>

Re: [SL] Upgrade problem

[Dr E. W L. <el...@li...>]

Roy

Roy W Pennington wrote:

> Either install the plpgsql language handler  manually as explained in the 
> postgresql docs.

The above is abbreviated as RTFM

:-)-O

el
-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN /   *   |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     / Please send DNS/NA-NiC related e-mail
Bachbrecht, Namibia     ;____/             to dns...@na...

Re: [SL] Upgrade problem

[Tony F. <to...@sy...>]

On Thu, 2004-08-12 at 10:59, Robert Irving wrote:
> On entering:   psql template1 -U postgres -l
> 
> I get
>           List of databases
>     Name    |   Owner    | Encoding
> -----------+------------+-----------
>   Standard  | sql-ledger | SQL_ASCII
>   template0 | postgres   | SQL_ASCII
>   template1 | postgres   | SQL_ASCII
>   test      | sql-ledger | SQL_ASCII
> (4 rows)
> 
> but trying to run any of the following results in:
> 
> root@barnum sql-ledger # createlang plpgsql test
> createlang: could not connect to database test: FATAL:  user "root" does 
> not exist
> root@barnum sql-ledger # createlang plpgsql Standard
> createlang: could not connect to database Standard: FATAL:  user "root" 
> does not exist
> root@barnum sql-ledger # createlang plpgsql template1
> createlang: could not connect to database template1: FATAL:  user "root" 
> does not exist
> root@barnum sql-ledger # createlang plpgsql template1
> createlang: could not connect to database template1: FATAL:  user "root" 
> does not exist
> 

Your on the right track here but not quite there...

The postgrsql command line tools connect to the DB using your current
UNIX userid unless you specifify a different one. You have a couple
options:

# su - postgres
# createlang plpgsl test
# createlang plpgsl Standard
# createlang plpgsl template1

- or -

# createlang -U sql-ledger plpgsl test
# createlang -U sql-ledger plpgsl Standard
# createlang -U postgres plpgsl template1 ### I'm not 100% this works


-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398

Re: [SL] Upgrade problem

[Roy W P. <arc...@mt...>]

On August 12, 2004 03:53 pm, Tony Fraser wrote:
> # createlang -U sql-ledger plpgsl test
> # createlang -U sql-ledger plpgsl Standard
> # createlang -U postgres plpgsl template1 ### I'm not 100% this works


Hmmm.... sorry  don't know what i've been drinking.... been a long rough day.
createlang does in fact accept a -U username switch.

Cheers,
Roy

Re: [SL] Upgrade problem

[Pedro T. <pt...@te...>]

> root@barnum sql-ledger # createlang plpgsql test
> createlang: could not connect to database test: FATAL:  user "root" does
> not exist

root doesn't exist in your database. Do the following;

root@barnum sql-ledger # su postgres
postgres@barnum sql-ledger$ createlang plpgsql test

That'll do.

Regards,
Pedro

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[James P. K. I. <jk...@lo...>]

Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl
<filename>.rpm |grep plpgsql  to find which one has the lang.

My latest Fedora setup has the .so files in the same place as yours but
the plpgsql.so file is there. It really sounds like an installation
issue.

There's always the source install...

On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
> I have the same problem,  but get an additional error:
>=20
> su postgres
> createlang -L/usr/lib/pgsql  plpgsql  template1
> ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or=20
> directory
> createlang: language installation failed
>=20
> In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking=20
> in that directory I see a bunch of "*.so" files, but "plpgsql.so" file=20
> is missing - I  believe this is the file that createlang is looking=20
> for.  Where can I get this file or am I on the wrong track.  Using =20
> postgresql 7.3.4,  that came with mandrake.
>=20
> Michael S.
>=20
> Roy W Pennington wrote:
>=20
> >Unfortunately Createlang does not allow you to specify the postgresql us=
ername=20
> >so it uses the username you are logged in as. In your case.... root.
> >Since root is not a postgresql user in your configuration, you get the e=
rror.
> >
> >
> >You have 2 choices.
> >
> >Either install the plpgsql language handler  manually as explained in th=
e=20
> >postgresql docs.
> >
> >or
> >
> >when logged in as root...
> >
> >"su  postgres"=20
> >
> >
> >and then use the=20
> >"createlang plpgsql template1"
> >"createlang plpgsql Standard"
> >"createlang plpgsql test"
> >
> >An import note that some people don't realize is that the template1 data=
base=20
> >is exactly that..... a template.
> >Anytime you create a new database, postgresql makes a copy of the  templ=
ate1=20
> >database.
> >
> >
> >Cheers,
> >Roy=20
> >
> >
> >-------------------------------------------------------
> >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> >_______________________________________________
> >sql-ledger-users mailing list
> >sql...@sq...
> >https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > =20
> >
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> sql-ledger-users mailing list
> sql...@sq...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20
> !DSPAM:411cf5dc134739290718234!
--=20
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jk...@lo...>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[ms m. l. <ms-...@sk...>]

I've just checked  the rpms for postgresql for all linuxs. Some contain 
the missing file (plpgsql.so) and some don't. Unfortunately both 
mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate to 
have to switch Linux OS just to get  SQL-ledger back up and running.

Michael S.

James P. Kinney III wrote:

>Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl
><filename>.rpm |grep plpgsql  to find which one has the lang.
>
>My latest Fedora setup has the .so files in the same place as yours but
>the plpgsql.so file is there. It really sounds like an installation
>issue.
>
>There's always the source install...
>
>On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
>  
>
>>I have the same problem,  but get an additional error:
>>
>>su postgres
>>createlang -L/usr/lib/pgsql  plpgsql  template1
>>ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or 
>>directory
>>createlang: language installation failed
>>
>>In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking 
>>in that directory I see a bunch of "*.so" files, but "plpgsql.so" file 
>>is missing - I  believe this is the file that createlang is looking 
>>for.  Where can I get this file or am I on the wrong track.  Using  
>>postgresql 7.3.4,  that came with mandrake.
>>
>>Michael S.
>>
>>Roy W Pennington wrote:
>>
>>    
>>
>>>Unfortunately Createlang does not allow you to specify the postgresql username 
>>>so it uses the username you are logged in as. In your case.... root.
>>>Since root is not a postgresql user in your configuration, you get the error.
>>>
>>>
>>>You have 2 choices.
>>>
>>>Either install the plpgsql language handler  manually as explained in the 
>>>postgresql docs.
>>>
>>>or
>>>
>>>when logged in as root...
>>>
>>>"su  postgres" 
>>>
>>>
>>>and then use the 
>>>"createlang plpgsql template1"
>>>"createlang plpgsql Standard"
>>>"createlang plpgsql test"
>>>
>>>An import note that some people don't realize is that the template1 database 
>>>is exactly that..... a template.
>>>Anytime you create a new database, postgresql makes a copy of the  template1 
>>>database.
>>>
>>>
>>>Cheers,
>>>Roy 
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>_______________________________________________
>>>sql-ledger-users mailing list
>>>sql...@sq...
>>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>> 
>>>
>>>      
>>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>_______________________________________________
>>sql-ledger-users mailing list
>>sql...@sq...
>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>!DSPAM:411cf5dc134739290718234!
>>    
>>

Re: [SL] Upgrade problem - 2nd problem with creatlang =?iso-8859-1?q?under=09Mandrake?=

[Gerardo R. <gre...@te...>]

On Friday 13 August 2004 13:12, ms mailing list wrote:
> I've just checked  the rpms for postgresql for all linuxs. Some contain
> the missing file (plpgsql.so) and some don't. Unfortunately both
> mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate to
> have to switch Linux OS just to get  SQL-ledger back up and running.
>

Maybe in another package, er rpm like postgres-lib lib-postgres or postgres- 
devel?

> Michael S.
>
> James P. Kinney III wrote:
> >Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl
> ><filename>.rpm |grep plpgsql  to find which one has the lang.
> >
> >My latest Fedora setup has the .so files in the same place as yours but
> >the plpgsql.so file is there. It really sounds like an installation
> >issue.
> >
> >There's always the source install...
> >
> >On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
> >>I have the same problem,  but get an additional error:
> >>
> >>su postgres
> >>createlang -L/usr/lib/pgsql  plpgsql  template1
> >>ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or
> >>directory
> >>createlang: language installation failed
> >>
> >>In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking
> >>in that directory I see a bunch of "*.so" files, but "plpgsql.so" file
> >>is missing - I  believe this is the file that createlang is looking
> >>for.  Where can I get this file or am I on the wrong track.  Using
> >>postgresql 7.3.4,  that came with mandrake.
> >>
> >>Michael S.
> >>
> >>Roy W Pennington wrote:
> >>>Unfortunately Createlang does not allow you to specify the postgresql
> >>> username so it uses the username you are logged in as. In your case....
> >>> root. Since root is not a postgresql user in your configuration, you
> >>> get the error.
> >>>
> >>>
> >>>You have 2 choices.
> >>>
> >>>Either install the plpgsql language handler  manually as explained in
> >>> the postgresql docs.
> >>>
> >>>or
> >>>
> >>>when logged in as root...
> >>>
> >>>"su  postgres"
> >>>
> >>>
> >>>and then use the
> >>>"createlang plpgsql template1"
> >>>"createlang plpgsql Standard"
> >>>"createlang plpgsql test"
> >>>
> >>>An import note that some people don't realize is that the template1
> >>> database is exactly that..... a template.
> >>>Anytime you create a new database, postgresql makes a copy of the 
> >>> template1 database.
> >>>
> >>>
> >>>Cheers,
> >>>Roy
> >>>
> >>>
> >>>-------------------------------------------------------
> >>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> >>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> >>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> >>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> >>>_______________________________________________
> >>>sql-ledger-users mailing list
> >>>sql...@sq...
> >>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>-------------------------------------------------------
> >>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> >>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> >>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> >>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> >>_______________________________________________
> >>sql-ledger-users mailing list
> >>sql...@sq...
> >>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >>
> >>!DSPAM:411cf5dc134739290718234!
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> sql-ledger-users mailing list
> sql...@sq...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[ms m. l. <ms-...@sk...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks for the tip Gerado. plpgsql.so buried&nbsp; in
postgresql-7.3.4-2mdk.src.rpm. It looks like the Mandrake rpm install
doesn't list this module, but does list some other modules in this rpm.
Hence my problem finding it. :)<br>
<br>
Michael S.<br>
<br>
Gerardo Reynoso wrote:<br>
<blockquote cite="mid...@te..."
 type="cite">
  <pre wrap="">On Friday 13 August 2004 13:12, ms mailing list wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I've just checked  the rpms for postgresql for all linuxs. Some contain
the missing file (plpgsql.so) and some don't. Unfortunately both
mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate to
have to switch Linux OS just to get  SQL-ledger back up and running.

    </pre>
  </blockquote>
  <pre wrap=""><!---->
Maybe in another package, er rpm like postgres-lib lib-postgres or postgres- 
devel?

  </pre>
  <blockquote type="cite">
    <pre wrap="">Michael S.

James P. Kinney III wrote:
    </pre>
    <blockquote type="cite">
      <pre wrap="">Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl
&lt;filename&gt;.rpm |grep plpgsql  to find which one has the lang.

My latest Fedora setup has the .so files in the same place as yours but
the plpgsql.so file is there. It really sounds like an installation
issue.

There's always the source install...

On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
      </pre>
      <blockquote type="cite">
        <pre wrap="">I have the same problem,  but get an additional error:

su postgres
createlang -L/usr/lib/pgsql  plpgsql  template1
ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or
directory
createlang: language installation failed

In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking
in that directory I see a bunch of "*.so" files, but "plpgsql.so" file
is missing - I  believe this is the file that createlang is looking
for.  Where can I get this file or am I on the wrong track.  Using
postgresql 7.3.4,  that came with mandrake.

Michael S.

Roy W Pennington wrote:
        </pre>
        <blockquote type="cite">
          <pre wrap="">Unfortunately Createlang does not allow you to specify the postgresql
username so it uses the username you are logged in as. In your case....
root. Since root is not a postgresql user in your configuration, you
get the error.


You have 2 choices.

Either install the plpgsql language handler  manually as explained in
the postgresql docs.

or

when logged in as root...

"su  postgres"


and then use the
"createlang plpgsql template1"
"createlang plpgsql Standard"
"createlang plpgsql test"

An import note that some people don't realize is that the template1
database is exactly that..... a template.
Anytime you create a new database, postgresql makes a copy of the 
template1 database.


Cheers,
Roy


-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink &amp; Toner - Free Shipping and Free Gift.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
          </pre>
        </blockquote>
        <pre wrap="">-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink &amp; Toner - Free Shipping and Free Gift.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>

!DSPAM:411cf5dc134739290718234!
        </pre>
      </blockquote>
    </blockquote>
    <pre wrap="">-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink &amp; Toner - Free Shipping and Free Gift.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>
    </pre>
  </blockquote>
  <pre wrap=""><!---->

-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink &amp; Toner - Free Shipping and Free Gift.
<a class="moz-txt-link-freetext" href="http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285">http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285</a>
_______________________________________________
sql-ledger-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sql...@sq...">sql...@sq...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sql-ledger-users">https://lists.sourceforge.net/lists/listinfo/sql-ledger-users</a>

  </pre>
</blockquote>
</body>
</html>

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[James P. K. I. <jk...@lo...>]

So it looks like you will need to get the src.rpm and compile your own
version since it is not included in the binaries.

Maybe I shouldn't say it, but Fedora has a great working Postgresql :)



On Fri, 2004-08-13 at 14:40, ms mailing list wrote:
> Thanks for the tip Gerado. plpgsql.so buried  in
> postgresql-7.3.4-2mdk.src.rpm. It looks like the Mandrake rpm install
> doesn't list this module, but does list some other modules in this
> rpm. Hence my problem finding it. :)
>=20
> Michael S.
>=20
> Gerardo Reynoso wrote:
> > On Friday 13 August 2004 13:12, ms mailing list wrote:
> >  =20
> > > I've just checked  the rpms for postgresql for all linuxs. Some conta=
in
> > > the missing file (plpgsql.so) and some don't. Unfortunately both
> > > mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate=
 to
> > > have to switch Linux OS just to get  SQL-ledger back up and running.
> > >=20
> > >    =20
> >=20
> > Maybe in another package, er rpm like postgres-lib lib-postgres or post=
gres-=20
> > devel?
> >=20
> >  =20
> > > Michael S.
> > >=20
> > > James P. Kinney III wrote:
> > >    =20
> > > > Try a reinstall of the postgresql rpm's. Double-check them with rpm=
 -qpl
> > > > <filename>.rpm |grep plpgsql  to find which one has the lang.
> > > >=20
> > > > My latest Fedora setup has the .so files in the same place as yours=
 but
> > > > the plpgsql.so file is there. It really sounds like an installation
> > > > issue.
> > > >=20
> > > > There's always the source install...
> > > >=20
> > > > On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
> > > >      =20
> > > > > I have the same problem,  but get an additional error:
> > > > >=20
> > > > > su postgres
> > > > > createlang -L/usr/lib/pgsql  plpgsql  template1
> > > > > ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such fil=
e or
> > > > > directory
> > > > > createlang: language installation failed
> > > > >=20
> > > > > In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. =
Looking
> > > > > in that directory I see a bunch of "*.so" files, but "plpgsql.so"=
 file
> > > > > is missing - I  believe this is the file that createlang is looki=
ng
> > > > > for.  Where can I get this file or am I on the wrong track.  Usin=
g
> > > > > postgresql 7.3.4,  that came with mandrake.
> > > > >=20
> > > > > Michael S.
> > > > >=20
> > > > > Roy W Pennington wrote:
> > > > >        =20
> > > > > > Unfortunately Createlang does not allow you to specify the post=
gresql
> > > > > > username so it uses the username you are logged in as. In your =
case....
> > > > > > root. Since root is not a postgresql user in your configuration=
, you
> > > > > > get the error.
> > > > > >=20
> > > > > >=20
> > > > > > You have 2 choices.
> > > > > >=20
> > > > > > Either install the plpgsql language handler  manually as explai=
ned in
> > > > > > the postgresql docs.
> > > > > >=20
> > > > > > or
> > > > > >=20
> > > > > > when logged in as root...
> > > > > >=20
> > > > > > "su  postgres"
> > > > > >=20
> > > > > >=20
> > > > > > and then use the
> > > > > > "createlang plpgsql template1"
> > > > > > "createlang plpgsql Standard"
> > > > > > "createlang plpgsql test"
> > > > > >=20
> > > > > > An import note that some people don't realize is that the templ=
ate1
> > > > > > database is exactly that..... a template.
> > > > > > Anytime you create a new database, postgresql makes a copy of t=
he=20
> > > > > > template1 database.
> > > > > >=20
> > > > > >=20
> > > > > > Cheers,
> > > > > > Roy
> > > > > >=20
> > > > > >=20
> > > > > > -------------------------------------------------------
> > > > > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blan=
k Media
> > > > > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $=
33
> > > > > > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gif=
t.
> > > > > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > > > > _______________________________________________
> > > > > > sql-ledger-users mailing list
> > > > > > sql...@sq...
> > > > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > > > >          =20
> > > > >=20
> > > > > -------------------------------------------------------
> > > > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank =
Media
> > > > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> > > > > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > > > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > > > _______________________________________________
> > > > > sql-ledger-users mailing list
> > > > > sql...@sq...
> > > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > > > >=20
> > > > >=20
> > > > >        =20
> > >=20
> > > -------------------------------------------------------
> > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Medi=
a
> > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> > > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@sq...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > >    =20
> >=20
> >=20
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@sq...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >=20
> >  =20
> !DSPAM:411d0d7b139352465114775!
> ------------------------------------------------------- SF.Net email
> is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic
> DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off
> Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________ sql-ledger-users
> mailing list sql...@sq...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--=20
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jk...@lo...>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7

Re: [SL] Upgrade problem - 2nd problem with creatlang under Mandrake

[ms m. l. <ms-...@sk...>]

No, it is in the Mandrake binaries after all.  With a bit more digging 
in rpmdrake, found binary in postgresql-pl-7-3-42-mdk.  Fedora will have 
to wait for another day. SQL-Ledger now running (after fixing read 
permissions problems on /css directory - don't know why that broke on 
2.4 upgrade!)

Michael S.

James P. Kinney III wrote:

>So it looks like you will need to get the src.rpm and compile your own
>version since it is not included in the binaries.
>
>Maybe I shouldn't say it, but Fedora has a great working Postgresql :)
>
>
>
>On Fri, 2004-08-13 at 14:40, ms mailing list wrote:
>  
>
>>Thanks for the tip Gerado. plpgsql.so buried  in
>>postgresql-7.3.4-2mdk.src.rpm. It looks like the Mandrake rpm install
>>doesn't list this module, but does list some other modules in this
>>rpm. Hence my problem finding it. :)
>>
>>Michael S.
>>
>>Gerardo Reynoso wrote:
>>    
>>
>>>On Friday 13 August 2004 13:12, ms mailing list wrote:
>>>  
>>>      
>>>
>>>>I've just checked  the rpms for postgresql for all linuxs. Some contain
>>>>the missing file (plpgsql.so) and some don't. Unfortunately both
>>>>mandrake 9,2 and 10.x rpms are missing this critical file. Dang. Hate to
>>>>have to switch Linux OS just to get  SQL-ledger back up and running.
>>>>
>>>>    
>>>>        
>>>>
>>>Maybe in another package, er rpm like postgres-lib lib-postgres or postgres- 
>>>devel?
>>>
>>>  
>>>      
>>>
>>>>Michael S.
>>>>
>>>>James P. Kinney III wrote:
>>>>    
>>>>        
>>>>
>>>>>Try a reinstall of the postgresql rpm's. Double-check them with rpm -qpl
>>>>><filename>.rpm |grep plpgsql  to find which one has the lang.
>>>>>
>>>>>My latest Fedora setup has the .so files in the same place as yours but
>>>>>the plpgsql.so file is there. It really sounds like an installation
>>>>>issue.
>>>>>
>>>>>There's always the source install...
>>>>>
>>>>>On Fri, 2004-08-13 at 12:46, ms mailing list wrote:
>>>>>      
>>>>>          
>>>>>
>>>>>>I have the same problem,  but get an additional error:
>>>>>>
>>>>>>su postgres
>>>>>>createlang -L/usr/lib/pgsql  plpgsql  template1
>>>>>>ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql': No such file or
>>>>>>directory
>>>>>>createlang: language installation failed
>>>>>>
>>>>>>In Mandrake 9.2 , the path to pgsql libraries is /usr/lib/pgsql. Looking
>>>>>>in that directory I see a bunch of "*.so" files, but "plpgsql.so" file
>>>>>>is missing - I  believe this is the file that createlang is looking
>>>>>>for.  Where can I get this file or am I on the wrong track.  Using
>>>>>>postgresql 7.3.4,  that came with mandrake.
>>>>>>
>>>>>>Michael S.
>>>>>>
>>>>>>Roy W Pennington wrote:
>>>>>>        
>>>>>>            
>>>>>>
>>>>>>>Unfortunately Createlang does not allow you to specify the postgresql
>>>>>>>username so it uses the username you are logged in as. In your case....
>>>>>>>root. Since root is not a postgresql user in your configuration, you
>>>>>>>get the error.
>>>>>>>
>>>>>>>
>>>>>>>You have 2 choices.
>>>>>>>
>>>>>>>Either install the plpgsql language handler  manually as explained in
>>>>>>>the postgresql docs.
>>>>>>>
>>>>>>>or
>>>>>>>
>>>>>>>when logged in as root...
>>>>>>>
>>>>>>>"su  postgres"
>>>>>>>
>>>>>>>
>>>>>>>and then use the
>>>>>>>"createlang plpgsql template1"
>>>>>>>"createlang plpgsql Standard"
>>>>>>>"createlang plpgsql test"
>>>>>>>
>>>>>>>An import note that some people don't realize is that the template1
>>>>>>>database is exactly that..... a template.
>>>>>>>Anytime you create a new database, postgresql makes a copy of the 
>>>>>>>template1 database.
>>>>>>>
>>>>>>>
>>>>>>>Cheers,
>>>>>>>Roy
>>>>>>>
>>>>>>>
>>>>>>>-------------------------------------------------------
>>>>>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>>>>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>>>>>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>>>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>>>>>_______________________________________________
>>>>>>>sql-ledger-users mailing list
>>>>>>>sql...@sq...
>>>>>>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>>>>          
>>>>>>>              
>>>>>>>
>>>>>>-------------------------------------------------------
>>>>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>>>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>>>>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>>>>_______________________________________________
>>>>>>sql-ledger-users mailing list
>>>>>>sql...@sq...
>>>>>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>>>
>>>>>>
>>>>>>        
>>>>>>            
>>>>>>
>>>>-------------------------------------------------------
>>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>>_______________________________________________
>>>>sql-ledger-users mailing list
>>>>sql...@sq...
>>>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>    
>>>>        
>>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>>>Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>_______________________________________________
>>>sql-ledger-users mailing list
>>>sql...@sq...
>>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>  
>>>      
>>>
>>!DSPAM:411d0d7b139352465114775!
>>------------------------------------------------------- SF.Net email
>>is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic
>>DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off
>>Retail on Ink & Toner - Free Shipping and Free Gift.
>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>_______________________________________________ sql-ledger-users
>>mailing list sql...@sq...
>>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>    
>>