PostgreSQL Database Forum

hi i want to write a php script that will back up all tables for postgres on a weekly basis. does anybody know how to read the table names/columns from php? thanks

Hello, Im trying to get some kde database application working, but I cant get them connected to the postgres server. psql connect seamlessly with - lets say - music database. But kde application dont? I created the user "janusz" in postgres I lived untached /etc/postgresql/pg_hba.conf (I understand localhost can connect allthe time) ...

I need to change a varchar(32) to varchar(1024). It is a primary key that many tables reference. How do I do this without reloading the entire database?

The postgresql documentation claims that "on insert" rules are executed after the insert. This is not happening for me. I have a rule that is being executed even though the insert should have failed due to a foreign key check. The rule does an insert that is failing, and the whole insert fails. So in this case it's not a huge problem. But I...

I want to allocate a contiguous block of ID's from a sequence generator. My concern is that between the time I call nextval() to get the start of the block and setval() to set a new starting seqence number past the end of the block that some parallel computation may already have called nexval() and allocated something within my block, or...

I'm trying to create a template database as a superuser. I set the value in pg_database datistemplate to 't'. But when I create a database as another user i don't have any priviliges on the tables in the new database. So I granted ALL to PUBLIC on the tables in the template database. Now when I create a database with the new template I can...

I have a script that updates one record in a PostgreSQL 7.2.1 database through the Perl DBI. Here is the output from my log, which outputs the query sent to the DBI and the return value: --- Update query: UPDATE item SET status='SOLD' WHERE item_id=1129832 1 rows affected.

Hi Everyone, I have a rather trivial (I hope) question about OID types and PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default, I'm wondering if it is bad practice to allow the default behaviour. For example, if I have a database with 60+ tables (all tables have their own PK that is not of type OID) and all of them have an...

I have a tough SQL join query and I figured it out, so I thought you might find it useful. I have 3 tables with tracking numbers in them. I want to think of the sum of all these tracking numbers, then find non-matches to a master tracking number table. When I find non-matches (orphans) in the master tracking number table, I want to...

First, this may not be the correct newsgroup. I have some relatively basic questions on SQL. I tried to find a newsgroup that was specifically just about SQL, and was surprised to find that all the SQL-related newsgroups seem to be product related. But if I missed something, and someone can steer me to a correct newsgroup, please do so. ...

I'm having trouble restoring databases that have to lo type installed in /contrib/lo. The dump seems to work just fine, I get no errors when I execute the following command #pg_dump -Fc -o -b mydb > mydb_dump > CREATE DATABASE mydb_restore TEMPLATE template0

Hi, I'm a novice to postgress and need to constract a simple tree. In my table I have: regionID int parentID int name char I need to do two functions: find all the children of XXX parent and find if an item is a child of an XXX parent.

Hi, I have one trouble about exec sql define. Here's an example: EXEC SQL DEFINE INTSIZE 2; EXEC SQL DEFINE I_(x,y) char x; EXEC SQL TYPE CUSTOMER_RECORD IS STRUCT { I_(cno,2)

hi, i make programms with c# and i would like to know if there is an alternative to odbc(wich is not really fast) to dialog with postgre. thanks thierry

Hi, I wonder how this can happen. A "not null" field is set to "" even if a sequence should set this to next sequence number. Ok, I know it is not set to null, it is set to '' which is proven by the below Select statement but it is not set to the next sequence number and the inserts

Hello, I can set user varibales in postgresql (ALTER USER user SET search-path=$owner,public,other;) and I can reset. (ALTER USER user RESET search-path) But, how can I show user variables? ALTER USER user SHOW search-path; <-- error.

My company is researching the idea of moving from a very large, old and complex UniData DB to something else that is newer and quicker. I was thinking about PostgreSQL, but am not sure PostgreSQL could import the data, and / or what kinds of issues could arrise, not to mention if it's even possible in the first place. Your thoughs would be...

Hi I'd like to ask you when (if ever) you predict to release native support for Windows. And what PostgreSQL version will be the first supported. Thanks for answers jan

Hello, I've installed redhat enterprise 3 on a system to use as a db server. Manually I can install and run postgresql 7.3 (the one on the extras CD). The problem is when you try to add postgres as a service, it might add it, but it will not start it. To do this, we got a postgresql script, placed it in the init.d folder with all the other...

Hello I have 2 databases on PostgreSQL, for instance base1, base2. I connect to psql: psql -p 3333 base1 how can I access to base2 ? for instance I wont do instruction: insert into test(a, b) values select a, b from basa2.test

Is there a method to encrypt data on postgresql similar to SafeJDBC?

Hi group - I'm using php to extract data from postgres and print to browser. I have data that was input through checkboxes on a form - each checkbox had a different value but got pushed into the same column. So - my values look like this: surveys=# select distinct(additionaldeliverablearray) from csssurvey; additionaldeliverablearray...

I'm a PostgreSQL newbie and I had a quick question concerning a setup that I have. I current have three tables, a, b, and c. On my create table statement for table a, I have the following: create table a ( id VARCHAR(3) NOT NULL, name VARCHAR(15) NOT NULL, CONSTRAINT a_pk PRIMARY KEY (id) ) INHERITS (b);

I'm new to postgresql and I'm having problems with the 'nextval' function (or whatever it is called in postgresql). I created a table (called ADDRESS) using 'pgadmin' which has a serial field (called addressid). When I tried the sql statement: select nextval('public."ADDRESS_addressid_seq"') everything seemed to be working fine.

Bonjour, Is there an embedded sql precompiler for MF Cobol for Postgres or such a project ? Regards. Alain