Forum: PostgreSQL / PGSQL

Hello I have compiled my php with --with-xmlrpc option to use xmlrpc server. Everything works fine, but there is one problem. Array (indexed...

postgres does not seem to pick up the following parameter in the postgresql.conf add_missing_from = false Setting the parameter via psql,...

I'm using ISO-8859-5 so should I change this to unicode? a _____________________________________________________________________ 12move...

Hi Everyone Has anyone been able to compile uniqueidentifier-0.2 on the openBSD 3.6 environment with Postgresql 7.4.3? We need to use this...

Hi, I'm using postgres 8.0 and I'm collecting data from many countries. So I've some slovakian data and i can't get properly into my table (COPY...

Hi, how can I import a SVG file to a row?? The main problem is that it has many postgres scape symbols. Can I utilize the 'text' type for that?...

Marc G. Fournier wrote: I want to make sure I understand this post. Does this mean that the patch will be included in all the source/binaries...

Hi All, Is there a way to stop a auto generated sequence from incrementing for some time and then activate it to do the increments. Regards ...

I merged 2 tables into 1 table and created a view for each of the tables so as not to break existing applications. I renamed the old tables with...

hi, I'm trying to make some hardware upgrades (increasing disk capacity) to the machine where the database server is running. So, I've backed up...

Hi, I am using PSQL on RedHat Linux 6.2...version given below. I inserted a new DB with somewhere around 200 tables and each table having...

On Jan 30, 2005, at 9:24 PM, Rick Schumeyer wrote: I think there are much better ways to do this. If the result set is large, the user could...

PostgreSQL users, What are the restrictions on naming tables or columns in tables other than uniqueness (assuming ascii characters)? For instance,...

I am having an issue with trying to dereference a 2-dimensional array in plpgsql. The idea is to have an setup like: DECLARE myarray varchar;...

Hi, how can I determin the number of elements of an array? I saw function array_dims() which returns a string value representing the dimensions of...

A couple of issues. I went to unsubscribe from one of the many PG lists to which I'm subscribed so I went to my original confirmation message and...

I have a table like this: create table objects ( id serial primary key, name varchar not null, parent integer references objects(id) default...

Marian POPESCU <softexpert@libertysurf.fr> writes: That bug was certainly fixed long ago, which means that whatever you have is some other bug. ...

Hi Announcing ShellSQL 0.7 to an unsuspecting world... ShellSQL is a utility to allow SQL to be intergrated easily into UNIX/LINUX shell...

I realize 7.2.4 is long in the tooth, but it's an old system that's been running for several years now. Someday we'll upgrade... However, part...