Re: [GENERAL] function compiled with g++

2001-09-23 Thread Thomas Lockhart
> Why the same function writen in C, compiled with gcc works OK, but compiled > with g++, doesn't even load? Not mentioning those written in C++. > i.e. loader reports undefined symbol: pg_detoast_datum__FP7varlena or some > other undefined symbol... C++ compilers do "name mangling" to allow func

Re: [GENERAL] Where are Perl DBI and DBD for PostgreSQL??

2001-09-23 Thread R Talbot
Peter Eisentraut wrote: > R Talbot writes: > > > My question refers to Perl... > > I checked CPAN and there are DBI modules but > > I don't see the DBD. > > http://www.cpan.org/modules/by-module/DBI/DBI-1.20.tar.gz > http://www.cpan.org/modules/by-module/DBD/DBD-Pg-1.01.tar.gz > > > I downloaded

Re: [GENERAL] My brain hurts - update field based on value of another table's field

2001-09-23 Thread Lee Harr
> * area - arbitrary name for a collection of sites (optional) > > * site name for a collection of buildings (may only be one building) > optional > > * building - a single building not optional name for a collection of rooms > > * zone - sub area of a building not optional name for a collectio

Re: [GENERAL] creating "user" table

2001-09-23 Thread Chris
Hey, > > Chris> Hi, > > Chris> This one is more for the developers, but other >comments welcome. > > > > Chris> Since we can't create a table called user in a >normal database due to > > Chris> the reserved keyword problem, > > > > False precondition! > > > > template1=# create database demo;

Re: [GENERAL] Where are Perl DBI and DBD for PostgreSQL??

2001-09-23 Thread Peter Eisentraut
R Talbot writes: > My question refers to Perl... > I checked CPAN and there are DBI modules but > I don't see the DBD. http://www.cpan.org/modules/by-module/DBI/DBI-1.20.tar.gz http://www.cpan.org/modules/by-module/DBD/DBD-Pg-1.01.tar.gz > I downloaded.. > pgsql_perl5-1.9.0.tar.gz This is a

Re: [GENERAL] creating "user" table

2001-09-23 Thread Daniel ?erud
Thanks for the information !! delyx. Daniel Ã…kerud. > > "Chris" == Chris <[EMAIL PROTECTED]> writes: > > Chris> Hi, > Chris> This one is more for the developers, but other comments welcome. > > Chris> Since we can't create a table called user in a normal database due to > Chris> the r

Re: [GENERAL] ERROR: Tuple is too big: size 15880, max size 8140

2001-09-23 Thread Doug McNaught
[EMAIL PROTECTED] (Konstantinos Agouros) writes: > Hi, > > I have a table with just one column of type varchar which gives me from time > to time (I guess when data is bigger then 8140 bytes) this message. > select version() says: > PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2

Re: [GENERAL] creating "user" table

2001-09-23 Thread Randal L. Schwartz
> "Chris" == Chris <[EMAIL PROTECTED]> writes: Chris> Hi, Chris> This one is more for the developers, but other comments welcome. Chris> Since we can't create a table called user in a normal database due to Chris> the reserved keyword problem, False precondition! template1=# create da

Re: [GENERAL] My brain hurts - update field based on value of another table's field

2001-09-23 Thread Lee Harr
On Sun, 23 Sep 2001 03:56:50 GMT, Pat M <[EMAIL PROTECTED]> wrote: > I'm just a hobbyist so this is probably atroceous, but I'm trying to do > something like the following. Sorry its not in real SQL format. I know how > to auto-update by referencing to a primary key of another table, but what if >

[GENERAL] ERROR: Tuple is too big: size 15880, max size 8140

2001-09-23 Thread Konstantinos Agouros
Hi, I have a table with just one column of type varchar which gives me from time to time (I guess when data is bigger then 8140 bytes) this message. select version() says: PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 Besides Upgrading to 7.1 somebody has an idea about thi

Re: [GENERAL] creating "user" table

2001-09-23 Thread Chris
> > I meant only be able to create users when you're connected to the > template1 db. > > > > so > > test=# create user x; > > > > wouldn't work, since you're not using template1. > > > > that way the user keyword would be free to use as a table name. > >But the parser is fixed at compile time

[GENERAL] Is it possible to stop the trigger execution for a moment?

2001-09-23 Thread Piotr Sroczynski
Hi All, I want to have table with all rows numbered from 1 to number_of_rows without any holes. It shoud be true all the time: after delete, modify and insert operations. The obvious solution are triggers but to write the procedure I need something to stop recursive trigger execution. Is it poss

Re: [GENERAL] Multibyte FAQ item

2001-09-23 Thread Peter Eisentraut
Jani Averbach writes: > --enable-multibyte > > Allows the use of multibyte character encodings. This is > primarily for languages like Japanese, Korean, and Chinese. Read > the Administrator's Guide for details. > --8<-- > > If you are 8-bit speaking people (ie.