Hi, I am coming with an oracle background. In oracle, if user A wants to access the objects of user B, User A has got 2 options: 1. Access the...

chakkara rangarajan

09-08-2003 02:38 PM
chakkara rangarajan

We're building a PostGreSQL 7.3.4 system; we want to place database index files on an external drive (for security and backup robustness); we...

David Rickard

09-08-2003 12:41 PM
Bruce Momjian

I am a Postgres novice. I have not done anything in the way of configuring the DB differently from what the defaults are. Here is my problem... I...

Derrick Betts

09-08-2003 10:39 AM
Derrick Betts

I am a Postgres novice. I have not done anything in the way of configuring the DB differently from what the defaults are. Here is my problem... I...

Derrick Betts

09-08-2003 10:30 AM
Derrick Betts

Hi! I got a legacy server to maintain, with PGSQL 7.0, Redhat 6 or smthing. One day a power interrupt changed my life to hell. Postmaster doesn't...

Marcin Gil

09-08-2003 10:10 AM
Tom Lane

Is there some easy way I can take an old PGDATA directory and load it into a new instance of Postgres? My server was rebuilt, and I didn't get a...

Damon Courtney

09-06-2003 08:05 PM
Tom Lane

After a successful install, and with postmaster running, we cannot get psql (or any of the psql-dependent scripts) to run; The error message...

David Rickard

09-05-2003 04:34 PM
Oliver Elphick

Hi all, I would like to know what the best queries are to get system status info like: Number of connected users List of connected user names with...

M. Bastin

09-05-2003 11:17 AM
M. Bastin

I have a few databases that set for ASCII encoding right now. Is there a way to convert them to Unicode? I tried using "alter database mConceptsEd...

Brad Rhine

09-05-2003 11:09 AM
M. Bastin

Hi again, I just tried the first load in my brand new pg database... And IT SUCKS! yeah! it took over an hour to load around 200 thousand records,...

Juan Francisco Diaz

09-04-2003 05:51 PM
Stephan Szabo

Attempting to install PostGreSQL 7.3.X on a sparc-sun-solaris2.9 (SunOS 5.9) machine; during configure, numerous errors like these were...

David Rickard

09-04-2003 05:36 PM
Tom Lane

Hello, all. I need to transfer a database from postgres 7.3.3 to another server, managed by other people, running version 7.2.3. So, I've...

Marcus Andree S. Magalhaes

09-04-2003 11:29 AM
Stephan Szabo

On restoring a plain-text SQL script file dumped from a version 7.1.2 database to 7.3.3 I got the following errors. ERROR: copy: line 67568,...

Stuart Woodward

09-04-2003 04:12 AM
Ron Johnson

Hi! I tried to combine Postfix MTA with PostgreSQL. Everythings works almost fine.. When I look at my postgresql log file there are lots of: "LOG:...

Marcin Gil

09-04-2003 03:53 AM
Marcin Gil

So lets say I got a table A(x,y,z, Q) ordered by column Q, with contents like so: x y z Q ------------------------ 21 5 x ...

LH

09-04-2003 01:12 AM
Jeffrey Melloy

Greetings - It looks to me as if there is no way to alter the datatype of a table column, as in from timestamp to varchar. Am I right? (I will...

Louise Cofield

09-04-2003 01:06 AM
Aarni Ruuhimäki

Hi, I need the setup of PostgreSQL and help files.Kindly do the needful and revert back asap. Regards Shekar

Shekar

09-03-2003 11:59 PM
Shekar

I'm trying to create a PLPGSQL function wich executes every statement inside it no matter if any one fails to execute. Any advice???

Dagoberto

09-03-2003 11:56 PM
Dagoberto

Hello, ive been all day trying to find out why a jdbc query does not work... I traced the error to the function I created. The function is written...

Juan Francisco Diaz

09-03-2003 10:22 PM
Tom Lane

hi all Is is possible from with in psql to edit a function - i.e. extract the a function definition and open it \e style. At the moment I keep lots...

glenn

09-03-2003 09:54 PM
glenn

Is there a way if one transaction has locked a row in a table, the next transaction does not get blocked while reading the same row, but moves on...

Girish Bajaj

09-03-2003 07:25 PM
Girish Bajaj

Hi, By default, all users can find out what other users exist, by looking at pg_user (which is a view on pg_shadow). For privacy reasons I would...

Oliver Fromme

09-03-2003 08:51 AM
Tom Lane

Hi, im trying to use the copy command to load some data in my tables but i get the following message: 000081": can't parse "pg_atoi: error in...

Juan Francisco Diaz

09-03-2003 01:30 AM
Tomka Gergely

Hi all I've imported data into an established database. The data is, off course, held together by various keys (which don't duplicate any of the few...

glenn

09-03-2003 12:11 AM
Tom Lane

I haven't been able to figure out how to determine the number of populated rows in a table - such as "select max(rownum)" in Oracle. Thanks!

Louise Cofield

09-02-2003 10:15 PM
Christopher Browne

"Ron Johnson" <ron.l.johnson (AT) cox (DOT) net> wrote I have used something like this: now() - interval '3 hours' so I supposed you could...

JohnH

09-02-2003 08:44 PM
Tyler Colbert

Please don't start new topics by by replying to unrelated messages. On Sun, Aug 31, 2003 at 21:44:12 -0400, "Luis H." <pgsql-novice (AT) geekhouse...

Christopher Koh

09-02-2003 01:49 PM
Al Hulaton

Hi, By default, all users can find out what other users exist, by looking at pg_user (which is a view on pg_shadow). For privacy reasons I would...

Oliver Fromme

09-02-2003 10:54 AM
Oliver Fromme

I wish to SELECT * FROM testTable WHERE any field contains any word in the string "my name is bill" All I can come up with is this. SELECT * FROM...

Kevin Waterson

09-02-2003 09:43 AM
Jeffrey Melloy

I need to know how I can use shared memory to improve the performance of postgresql. Someone can help me...

Mariano M. Gonzalez

09-02-2003 07:35 AM
Mariano M. Gonzalez

Hi, Im trying to restore a postgresql database from a backup that was done a few days ago. The backup is on CD and was a straight copy of everything...

Cody Phanekham

09-02-2003 01:28 AM
Tomka Gergely

Hi, I'm a novice for using Postgres and Linux - any help or suggestions would be really appreciated, thanks!!! I'm having trouble logging on as the...

Jennifer Liu

09-01-2003 10:47 PM
mathan

I know that on my mailing lists the software I use to make web archives would pick up the reply as a reply even if you changed all of the headers...

Williams, Travis L, NEO

09-01-2003 12:22 PM
Williams, Travis L, NEO

hi Q1 - is it at least notionally possible to declare a function to return 'setof record' - i.e. a generic composite type as opposed to a...

glenn

09-01-2003 12:48 AM
Avi Schwartz

I need to add a large number(1000) records to my table. How would I do this using a file? Any help is greatly...

Kelly

08-30-2003 11:06 PM
Joe Conway

On the BOOLEAN issue, it seems that a majority of the 'MAJOR', high dollar DBs. do not support the boolean datatype. Is PG supporting a depreciated...

Cath Lawrence

08-30-2003 04:36 PM
Tom Lane

We are planning to migrate from Oracle to PostGreSQL, and we would like to replicate our database maintenance procedures/scripts as closely as...

David Rickard

08-29-2003 08:40 PM
Bruce Momjian

Hello all, Is there a way I can force a more aggressive lock on a table in a SELECT statement that's being executed in a transaction? SELECT...

Girish Bajaj

08-28-2003 09:59 PM
Nabil Sayegh

Hello again, i found ou that no matter the function, if the return type is a SETOF INTEGER, or a SETOF CUSTOMTYPE that includes at least ONE...

Juan Francisco Diaz

08-27-2003 10:58 PM
Tom Lane

Stuart Woodward <woodward (AT) garage (DOT) co.jp> writes: There's no implicit coercion from integer to smallint in 7.3. I'd suggest changing the...

Tom Lane

08-27-2003 10:34 PM
Tom Lane

Hi, me again! Im trying to return a setof integer from various functions and in all of them the message when executed is: WARNING: plpgsql: ERROR...

Juan Francisco Diaz

08-26-2003 03:44 PM
Juan Francisco Diaz

Create or replace function foo(param1, param2, param3) RETURNS SETOF RECORD(name TEXT, age INTEGER, address TEXT) AS ' ... ' LANGUAGE 'plpgsql'; If...

Juan Francisco Diaz

08-26-2003 02:35 PM
Stephan Szabo

Is this true? I mean it must be sicne pg shows me the error message... But id like o know why? Also, I really need to use more than 32 params, i have...

Juan Francisco Diaz

08-26-2003 10:39 AM
Juan Francisco Diaz

The subject says it all... How can that be done? I tried to do an explicit cast but... Id dint work. JuanF (A newbie in...

Juan Francisco Diaz

08-26-2003 01:00 AM
Stephan Szabo

I'm finding that some update process is holding all other transactions on a particular table. Is there a way to tell what the Update statement is...

Patrick Hatcher

08-25-2003 04:09 PM
CoL

Hi, I'm looking for a good treatment of searching through tables in PostgreSQL.I've read the doc, so I can build searches using LIKE/SIMILAR TO/~ ,...

Luis H.

08-25-2003 12:09 PM
Nabil Sayegh

Hi, Im trying to return a setof record (plpgsql) but this error message appears and i dont know what to do. ERROR: A column definition list is...

Juan F Diaz

08-25-2003 11:52 AM
Juan F Diaz

Hi, I'm looking for a good treatment of searching through tables in PostgreSQL.I've read the doc, so I can build searches using LIKE/SIMILAR TO/~ ,...

Luis Hernandez

08-25-2003 11:32 AM
Luis Hernandez

Tomka Gergely <tomka (AT) zeus (DOT) gau.hu> writes: Cast both to type "date" and subtract. regression=# select current_date -...

Tom Lane

08-25-2003 09:45 AM
Tom Lane

On Fri, 2003-08-22 at 12:42, Luis Hernán Otegui wrote: Hi, Sorry, but PG isn't designed to have more than 1 computer accessing the files at the...

Ron Johnson

08-24-2003 10:39 PM
Mike Castle