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 ne
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 `post
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 respec
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?
http://www.postgresql.
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 p
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"
, 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, Octo
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
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 5
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 wit
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.
--
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 creation
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?
http://www.postg
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 broadcast)-
AIL 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. pos
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:
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 PROT
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
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 fiel
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:
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 unsubs
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]&g
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?
>
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
tens 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: [GENER
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 Gheo
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
ta
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 postma
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 broa
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
7; does not
exist'
conn=58261624, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
The message on screen appears later: "Unable to locate type name 'lo' in
catalog".
Thanks everybody,
Mihai Gheorghiu
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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.
--
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 <[EM
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
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, P
implemented...
>
>On Tue, 30 May 2000, 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
36 matches
Mail list logo
