PostgreSQL Database Forum

Hi, Just spotted it on LinuxToday. I don't think there would be many 8-way configurations for opterons out there.. http://www.linuxelectrons.com/article.php/20041109100626264 Shridhar ---------------------------(end of broadcast)---------------------------

On 7.4.6 and earlier, we use apache's log rotation program as follows: pg_ctl start | rotatelogs ... If we have a configuration failure, say a bad parameter in postgresql.conf, we often don't quickly notice because it goes to stdout (into the log). It'd be nice if it went to stderr as well so we could see it without having to search the...

I'd like to propose that certain GRANTs on a table cascade to the table's implicit sequences. In the current implementation (as of 7.4.5 and 8.0.0beta3), a table owner must typically issue GRANT statements on both the table and its sequences to allow other users to insert records into the table. The GRANT on the sequences seems superfluous....

Hi, I have a problem with PostgreSQL 7.4. (With the old one 7.3 no probllem.) I create a connection and a statement : Class.forName("org.postgresql.Driver"); conn = DriverManager.getConnection( O_Constants.DB_CONNECTION_URL, O_Constants.DB_CONNECTION_USERNAME, O_Constants.DB_CONNECTION_PASSWORD); st =...

From the 7.4 docs: A column can be referenced in the form correlation.columnname correlation is the name of a table (possibly qualified with a schema name),or an alias for a table defined by means of a FROM clause, or one of the key words NEW or OLD. (NEW and OLD can only appear in rewrite rules, while other correlation names can be...

I have a database with a btree index on the 'removed' field, which is of type 'date'. However it isn't being used: techdb2=> explain select * from lines where removed > CURRENT_DATE; QUERY PLAN ------------------------------------------------------------ Seq Scan on lines (cost=0.00..243.47 rows=2189 width=324) Filter: (removed >...

Hello, I get an error in my log when connecting to postgres server on Windows. Postgres version : 8.0.0-beta4 LOG TEXT 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token "192.168.2.1/254"

Greetings. Is it possible to modify a foreign key constraint and force it to cascade on update? If there is no such SQL command, then is it possible to update some system tables to accomplish this? The problem is that I have a bunch of tables with FK constraints and I need to update primary key values in a lot of these tables. FK...

Is it possible to undo a transaction after it has completed (using 8 beta1) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

We've actually implemented this kind of thing in a different DBMS. The physical design consists of a single "organization" table that's something like: Org_key (primary key) Org_type (group, company, etc.) Org_level (group is 1, company is 2, etc.) Org_parent_key (foreign key to org that encompasses this org; this is a "recursive...

Hey Mike Cocks!!! Kiss my bullocks you bloody wanker! Go bugger off and take your yank arse to Burger King, you uncultured American cretin. Twits like you make me proud to be a Brit. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG:...

Hi, I'm using PostgreSQL 8. I have two tables that I am doing a join on, and the join executes very slowly. The table called Notification has a text field called NotificationID, which is its primary key. The Notification table also has an int4 field called ItemID, and it has an index on the ItemID field. The table

Hi! My 8.0beta2 database was initialized with option "-E UNICODE". Psql sets client encoding to Big5: database1=# \encoding big5 I get this error when inserting Big5 character 0xf9d8: WARNING: ignoring unconvertible BIG5 character 0xf9d8

When i write code in C to create the functions that define a new data type, how can i set a value so that the user sees a null value from sql. thanks Alex ---------------------------(end of broadcast)---------------------------

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A bad link in the ftp source directory inspired me to check the rest of it out: * Main README file needs updating. The URL is given as: http:/www.postgreSQL.org

A power failure led to failed postmaster restart using 7.4.6 (see output below). The short-term fix is usually to delete the pid file and restart. I often wonder why ipcs never seems to show the shared memory block in question? Am I using the wrong command? Does the key mentioned by pgsql map to the key in the ipcs output? And if the...

Hi folks. I'm creating a database using the following command: createdb -U pablo -W pablotest1 I'm prompted to enter the password to create the DB, and after doing so the db is created successfully. However, when I connect to this database via a php script, I can enter any valid database user, and I can enter anything for the password...

I'm wrestling with tracking down a deadlock. Here's a 7.4.6 deadlock message: ERROR: deadlock detected DETAIL: Process 15655 waits for ShareLock on transaction 9381; blocked by process 15600. Process 15600 waits for ShareLock on transaction 9388; blocked by process 15655. I know the original statement is printed right after this, but...

PG: 7.4.5 RH 7.3 Vac_Mem=12mg Doing a Vacuum Analyze on a table and it's been hanging for at least 2 hours. I could see no other users hitting the table at the time. This is the second time this has happened on this particular table and I can't seem to pin point the issue. If I kill the PID and restart the vacuum analyze it works...

I have a simple function which I use to set up a users' expiry date. If a field in a table contains an interval then this function returns a timestamp some time in the future (usually two weeks), null otherwise. I can't pass the interval from the table into a variable properly within the function. Any ideas? CREATE OR REPLACE FUNCTION...

I've made some functions, an i want these functions to be used by a specified user, but i don't want this user can see the code of the functions. Does somebody knows how can i do this? Sorry about my english, i'm spanish. Víctor Robador Capel Análisis de Sistemas y Programación www.creativosdolmen.com

Hi I'd like to know if there is a way to specify different transaction isolation levels for different tables in the db. The reason i'm asking this (rather bizarre sounding, i know ;-) ) question is the following: I'm importing about 2 million records into my application each day (the data is more or less fully replaced each day). My...

I need help to connect DBDesigner4 linux in ODBC to postgres. I'm having a problem connecting to a remote Postgres db using ODBC from my Debian Linux laptop. I've got ODBC set up (UnixODBC). In DBDesigner I'm simply trying to set up the connection using the ODBC datasource, but I keep getting the following error message: "Connection to...

Is there a visual designer (open source) in linux for database? I would like to developp my data model on the computer... I see "dia" with uml library but... it won't export to SQL. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Is there a way to create an index that would make this query be efficient and not perform a sequential scan? SELECT count(*) AS count,id FROM sometable GROUP BY id; ... I've considered creating a rule on this table which would put the results of this into another table anytime it is updated, but I thought there might be an easier way. ...