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...

antonio

01-19-2004 07:29 AM
antonio

I want to design a data base that can hold the following structure.... struct { unsigned short a; unsigned short b; unsigned int len; unsigned char...

JustSomeGuy

01-15-2004 11:46 AM
JustSomeGuy

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...

Steven O.

01-13-2004 06:25 PM
Jeff Boes

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...

Google Mike

01-11-2004 09:50 AM
Google Mike

Hi Everyone, I have a rather trivial (I hope) question about OID types and PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default,...

Amir Khawaja

01-09-2004 07:24 PM
boyd

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...

Brendan LeFebvre

01-07-2004 05:14 AM
Brendan LeFebvre

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...

Sam

01-05-2004 05:05 AM
Sam

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...

NahtMy ReelName

01-04-2004 04:03 PM
NahtMy ReelName

Hi everyone...my name is Mike MacEachern. I work with a technical search firm in Toronto - ARES Consulting A client of mine in Toronto is keen to...

Ares Consulting Services

12-31-2003 02:36 PM
Ares Consulting Services

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...

Thomas Reat

12-30-2003 03:49 PM
Thomas Reat

Hello, Im trying to get some kde database application working, but I cant get them connected to the postgres server. psql connect seamlessly with -...

afila

12-30-2003 09:49 AM
Tim Ashman

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...

Thomas Reat

12-29-2003 09:53 AM
Thomas Reat

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...

Sid

12-22-2003 07:21 AM
Sid

What is the most appropriate encoding for the UK when creating a database?

My Deja

12-21-2003 05:04 PM
My Deja

Hi, I developing a program using postgres and linux like operating system. My problem is this: I have a quite complicated view with roughly 10000...

claudia

12-16-2003 09:17 AM
claudia

Hello, I have a question about pgplsql: Is it faster to execute a compact function (with minimal spaces and comments) than a function with many...

Luc Martineau

12-14-2003 12:27 AM
Luc Martineau

Hi, I am looking for a database engine which: 1) runs under Windows (multiple versions) 2) Can be redistributed without additional fees as part of...

PhilM

12-12-2003 07:57 AM
Tony Reina

Hello I'm Paola and I have an urgent problem. First I did a trigger to delete on cascade but didn't work, then I did a rule for delete on cascade but...

Ubaldo

12-05-2003 01:07 PM
Ubaldo

Is it reasonable to have a table with about 300 columns? There will be about 2500 rows. The data does not normalize. The alternative would be about...

Thomas Reat

12-04-2003 12:13 AM
Eric Friedman

Hi all, I need to filter out rows like 'A <number>' where the second character=space character. To start with I have the expression: ~* '^A' which...

Gandalf

12-03-2003 03:56 AM
Gandalf

I'm having a problem with a table that accidently had a column added whose type is the same as the table. This is seriously creating a problem as I...

Liam3

11-27-2003 06:58 PM
Liam3

waiting for postmaster to shut down...LOG: received smart shutdown request ..LOG: shutting down ...LOG: database system is shut...

Mounir Benzid

11-26-2003 08:02 AM
Mounir Benzid

Hello I have database: base and user: vertigo. When i log into that database from pgsql: #psql base -U pgsql and try to give user vertigo all...

vertigo

11-21-2003 07:51 AM
vertigo

Hello When we create a table, what is the difference between the REFERENCE constraint on column and the FOREIGN KEY constraint on table ? I guess...

Luc Martineau

11-21-2003 12:17 AM
Luc Martineau

I wrote a function that basically executes a dynamic query and returns True if there is at least one record and false in not. CREATE OR REPLACE...

George

11-20-2003 04:29 AM
George

I everebody, it's possible to reinitialiser the meter of oid, after drop a database and before recreate it. I need a solution because I have negative...

lionel

11-18-2003 02:46 AM
lionel

I've been hitting the DB books lately and I was wondering if anyone knows where features like "CREATE ASSERTION" and sub-selects in CHECK constraints...

G. Brannon Smith

11-17-2003 02:32 PM
G. Brannon Smith

Hello all, I have a table with among other things a timestamp field. To get the count of records per hour I do: select count(*) as...

Joseph Santaniello

11-17-2003 11:31 AM
Jeff Boes

Hello! I need a mdb 2 PostgtreSQL migration tool (something similar to pgAdmin plugin - "Database migration wizard") that don't needs Microsoft...

Pawel Gruszka

11-17-2003 07:03 AM
Pawel Gruszka

Hi I have install bin pack of PostgreSQL 7.3.1 on Windows 2000 Server, i try to run it as LocalSystem User, but dosen't work I download libpq.dll and...

slash

11-14-2003 05:46 AM
slash

where I can download a windows version of PostGreSql.

Radhika Dileep

11-07-2003 01:44 AM
cansea

Can anyone help me out the explanation why the new version of postgresql called peerdirect and what peerdirect exactly means? -- Bharani Posted...

bharani

11-07-2003 12:48 AM
bharani

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...

Damon

11-05-2003 03:00 AM
Damon

Originally posted by Otisg Hi: I have the same problem after I updraded from 7.1->7.3 without taking any backup.

Gautam Saha

11-04-2003 04:11 PM
Gautam Saha

Almost all of my foreign key definitions are NOT present in pg_constraint. However, they do exist as triggers. It appears that *new* foreign keys,...

Jeff Boes

11-04-2003 11:55 AM
Jeff Boes

Hi, I wanted to get the primary keys' column names and data types for a particular table created. Although I only created one primary key involving...

Damon

11-04-2003 09:01 AM
Damon

I want to create a rule that transforms a query on one table to a query on many with table names and columns named after one of the columns in the...

Thomas Reat

11-02-2003 03:48 PM
Thomas Reat

This is more of a general SQL relationship question than a PostgreSQL-specific question, although I am using PostgreSQL to implement this. I have a...

Dave Roe

11-01-2003 02:51 PM
Dave Roe

We're trying to eliminate possible problems with our PL/Perl code base. Some of the functions use locally authored modules that make...

Jeff Boes

10-30-2003 02:02 PM
Jeff Boes

I'm running PostgreSQL 7.3.4 on Windows 2000/Cygwin (AMD Athlon XP+ 1800, 512MB RAM). I want to insert about 500 records into a table. The table is...

Razvan Surdulescu

10-29-2003 10:41 PM
Razvan Surdulescu

i also has a same problem like Ferindo Middleton and i had try to using the createuser -a -d yawhum, then the system display a error message said...

yawhum80

10-28-2003 09:39 PM
yawhum80

I have a SQL script that needs to invoke a non-SQL command, so I'm using ... \! some_cmd arg arg arg However, when the SQL script is invoked for a...

Jeff Boes

10-27-2003 08:32 AM
Jeff Boes

Hi Bit of an unusual one. I have an Access front end. Two tables tblHeader and tblDetails. Each has an ID field (unique and primary) plus other...

Mark

10-27-2003 01:45 AM
Mark

Mandatories: Ver 7.3.4, Redhat Linux 8.0, P4, 2GB RAM I want to add a 'nullable' foreign key to a column in a table. I have tables "company" and...

Ron

10-22-2003 05:23 PM
Ron

Hi, I've been scouring the net and reading the PostgreSQL docs for a while now trying to learn how to create a recursive function in PL/pgSQL that...

t_pet422

10-18-2003 12:56 AM
t_pet422

I need to know if is possible to read oracle tables from PostgresSQL. Can someone give me some help? Thanks a lot

Marco

10-15-2003 09:45 PM
Tim Ashman

can somebody tell me how can I get old data from a recently damaged table?

Dagoberto

10-15-2003 09:02 PM
Dagoberto

Hi, I've got a table in PostgreSql 7.3.2 that has a serial column as a primary key. I want to insert data into the table (inserting values for...

t_pet422

10-15-2003 03:32 PM
sebmil

Does anyone know what this code does? It's from an .asp web page and there are things being called from a database. <% While ((Repeat2__numRows <>...

Shap

10-15-2003 10:21 AM
Shap

I am goign to implement a website that has a slashdot like program running the site, but I am goign to use PostgreSQL. Does anyone know of some...

toy

10-12-2003 05:13 PM
toy