PostgreSQL Database Forum

What exactly is the "SQL_ASCII" encoding for databases? Is it like Unicode, UTF-8, ISO_8859_x, ...? In what cases wouldn't you want to use it? __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---------------------------(end of...

In one system I have a table of work to be done (for simplicity in this explanation I'll use a table consisting of id and status). A client-side app needs to fetch 10 available items from the table but naturally we don't want two clients working on the same 10 items. My first attempt at handling this was, in pseudocode: begin...

My company has just finished a simple replication system in java. We are now interested in sharing our work under the GPL license so that we can hopefully work with others in improving this product. Would such a thing be useful, or simply overly redundant considering the current development cycle of other more advanced systems? Thanks, ...

I have installed tsearch2 and have noticed that the gist index used to do searches grows and grows as I update rows, delete rows, or run VACUUM FULL ANALYZE. Below are some details: PostgreSQL 7.4RC1 Red Hat 9 Table "public.series" Column | Type | Modifiers...

Is postgres going to support in a future release the use of SUBSELECT in a CHECK expression ?? Thx

Hallo, we runs PostgreSQL 7.3.4 on RedHat 9. I initialized dbcluster with --locale=cs_CZ.UTF-8 and created database with --encoding=unicode. But following script generates error: -- -*- coding: iso-8859-2 -*- set client_encoding to LATIN2; create table t (txt text); begin; --inserted character is latin small letter r with caron, coded in...

After a abnormal system shutdown I am trying to run a vacuum full verbose ANALYZE and getting the following error. NOTICE: Analyzing classification NOTICE: RelationBuildDesc: can't open pg_temp_5821_0: No such file or directory NOTICE: --Relation pg_temp_5821_0-- ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_5821_0: No such...

Hi, I need to query pg_constraint's conkey field in my C++ program. I am not sure how to store the result as it appears to be an array. Thank you. Regards, Damon

Hi, I need to query each column's constraint and name of a table in postgreSQL v7.3.4 with a single SQL query but don't know how. Would appreciate any pointers! Thank you. Regards, Damon

I need to maintain a manually counter for an id-field, but I can do this two ways. Either make a counter table (which means one select and one update) or just selecting the largest id from existing table and increment by one (just one select + one table lock). Which one is fastest? Regards, BTJ

Hi There is question. I have column name_my varchar (not array) in table1, and column name_my_ref varchar (array) in other table2. I want set Foreign Key on name_my_ref and every element in the same row of array must match any element in name_my. How can I do this? ---------------------------(end of...

hello all...... I have a litle question, do i have acces linux command from postgresql query like send message to others linux user in LAN ? any feature for that ? thanks regards, Alam Surya

Hi, is there a document available describing the changes / additions in 7.4 ? Thanks Alex ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hi, I have a bit string , 7 bits, every bit representing a day of the week. e.g. 1110011. Is there and easy way where I can translate/format that string in a query. I want to give the string back with a '-' for every 0 and the first char of the Day for every '1'. example 1100111 = SM--TFS. thanks for any suggestions

I have a table called Person that has a primary key personID. Another table called ProUser that inherits from Person. In another table called ProPriceSchedule I have a foreign key constraint to the ProUser table, like so: CONSTRAINT proUser FOREIGN KEY (personID) REFERENCES ProUser(personID). The problem I am having is this: ERROR: UNIQUE...

Can't select 3 columns from a table called varer. The columns are the three first and are called vnummer, puNr and dNr. The error message is: indiadan=# select varer.vNummer from varer; ERROR: No such attribute varer.vnummer indiadan=#

Hello My task is to validate expression and get value of it in boolean variable. I try to do following: CREATE OR REPLACE FUNCTION get_value(integer) RETURNS boolean AS' DECLARE Ret boolean; Op TEXT = ''=''; BEGIN

Hi, We're currently experiencing a problem where SQL statements are failing when entring a '' for not not-null integer columns: ERROR: pg_atoi: zero-length string This was discovered just after a database migration from 7.2 to 7.3.4. Example:

Hi! I am trying to do a dump all and when I do this I get this error pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to timestamp pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb, usesuper, CAST(valuntil AS timestamp) FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname =...

RedHat 9, PostgreSQL 7.3.4. When I perform initdb --locale=cs_CZ createdb --encoding=latin2 lat createdb --encoding=unicode uni , the tables of lat are sorted fine, but the tables of uni not. When I initdb --locale=cs_CZ.UTF-8, sorts of uni are good, but sorts of lat not. Is some way to create two databases in the same database cluster...

Hi all!! I've got a serious problem with time functions.... After changing time (dayligt savings) now() returns decreased time. Linux date command returns proper time... UTC+2... postgres returns UTC+0 :( Why? What is wrong with postgresql configuration?? Help...

Hello list I hope someone can gave me a hint / advice on this. I wanted a auto-increasement function, similar to sequence, to increase a field. I cannot use CREATE SEQUENCE because it cd_line_no will start again with a new coursedetail. TQ in advance.

Hi there, I have a database where I'm given data in an MSAccess table which I then need to move into the appropriate table in my postgresql database (version 7.3.4). There are a couple of fields which I am trying to parse. The most complicated is a plant pedigree field and looks something like Parent1*Parent2 or

What I'd like to do is use dblink to extract a few rows from a remote database and manipulate these within a function in pl/pgsql. Something like this: CREATE OR REPLACE FUNCTION find() RETURNS INTEGER AS ' DECLARE count INTEGER: myrec RECORD; BEGIN FOR myrec IN SELECT * FROM DBLINK(''select x,y from mytab'') as

Hi; I've got problems with a query. I'm not sure if it is possible to do this with Postgres, although I think it should be. I had resolved these kind of queryes in MSAccess, where they are called "cross references querys" but I can't find my way in Postgres. My table 'muestras_rambla' is like: date | id_punto | muestra | flow ...