PostgreSQL Database Forum

Hello There , I hope u answer these questions: I have installed postgresql DBMS , with SQL_ASCII encoding, so far, it is working ok, I think I might have probelems when manipulating the strings(substring, lenght), but now I don't do i. Could anyone tell me , with reasons, the best encoding? Also I would like to do text search, I 'd like to...

I have an application where each user session opens and maintains a long-lived connection to the postgresql backend database. I need to keep a small amount of information (things like a unique session identifier, the application - as opposed to database - username and so on) that is local to each database session. It needs to be visible...

I have tried contacting the list owner, but nobody responds so I am knowingly sending administrative mail to the list. Sorry folks. For months, particularly since February, I have been receiving e-mail that is out-of-date. Since they are relatively old (weeks to months) I cannot say whether or not they are duplicates. A copy of such an...

Hello all, Is it possible that we setup the password in the pg_dump command line instead of let users input it through prompt command. E.g., pg_dump test -c -d --host=localhost -U testUser1 --file='a.dmp' --no-privileges Thanks a lot! Ly

After I restore a Postgres database (using pg_restore), I get the following error message when I try to run a simple UPDATE query: ERROR: cache lookup failed for function 70529 More details: 1. I backup the database: pg_dump -Fc --username=webclient > database.backup

Hi, I have question: why such condition: foofield not like '%bar%' where foofield is varchar returns false (or rather even ignore row) on record where foofield is null

unsubscribe

Hi, I'm having some problems with pg_database -system table. It lost all of it's contents while database was running. It's actually still running but I don't know what to do because I'm not sure if it will start up at all after shutdown. I noticed the problem while trying to use pg_dump: tuner@xyzzy:~$ /usr/local/pgsql/bin/pg_dump...

please CC me, I am on digest --------------------------------- I have the following code from an application that is 'mysql_centric'. I want to make it generic across all databases, if it's possible, especially postgres :-) mysql version: INSERT INTO calendar_setting SET setting='colorEvent',value='#C2DCD5'; There is no data in this...

Hi, I found a strange behavior in PostgreSQL. I created a table as user pippo then I created a view based upon this tables, latter someone drops user pippo and now when I do: select from view PostgreSQL show me this: pg_aclcheck: invalid user id # I suppose it is because the user pippo the owner of this view, is any

My pgsql service keeps dieing and has a bunch of errors like this in the server log, eventually it stops giving these Warning: terminatin connection because of crash of another server process Detail: The postmaster has commanded this server process to roll back the current transaction and exit, because nother server process exited...

Hello, I'm having a problem with timestamps in postgresql. I run the following query to pull dates in this format: WEEK/MONTH/YEAR However the data says that April 28th 2004 was in week 4 of April and that April 29th 2004 was in week 5 of april. This is incorrect. This is causing my reports to print out incorrect data.

I cannot set up password authentication with encrypted passwords. With plaintext passwords auth works fine. So my guess is that I am using an incorrect password encryption program. What encryption utility should I use to store an MD5 password? I tried md5sum, but passwords encrypted with md5sum will not let me log in. I also tried...

unsubscribe ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly

Hi All, Is it possible to find the size of a pgsql table. TIA -- regards, Deepa K

A manager friend of mine sent me the following concern. He's preparing to shift to Postgresql from a proprietary DB and 4gl system: ----------- To that end, I've also started studying up on Postgresql. It seems to have all the necessary features for a transaction heavy DB. The recent release is 7.3. Of course, "the proof will be in the...

I am using Asynchronous Query Processing interface from libpq library. And I got some strange results on Solaris My test select query is 'SELECT * from pg_user;' and I use select system synchronous I/O multiplexer in 'C' The first test sends 10000 select queries using 10 nonblocking connections to database ( PQsendQuery ). The second...

Hi to all i received "message type 0x50 arrived from server while idle" ... RedHat Linux 9, postgres 7.3.4 the program is quite simple, a loop do UPDATE on a random entry on a table. Server is without autocommit. with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,

Is there a way to replicate one-off(a copy of duplicate) of an existing Postgres database. regards, caroline __________________________________ Do you Yahoo!?

Hello pgsql-general, When I am running "make" I get the following: > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c > dbsize.c:1: postgres.h: No such file or directory > dbsize.c:7: access/heapam.h: No such file or directory...

Hello, Are the indexes inherited during table inheritance ? Thanks -- Fabien Fournier ---------------------------(end of broadcast)---------------------------

what's wrong with this? create type tSession as ( ty_found boolean, ty_Session char(32) ); create or replace function GetSessionID( integer ) returns tSession as ' declare thisSession tSession; begin

Hello, I'm trying to set up PostgreSQL for proof of concept according to our standards. I need to create a user for database01 that has the ability to create any objects they want. They can create tables, views, indexes, etc. Then I need a second user that has the privileges to only SELECT, INSERT, UPDATE, DELETE from objects in a...

Hi, Is there any way to prevent implicit joins in 7.3.x? I tried to put 'ENABLE_IMPLICIT_FROM = false' in postgresql.conf but it did not work. Thanks, Patrick

Hi. Where is the SQL text of view stored in the database? I mean the text like "SELECT the_field FROM the_table". I can found the function's text in "pg_proc.prosrc", but can't find the same for a view. Yury Shvetsov.