[GENERAL] Upgrade

A new system came in with RH7.1 and PG7.0.3 installed (no data). I want to upgrade to PG7.1.3 After reading README.rpm-dist, it is my understanding that rpm -U postgresql713 followed by the db initialization is enough. The system locale is en_US; I will change it to C. The question is: when the

[GENERAL] Please help

Last night postmaster crashed while running a lengthy querry. The message I found was that a log file grew too big. Postmaster was down. I tried to restart it , but it would not. I restarted the system, but it would not start either. Manual start with a log file: FATAL 1: configuration file

Re: [GENERAL] PostgreSQL and OpenOffice

Here is from staroffice.com.support.starbase: Mihai Gheorghiu wrote: I want to connect to a PostgreSQL database on a RH7.0 machine. I go File New Database, general Test, Type JDBC, JDBC org.postgresql.Driver jdbc:postgresql:sales username password. I use the same strings to successfully

[GENERAL] User privileges on sequences

I have a db in which users can view and update data only via views. It is my understanding that the privileges of the view/rule creator do not extend to sequences. Therefore, I have to give users permissions to sequences, just to the extent that they could add records. What is the minimum set of

[GENERAL] User privileges

It is possible that a user is a member of more than one group. Do this user's privileges AND or OR the privileges of each of the two groups? Thank you all. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[GENERAL] User permissions for functions

The users can access the database only via rules. Some of the rules do call functions. I found in PG notes that: An SQL or plpgsql function invoked by a rule would be executed with the current user's permissions, not the rule owner's. What exactly does this mean? What do I need to do with respect

Re: [GENERAL] Session identifier

, because the same user may have more than one session, from different machines or frontends. Any suggestions? -Original Message- From: Brett W. McCoy [EMAIL PROTECTED] To: Mihai Gheorghiu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, October 10, 2001 11:16 AM

[GENERAL] Triggers again

1) I have some TRIGGER BEFORE INSERT created explicitly, and other(s) created implicitly, through default constraints. What is their execution order? 2) Are the changes made by the first visible to the following ones? ---(end of broadcast)--- TIP

[GENERAL] Triggers and rules

A table has TRIGGER BEFORE UPDATE, TRIGGER AFTER UPDATE and RULE ON UPDATE. 1. What is the order these three are executed? 2. Are the actions of one of them visible to the following ones, or they all refer strictly to the record before update? E.g.: If the TRIGGER BEFORE UPDATE changes a value in

[GENERAL] String functions

Is there any function that removes multiple blanks from within a string? Can any trick be played with the existing string functions without having to write a loop? Thank you all. ---(end of broadcast)--- TIP 2: you can get off all lists at once

[GENERAL] Test is_data_type

Sorry if it double posts, the first one seems to have vanished... How can I test that a text variable has a value that represents a valid data type, other than writing something like: variable IN ('integer', 'text', 'float'...)? ---(end of

[GENERAL] Test is_data_type

How can I test that a text variable has a value that represents a valid data type, other than writing something like: variable IN ('integer', 'text', 'float'...)? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[GENERAL] Successful EXECUTE

Sorry if it posts twice, the first one seems to have vanished... I have a function f1 with two parameters, par1 and par2. f1 creates another function with name=par1 and type=par2. How can I test if EXECUTE was successful or not, because I want f1 to return a boolean that shows whether the

[GENERAL] Successful EXECUTE

I have a function f1 with two parameters, par1 and par2. f1 creates another function with name=par1 and type=par2. How can I test if EXECUTE was successful or not, because I want f1 to return a boolean that shows whether the creation of the new function was successful or not.

Re: [GENERAL] postgresql.conf

PROTECTED] To: Mihai Gheorghiu [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, September 25, 2001 8:30 PM Subject: Re: [GENERAL] postgresql.conf On Tuesday 25 September 2001 11:34 am, Mihai Gheorghiu wrote: I installed PG from RPMs. postgresql.conf comes with all options

[GENERAL] postgresql.conf

I installed PG from RPMs. postgresql.conf comes with all options commented out. What are the defaults? PG works anyway (Well... I know... -i etc.) Thank you all. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Function exists

I want to write a function that finds out whether a function already exists. Is that possible? How? Thank you all. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[GENERAL] Functions

I created 2 functions: f1 and f2. f1 calls f2. I then change f2. What is the minimum I need to do for f1 to see the modified f2? Is my understanding correct that I need to drop and recreate f1? Thank you in advance. ---(end of broadcast)--- TIP 4:

[GENERAL] Global constants

Can there be anything like global constants in PG? They should be seen by any session. E.g.: User rights are defined as int4's, with each bit representing an area where they have access. Testing this would be easier if I had constants like ISACCOUNTING, which I AND with the data in the rights

[GENERAL] Messages

While restoring a db I got the following messages: CREATE UNIQUE INDEX bookings_inventoryid_key on bookings using btree ( inventoryid int4_ops ) NOTICE: RegisterShareInvalid: SI buffer overflow CREATE INDEX bookings_account_idx on bookings using btree ( acount bpchar_ops ) NOTICE:

[GENERAL] CREATE USER vs. createuser

With createuser I managed to create users like 12345 and John Doe (with a space). It did not work with CREATE USER. Aren't they supposed to do the same? Thank you all, Mihai Gheorghiu ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [GENERAL] Corrupted tables?

I'll try. Thanks a lot. Mihai -Original Message- From: Tom Lane [EMAIL PROTECTED] To: Mihai Gheorghiu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 01, 2001 11:14 AM Subject: Re: [GENERAL] Corrupted tables? Mihai Gheorghiu [EMAIL PROTECTED] writes

Re: [GENERAL] Corrupted tables?

I tried to connect from another computer: the same tables cannot be opened. What would be in PG that ODBC uses and psql does not? Mihai -Original Message- From: Tom Lane [EMAIL PROTECTED] To: Mihai Gheorghiu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday

[GENERAL] Number of days

Is there a function that returns the number of days between two dates? I found only age, which calculates the difference between two timestamps, but the example shows the result as a timestamp. Thanks, Mihai Gheorghiu ---(end of broadcast)--- TIP

[GENERAL] Regression

I installed PG 7.1.2 from rpms on RH 7.0 Regression fails 8 of 76 tests: char, varchar, int8, numeric, abstime, select_implicit, select_having, select_views. Looking at regression.diffs (attached) my first guess is that I'm missing a setup/locale? Please help. Thanks in advance, Mihai Gheorghiu

Re: [GENERAL] Regression

of them, but no en_US or us. Thanks in advance, Mihai Gheorghiu -Original Message- From: Peter Eisentraut [EMAIL PROTECTED] To: Mihai Gheorghiu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, July 03, 2001 12:22 PM Subject: Re: [GENERAL] Regression Mihai

[GENERAL] Modifying a table that other tables refer to for foreigh key

I have a database with multiple referential integrity links. I want to make important changes to one of the tables, which is referenced by other tables for foreign keys (like deleting some columns, or changing data type). What would be the easiest way to do it (without re-creating all the other

[GENERAL] 7.1-1 installation from RPM

I installed PostgreSQL 7.1-1 from RPM on RH7.0 (I used GNOrpm). Then I opened a terminal and ran /etc/rc.d/init.d/postgresql start chkconfig --add postgresql as per README_rpm-dist (Lamar Owen) psql works OK, pgaccess displays an error message (PQConnectPoll() --connect() failed... check if

[GENERAL] Temporary table

CREATE TEMPORARY TABLE table (... Where is the table created? On HD (what dir), in memory,... Thanks, Mihai Gheorghiu ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] What is faster?

I have a short table (10 records) with a primary key column. What primary key column data type will make search faster: int2 or char? What about char(n) n=2,3...? I'm looking for speed, as that search is very frequent. Thanks, Mihai Gheorghiu ---(end of broadcast

[GENERAL] Migration from MSAccess

e 'lo' in catalog". Thanks everybody, Mihai Gheorghiu ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Special characters

I want to switch from MSAccess to Postgres. 1. I have memo fields that include new line characters (I don't know whether it is actually a CR). How can this be exported to Postgres? 2. How do I query for strings that include single or double quotes (e.g. O'Hara)? Thank you all.

Re: [GENERAL] Conversion from MS Access to Postgresql

I tried to export an Access Yes/No field to pgsql boolean and got an error message. By default, Access (and the ODBC driver) exports Yes/No to bpchar. However, I want to use bool. Any suggestions? Thanks, Mihai -Original Message- From: Stephen Davies [EMAIL PROTECTED] To: G.L.Lim

[GENERAL] Data type

A logical field (Yes/No) in MS Access was exported as bpchar in Postgres. I failed to find this data type in the User's Manual. Only bool is mentioned there. Please advise. Thanks, Mihai

[GENERAL] Dump

I wanted to back up a database prior to upgrading to 7.0.2 pg_dump dbname dbname.bak FATAL 1: Memory exhausted in AllocSetAlloc() PQendcopy: resetting connection SQL query to dump the contents of Table 'tblname' did not execute correctly. After we read all the table contents from the backend,

Re: [GENERAL] PostgreSQL capabilities

, Mihai Gheorghiu wrote: http://networkdna.com/database/index.html mentions that PostgreSQL is capable of "Online backup". What does that exactly mean? I'd like to be able to run a synchronization (in MS Access terms) (or "incremental backup"???), i.e. to have two databa