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 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 Go to last post
0 99
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 Go to last post
1 1,863
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 Go to last post
1 593
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 Go to last post
2 459
Robert Uhl wrote: Schmidty
Schmidty
04-04-2006 12:51 AM
Schmidty Go to last post
0 561
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 Go to last post
2 573
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 Go to last post
0 449
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 Go to last post
2 454
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 Go to last post
6 437
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 Go to last post
3 420
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 Go to last post
3 423
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 Go to last post
0 355
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 Go to last post
5 426
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 Go to last post
2 678
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 Go to last post
0 410
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 Go to last post
0 392
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 Go to last post
0 406
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 Go to last post
1 416
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 Go to last post
1 572
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 Go to last post
1 419
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 Go to last post
4 406
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 Go to last post
2 480
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 Go to last post
1 413
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 Go to last post
1 391
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 Go to last post
6 1,224
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] Go to last post
2 425
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 Go to last post
1 452
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 Go to last post
4 1,023
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 Go to last post
0 430
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 Go to last post
2 433
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 Go to last post
1 500
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 Go to last post
3 458
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 Go to last post
1 513
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 Go to last post
0 440
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 Go to last post
0 389
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 Go to last post
0 402
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 Go to last post
1 890
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 Go to last post
2 672
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 Go to last post
21 1,317
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 Go to last post
1 519
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 Go to last post
1 455
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 Go to last post
1 402
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 Go to last post
4 434
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 Go to last post
3 396
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 Go to last post
0 379
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 Go to last post
1 408
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 Go to last post
5 585
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 Go to last post
0 404
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 Go to last post
1 686
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 Go to last post
1 471
Post New Thread

Display Options
Showing threads 1 to 50 of 1001
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 - 2010, Jelsoft Enterprises Ltd.