I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...

Virgina Hernandez

01-27-2010 03:53 PM
Virgina Hernandez

What is the correct data type to store an image in? In MSSQL it's "Image" what would be the equivalent in PostgreSQL? Or what would be the...

ComCast Technical Groups

03-26-2007 05:47 PM
Robert Uhl

Hi- Newbie to postgresql. I download and complied 8.15 on RH 9. I wrote a trigger that records the actions of customer table into a customer history...

Melvin Toy

11-07-2006 06:04 PM
Filip Rembiałkowski

1. I'm trying to use the money data type in a table. Just playing around with this stuff. I have a table with two fields defined, a varchar field for...

Mark Drummond

11-04-2006 03:33 PM
Mark Drummond

Robert Uhl wrote: Schmidty

Schmidty

04-04-2006 12:51 AM
Schmidty

Hi, I'm attempting to move some SQL code from a MySQL database to a Postgres database. First, I bet I'm not the only person ever to this - so I bet...

John Fabiani

10-31-2004 11:47 AM
John Fabiani

On Wed, Oct 27, 2004 at 01:59:56PM +0200, Kjetil Haaland wrote: See the "Compiling and Linking Dynamically-Loaded...

Michael Fuhr

10-31-2004 09:04 AM
Michael Fuhr

Perhaps this is simple, but it has me stumped. What is the data type to use for returning a value from count? Example: CREATE FUNCTION...

Michaud, Everett

10-31-2004 01:54 AM
Michael Fuhr

Greetings: I have a customer history table that contains several integer and decimal arrays for recording sales and load count information for each...

Terry Lee Tucker

10-30-2004 12:58 PM
Tom Lane

Dear all, While checking the last Beta3-Beta4 Changelog of Postgres 8.0, I saw the following: * doc/TODO: Remove completed items: <snip> * -Make...

Marcus Andree S. Magalhaes

10-29-2004 06:41 PM
Marcus Andree S. Magalhaes

Postgresql just reset itself, this is what I found in the log. FATAL: block 26 of 1663/17228/3425958479 is still referenced (local 2) LOG: server...

Michael Guerin

10-29-2004 04:01 PM
Tom Lane

Hi, I have a simple question: does anybody knows a good util for importing databases from MS Sql 2000? Best regards, Aleksandar Dezelin -- Linux...

Aleksandar Dezelin

10-28-2004 02:41 PM
Aleksandar Dezelin

Trying to convert an application from MySQL to PostgreSQL I ran into some troubles.. In MySQL is it quite easy to find out which type a column is.....

Jesper Krogh

10-28-2004 01:33 PM
Michael Fuhr

Dear Group, I am trying to insert data in to a single row (although I have ~ 10K rows to fill, I am experimenting with one row because this data is...

Kumar S

10-28-2004 12:56 PM
Reinhard Hnat

I'm trying to bulk load CVS data into my postgres database. All my data files contain a field header & most are quote enclosed. Is there an...

Sample, Matt

10-28-2004 11:20 AM
Sample, Matt

I have used pg_dumpall to create a backup of my database. The output looks correct containing both the schema and data contained in the tables. I...

Mousa.Shaya@nokia.com

10-28-2004 08:02 AM
Mousa.Shaya@nokia.com

Hi, (A small note first: Please don't post in HTML. It makes reading your message more difficult, and might prevent some people from providing...

Oliver Fromme

10-28-2004 03:25 AM
Oliver Fromme

Greetings: I am working on converting a transportation application from a Progress database to PostgreSQL. This application will be hammered by...

Terry Lee Tucker

10-27-2004 06:44 PM
Tom Lane

Hi folks, I successfully edited pg_hba.conf a few weeks ago (which means I don't remember where the file I edited was, now). Today I'm needing to...

Daniel Lerch

10-27-2004 04:24 PM
Tom Lane

Hi, I am running postgresql 7.1.3 in RedHat Linux 7.2. From an external C application, three connections are established with postmaster (it is...

Deepa K

10-27-2004 11:27 AM
Tom Lane

I would like to create a function that accepts an array of IDs (integers) and loops over them, returning the the rows (setof rowtype...?) that match...

Sean Davis

10-27-2004 09:25 AM
Bruno Wolff III

I have installed Postgresql 8.0 bet3 successfully. But whenever I want to create a table, be it with psql or pgAdminIII, I get the following...

ishaame@bluewin.ch

10-27-2004 05:43 AM
Michael Glaesemann

PostgreSQL 7.4.5 Is there a simple way of altering the definition of a column? Say I have a column defined as CHAR(5) and I want to make that...

Steve Tucknott

10-27-2004 04:58 AM
Michael Fuhr

I have installed Postgresql 8 beta3 on my windows machine, and everytime I issue a commond to create a table I get this message "Error: syntax...

ishaame@bluewin.ch

10-27-2004 03:00 AM
Michael Glaesemann

I am wondering how to do this simple mysql task in postgres. Any hints? Thanks, Sean ---------------------------(end of...

Sean Davis

10-26-2004 05:35 PM
Sean Davis

Dear PostgreSQL enlightened , I have an error with this function can anyone suggest me what stupid thing am i doing <code> create type_a as...

Vishal Kashyap @ [Sai Hertz And Control Systems]

10-26-2004 01:35 PM
Vishal Kashyap @ [Sai Hertz And Control Systems]

henry wrote: XP box but it's something like Start->Programs->PostgreSQL8->pgsql command. This may help identifiy where the problem is. hth Ron

Ron St-Pierre

10-26-2004 12:23 PM
Ron St-Pierre

Hi all, For my application we are storing the date information by casting it into BIGINT using the following extract('epoch' from...

Pradeepkumar, Pyatalo

10-25-2004 11:46 PM
Steven Klassen

Dear all Recently I try to run pgreplicator in Redhat linux 9.0. I have made it in installation and Managing Replicated databases. Now I'm entering...

aditya s

10-25-2004 09:56 PM
aditya s

I have a postgres table like this: CREATE TABLE "temp50" ( "gc" character varying(36), "co" character varying(7), "data" date, "ora" smallint );

cristivoinicaru

10-25-2004 10:06 AM
Tom Lane

Greetings. I'm in the process of porting an existing Oracle pl/SQL implementation to Postgres and plpgsql. My schema, constraint, index, and...

Eric Bieschke

10-23-2004 08:11 PM
Tom Lane

Just a quick general question: Can someone comment on using where clauses like: (sample = 2 OR sample = 3 OR sample = 4) as compared to sample in...

Sean Davis

10-22-2004 11:42 AM
Scott Marlowe

hello everyone, how do i add an ON UPDATE/DELETE CASCADE constraint to an existing table? ---------------------------(end of...

Matt Arnilo S. Baluyos

10-22-2004 06:12 AM
Sean Davis

Google supports some pretty elaborate modifiers for its searches and I thought I would pass along a couple useful ones. If you're using firefox, you...

Steven Klassen

10-21-2004 12:53 PM
Steven Klassen

I downloaded and installed postgresql-8.0-beta2-dev3. Do I need cygwin to connect to it. I am trying to connect from pgAdmin and it fails. Getting...

padma k

10-21-2004 01:13 AM
padma k

Hello, I have a problem using latin2 in postgresql 8 (beta2) with Delphi, with settings client_encoding = server_encoding = latin2 for...

PavelK

10-20-2004 07:05 PM
PavelK

Dear group, When I try create a database mydb, I am getting this unix socket domain error. What is this problem. Is this because the postmaster is...

Srinivas Iyyer

10-20-2004 05:26 PM
Steven Klassen

I'm using PG-7.4.2 on a SUSE-9.1 box. The docs say that I need to be the 'postgres' user in order to do things like create databases, which...

Derek Fountain

10-20-2004 11:49 AM
Bruno Wolff III

I need to learn how to work with PostgreSQL for work, but I am *completely* unfamiliar with the program, almost completely unfamiliar with databases...

Daniel Lerch

10-20-2004 01:37 AM
Hari Bhanujan

Hi All, I have two tables. MYDB=# \d myschema.tbl_part Table "myschema.tbl_part" Column | Type |...

Keith Worthington

10-19-2004 03:12 PM
Steven Klassen

This is perhaps more of a style question. I'm trying to find the 'right' way with date/time functions to pull out the last day in a month from a set...

Paul Makepeace

10-19-2004 02:40 PM
Doug Silver

Hi all, I've noticed that vacuum seems to be looping around the same table, is this a expected behavior using v8 beta3? It usually finishes,...

Michael Guerin

10-19-2004 01:22 PM
Tom Lane

Hi All, I am trying to build a foreign key constraint. The objective is to prevent parts from being entered that do not have a valid sales account....

Keith Worthington

10-19-2004 12:33 PM
Keith Worthington

I'm probably missing something obvious here but I can't quite see it. Given, CREATE VIEW weekly_bar_info AS SELECT bar_name, MIN(bar_date) AS...

Paul Makepeace

10-19-2004 08:12 AM
Paul Makepeace

Is there a way in PostgreSQL to initiate some sort of administrative lockout which will effectively block all logins of the same user from connecting...

Martin Foster

10-18-2004 10:43 PM
Martin Foster

hi, The problem I have is: I have a database template, which define several tables, contain some pre-defined data, and some server-side...

Zhenchang Xing

10-18-2004 05:54 PM
Steven Klassen

Hi, I am running a gentoo system and can't seem to get started. I have postgres beta2 sort of set up and running (I did a initdb and have the server...

Antoine

10-18-2004 11:30 AM
Andreas

Hello, Is there a way to "validate" the PL/pgSQL statements in (trigger-)functions. With validate I mean check syntax and ensure that all referenced...

Ruediger Herrmann

10-17-2004 03:27 PM
Ruediger Herrmann

Hi All, My data has a columns with numbers and some spaces. That means no number is predicted for that row and column. In my table definition I...

Kumar S

10-15-2004 06:03 PM
Stephan Szabo

Dear Group, I have a large file of 71 columns and 10K rows. I had to pass this whole document into a table and using a python script I created insert...

Kumar S

10-15-2004 05:39 PM
Tom Lane