Re: [GENERAL] Load fails

2000-07-13 Thread Brandon Ibach
Quoting Tom Lane <[EMAIL PROTECTED]>: > Brandon Ibach <[EMAIL PROTECTED]> writes: > > ERROR: Load of file /home/postgres/lib/vcic.so failed: > > /home/postgres/lib/vcic.so: undefined symbol: palloc > > palloc() has been a macro for a long time. Could you be > compiling against some extremely o

Re: [GENERAL] Load fails

2000-07-13 Thread Tom Lane
Brandon Ibach <[EMAIL PROTECTED]> writes: > ERROR: Load of file /home/postgres/lib/vcic.so failed: > /home/postgres/lib/vcic.so: undefined symbol: palloc palloc() has been a macro for a long time. Could you be compiling against some extremely obsolete header files that declare it as a plain fu

[GENERAL] Re: How to list and remove a user in postgres ?

2000-07-13 Thread Yves Dorfsman
HomerWelch <[EMAIL PROTECTED]> wrote: > (\h createuser.) I don't recall a method for listing all > users. man psql has a lot of good information. Log in as postgres (or whoever is your postgres super user), then run psql, and: \dS Will give you a list of the system tables (

[GENERAL] Re: How to remove a user ?

2000-07-13 Thread Yves Dorfsman
Fred <[EMAIL PROTECTED]> wrote: > How to remove a user in postgres ? either: dropuser username (from the command line) or DROP USER username; (as an SQL statement) Yves. Yves Dorfsman[EMAIL PROTECTED]

[GENERAL] Load fails

2000-07-13 Thread Brandon Ibach
Greetings... I have a couple of custom functions (written in C) which used to work just fine. However, I recently relinked them, and now I get a failure whenever I try to use them: ERROR: Load of file /home/postgres/lib/vcic.so failed: /home/postgres/lib/vcic.so: undefined symbol: palloc

Re: [GENERAL] Object oriented features - MISSING

2000-07-13 Thread Chris Bitmead
Hi, This has been broken in postgres for many years. But I have fixed it recently in current CVS. So you'll either have to wait for the next release or else risk a development version. Another option is to go to patches archive and manually apply the patch to 7.0.2 which wouldn't be that hard.

Re: [GENERAL] PostgreSQL and Access (via ODBC)

2000-07-13 Thread Sean Weissensee
Within Access, click file, get external data, link tables, choose ODBC, select the postres driver, select the DSN, this will bring up a window to select tables from the db, highlight the tables, click ok, at this stage if a unique ID was not set in the postgre table a window will appear to ch

[GENERAL] Multi Byte Strings

2000-07-13 Thread Luis Quintano
Hello! Whe I try to connect remotely to a postgres database the following error occurs: Warning: Unable to connect to PostgresSQL server: ERROR: MultiByte strings (MB) must be enabled to use this function The function in question is a pg_connect from php. It's the first time this hap

Re: [GENERAL] sql question

2000-07-13 Thread Travis Bauer
Thanks, Now that you mention it, I even remember reading it in the book! Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Wed, 12 Jul 2000, Ross J

[GENERAL] plpgsql and cyrillic characters

2000-07-13 Thread Yury Don
Hello All, I have a database where tables and fields have a names consisting of cyrillic characters. And I would like to create a trigger on plpgsql, but when I use cyrillic characters in names of elements of record NEW or OLD, I am getting an errors. I tried NEW.fieldname_with_cyrillic, NEW."fie

Re: [GENERAL] pgdump & blob

2000-07-13 Thread Philip Warner
At 10:56 13/07/00 GMT+1, Alexandre FLAMENT wrote: >Is there a version of pg_dump that save blob ? There is pg_dump_lo in contrib/ and there is an experimental version available for testing at: ftp://ftp.rhyme.com.au/pub/postgresql/pg_dump/blobs/ ---

[GENERAL] pgdump & blob

2000-07-13 Thread Alexandre FLAMENT
Is there a version of pg_dump that save blob ? ___ Vendez tout... aux enchères - http://www.caraplazza.com

[GENERAL] WinZEOS components and CREATE USER

2000-07-13 Thread Alex Bolenok
Hello, I use WinZEOS Delphi components. I want to create a user using ExecSQL method of TZPgSqlQuery component. When I call this method, the exception is raised: 'CREATE USER: may not be called in a transaction block'. The component seems to begin an implicit BEGIN / END block when ExecSQL method

[GENERAL] tcl/tk interface on Digital Unix

2000-07-13 Thread Peter Mittermayer
Hi, When I try to run the configure script with the option --with-tcl, the tclConfig.sh is not found because it simply does not exits! But the Tcl/Tk package is installed on the machine (without these scripts). Is there a way to compile the tcl/tk interface without these scripts? Peter --

Re: [GENERAL] select for update not locking properly.

2000-07-13 Thread Tom Lane
Joseph Shraibman <[EMAIL PROTECTED]> writes: > But the locking isn't working properly. I do something that should > cause 3 different threads to try and do that append, and the first one > goes through properly, but the second two append to the result of the > first on only, meaning that the thir