PostgreSQL Database Forum

I create a table like so: create table types ( typeid integer unique not null, typename varchar(255) unique not null ); and I get the expected messages: NOTICE: CREATE TABLE / UNIQUE will create implicit index 'types_typeid_key' for table 'types'

Running postgresql-7.3.2-3 which came with Red Hat 9.0. Created a database with unicode encoding (in psql) as below: create database leatherlink with encoding='unicode' template=leatherlinkdb; leatherlinkdb is an existing database with the default encoding SQL_ASCII. When I insert Chinsese strings into the database, it is taken in and...

Hi all, I am having a number of problems with a customer of ours. This customer is in Thailand so I don't have good machine direct access to their computers. Scenario - we have a Java based POS system that we chose to run on Linux using PGSQL. This generally works quite ok, However at this particular customer they seem to be getting regular...

Hi all: I have here a table with the following schema: Table "todocinetv" Column | Type | Modifiers -------------+-----------------------------+---------------------- id | integer | not null default '0' datestamp | timestamp without time zone | not null thread | integer ...

Hello list, That's my question, I can't figure out a way to know if a given string is digit, soemthing like this: ISDIGIT("ARWA") = False ISDIGIT("5334") = True If anyone know a way to get that done, I'll appreciate the help.

I'm trying to get PostgreSQL-7.4RC2 to compile with 64 bit support on my Linux SPARC Ultra5. The problem is that the linker has to be passed (for what I have experienced) the value -m elf64_sparc to /usr/bin/ld, else the linker will give this error: /usr/bin/ld -r -o SUBSYS.o heaptuple.o indextuple.o indexvalid.o printtup.o scankey.o...

Hi , I think one of the usage patterns of DOMAINS is to have size specifications and validity constraints at one place for easy administration of Database. Eg, instead of declaring email to be varchar(30) in 10s of tables and putting a CHECK constraint for presence of '@' we could declare

Its really nice to see/read the pretty printing of VIEW definations!! in 7.3 it was a nightmare to see definations of long views. Kudos to the TEAM. Regds Mallah

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I have the following little stored proc: CREATE OR REPLACE FUNCTION public.ib_nextval(varchar) RETURNS varchar AS 'DECLARE

Dear community, for some reason the post I sent yesterday night still did not show up on the mailing lists. I have set up some links on the developers side under http://developer.postgresql.org/~wieck/slony1.html The concept will be the base for some of my work as a Software Engineer here at Afilias USA INC. in the near future. Afilias is...

Greetings, I've got a fairly simple function that I'm trying to return a set, but seem to have come across a stumbling block. When I execute the function below (the input params are not used at the moment) I get this: chris=# select htdig('foo', 'foo'); ERROR: set-valued function called in context that cannot accept a set CONTEXT: ...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Im building an user database with many tables keeping the data for the Address, Phone numbers, etc which are referenced by a table where I keep the single users. My question is, how do I get the "Id"-value of a newly inserted address to store it in the referencing user table:

I was wondering if there was a reliable method to get the last id inserted into a serial column in a table. I believe previous recommendations given were to use a sequence, have your app get the nextval for the sequence and then use that in the insert. I was wondering if things had changed or if that is still the recommended method. -- ...

Greetings, Thanks to a lot of help on this list, I've managed to get my pl/perl function working. However, I have an unexpected result. Here's a simple way to reproduce this problem: CREATE or REPLACE FUNCTION perltest(integer) returns integer as ' $MyInt = $MyInt + 1; return $MyInt;

Hi, When we use WITH (NOLOCK) at the end of table list in a SELECT query, a Cartesian join is returned (i.e. approximately 6,500 records instead of 57, which is distressing.

Hi , I noticed that an entry in pg_stat_activity was existing for a long duration > 2 mins while its backend ( process corresponding to that procpid) was not running. how can it be possible ? version: 7.3.4

I've noticed that postgresql 7.4beta2 pgdump dumps sequences like this: CREATE SEQUENCE xxxx INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; but postgresql 7.4RC2 doesn't accept this sintax. If anyone has already noticed this bug, please ignore this email. I haven't had time in the last days to follow the mailing lists. Thanks.

Hi guys, Do you know any web based bug tracker software that use PostgreSQL??? Somebody has told me about Mantis, but it use MySQL... and I resign to use that! :( Which is the best bug tracker you know???(PHP+PostgreSQL)

I have a situation where I need to set my constraints and keys deferrable. Is it safe to update the condeferrable flag in pg_constraint to true to make this happen? The alternative is to drop all the constraints and add them back as deferrable. Michael L. Boscia mbrngrboy@cox.net ---------------------------(end of...

How come pgsql7.3.4 Was allowing me to delete the master record while referencing records were present in slave table? The problem was detected when the database was migrated to 7.4 and deletions were being refused. Regards Mallah

I'm trying to load plperl to experiment with it in 7.3.4 with perl v5.8.0. I've basically tried the following: configure --with-perl, then initdb, then start postmaster, then createlang plplerl template1 No matter what I try, I keep getting this error:

I'm trying to run the latest Postgresql on OSX 10.3, but am receiving a version mismatch error when I try and run the database: dyld: psql version mismatch for library: /usr/local/lib/libreadline.4.dylib (compatibility version of user: 4.2.0 greater than library's version: 4.0.0) Trace/BPT trap Has anyone else run into this problem, or...

Hello pgsql-general, I'm trying to implement a table with rows that are automatically deleted when the session that inserted them disconnects, sort of like our own alternative to pg_stat_activity. Is it possible and what approach should I be trying to achieve such a thing? Thanks! --

List, Hello. I am trying to get PostgreSQL 7.3.4 installed after moving to Mac OS 10.3, known as Panther. I am using the following configure statement: pbg417:/usr/local/src/postgresql-7.3.4 barryh$ ./configure --prefix=/usr/local/pgsql --enable-locale --enable-multibyte=UNICODE --with-openssl=/usr --with-perl --with-java...

Hello pgsql-general, When trying to create a table CREATE TABLE sessions ( id serial PRIMARY KEY, procpid int4 REFERENCES pg_listener(listenerpid) ON DELETE CASCADE ); I get a warning saying 'relation "pg_listener" is a system catalog'