PostgreSQL Database Forum

Dear my friends... I want to change the datatype of a completed table (has had already content). But I don't know how. Here is my try: " kv=# alter table customer alter column address set type char(150); ERROR: syntax error at or near "type" at character 47

Hi everyone, I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2 that given a tree node id (ictid) will return all the nodes below it in the tree, one row per node. When I try and execute the function I get the following error message: CONTEXT: PL/pgSQL function "findsubcategories" line 15 at for over select rows...

hi people, i am using mysql and i am having the following problem.... I know this is not the correct to ask this problem. but i am need of help urgently thats why i posted this here. but please help i have a table with the following fields .when i try to enter data i get the following error.any help would b

Hello. I have created a new group in the Google Groups beta site for PHP + PostgreSQL development. This group is for questions on advanced web development with PHP and PostgreSQL using Linux. Topics include functions, regular expressions, classes (OOP), speed, security, editor customization, SQL, and software installation/maintenance. ...

Hi, I am seeing a different sorting behaviour for varchar columns in Postgres 7.4.2. postgres 7.4.2 is ignoring case for varchar columns for "ORDER BY" commands where as 7.2.2 is not. I am in a situation where I need to do diff from the select outputs of two databases - one in 7.2.2 and one in 7.4.2.

Hello, my web application grows slower and slower over time. After some profiling I came to the conclusion that my SQL queries are the biggest time spenders (25 seconds). Obviously I need to optimise my queries and maybe introduce some new indexes. The problem is, that my application uses dynamic queries. I therefor can not determine...

Just wondering, is updateable views slated for a future version of Postgresql? In addition to using rules that is. CSN __________________________________ Do you Yahoo!?

Today, queries to one of our tables started giving the following error: ERROR: root page xxxx of "primary_index_name" has level 0, expected 3. What would cause that? We did have a earlier today, methinks they are probably related. It's a big table, in the neighbourhood of 45 million rows. How can I fix the problem? -Adam Palmblad

Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks or the likes) type of program? What could be the potential drawbacks of using PostgreSQL (perhaps its big size)? What would be a better database for that kind of job? Kaarel ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will...

I'm de-duping a 45-million-row table (about 4 gigs) by creating a new table with the unique rows of the first table (should be about 3 gigs). I'm on a 64-bit SuSE Linux with 2 gigs of memory and another gig of swap space. I tracked postmaster's use of memory and swap space after I run the query, and I noticed that as soon as postmaster first...

Hi list, when doing a large Insert I get in the logfile: 2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000BD" 2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C2" 2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C3" 2004-08-03 07:34:00 LOG: recycled transaction log file...

Dear List! I'm new on this list, and in PostgreSql too. I have the following problem: I would like to lock out users after the 5th failed login (incorrect password). I can't found any information from it in PostgreSql docs. Can you help me, how to make it?

Dear my friends... I want to drop a rule but I get an error message. Could you tell me my I can not drop (delete) the rule? Thank you very much in advance. ps: Here is my try underbelow: postgres@patrix:~> psql kv

Hello, yesterday I ran into problems installing my first PostgreSQL on Solaris. My main problems consisted on missing packages, because the test system I had to use was a very small installation. After spending hours on installing gcc+friends, we decided to install a new full solaris on the hardware. My question to avoid installation : Are...

I'm trying to set up the Interchange 5.2 shopping cart (icdevgroup.org) to use the CREATE SEQUENCE functionality of pgsql properly and I'm having some trouble. The table is called order_items and the field that should sequence is called autonumber. The Interchange DB config file looks like this for my order_items table: Database...

I've been running pg_autovacuum for a week or so, now and while I like it I'm having trouble trusting it. I have several small (~0-50 record) working tables that have high insert/update/delete activity. When I first set up pg_autovacuum they were being vacuumed every ~1-4 hours during the day and less often at night. Most of the time the...

Dear my friends... I am developing a database application with postgres 7.2.x, qt on SuSE 9.1 . I am in a situation where I have to use QDataTable and I have to use QSqlCursor that support only 1 table manipulation ( QSqlCursor * cursor = QSqlCursor("viewpatrix", true, db); ). So, as a strategy I make a view. with this view I hope I can...

Hi, i searched the docs and the archives and was really wondering that i have not found anything searching for "functional index primary key". i would like to have a table of members with nicknames which are case-insensitive but i would like to save the user given name case-sensitive to display 'JimKnopf' instead of 'jimknopf': CREATE...

When I distribute a binary-only distribution of Postgre to a client, can I exclude some parts of Postgres (to make it smaller), e.g. documentation (all of doc/), some PL's, or even psql, initdb, pg_dump, etc.? -- dave

Dear my friends... My boss requested that my application is equipped with emoicon (smiley) in the sales report. That's why I need to know, is it possible to save a small image into the postgres? with which data type should I define the column (field)? I have a currently table, salesreport. Its fields are : noapp (appointment number,...

Hello ! My ODBC driver in MS Visual Basic 6 refers also to "Stored procedures" as Record source. What are these stored procedures, I don't find anything in the 7.4 documentation, Where can I find documentation ? Many thanks. Luc

В Пнд, 02.08.2004, в 14:49, Federico Di Gregorio пишет: > On lun, 2004-08-02 at 14:30 +0200, Markus Bertheau wrote: > > Hi, > > > > I wonder if there is some kind of support for PostgreSQL's arrays in > > psycopg? The fetch routines return the literal array syntax of > > PostgreSQL. I'd want the fetch routines to return a list for...

Hello. It seems that every time I make a change to pg_hba.conf, I have to restart the database server for the new authentication to take effect. Is there a way to have the server use the new pg_hba.conf authentication without restarting the production server. Thanks, Si

All, I am looking for documentation on the pg_proc.proacl column. I am working on a schemadiff and when I expect the acl to be the same, they come out slightly different. I searched the PG 7.4 doc site, and didn't find anything except the one liner on the pg_proc description page. Any kind of documentation, other than the code itself, would...

Hi, EXPLAIN on delete stamements works, but doesn't show me all the subsequent deletes or checks which has to be done because of foreign keys cascading/restricting. Is there a solution to show up which tables are checked and which scans the planner is going to use to check these related tables? kind regards,