[GENERAL] PG_DUMP permissions

Hello, ALL I made changes in pg_hba,conf setting-up the PASSWORD required for remote users, but left the TRUST to local users. But the pg_dump don't have any form to input the password by command-line, and so, all my scripts in CRONTAB don't work anymore. Anybody has any suggestion ??? Reg

[GENERAL] Trigger and Permissions

Hello, ALL I'm making a simple log system where all the users (each one have a different login and password) will be logged all your actions. When a user delete, insert ou update any data in a table, the trigger will log the operation in another table. Until this point, all OK. I made this tr

Re: [GENERAL] Problem with host connection

Jeremy Smith <[EMAIL PROTECTED]> writes: > This is a new area to me, I am rewriting a Microsoft Access > application for the company I work for in Java and Postgres. I have > created a testdatabase called history which I can access with history> fine as well as from a Perl test app I have writt

Re: [GENERAL] newbie question

prashanth bhat <[EMAIL PROTECTED]> writes: > hi all, > > Is it possible to store java Objects in postgres and > invoke methods on them??. Is it possible to store XML > in postgres?. The answer to both your questions is "yes, but..." Any Java object that implements Serializable can be serialize

Re: [GENERAL] version issue?

Excellent! That worked! Thank you once again Tom! I was under the impression that you couldn't use an alias in the ORDER BY. Obviously, I was mistaken. Thanks, -Dan - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> : "Dan Wilson" <[EMAIL PROTECTED]> writes: : > : Possibly some

Re: [GENERAL] version issue?

"Dan Wilson" <[EMAIL PROTECTED]> writes: > : Possibly some future release will actually do the right thing with ORDER > : BY of an expression on the output columns, but right now it has to be an > : output column, period. > OK... I tried adding UPPER(last_name) to the result column lists of both

Re: [GENERAL] version issue?

- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> : "Dan Wilson" <[EMAIL PROTECTED]> writes: : > I have the following query running on two different servers. It works on : > 7.0.3 and gives the following error on 7.1beta4. : : > ERROR: Attribute 'last_name' not found : : > Your S

Re: [GENERAL] A couple of funny things happening?

Christopher Sawtell <[EMAIL PROTECTED]> writes: > chris=# SELECT count(number) from subject ; # Correct, isn't it? > ERROR: ExecEvalAggref: no aggregates in this expression context make distclean, reconfigure, rebuild... As I've told the last couple of people to report this same symptom, you

Re: [GENERAL] version issue?

"Dan Wilson" <[EMAIL PROTECTED]> writes: > I have the following query running on two different servers. It works on > 7.0.3 and gives the following error on 7.1beta4. > ERROR: Attribute 'last_name' not found > Your SQL statement: > SELECT first_name, last_name, middle_name, u.uid, end_year > FR

[GENERAL] Create type

If I can't use nested tables, how can I create a type that will be a kind of "dynamic list of structure". regards, Renaud THONNART

[GENERAL] Re: sort order problem

On Sun, 18 Feb 2001 [EMAIL PROTECTED] wrote: > hi! > > could somebody tell me where is the problem? > > i have postgres 7.0.3-4 comming with unstable debian distribution (locales 2.2.1-1, >libc6 2.2.1-1) > i am unable to force postgres to sort in correct order when I have national >characters (

[GENERAL] Re: Newbie question :-)

Oh and the instructions in the INSTALL file (under the directory where the source was un-tar'd) is very easy to follow and walks you through the installation as much as possible IMHO.. The user/admin/programmer manuals and the tutorial @ www.postgresql.org are all good too, they detail just abou

[GENERAL] Re: Newbie question :-)

If you're talking about some kind of C application then it's going to be portable only you'll have to rip out the PG API and replace it with the Oracle API, I'm sure that's not such an easy task.. If you're speaking of an application written in say, PHP, then that's a horse of a different color.

[GENERAL] Using a messaging service

Hello, I'm trying to use a java messaging service so I can post a message whenever my table has an update. Java API ^ | | Trigger update Java messagging

[GENERAL] newbie question

hi all, Is it possible to store java Objects in postgres and invoke methods on them??. Is it possible to store XML in postgres?. please reply ASAP thanx in adv. prashanth __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://pe

Re: [GENERAL] Newbie question :-)

On Sat, 24 Feb 2001, Bela Lantos wrote: > I just started learning Database Design, our programs have to work on > Oracle, but at home I run Linux. > > Can any of you tell me how portable are the programs written for Progresql? > Would they run on Oracle without problem? That all depends on the p

[GENERAL] Migrate from MS SQL 6.5 to postgres??

Any utilities around which would ease the pain involved in migrating an m$ sql6.5 database running on WinNT box to postgres running on a Linux box?? If no such utilities around - any advice on strategy to adopt?? Regards, Steve O'Hagan

[GENERAL] Postgresql and ODBC

Hi, I run Postgresql in Linux box to act as a database server. What should I do if I want to access this database from a MS Windows client via ODBC. I download the driver but do not know how to set up the connection. Thanks Billie

[GENERAL] Load fixed length records.

Hi   I am receiving records as fixed length ascii.  I would like to load them into PostgreSQL tables.  I could write an ecpg program to parse the records and do an insert - or I could write an awk script to split the records and insert delimiters, then use COPY (which is what I did), but I w

[GENERAL] Re: Problem with PL/pgSQL

Hans-Jürgen Schönig wrote: > What is wrong with the following function? > > CREATE FUNCTION logfunc2 (text) RETURNS int AS ' > DECLARE > text ALIAS FOR $1; > BEGIN > SELECT length(text); > RETURN ''3''; > END; > ' LANGUAGE 'p

[GENERAL] Help with database locking

We're having awful trouble with something getting locks on one of our tables (or locks on something) and shutting out other clients. Is there a way of getting a list of what locks are active, or logging them as they're set and unset? Do locks have a timeout, and can we adjust it? We're running

Re: [GENERAL] version issue?

Ok... here's what I tried. I was mistaken in my beta version. sib=# select version(); version PostgreSQL 7.1beta3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 (1 row) sib=# SELECT firs

[GENERAL] Nested tables

How can I create nested tables ? I haven't find how it can be made in the doc. Could someone give me a little example to create and then insert in nested table? Thank you. Renaud THONNART

[GENERAL] Help with pq++

Hello I need to make a program that uses pq++, before starting I made a little program to see if I understood correctly how to use pq++, however I have a problem: The program can't connect to the DB. My code looks like this: #include #include int main() { PgDatabase db("dbname=mydb");

Re: [GENERAL] Re: postmaster question

Lonnie Cumberland wrote: > > Hello Mitch, > > I have been trying to do just that and hove found that by going to my init.d > directory and starting up the "postgresql" service helps. > > Now the problem seems to be that even though I have just used "pg_passwd" to > add me as a user, I am now ge