PostgreSQL Database Forum

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...

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;

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...

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...

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...

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...

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...

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...

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

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,...

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...

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.

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...

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...

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...

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...

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

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:

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...

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...

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...

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...

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,...

Hi, If you can help me to correct my mistake. To simplify my question: I have table: create table test ( name varchar(10),

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