| |
thread by: David Garamond |
last post Nov 23 '05 by: David Garamond
Wouldn't it be cool if someday psql could do value completion?
# delete from person where lastname = 'Garam<tab>
# delete from person where lastname = 'Garamond' _
# delete from person where firstname = 'Da<tab><tab>
# delete from person where firstname = 'Da
Damian Darren Dave David Dawson
# delete from person where firstname...
|
thread by: Daniel Schuchardt |
last post Nov 23 '05 by: Gaetano Mendola
Hi ,
can anybody tell me the postgres - syntax for begin excepion end if I
want to ignore the error?
BEGIN
exception ...
EXCEPTION
WHEN OTHERS THEN ?????????????what to write for do nothing?????????
END;
|
thread by: Shelby Cain |
last post Nov 23 '05 by: Bruce Momjian
When I enable log_statement_stats AND log_parser_stats
in my postgresql.conf file and attempt the start the
service I receive the following error:
"Could not start the PostgreSQL Database SErver
8.0-beta1 service on Local Computer. The service did
not return an error."
Attempting to start the server manually using the
following...
|
thread by: Ulrich Wisser |
last post Nov 23 '05 by: Ulrich Wisser
Hello,
yesterday I took our database down and started in single user mode.
After reindexing of three tables I thought a vacuum would be a good idea.
backend> VACUUM FULL VERBOSE ANALYZE
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
WARNING: Index...
|
thread by: Ulrich Wisser |
last post Nov 23 '05 by: Tom Lane
Hello,
the maintainance chapter in the docs gave me the impression that a
reindex of some tables would be a good idea. Last night I took the
database down, started up in single user mode and tried to reindex.
The reindex of tables did work fine, but a reindex of the database
did not. Please see a session transscript below.
How can I...
|
thread by: val |
last post Nov 23 '05 by: val
Hi;
I am being asked if the ODBC drivers are "compliant to 3.x
standards with backwards compatibility to 2. x functions". We
are currently using 7.3.5 and the last ODBC driver I downloaded
for use on Windows is psqlodbc-07_03_0200.zip
I have had a peruse about and not found any info about
standards compatibility. Would one of you be...
|
thread by: John Ramsden |
last post Nov 23 '05 by: John Ramsden
I have a script running on PHP v4.3.6 (cgi) that hangs forever
in a call to the Postgres pg_get_result() function when and only
when the query length is 65536 or more bytes.
The query is a simple INSERT, of a single ASCII value into a
'text' type field, and works fine for shorter queries.
(As the code first calls pg_escape_string() on the...
|
| |
thread by: Jason Tesser |
last post Nov 23 '05 by: Mike G
I just downloaded the new beta for windows. I usually only use postgres
on Linux. Could someone tell me how to use pg_dump /restore in windows.
I cannot use it from the cmd prompt. Thank you I know this is a stupid
question.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the...
|
thread by: Elie Nacache |
last post Nov 23 '05 by: Kris Jurka
Hi All,
A data writed in a table but not commited is not accessible in modification by the resultset. The error returned is "Cannot move to index of 0".
BTW in SQL a sequence of INSERT, UPDATE and then COMMIT work fine.
I'm using the same code with oracle and it's working well.
Is it a BUG !?
I'm using psql 7.4.3 on Linux 9.0
|
thread by: Raymond O'Donnell |
last post Nov 23 '05 by: Arthur van Dorp
Hello all,
I've installed the new Win32 version of 8.0-beta1, running as a
service. When I connect to it using pgAdmin III and attempt to list
databases, I get an error: 'Column "datpath" does not exist.' I got
the same error reported when starting postmaster from the command
line using pg_ctl.
It's not causing me any real problems,...
|
thread by: Sven Willenberger |
last post Nov 23 '05 by: Sven Willenberger
Created a pg_dump with Fc (custom format compression) that resulted in a
300+MB file. Now trying to pg_restore this thing fails with either an
out of memory error (as in the subject line) on FreeBSD 4.10-STABLE or
a:
pg_restore in malloc(): error: allocation failed
Abort (core dumped)
error on FreeBSD 5.2.1-P9 (RELEASE)
In both cases I...
|
thread by: Karam Chand |
last post Nov 23 '05 by: Laura Vance
Hello,
My linux admin left the job. We had a PostgreSQL
installed under his username. He used to maintain it.
Now I am looking at the Linux box and I am just a
super duper newbie in Linux administration.
The previosu admin had a database created under his
name coz PostgreSQL dosnt allow root database.
|
thread by: Renato Cramer |
last post Nov 23 '05 by: Michael Fuhr
Hello All,
There is data of several enterprises (ours clients) in a single database.
All tables have a column on primary key what identify the enterprise called
id_enterprise.
My objective is restrict users access on rows depending on value of the
column id_enterprise.
That is, an user can access data only of his enterprise.
I don't...
|
thread by: Matt Van Mater |
last post Nov 23 '05 by: Vivek Khera
I'm looking to get a little more performance out of my database, and saw in
the docs a section about disabling autocommit by using the BEGIN and COMMIT
keywords.
My problem is this: I enforce unique rows for all data, and occasionally
there is an error where I try to insert a duplicate entry. I expect to see
these duplicate entries and...
|
thread by: Sim Zacks |
last post Nov 23 '05 by: Robby Russell
Are there known issues and how do I get around installing the PostGreSQL
7.4.3 binaries on RH 8?
I tried installing it and it needed dependencies. So I got the
dependencies, which included OpenSSL, but it wouldn't let me update
OpenSSL because the current version is needed for other programs.
It also says postgresql = 7.2.2 is needed by...
|
| |
thread by: Raphael Bauduin |
last post Nov 23 '05 by: Tom Lane
Hi,
I'm looking at the logging of a database we'll put in production soon.
I've seen some posts on this list about history tables, like mentioned in http://www-106.ibm.com/developerworks/web/library/wa-dbdsgn2.html .
I think I'll go that way too, but I still have some questions on the approach, and would appreciate any advice on it.
Here...
|
thread by: Paramveer.Singh |
last post Nov 23 '05 by: Tom Lane
hi!
I tried to extend the grammer for plpgsql by editing
postgresql-7.4.3/src/pl/plpgsql/src/gram.y
but as soon as you compile it (even without any changes)
it gives an error
user$ make
bison -y -d gram.y
|
thread by: Christian Traber |
last post Nov 23 '05 by: Tom Lane
Hi!
just playing with tablespaces...
- moved a existing table to a new tablespace
- tried to move it back to default tablespace
(ALTER TABLE accounts SET TABLESPACE pg_default;)
Got the following error in logfile:
|
thread by: Nikola Milutinovic |
last post Nov 23 '05 by: Bruce Momjian
Hi all.
Ran into a minor showstopper. Sometimes, my CC is just too much of a
nitpick, but on this matter, I agree with it. "./src/timezone/zic.c" has
a mismatch in declaration and definition of "memcheck(...)" function. My
CC beltched on it (I was running it in strict ANSI mode). The diference
is this:
static char *memcheck(char...
|
thread by: Jon Brisbin |
last post Nov 23 '05 by: Richard Huxton
We're trying to figure out how we can implement a reasonably simple cluster
of postgres servers on a private network at our store locations. The idea
is to have a group of 2-6 PCs each be able to share data in a replicated
manner. Having a separate database server is not an option due to the
immense cost and logistics (we have over 800...
|
thread by: Shanmugasundaram Doraisamy |
last post Nov 23 '05 by: Richard Huxton
Dear Group,
We have a java front-end for postgresql 3.4. When
we monitor the system usage using top we find couple of postmasters
taking up close to 90% of the CPU time in total. I would like to know
which are the queries that are currently running at this point of time.
How do we do this?? Another thing that I have noticed is that when I...
|
thread by: Scott Ribe |
last post Nov 23 '05 by: Scott Ribe
Here's my issue:
Data comes in and is inserted into the database automatically, into a base
table A. Later a human looks at the records, fills in some data, and now the
records are assigned to some derived table, B or C. In some cases there is
no way for the software to know at import time which derived type the data
actually is (that...
|
thread by: Eric B.Ridge |
last post Nov 23 '05 by: Eric B.Ridge
Been playing with the 8.0 beta of Postgres. It seems really nice. One
new thing I noticed is 'psql' displays RULE definitions in the \d
<viewname> output. This is nice compared to 7.3.x's inability to see
RULE definitions at all.
However, this makes the output of \d completely useless. Maybe my rule
definitions are atypically complex,...
|
| |
thread by: Igor Kryltsov |
last post Nov 23 '05 by: Igor Kryltsov
Hi,
If you can help me to correct my mistake.
To simplify my question:
I have table:
create table test (
name varchar(10),
|
thread by: Clodoaldo Pinto Neto |
last post Nov 23 '05 by: Stephan Szabo
Hi all,
I'm trying to copy a table with a text field column containing a new
line char to a file:
ksDesenv=# create table page(line text) without oids;
CREATE TABLE
ksDesenv=# insert into page (line)
values('1stline'||chr(10)||'2ndline');
INSERT 0 1
|