> ~~
> Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
> ~~
It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record simultaneously.
Hi,
I have pg7.3.1 in my PC and pg7.2.3 in another machine. While i tried psql
pg7.2.3 from pg7.3.1 machine, it reports
ERROR: parser: parse error at or near "."
But still, it established the connection. Then it was found that i was
unable to execute any of the forward slash (\) commands from t
> What is the correct method of temporarily
> disabling all triggers from a table?
Disable:
db=# update pg_class set reltriggers = '0' where relname = 'your_table';
Enable:
db=# update pg_class set reltriggers = (select count(*) from pg_trigger
where pg_class.oid = tgrelid) where relname = 'yo
> So, I ran psql, did a \o to capture the output,
> did a select * from table where x=y
> whacked the first row in the output file, and added the COPY statement.
test_db=> \pset tuples_only -- does whacking for you
> This seems way too klunky, so I must be going about it all wrong. In
> Informix
> > I use postgresql 7.2. Last night i received a strange error and the
> > postmaster was crashed. It reported
> > 'cannot read block 1470 of pg_log: no such file or directory'.
>
> There is no pg_log in 7.2. You'll need to be more accurate about your
> situation if you want help ...
>
Sorry
> I need to set up a daily cron job that performs a pg_dump on a remote
> database. I can't figure out how to pass a password to it. How do I do
> this. Everything I've tried still comes up with asking me for a password
> when I test it.
>
$ export PGPASSWORD=user_pass
$ echo -e "Would do the tr
Hi,
I use postgresql 7.2. Last night i received a strange error and the
postmaster was crashed. It reported
'cannot read block 1470 of pg_log: no such file or directory'.
While googling i found,
"You can change "/\name/" to "/name/" in src/backend/catalog/genbki.sh,
then re-make install in tha
> One way might be to create a C (or C++) program that emulates your my_func
> function.
>
> We've tried doing this and did some benchmarks that show that the system
> works quite faster when you take out the stored procedures/functions and
> "translate" them into C programs.
Rightly said. C fun
Hi,
I am using postgresql 7.2 on RHL7.3.
I know that we cannot return a record or multiple values from a plpgsql
procedure unless otherwise it is a triggered procedure. But i have a need
to use a function in place of sub-select, something like
select * from my_table where field1 in (select my_fu
Hi,
I am not sure about the command line option, but the password for any user
can be set using ALTER USER sql command.
ALTER USER my_user ENCRYPTED PASSWORD 'my_pass';
also refer the documentation for details.
regards,
bhuvaneswaran.
On 8 Jul 2002, Stephane Schildknecht wrote:
> Hi,
>
>
status.
>
> Also i would like to ask the list if there exists
> some place where these are discussed,..
>
>
> regds
> Mallah.
>
>
> On Wednesday 29 May 2002 12:54 pm, Bhuvan A wrote:
> > Hi,
> >
> > How can we mirror an ENTIRE DATABASE? I have ca
Hi,
How can we mirror an ENTIRE DATABASE? I have came across pgreplicator
and it seems that it will mirror ONLY TABLES. Then how about views,
functions, triggers, sequences, etc.(somebody correct me if wrong)
So am i unable to mirror a ENTIRE DATABASE in postgres? Else shall i
do this way on per
On Apr 16, Dieudonne Nanga wrote:
> How do i insert a file in the database?
You mean large objects?
If yes, try
# select lo_import('');
this will return a OID.
and to access the same, try
# select lo_export(, '');
>
> ---(end of broadcast)---
hi,
here i have 2 machines which have postgres 7.1.2 & 7.2 running,
respectively. I did try pg_dump of database in machine (7.2) from the
machine where i have 7.1.2 and it produced the message
Archiver(db) version: 7.1
Aborting because of version mismatch.
Use --ignore-version if you think it'
14 matches
Mail list logo
