Indexes could get corrupt, requiring rebuilding.
That problem is gone
with WAL. Transaction commits where always safe.
Thanks. I was specifically asking about Result '3'
above mentions 'totally corrupted table page content
because of partially written data pages' . Is this
With 7.1b4:
test=# create table auction_type(id serial,login text,birthday timestamp);
test=# create table auction(unique(login)) inherits("auction_type");
ERROR: inherited attribute "login" cannot be a PRIMARY KEY because it is not marked
NOT NULL
But I didn't ask that "login" be a PRIMARY
Tom Lane wrote:
Do a VACUUM ANALYZE, for starters. These results look like the planner
is working with the initial default estimates for a never-vacuumed table.
Indexes might be a good idea too.
http://www.postgresql.org/devel-corner/docs/postgres/indices.html
has a good intro to the
If there's no simple way to do this, I think I found an example of what I
need in function printQuery in psql/print.c
Alex.
On Fri, 23 Feb 2001, adb wrote:
Is there an easy way in libpq to get the results from
any query as strings.
Imagine a cgi where you input any query and then it
Thanks ! I'm using JDBC to insert into the tables.
Would it throw an SQLException in such a situation ?
Rini
--- "Diehl, Jeffrey" [EMAIL PROTECTED] wrote:
I happen to know this very well... It handles
things very gracefully as far
as I can tell. I complains that it can't extend the
table
We have a number of client machines running Debian Linux, "potato"
release (i.e. 2.2, latest stable). The provided PostgreSQL is release
6.5.3, but I managed to track changes in unstable ("woody") until 7.0.2,
as long as packages were built using an older glibc. Now, unstable
packages (of 7.0.3)
Hi,
I have a
- development machine with postgresql 7.0.3 installed and php 3.0.16
with phplib 7.0.2
- production machine idemdito
When running my webapplication on the development machine I have no
problems, but when running it from the production machine I constantly
get the message:
[EMAIL PROTECTED] (Bruce Richardson) writes:
OK, great. Now - if a table has both a before-update trigger and an
DO (as opposed to DO INSTEAD) update rule and the trigger cancels the
update, is the update rule (or rules) cancelled?
No. The trigger can only cancel the update of the specific
Hi. I am trying to copy tables. I want to copy a table in one database to a
table in another database. The tables are identical. Here is to code and the
error when using DBI. Can I just use postgresQL somehow?
Thank you.
Table= fs648
Hello,
I am using the postgres driver for my Java code (JDK 1.2.2) which came
with the Postgres 7.0.3 tar file. I am trying get the name of a column
which is essentially the primary key in this table. Unfortunately, the
result set returned does not have any records(as shown below). This code
Hello,
I'm new to Postgresql and just tried to write my very first pgsql
trigger procedure. So
please forgive me if this is a stupid question.
This is what I did:
1. using bash as user postgres (my db superuser) on my RH6.2 linux box:
bash$ export PGLIB=/usr/lib/pgsql
bash$ createlang plpgsql
Hello Mitch,
I have been trying to do just that and hove found that by going to my init.d
directory and starting up the "postgresql" service helps.
Now the problem seems to be that even though I have just used "pg_passwd" to
add me as a user, I am now getting an error message back saying that:
I use debian sid, kernel 2.2.18, libc6 2.2.2-1, postgresql 7.0.3-4
After upgrading to perl 5.6.0-19 I haven't been able to use my postgresql function
created with LANGUAGE 'plperl'.
Calling function failed with message:
"ERROR: Load of file /usr/lib/postgresql/lib/plperl.so failed:
Hi,
Does anyone know how postgres/ postmaster handles the
situation where the physical hard disk space is full ?
Does it crash / corrupt the database, or does it
cleanly exit with appopriate message so that relevant
tables can be pruned (by the user) to free up disk
space and get it working
Hi,
I happenned to come across the following in the
documentation on WAL implementation in v7.1 -
*
Before WAL, any crash during writing could result in:
1.index tuples pointing to non-existent table rows
2.index tuples lost in
i got help with this from one of the developers on irc, thanks man,
sorry i forgot your handle:
(hope this is right)
select keyword, count(*)
from facts
where having count(*) 1;
i think that is it, i dont have to table anymore,
building a better schemea and more stuff for everything,
but that
Hi all.
This my code snapshot:
CREATE FUNCTION CreateObject(varchar(600)) RETURNS int4 AS '
DECLARE
. . .
ObjectSeqName text;
BEGIN
. . ..
ObjectSeqName := ''ObjectLog'' || ObjectID || ''_Seq'';
CREATE SEQUENCE ObjectSeqName start 1 increment 1 maxvalue 2147483647
a simple question:
in the version 7.1 is there a timestamp in this logfile
it's really bad if someone lokks at the logfile and one does not know when
the error happenend.
If anyone knows abaout it please tell me.
Ewald
Please tell me where and how I get the PL/PGSQL Programming Guide
and Reference Guide? Because the online documentation pages are not
enough examples.
Thank you very much!
--
Why we want to teach our babies to talk and walk,
then later we tell them "sit down!", "be quiet!" ?
Democracy is not a
Hi all.
This my code snapshot:
CREATE FUNCTION CreateObject(varchar(600)) RETURNS int4 AS '
DECLARE
. . .
ObjectSeqName text;
BEGIN
. . ..
ObjectSeqName := ''ObjectLog'' || ObjectID || ''_Seq'';
CREATE SEQUENCE ObjectSeqName start 1 increment 1 maxvalue 2147483647
Meanwhile, I've found the source of my problem myself. When I drop a
function and re-create it (this is what phpPgAdmin does when "modifying" a
function), I also have to drop and re-create the corresponding trigger.
Again one of these 'gotchas' for beginners...
mg schrieb:
Hello,
I'm new to
Is there a way to temporarily turn of the use of a
default editor when using psql ?
I need to do this when I try to use psql from a
script/batch file. Whenever a query is executed psql
displays a result, displays it - I need to hit 'q' to
end the display and would like to avoid this
unnecessary
Hello Tom,
thanks for taking a look at www-sql as I was going to use as a quick solution
to having to write so much code, but now a better solution seems to have
presented itself and should work without any problems with PostgreSQL.
I was initially looking at an application called MetaHTML, but
Hi all,
I try to use Postgres 7.0.3 on SCO Unixware 7.1.1. It compiles fine, but I
have the following error message when a launch psql:
psql: No pg_hba.conf entry for localhost, user postgres, database postgres.
I have made no change to the pg-hba.conf.
I have read in the documentation, it is
Hi,
I want to set encoding hungarian language.
I try to set LATIN2, but char order is "abc..".
The good order is "abc...".
What is the soultion?
Thx,
Andras
ICQ: `find [EMAIL PROTECTED]`
Hello, I working on your DB and I need to get some advanced data from the
System Catalog.
Pleace can you send me the system catalog or information.
Carlos A. Garca
[EMAIL PROTECTED]
--
E-Mail Gratis La Brujula www.brujula.com.ar
Su punto de partida internet
i have created a table having blob object but now i am
not able to insert a picture into the table. Can you
send me sql command to insert picture into the table i
need syntax. i tried through DB2IMAGE but failed to
insert.
if there is any other method of putting image in the
table, kindly
Attached are large object read and write functions I wrote based on
information I gleened from the DBD::Pg install test script.
They read and write to buffers rather than files because my
information wasn't comming from a file and wasn't going to one. However
if you need the data to go
hi,
i have a problem. i'm living in poland, which has its national characters. of
course they work great under postgresql, but:
when i use non-C locale all ~ '^xxx' and like 'xxx%' searches are not using
index scan.
this is paintful.
for some of the tables i dont need all national characters. in
29 matches
Mail list logo
