Can someone please share some light on this
- Forwarded Message
From: Postgre Novice
To: pgsql-general@postgresql.org
Sent: Wed, December 9, 2009 5:23:18 PM
Subject: [GENERAL] ERROR: could not open relation with OID 59132
Hello ,
after google search i havent found any solution
Hi,
We have started using PostGreSQL for more than 3 months and it looks
awesome. Currently, we have been suing superuser by default as login
account. Now, the users are getting increased and we want to go away with
using superuser by default. We want to create the separate user account for
every
On Wed, 2009-12-09 at 15:38 -0800, DM wrote:
>
> How to Install compat-postgresql-libs-debuginfo on postgres 8.3.8 by
> compiling the source code.
> The way i have installed postgres is by compiling the postgres files.
You can still install it via RPM -- it doesn't matter whether you
compiled Pos
Guillaume Lelarge writes:
> I'm searching for a Unix implementation of ODBC working on SPARC 64 bits?
> iodbc doesn't seem to work well. DataDirect is really good but not free. And
> UnixODBC doesn't seem to compile.
What unixODBC version? If 2.2.14 doesn't work on Sparc I'm sure I'll
be heari
On Wed, Dec 9, 2009 at 6:24 AM, Stephen Tyler wrote:
> Thank you for your suggestions. I will turn on log_checkpoint next time I
> get the chance to restart.
>
You should be able to set this via a sighup to the server. No restart required.
--
Sent via pgsql-general mailing list (pgsql-genera
On 10/12/2009 3:31 AM, CG wrote:
Hi all,
We're using PostgreSQL 8.4 ... We do our nightly database backups with
pg_dump. I was doing a test restore and I encountered some data during
the reload that was in a table against the conditions of a foreign key
constraint. I run my restores with the "-e"
On Thu, Dec 10, 2009 at 8:38 AM, Greg Smith wrote:
> PostgreSQL on OS X uses a special fsync method by default named
> 'fsync_writethrough'. If you do this on your database you should be able to
> confirm it's using it:
>
> show wal_sync_method;
>
> This method includes a call to Apple's API to
All
How to Install compat-postgresql-libs-debuginfo on postgres 8.3.8 by
compiling the source code.
The way i have installed postgres is by compiling the postgres files.
Thanks
Deepak
On Wed, Dec 9, 2009 at 8:33 AM, AlexeyChe wrote:
>
> Hi there
> Need help, I just took the example from Postgres help, code:
>
> #include "postgres.h"
> #include "fmgr.h"
>
> #ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif
>
> PG_FUNCTION_INFO_V1(add_one);
>
> __declspec (dllexport) Datum add_o
> We just upgraded a customer's PostgreSQL installation from 8.3 to 8.4.1. I
> wanted to make a small change to the database. I wanted to take a backup
> before I did it, just in case. When I run pgAdmin from the
> PostgreSQL/8.4/bin folder and try to take a backup, the backup fails. The
>
On Wed, Dec 9, 2009 at 2:35 PM, Ron Mayer wrote:
> Scott Marlowe wrote:
>> Actually, it's usually the drives that lie about fsync, especially
>> consumer grade (and some server grade) SATA / PATA drives are known
>> for this.
>
> I'm still looking for any evidence of any drive that lies.
I've tes
Ron Mayer wrote:
Scott Marlowe wrote:
Actually, it's usually the drives that lie about fsync, especially
consumer grade (and some server grade) SATA / PATA drives are known
for this.
I'm still looking for any evidence of any drive that lies.
Is there actually a drive which claims to su
Stephen Tyler wrote:
The times are apparently in milliseconds. But that doesn't make any
sense for the 7200rpm SATA HDD, given it has an 8.3ms rotation time.
And the numbers for the SSD are basically identical to the HDD, apart
from the bare write timing.
Do I conclude that the sync timings
My silly question is, do I needo to install a postgreSQL server or the freeradius-postgresql package already takes care of it?!
My question it's because it doesn't recognize any user ids and the createuser
command.
Yeah, that's pretty much the way things work on unix-like systems.
Instead
Scott Marlowe wrote:
> Actually, it's usually the drives that lie about fsync, especially
> consumer grade (and some server grade) SATA / PATA drives are known
> for this.
I'm still looking for any evidence of any drive that lies.
Is there actually a drive which claims to support the
IDE "FLUSH_C
On Wed, Dec 9, 2009 at 5:11 AM, Stephen Tyler wrote:
> The times are apparently in milliseconds. But that doesn't make any sense
> for the 7200rpm SATA HDD, given it has an 8.3ms rotation time. And the
> numbers for the SSD are basically identical to the HDD, apart from the bare
> write timing.
Some more information on fsync using the test_fsync tool in
postgres/src/tools:
System is Snow Leopard 10.6.2 (64 bit). Volumes are HFS+ formatted.
PASS 1 - DATABASE VOLUME (SSD RAID 0)
===
$ sudo ./test_fsync -f /Volumes/SSD/fsync_test.out
Simple write timing:
On Wed, Dec 9, 2009 at 12:57 PM, Greg Smith wrote:
> You should turn on log_checkpoint in the postgresql.conf and confirm the
> slowdowns are happening around the same time as the checkpoint report gets
> written to the log files.
Thank you for your suggestions. I will turn on log_checkpoint n
Greetings!
We just upgraded a customer's PostgreSQL installation from 8.3 to 8.4.1. I
wanted to make a small change to the database. I wanted to take a backup
before I did it, just in case. When I run pgAdmin from the PostgreSQL/8.4/bin
folder and try to take a backup, the backup fails. The
Hi there
Need help, I just took the example from Postgres help, code:
#include "postgres.h"
#include "fmgr.h"
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
PG_FUNCTION_INFO_V1(add_one);
__declspec (dllexport) Datum add_one(PG_FUNCTION_ARGS)
{
int32 arg = PG_GETARG_INT32(0);
PG_
Hi all,
We're using PostgreSQL 8.4 ... We do our nightly database backups with pg_dump.
I was doing a test restore and I encountered some data during the reload that
was in a table against the conditions of a foreign key constraint. I run my
restores with the "-e" option to halt on errors, so
Sergey Levchenko writes:
> Why I get: update or delete on table "people" violates foreign key
> constraint "transactions_person_id_fkey" on table "transactions"
> But before that query I run: SET CONSTRAINTS
> transactions_person_id_fkey DEFERRED; before delete from people table
It looks to me l
Why I get: update or delete on table "people" violates foreign key
constraint "transactions_person_id_fkey" on table "transactions"
But before that query I run: SET CONSTRAINTS
transactions_person_id_fkey DEFERRED; before delete from people table
Log:
2009-12-09 20:01:51 EET LOG: statement: BEG
Le mercredi 9 décembre 2009 à 17:04:32, George Silva a écrit :
> Hello all again :)
>
> I have a question: is it possible to replicate the behavior of a rule
> INSTEAD of with a TRIGGER?
>
> For some specific reasons i need to use a trigger to update a
> secondary table, but i don't want the chan
Hello all again :)
I have a question: is it possible to replicate the behavior of a rule
INSTEAD of with a TRIGGER?
For some specific reasons i need to use a trigger to update a
secondary table, but i don't want the changes to happen in the primary
table too.
Is it possible to do it? If so, how?
Hi all,
I'm searching for a Unix implementation of ODBC working on SPARC 64 bits?
iodbc doesn't seem to work well. DataDirect is really good but not free. And
UnixODBC doesn't seem to compile.
Any ideas?
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
--
Sent via pgsql-genera
John R Pierce a écrit :
> Jean-Yves F. Barbier wrote:
>> Joana Camacho a écrit :
>> ...
>>
>>> su - postgres
>>> createuser radius --no-superuser --no-createdb --no-createrole -P
>>>
>>^^
>>
>>> createdb radius --owner=radius
>>>
>>
Jean-Yves F. Barbier wrote:
Joana Camacho a écrit :
...
su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P
^^
createdb radius --owner=radius
^^
There's a slight contradic
Joana Camacho a écrit :
...
>
> su - postgres
> createuser radius --no-superuser --no-createdb --no-createrole -P
^^
> createdb radius --owner=radius
^^
There's a slight contradiction...
--
***
***
*
Hi, I'm trying to set up a database with freeRADIUS server and I'm getting
some doubts.
I installed freeradius-postgresql package and nothing else. I've configured
all the files like it explains in the SQL How To on FreeRADIUS wiki. So far
so good, but at this part:
"
*Setting up the RADIUS databa
On Tue, Dec 8, 2009 at 3:51 PM, Scott Marlowe wrote:
> On Tue, Dec 8, 2009 at 12:12 PM, Allan Kamau wrote:
>> Hi,
>> I did follow the basic advise and consulted the documentation for
>> "SELECT" and came across "[ FETCH { FIRST | NEXT } [ count ] { ROW |
>> ROWS } ONLY]" clause which seems to sat
Le mercredi 9 décembre 2009 à 12:38:33, George Silva a écrit :
> Hello guys,
>
> Still having some trouble with this.
>
> I'm trying to use a case when, but postgres is still giving me syntax
> error.
>
> CREATE OR REPLACE RULE instead_update AS ON UPDATE TO foo
> DO INSTEAD
> (
> CASE SELECT e
Hello ,
after google search i havent found any solution or clue for this specific case:
Background:
Postgresql: 8.3.0
select version();
version
PostgreSQL 8.3.
Hello guys,
Still having some trouble with this.
I'm trying to use a case when, but postgres is still giving me syntax error.
CREATE OR REPLACE RULE instead_update AS ON UPDATE TO foo
DO INSTEAD
(
CASE SELECT exists(SELECT 1 FROM versioning.foo_version_1 WHERE
OLD.oid = NEW.oid) as a WHEN a=true
On Wednesday 9. December 2009 09.06.12 Guillaume Lelarge wrote:
> Le mercredi 9 décembre 2009 à 01:52:03, George Silva a écrit :
> > [...]
> > I can't seem to understand why a simples if is not working on the
> > creation of rules.
> >
> > I tried both ways (am i missing something?):
> >
>
> Sur
Thanks for that clarification Merlin,
The server/client is on a workstation that is essentially private (I
share some time with students, but they don't have pg access). The locks
are across sessions. There are three perl scripts that connect to a pg
db, one loads the database and creates some com
Thanks Tom,
That was my initial view and I'm still not convinced that I'm wrong - I
can see no way that the server can tell that the query came from a
process without a terminal (though I may be missing something here).
Unfortunately I'm working at the boundary of my knowledge for both
torque and
Le mercredi 9 décembre 2009 à 01:52:03, George Silva a écrit :
> [...]
> I can't seem to understand why a simples if is not working on the
> creation of rules.
>
> I tried both ways (am i missing something?):
>
Sure. IF does not exist in SQL, and you can only put SQL statements in a rule.
Inste
38 matches
Mail list logo
