dbTalk Databases Forums  

Sponsored Links

comp.databases.postgresql.novice comp.databases.postgresql.novice

Discuss in the comp.databases.postgresql.novice forum.

Post New Thread
Threads in Forum : comp.databases.postgresql.novice Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I copeid myself on this forward and never received it so I am sending it again.... It has been over a week and I have not seen this posted. I was...
02-15-2004 01:54 PM
Stephan Szabo Go to last post
1 205
I typed in "NULL value without indicator" into the postgresql.org site and received 5 responses, all having to do with error codes and structures. ...
02-12-2004 05:55 PM
Lynn.Tilby@asu.edu Go to last post
2 176
How to perform COPY from memory instead of files? Any examples/pointers would be greatly appreciated. Thanks in advanced Rajan
Rajan Bhide
02-12-2004 05:12 AM
M. Bastin Go to last post
4 202
Hi, does anybody know how I can have psql scroll wide tables instead of wrapping them? At the moment it uses the pager if there are too many rows....
Nabil Sayegh
02-11-2004 10:01 PM
Greg Sabino Mullane Go to last post
3 189
I want to use postgreses user name and password capability to allow web-bases users to log in and be authenticated. I also want to go the user the...
02-10-2004 11:50 AM
Francisco Go to last post
4 191
I've just installed the beta version of PeerDirect's Postgres. According tothe instructions I am able to create a database with createdb comand,...
Arman Meltonyan
02-10-2004 10:48 AM
Go to last post
1 228
Michal, It's possible in 7.3 and 7.4 but not in earlier versions of PostgreSQL. ...
Josh Berkus
02-10-2004 07:52 AM
Nabil Sayegh Go to last post
1 148
Is there a way to initialize tables by reading the data from a regular text file? Thanks! kynn ---------------------------(end of...
02-08-2004 12:00 PM
kynn@panix.com Go to last post
4 160
G'day- I'm running Postgresql 7.4.1 and pgplsql as a procedural language. I want to call a java class from the command line inside a...
Doug Boyd
02-07-2004 02:51 PM
Tom Lane Go to last post
1 180
Hi I have a scheme that I want to save ditribute to other people. How can Isave it in a .dat file? Thanks Janet
02-06-2004 12:13 PM
Josh Berkus Go to last post
1 188
Hello, I was looking in postgres source code because I am in an operating systems class yaddd-yadda-yadda and wanted some code examples of working...
joseph speigle
02-05-2004 08:25 PM
Marc G. Fournier Go to last post
1 152
I'm a rank beginner. (I took a mickeymouse DB course a few years ago; that's the extent of my DB background.) I want to become proficient with...
02-05-2004 07:13 PM
brew@theMode.com Go to last post
2 189
Thanks Guys! Let me be a little for specific. I am trying to make a php/pg/apache app that when run checks for its database and if not found creates...
Marcel Wolf
02-05-2004 06:30 PM
Josh Berkus Go to last post
1 203
Guys I am trying to log on to the template0 to create a new database. The error I get is .. Warning: pg_connect(): Unable to connect to PostgreSQL...
Marcel Wolf
02-05-2004 04:42 PM
Josh Berkus Go to last post
2 302
I am looking to automate and simplify the creation of new, empty tables from a template. I'm running PostgreSQL 7.3.4 under Fedora Core 1. My...
Matthew Syvinski
02-04-2004 09:53 PM
Josh Berkus Go to last post
1 189
Rob, The problem is our last release coincided poorly with the Potato (or was it Woody?) release of Debian. As a result, the PostgreSQL offered...
Rob Mosher
02-04-2004 08:33 PM
Rob Mosher Go to last post
5 223
Hello can any body tell me how to code a table with dual primary keys? The table 'borrower' has two PKs each one has been used in other tables within...
02-04-2004 11:31 AM
Josh Berkus Go to last post
3 200
Hello, In my query: select * from experimentinfo where expid='1'; here data type of expid is int. My question is: if I change expid ='xyz', error...
02-04-2004 08:22 AM
george young Go to last post
6 333
Hi, I'm trying to get a list of all the rows in the Parts table, with the integer indexes of man_id, case_id, and desc_id, replaced with text from...
Russell Shaw
02-03-2004 04:48 PM
Nabil Sayegh Go to last post
1 196
Hello, I've installed redhat enterprise 3 on a system to use as a db server. Manually I can install and run postgresql 7.3 (the one on the...
02-02-2004 03:30 PM
Christian Armeanu Go to last post
1 187
Thiemo Kellner <thiemo (AT) thiam (DOT) ch> writes: It's not trying to insert a row of nulls; it's simply not inserting any row at all. The...
Thiemo Kellner
02-02-2004 08:24 AM
Iandé Coutinho Go to last post
8 335
hi, this simple update closes the connection. I use the database to dynamically update titles and directory on my web pages. I show table...
joseph speigle
02-01-2004 04:27 PM
Tom Lane Go to last post
9 299
I sent this one a little over a week ago, hadn't seen it posted yet, and was just wondering if it got lost in the fray...? Thanks for your...
02-01-2004 01:18 PM
Tom Lane Go to last post
1 201
hi, I can't seem to find the comment for an sql file drop function dups(); -- joe speigle -- Feb 1 2004 CREATE FUNCTION dups() RETURNS int4 AS...
joseph speigle
02-01-2004 10:16 AM
Tom Lane Go to last post
2 289
If I insert a large amount of data into a Postgres table, so that the data file (or files) grow by a large amount (something in the gigabyte range),...
Lawrence Smith
02-01-2004 10:00 AM
Lawrence Smith Go to last post
2 167
Hi, Is there a way to make postgresql report an error if when inserting data, a multiple-column combination is duplicated? CREATE TABLE...
Russell Shaw
02-01-2004 03:46 AM
Russell Shaw Go to last post
4 165
Hi all, I'm using the PostreSQL30 ODBC driver to hook a Windows app to a 7.4.1 PostreSQL DB. Might be the driver, or it might be the app itself (I...
Michael J. Conroy
01-31-2004 06:08 PM
Tom Lane Go to last post
1 201
On Wed, 28 Jan 2004, Ben Burkhart wrote: Well, you'd probably be best off writing a function to go over the rows or doing this in a front...
Stephan Szabo
01-31-2004 11:06 AM
Tom Lane Go to last post
1 252
Hi, I need to develop my database so when a record is entered through a browser, it will automatically email a list of interested parties. I am ok...
Nick Tew
01-31-2004 01:18 AM
Derrick Betts Go to last post
1 170
Hello All, I'm a virgin newbie to Linux and PostgreSQL but have very much experience in - (whispered) sssh, Windows. I have downloaded the Red Hat...
Phil Seretti
01-30-2004 04:42 PM
Markus Bertheau Go to last post
3 177
George Weaver <gweaver (AT) shaw (DOT) ca> writes: PostgreSQL uses the OS clock for date/time issues. If you can change the date on your system,...
Manuel Sugawara
01-29-2004 12:00 PM
Tom Lane Go to last post
5 172
I have an application that will only ever run locally on a development box. The application writes a text file to the hard drive, and then issues...
Alan T. Miller
01-29-2004 07:14 AM
Bruno Wolff III Go to last post
2 174
Hi all, Could I have guidelines on how to store and display (generic ?) Russian characters right, and Spanish as well, for that matter, alongside...
Aarni Ruuhimäki
01-29-2004 05:44 AM
Aarni Ruuhimäki Go to last post
2 185
I have switched identification method from 'trust' to 'md5' for all local requests, ie: - local all all trust + local all all md5 But that creates...
Marcin Gil
01-28-2004 01:01 PM
Bruno Wolff III Go to last post
10 328
Guys & Gals What is the best way to get a list of tables in a database? Is there a syntax for getting from the database after I connect or do I have...
Marcel Wolf
01-28-2004 10:33 AM
George Weaver Go to last post
1 191
I have written a pl/pgsql function as follows: create function aufloesung(varchar,varchar) returns integer as ' declare tabnam alias for $1; proj...
Reinhard Hnat
01-28-2004 10:23 AM
Stephan Szabo Go to last post
1 270
What can cause such an error: 'unexpected eof on client connection'. I can find it in logs, all the connections I make to the db are from...
Marcin Gil
01-28-2004 02:23 AM
Marcin Gil Go to last post
2 259
I have two tables. The first will contain recent records that are used on a daily basis. The other table is identical but only exists to archive...
Alan T. Miller
01-27-2004 08:40 PM
Alan T. Miller Go to last post
2 227
Hello group I am trying to follow through on advice I received from you earlier. I would like to check for my database when I logon and if it is not...
Marcel Wolf
01-27-2004 05:23 PM
Andre Dubuc Go to last post
2 240
Hello All, I have a problem when starting postgre under solaris 8 : bash-2.03# su - postgres -c "/usr/local/pgsql/bin/pg_ctl -D /dat/pgsql/data -l...
Patrice Durosay
01-27-2004 05:04 AM
Patrice Durosay Go to last post
2 185
Hello, I am trying to create a database on FreeBSD 5.2-RELEASE, This is inside a jail. I had it working in 5.1 and now am having a problem. The...
Paul Bauer
01-26-2004 04:26 PM
April Carvalho Go to last post
12 462
I would like my application to start up and see if the database is there if not create it. I am not sure how to do it. When I try and query...
Marcel Wolf
01-26-2004 02:53 PM
Jeff Eckermann Go to last post
2 311
I realize this is a classic problem, but I'm a NOVICE after all. I want to represent hierarchal topics (just like dmoz.org). I've seen two ways to...
Bill Moseley
01-26-2004 02:25 PM
glenn Go to last post
6 246
Hi, Is a long field ok for a primary key, or should i use a unique integer?: create table parts ( manufacturers_code char(40) primary...
Russell Shaw
01-25-2004 06:34 PM
Tom Lane Go to last post
4 215
Hi, I'm making my first database. I have a list of parts, each of which is sold by multiple vendors. I also have a list of vendors, each of which...
Russell Shaw
01-25-2004 12:33 AM
Michael Glaesemann Go to last post
3 176
Hi! Can someone pls help me? I was trying to install postgresql7.4, when I run ./configure, I got this weird error: ./src/template/linux: No such...
Peggy Go
01-24-2004 03:04 PM
Tom Lane Go to last post
1 246
Hi all, Just noticed that 7.4.1 template1 has 40 views / tables in it and copies all of them to new databases. Tried to DROP them in template1 and...
Aarni Ruuhimäki
01-23-2004 12:12 PM
Aarni Ruuhimäki Go to last post
2 196
Hi there, I am having a hard time installing PostgreSQL for the first time. I worked my way through the INSTALL instructions upto the...
Christian Poecher
01-23-2004 09:27 AM
Tom Lane Go to last post
1 212
chris (AT) vote4ad (DOT) com writes: I assure you there is something relevant in config.log. For example, I get the following trace for <dld.h>,...
01-23-2004 01:01 AM
Tom Lane Go to last post
4 181
Hi all, I'm trying to delete from a table which has 42Mill rows, using a foreign key, which is index. The delete has been going three days now :(...
01-22-2004 09:49 AM
Tom Lane Go to last post
5 204
Post New Thread

Display Options
Showing threads 351 to 400 of 717
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.