Re: [GENERAL] Getting closer with functions, but...

2000-07-13 Thread Philip Warner
At 20:58 12/07/00 -0700, Scott Holmes wrote: This function works but is not selective enough. The tg_argv[] are pointers to the arguments passed. And they do work correctly. ... Is there a syntax that will allow me to build an sql statement for use in theis funcation (ie delete from

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 third one

[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 --

[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

[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

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] 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,

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

[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

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

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.

[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

[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] 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