Tom Lane wrote:
Justin R. Smith [EMAIL PROTECTED] writes:
I've solved the problem.
I was accessing Postgres over an ssh connection and had enabled X
forwarding in the sshd server (not the default configuration). For
reasons that pass understanding, psql attempts to establish an
hi
setup:
postgresql 8.0.3 put on debian on dual xeon, 8GB ram, hardware raid.
database just after recreation from dump takes 15gigabytes.
after some time (up to 3 weeks) it gets really slow and has to be dump'ed and restored.
as for fsm:
end of vacuum info:
INFO: free space map: 248 relations,
Context:FREEBSD 5.4, postgresql 8.0.3
I'm not a C newbye and I'm
having a go at compiling my first, simple C(++) program:
#include
libpq-fe.h
int main()
{
PGconn *psql;
psql = PQconnectdb(hostaddr =
'127.0.0.1' port = '' dbname = 'curve' user = 'vi
return 0;
}
But
when
I compile it the
On Wed, Sep 28, 2005 at 10:11:45AM +0100, [EMAIL PROTECTED] wrote:
vicbsd# gcc -I
Don't use gcc to compile C++. Use g++.
Peter
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On Wed, Sep 28, 2005 at 10:11:45AM +0100, [EMAIL PROTECTED] wrote:
Context:FREEBSD 5.4, postgresql 8.0.3
I'm not a C newbye and I'm
having a go at compiling my first, simple C(++) program:
1. If it's a C program, you should name the file .c otherwise gcc is
likely to consider it a c++
Hi Tom, Hi Damon,
Am Dienstag, 27. September 2005 20:36 schrieb Tom Lane:
Damon Hart [EMAIL PROTECTED] writes:
I came across this thread after intermittently observing very similar
error messages last week from a PostgreSQL (8.0.2) server, e.g.:
SQL error: = 'type local_roll already
Hi list,
I am currently trying to give normal users some read access to some
tables in the database. I also need to give update access to one
column of one table.
I have the table contact, the user should not be able to read or
update anything in it, except for his own record. So I created the
I've just modified the extension with .c instead of .cpp and run:
vicbsd# gcc -I /usr/local/include/ prova.c -o prova -Lpq
/var/tmp//cc86RZZl.o(.text+0x25): In function `main':
: undefined
reference to `PQconnectdb'
Nothing seems to be changed!
Thanks
anyway.
Vittorio
Messaggio
Wijnand Wiersma wrote:
I have the table contact, the user should not be able to read or
update anything in it, except for his own record. So I created the
view v_my_account. When the user selects * from it he only sees his
own record. That works great. I also made a rule:
CREATE RULE
I agree with you that it's probably not hardware problem.
I had the exactly the same issues some months ago with the 8.0 version when
using temp tables in functions.
I changed the temp tables to standard tables and used the PID
(pg_backend_pid) to manage concurrent access to this table... The
On Wed, Sep 28, 2005 at 10:59:04AM +0100, [EMAIL PROTECTED] wrote:
I've just modified the extension with .c instead of .cpp and run:
vicbsd# gcc -I /usr/local/include/ prova.c -o prova -Lpq
/var/tmp//cc86RZZl.o(.text+0x25): In function `main':
: undefined
reference to `PQconnectdb'
2005/9/28, Richard Huxton dev@archonet.com:
Wijnand Wiersma wrote:
I thought that when a rule is applied the triggers which are triggerd
would also have the same userid as the rule query, but I was wrong.
Can you show the (cut down) contents of your trigger? It's difficult to
see what you
Hi Tom:
No way to get the core dump, this is what I did:
1) Add ulimit to /etc/rc.d/init.d/postgresql just before pg_ctl start
in the start section of the script:
...
ulimit -c unlimited
su -l postgres -s /bin/sh -c /usr/local/pgsql/bin/pg_ctl -D $PGDATA
-p
Is there a way to avoid trigger self-recursion?
In other words, update a table and have the trigger update another row in
the same table without calling the same trigger?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
On Wed, Sep 28, 2005 at 01:41:29PM +0200, Sim Zacks wrote:
Is there a way to avoid trigger self-recursion?
In other words, update a table and have the trigger update another row in
the same table without calling the same trigger?
No, although generally it's a sign of a coding problem. If
On Wed, Sep 28, 2005 at 11:40:11AM +0200, ruben wrote:
Hi Tom:
No way to get the core dump, this is what I did:
1) Add ulimit to /etc/rc.d/init.d/postgresql just before pg_ctl start
in the start section of the script:
snip
2) Restart postmaster
/etc/rc.d/init.d/postgresql restart
Wijnand Wiersma wrote:
2005/9/28, Richard Huxton dev@archonet.com:
Wijnand Wiersma wrote:
I thought that when a rule is applied the triggers which are triggerd
would also have the same userid as the rule query, but I was wrong.
Can you show the (cut down) contents of your trigger? It's
Sim Zacks wrote:
Is there a way to avoid trigger self-recursion?
In other words, update a table and have the trigger update another row in
the same table without calling the same trigger?
No a per-row trigger will fire for every row updated.
There is presumably some test you can make to see
Basically I have a table that is not fully normalized. When the user
updates a field that has a duplicate I would like it to update those
duplicate rows as well.
The code is very straightforward.
Update table1 set f1=new.f1,f2=new.f2,f3=new.f3 where pknew.pk
and f4=new.f4 and f5=new.f5
On Wed, Sep 28, 2005 at 02:20:57PM +0200, Sim Zacks wrote:
Basically I have a table that is not fully normalized. When the user
updates a field that has a duplicate I would like it to update those
duplicate rows as well.
The code is very straightforward.
Update table1 set
Thanks Martijn:
Martijn van Oosterhout wrote:
On Wed, Sep 28, 2005 at 11:40:11AM +0200, ruben wrote:
Hi Tom:
No way to get the core dump, this is what I did:
1) Add ulimit to /etc/rc.d/init.d/postgresql just before pg_ctl start
in the start section of the script:
snip
2) Restart
Good point. I don't know how I missed that one.
Thank You
Sim
On Wed, Sep 28, 2005 at 02:20:57PM +0200, Sim Zacks wrote:
Basically I have a table that is not fully normalized. When the user
updates a field that
El Sáb 24 Sep 2005 13:15, Tom Lane escribió:
=?iso-8859-1?q?Mart=EDn_Marqu=E9s?= martin@bugs.unl.edu.ar writes:
I can't create any VIEW at all. I'm using the latest debian testing
PostgreSQL (8.0.3):
Maybe you got a corrupt download?
How can I seek if it's a corrupt download or something
2005/9/28, Richard Huxton dev@archonet.com:
The solution is to mark your trigger functions with the SECURITY
DEFINER attribute and create them as a user who can access relation
contact.
http://www.postgresql.org/docs/8.0/static/sql-createfunction.html
Damn, I really really missed that one :-(
Hi,
Is there any tools to migrate MS SQL 2K
including:
- PK and FK
- Index and Contraints
- Trigger
- View
- Store Procedure
- User Accounts
I use Postgres 8.0.3 Windows.
Thanks.
Janning Vygen [EMAIL PROTECTED] writes:
I recently reported this problem and i would like to help solving it. But how
can i build a self-contained test-case? It just happens sometimes under load.
I didn't say you need to make it 100% reproducible; you just have to
make a case that someone else
[EMAIL PROTECTED] wrote:
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
On 9/27/2005 12:20 AM, George Essig wrote:
We have a database with about 30 tables and some RI. The RI
constraints,
however, were not named upon creation of the database 2-3 years ago
and
now when we get an
Mario Splivalo [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I've learned that one can't use temporary tables within the function
unless
EXECUTE'd the SELECTS from that temp table.
So, I have a function like this:
CREATE FUNCTION Foo1(int4, int4) RETURNS SETOF myType
AS
'
Douglas McNaught wrote:
CSN [EMAIL PROTECTED] writes:
Hmm, in putty (Terminal-Keyboard) I changed the
function keys and keypad from ESC[n~ to Linux.
Hitting F1-5 in psql outputs ABCDE - no segfaults!
Setting it to Xterm R6 also results in function keys
1-4 causing segfaults (there are also
Hi,
Our current project requires a fine-grained permission system (row-level
and possibly column-level as well). We have a pretty large (tens of
thousands) of users in the 'party' table. I'm thinking of choosing
Unix-style security for now (adding 'ugo' and 'owner' and 'group'
columns to each
Hi,
two questions
1. Why on page http://www.postgresql.org/community/lists/ no reference
to [EMAIL PROTECTED]
2. Somebody tried work Kernel Mode Linux and PostgreSQL, there were
problems?
---(end of broadcast)---
TIP 1: if posting/reading through
Hi,
Currently I have serious problem to migrate a
"production" MS SQL 2K to Postgres 8 for Windows.
Is there any tools to import MS SQL 2K to Postgres
8 including:
- PK and FK
- View, Trigger, Store Procedure
- Username
- Index and Constraint
- Diagrams
Regards.
Yahoo! for Good
Click
32 matches
Mail list logo