PostgreSQL Database Forum

Hello, Could anyone explain why the following is no longer supported by default. Now I have to write a function upper(inet). I have a script which suddenly stop working after the upgrade:))) I just want to know why:) Kaloyan template1=# select version();

I have two varchars on my table... I tried to run the following: VMGEngine=# update user_account set editor_status = 'true' and administrator_status = 'true' where rec_num = 20; ERROR: column "editor_status" is of type character varying but expression is of type boolean I was expecting the single quotes to tell psql to treat the data...

I'm using PG 7.4.3 on Mac OS X. I am disappointed with the performance of queries like 'select foo from bar where baz in (subquery)', or updates like 'update bar set foo = 2 where baz in (subquery)'. PG always seems to want to do a sequential scan of the bar table. I wish there were a way of telling PG, "use the index on baz in your plan,...

I need to introduce an extra field in a table that has one field as primary key. The "problem" is that this new field should be combined with the existing pk to create a new combined pk for the table, how to I change the table? Using the Alternate command? How? Or do I need to create a new table and copy everything to the new table? ...

Dear all, I have this problem with getting information out of my database and I don't know if it is my knowledge of sql or that this is something that can't be done in sql. I have the following table: id fdate prod price stat nr_items sdate x1 23-11-2003 123 456 yes 7 01-11-03

Hi, What is a difference, if any, between: _________________________________ ALTER TABLE ONLY employee_role ADD CONSTRAINT fk_survey_id_employee_id FOREIGN KEY (survey_id, employee_id) REFERENCES employee_survey(survey_id, employee_id) MATCH FULL ON UPDATE C ASCADE ON DELETE CASCADE; __________________________________

hi! I'm new to postgres and I want to write a simple program in C in Postgresql7.4.2. I started trying to write down the example execq( ) ,that there is in the Documentation7.4.2, using the SPI functions but I can't even compile it. Can you please send me some more instructions? The C compiler that is installed is gcc and the OS is...

Hi, I'm trying to do a simple import of a comma delimited text file with COPY but it's returning an error. The file has been granted all permissions in Linux, so it's not clear to me what the problem is. Version 7.41 is installed... see below for details: A comma delimited text file has been placed in a local directory with permissions...

Hello, I'm using PostgreSQL 7.4.3 on a RedHat 9 Linux server (a P4 HyperThreaded, using the SMP kernel, in case this makes a difference). I'm not 100% sure I understand exactly why I am causing them, but let's say that several inserts inside an SQL transaction (i.e., a BEGIN / COMMIT-ROLLBACK block), where each insert references two...

With mysql I know how much space a row will take, based on the datatype of it columns. I also (approximately) know the size of indexes. Is there a way to know that in postgresql? Is there a way to pack (compress) data, as with myisampack for mysql? Thank you

I have a view, vw_tc_user_acccess, for determing user access to certain objects. On my machine, I get the following query execution times: 1. SELECT * FROM vw_tc_user_access: 33.04ms 2. SELECT * FROM vw_tc_user_access WHERE object_type = 'FORUM': 3.49ms 3. SELECT * FROM vw_tc_user_access WHERE object_type = 'CATEGORY': 107.53ms Queries...

hello, I have interesting problem... I have stored procedure, which works good, but only if input is "correct". Correct input is, when $1 is id, which exists in table... If I put non exists id, database fall down and restart with this error: server closed the connection unexpectedly This probably means the server terminated abnormally...

Is it possible to alter field type (from varchar to text) without making a new table? Regards, BTJ -- -----------------------------------------------------------------------------------------------

Hello, I've a strange problem with inheritance on PostgreSQL 7.4.1. It seems like tables don't inherits the primary key of the 'mother' table. Here's a little sample to show my problem : CREATE TABLE foo_a ( pk_idmyfoo INT2 PRIMARY KEY NOT NULL, myfoo_name VARCHAR(10)

Hi list. I just want to send to you an sql file containing tools for audit the UPDATE and DELETE statements in a database by saving all the modifications made by a network/system/database user. I hope you find it useful El Santi =====

Hi, I am working on the G System project (BSD licenced) and we are going to be (eventually) implementing a distributed database to hold data for the game that (eventually) will be developed. People have (though I don't think anyone has seriously investigated yet) suggested that we use a grid with postgresql databases to serve the data. There...

Our application currently runs in Microsoft SQL Server and we are porting it over to Postgres. When we write enbedded SQL queries for SQL Server, we need to reference user-defined functions with the prefix "dbo." (e.g., "dbo.Function_Name()"). In experimenting with Postgres, it appears that we can create a schema called "dbo" and then...

Hi! Is it possible to copy/migrate one database from one postgres server to other copying just the files in /var/lib/postgres/data/ ? I can't use pg_dump because it give me an error. I think than the instalation of postgres is corrupt because it give me a lot of error like "ERROR: relation "pg_catalog.pg_user" does not exist". Thanks,

Hello everyone... .... currently I am dealing with migrating the (unfortunately highly proprietary) document management software we are running here from MS Windows NT Server 4.0 to some more reliable environment. This software relies on a file system to actually store the documents it handles as well as on a database to keep them sorted....

Not a big deal, but I'm transferring a dumpall and it's choking on databases where the owner no longer exists. Maybe it shouldn't be possible to delete a user while it still owns databases, or maybe a cascade option, or requiring changing the ownership to another user? CREATE DATABASE "orphan" WITH OWNER = "deleted" ...; .... SET SESSION...

I have two tables like following: create table attendancereport ( id serial unique not null, staff_id integer not null references staff(id), schoolyear varchar not null references schoolyear(year), students_id integer not null references students(id) ); // schoolyear.year in format "2003 - 2004".

Hi list, i'm a bit confused. I have a table with a trigger after insert. It is possible that this trigger will do inserts in the same table, but is the after insert trigger fired again in this case? (I would need this) e.g. USER INSERT

Hiya I have now managed to get my code to function correctly for a none present db, and one that is shutdown whilst it is being used. In both cases my code functions and happily recovers on the db's return. However one of the tests I performed was to kill -9 the postmaster process to see how it would handle that (assuming the same...

Hi, lately I've been acused of "stone-age maintenance procedures". Hopefully I will find some help to develop from stone-age to roman empire. ;-) To optimize the performance and to minimize the maintainance needs I would like to ask you guys about some values in my postgresql.conf. select version();

unsubscribe