Hello, I need a method of returning a date in a given timezone and accomidating DST. For example, my server is set to UTC, Id like to return the...

A Gilmore

09-18-2004 10:03 PM
Tom Lane

Hi I've made heaps of Filemaker databases on a Mac, now I'm moving to use PostgreSQL on Debian GNU/Linux. Can I use textfiles (e.g. tab-separated)...

Neacal

09-18-2004 03:03 PM
M. Bastin

Dear group, I am trying to upload a file into a table using COPY command. My table: exp_id exp_X exp_y exp_std exp_npix

Kumar S

09-18-2004 07:44 AM
M. Bastin

I'm trying to write my own aggregate function. I'm getting messed up in both the sfunc and finalfunc and I'm reasonably certain it's because I'm not...

Todd Kover

09-17-2004 08:41 PM
Tom Lane

Hello, I hope this is the right place to ask for installation help... Ok I followed the Installation steps and stuck with compiling or better with...

Alexander Jochum

09-17-2004 01:50 PM
Tom Lane

I am looking for the rough equivalent of: mysqlimport -L -h <host> -r --fields-terminated-by=',' -u<user> -p<pass> --fields-enclosed-by='"'...

Sean Davis

09-17-2004 01:07 PM
Sean Davis

Hello, I installed EMS postgres Admin (win) and I'm trying to connnect directly to the database (linux). I have specfied the host ip, default port...

Sun H Chi

09-17-2004 04:43 AM
Lars Haugseth

Hi, I am intending using the latest and greatest postgresql to learn about how it works and where it is heading (the project I am on is in for the...

Antoine

09-16-2004 05:28 PM
Josh Berkus

Is there a command similar to the oracle DESCRIBE command to view the table definitions? Thanks

Sun H Chi

09-16-2004 05:09 PM
Jake Stride

PostGreSQL 7.4.3 I have a table that 'translates' codes between two types. The structure is: recno | integer | not null...

Steve Tucknott

09-15-2004 04:56 PM
Kumar S

Dear Group, is there a way to define a hyperlink as a datatype. I want to store hyperlink for an FTP site as my data link. Is this possible or it is...

Kumar S

09-15-2004 08:46 AM
Arthur van Dorp

Hi, I just wanted to clarify as to what is the maximum value of a SERIAL datatype. In the documentation it is given that with BIGSERIAL it...

Pradeepkumar, Pyatalo

09-14-2004 06:07 PM
Josh Berkus

Dear group, Could you please suggest if my sql syntax is wrong for creating the table: my sql statements: create table EXPERIMENT ( exp_id ...

Kumar S

09-14-2004 04:55 PM
Stephan Szabo

Hello, I am getting the following error while running a series of stored procedures. I have increased the max_locks_per_transaction parameter from 64...

Betsy Barker

09-14-2004 10:43 AM
Burçin Gülen

Hi, I have a customer who would like to extract all their data from one system and dump into another. Not too difficult except for the images. The...

Sun H Chi

09-14-2004 01:03 AM
Aarni Ruuhimäki

Hi, I'm having problems trying to connect to the postgresql 7.5 using libpg. I'm developing on the windows platform and using visual c++...

Adrian Chew

09-14-2004 12:20 AM
Michael Glaesemann

Calling myself a novice would be inflating my skills/knowledge. My situation and following question: I have a customer (a Human Resources...

Mike Ellsworth

09-13-2004 07:47 PM
Mitch Pirtle

Mike wrote: owns the postmaster), you can psql into the database eg psql myDB You don't need to putty into the box to use pgAdmin, you just...

Mike

09-13-2004 07:41 PM
Mitch Pirtle

Long time MySQL user, six weeks into Postgres here. I'm converting a PHP script that uses MySQL to use Postgres instead. To substitue the missing...

Greg Donald

09-13-2004 05:02 PM
Michael Fuhr

Hi all, I have an application that for a very specific reason will generate a row of data that I want to put into a database. One problem is that...

Tim Pushor

09-13-2004 02:38 PM
Tim Pushor

Hello, Im using the default precision for my timestamps, 6. Is it safe to declare this column unique? Because you can define the level...

A Gilmore

09-13-2004 11:30 AM
A Gilmore

The subject says it all! I looked on my local mirror but couldn't find it. Any help appreciated. Paul... -- plinehan y_a_h_o_o and d_o_t com

Paul Ganainm

09-12-2004 12:44 PM
Rafael Charnovscki

Hi all I need to use polish charset in postgresql and it should be iso-8859-2. But i dont know how to make postgresql use it. I try : initdb -E...

ppp

09-11-2004 09:00 AM
Ennio-Sr

On Sep 6, 2004, at 10:21 PM, tab view wrote: What is the data type of the datetimelogged column? Michael Glaesemann grzm myrealbox...

Michael Glaesemann

09-11-2004 01:22 AM
Tom Lane

the inquirer wrote: As Tom Lane said before me, use EXECUTE. I have that on a similar project CREATE FUNCTION s_user() RETURNS "trigger" AS...

Michalis Kabrianis

09-11-2004 01:22 AM
Michalis Kabrianis

In Oracle you can log on using OS authentication & then: ALTER SESSION SET CURRENT_SCHEMA= <schema name>; Is there anyway to do this in...

Salerno, Vincent

09-11-2004 01:19 AM
Tom Lane

the inquirer <listquestions (AT) yahoo (DOT) com> writes: Utility statements (which is to say anything except SELECT/INSERT/ UPDATE/DELETE)...

Tom Lane

09-11-2004 01:03 AM
Tom Lane

On Tue, 2004-09-07 at 11:44, William Herrera wrote: Use the createlang script. -- Oliver Elphick olly (AT)...

Oliver Elphick

09-11-2004 12:55 AM
Oliver Elphick

Hi, I have a table pointattributes(pointid,attributeid,strvalue,numvalue)......where pointid and attributeid are foreign keys refering to other...

Pradeepkumar, Pyatalo

09-10-2004 01:15 PM
Tim Pushor

Hi, I have had a look at the docs but, correct me if I am wrong, cannot find a way to select data into an existing table. I have looked at select...

Jake Stride

09-10-2004 01:58 AM
Michael Glaesemann

Eduardo Vázquez Rodríguez wrote: Try with: .... SUM(duration::integer) ... You can create a new integer column, copy all datas from the old

Gaetano Mendola

09-08-2004 06:18 PM
Gaetano Mendola

Hi, I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following error when I try and run a SQL query on a script: Error...

Daniel Secomb

09-08-2004 10:11 AM
Ron St-Pierre

Hi, I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following error when I try and run a SQL query on a script: Error...

Daniel Secomb

09-08-2004 09:16 AM
paul@entropia.co.uk

Hi, I am using plpgsql to write user function and type. I am facing problem while executing the function. psql=# select * from...

Rajan Bhide

09-08-2004 09:08 AM
Tom Lane

My webhost only supports PGSQL 7.3.4. The current CYGWIN version of PGSQL is 7.4.5. I'd love to use the latest, but I want to avoid problems moving...

operationsengineer1@yahoo.com

09-05-2004 02:29 AM
operationsengineer1@yahoo.com

Hi, I am working on the G System project (BSD licenced) and we are going to be (eventually) implementing a distributed database to hold data for the...

Antoine

09-03-2004 04:55 PM
Antoine

i'm will likely be working with a webhost that offers pgsql 7.3.3. will i run into problems if i develop using pgsql 7.4.5 and try to upload it to...

operationsengineer1@yahoo.com

09-02-2004 10:24 AM
Mike

Is it possible to get a select statement to work like this with a for loop? CREATE FUNCTION public.search(int4) RETURNS SETOF search1...

derrick@grifflink.com

09-01-2004 10:20 PM
derrick@grifflink.com

Hi all, I have a database that I made a copy of (useing pg_dump) to test a new program on. The program runs just fine on the new(copy) database. ...

jason@soundconcept.net

09-01-2004 04:42 PM
Steve Crawford

Hi, I am using Postgresql 7.4.3 running on RedHat Linux 2.4.7. My Application is coded in C. I am using libpq functions inorder to connect to the...

Pradeepkumar, Pyatalo

09-01-2004 09:27 AM
Tom Lane

Dear all, Will installing the beta 2 of win32 be a just next - next button click sequence on windows port or does upgradation requires some tweaking...

V i s h a l Kashyap @ [Sai Hertz And Control Systems]

08-31-2004 02:44 AM
Dmitry Karasik

Hi all, I am using Postgresql 7.4.3 on Linux 7.2. In my project i am using many user defined functions. All the functions are working fine, no...

Pradeepkumar, Pyatalo

08-31-2004 01:28 AM
Pradeepkumar, Pyatalo

hi all I use FreeBSD 4.10. I downloaded the packages for PostGRE SQL (7.4.2), and installed the packages. I also happened to see the messages...

Kesav.Tadimeti@ubs.com

08-30-2004 11:18 AM
Oliver Elphick

Rajan Bhide wrote: Not sure but you should upgrade anyway. It is easy. -- Bruce Momjian | http://candle.pha.pa.us pgman...

Bruce Momjian

08-30-2004 09:42 AM
Tom Lane

Hi, The recent Postgres7.4.5 mentions a fix for a crash. http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-5 "Repair possible crash...

Rajan Bhide

08-30-2004 04:20 AM
Rajan Bhide

Can anyone tell me if there is any difference between these two commands: select * from table1, table2 where table1.id = table2.id and select * from...

Natan

08-29-2004 07:54 PM
Tom Lane

Hi, I am just testing this list and my new gmail account. Sorry about that, Antoine ---------------------------(end of...

Anton Melser

08-29-2004 05:15 AM
Anton Melser

I read the posts on pgsql functions and transactions from the Novice list, and I think they are saying "PGSQL functions do not support transactions"....

Betsy Barker

08-29-2004 01:55 AM
operationsengineer1@yahoo.com

I'm sorry for the simple question, but.... I have a table (description given below) that I want to do something like: select...

Sean Davis

08-29-2004 01:50 AM
Oliver Elphick

I had a-couple of questions regarding the text formatting in the pg_dump file. First, when dumping my database, I seem to be getting...

John Browne

08-28-2004 01:11 PM
Bruce Momjian