Re: [GENERAL] newbie question

2011-06-06 Thread Craig Ringer
On 06/07/2011 04:17 AM, Heine Ferreira wrote: Hi Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows? Sort-of. PostgreSQL runs many processes, one per query. Each process has a single thread. This means that one query can use at most one CPU core,

Re: [GENERAL] newbie question

2011-06-06 Thread Dann Corbit
: [GENERAL] newbie question Hi Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows? Thanks H.F.

Re: [GENERAL] newbie question

2011-06-06 Thread Chris Curvey
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira wrote: > Hi > > Does Postgresql utilize hyperthreading and multiple cores on the relevant > processors on windows? > > Thanks > > H.F. > > It certainly looks like it on my machine! As far as my Linux box can tell, the "hyperthreaded" CPUs just appear

[GENERAL] newbie question

2011-06-06 Thread Heine Ferreira
Hi Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows? Thanks H.F.

Re: [GENERAL] newbie question - delete before insert

2010-11-20 Thread Sim Zacks
How do people implement insert or upate ( otherwise known as upsert ) behaviour in postgres i.e. insert a row if it's key does not exist in the database else update the existing row? I tried using an insert rule to delete any existing rows first then insert however this leads to infinitely r

Re: [GENERAL] newbie question - delete before insert

2010-11-20 Thread Ashish Karalkar
On 11/20/2010 02:43 PM, Thomas Kellerer wrote: > Grant Mckenzie wrote on 20.11.2010 07:00: >> How do people implement insert or upate ( otherwise known as upsert ) >> behaviour in postgres i.e. insert a row if it's key does not exist in >> the database else update the existing row? >> > > You can s

Re: [GENERAL] newbie question - delete before insert

2010-11-20 Thread Thomas Kellerer
Grant Mckenzie wrote on 20.11.2010 07:00: How do people implement insert or upate ( otherwise known as upsert ) behaviour in postgres i.e. insert a row if it's key does not exist in the database else update the existing row? You can simply send the UPDATE, if nothing was updated, it's safe to

[GENERAL] newbie question - delete before insert

2010-11-19 Thread Grant Mckenzie
Hi, a question that I imagine is a faq but have not been able to find much help. How do people implement insert or upate ( otherwise known as upsert ) behaviour in postgres i.e. insert a row if it's key does not exist in the database else update the existing row? I tried using an insert rule t

Re: [GENERAL] newbie question

2007-10-17 Thread Joris Dobbelsteen
>-Original Message- >From: Russell Aspinwall [mailto:[EMAIL PROTECTED] >Sent: woensdag 17 oktober 2007 11:37 >To: Joris Dobbelsteen >Subject: Re: [GENERAL] newbie question > >Joris Dobbelsteen wrote: >>> -Original Message- >>> From: [EMAIL

Re: [GENERAL] newbie question

2007-10-17 Thread Joris Dobbelsteen
>-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Russell Aspinwall >Sent: woensdag 17 oktober 2007 9:34 >To: pgsql-general@postgresql.org >Subject: [GENERAL] newbie question > >Hi, > >[snip] For example, if you had a

[GENERAL] newbie question

2007-10-17 Thread Russell Aspinwall
Hi, In the mid 1990's I used the Progress Database which had a great feature where the it was possible to set the software version in the configuration file. For example, if you had a built a database and application using version 3 and then upgraded the version 7, it was possible to set the

Re: [GENERAL] Newbie question about importing text files...

2006-10-11 Thread Scott Marlowe
On Tue, 2006-10-10 at 04:16, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 10/09/06 22:43, Jonathan Greenberg wrote: > > So I've been looking at the documentation for COPY, and I'm curious about a > > number of features which do not appear to be included, and whether

Re: [GENERAL] Newbie question about importing text files...

2006-10-10 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/09/06 22:43, Jonathan Greenberg wrote: > So I've been looking at the documentation for COPY, and I'm curious about a > number of features which do not appear to be included, and whether these > functions are found someplace else: > > 1) How do I

Re: [GENERAL] Newbie question about importing text files...

2006-10-10 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/10/06 01:44, Merlin Moncure wrote: > On 10/10/06, Jonathan Greenberg <[EMAIL PROTECTED]> wrote: >> So I've been looking at the documentation for COPY, and I'm curious >> about a >> number of features which do not appear to be included, and whethe

Re: [GENERAL] Newbie question about importing text files...

2006-10-09 Thread Merlin Moncure
On 10/10/06, Jonathan Greenberg <[EMAIL PROTECTED]> wrote: So I've been looking at the documentation for COPY, and I'm curious about a number of features which do not appear to be included, and whether these functions are found someplace else: 1) How do I skip an arbitrary # of "header" lines

[GENERAL] Newbie question about importing text files...

2006-10-09 Thread Jonathan Greenberg
So I've been looking at the documentation for COPY, and I'm curious about a number of features which do not appear to be included, and whether these functions are found someplace else: 1) How do I skip an arbitrary # of "header" lines (e.g. > 1 header line) to begin reading in data? 2) Is it possi

Re: [GENERAL] Newbie Question: FAQ for database optimization?

2005-12-22 Thread David Fetter
On Tue, Dec 20, 2005 at 10:21:54PM +0100, Alexander Scholz wrote: > Hi, > > is there a newbie's FAQ / book / link for "howto optimize databases with > PostgreSQL"? > > Background: Customer has the Windows* (sorry ) Postgres 8.1.0 > standard installation "out of the box". A table has 2.5 mio reco

Re: [GENERAL] Newbie Question: FAQ for database optimization?

2005-12-20 Thread A. Kretschmer
am 20.12.2005, um 22:21:54 +0100 mailte Alexander Scholz folgendes: > Hi, > > is there a newbie's FAQ / book / link for "howto optimize databases with > PostgreSQL"? 07:12 < rtfm_please> For information about tuning 07:12 < rtfm_please> see http://www.powerpostgresql.com 07:12 < rtfm_please> or

[GENERAL] Newbie Question: FAQ for database optimization?

2005-12-20 Thread Alexander Scholz
Hi, is there a newbie's FAQ / book / link for "howto optimize databases with PostgreSQL"? Background: Customer has the Windows* (sorry ) Postgres 8.1.0 standard installation "out of the box". A table has 2.5 mio records. No indizes defined, primary key (sequence) does exist. In pgAdmin "sele

Re: [GENERAL] newbie question: reading sql commands from script

2005-10-28 Thread basel novo
Thanks to all who answered this question! From: Brent Wood <[EMAIL PROTECTED]> To: basel novo <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] newbie question: reading sql commands from script Date: Wed, 26 Oct 2005 10:36:34 +1300 (NZDT) On Tue, 25 Oct

Re: [GENERAL] newbie question: reading sql commands from script

2005-10-26 Thread Brent Wood
On Tue, 25 Oct 2005, basel novo wrote: > What is the equivalent of the mysql 'source' command for reading sql > commands from ascii script files? > I have not used mysql, so am not familiar with the source command, but to have postgres run a set of sql statements/queries from a file you can: p

Re: [GENERAL] newbie question: reading sql commands from script

2005-10-25 Thread Oliver Elphick
On Mon, 2005-10-24 at 20:39 -0400, Sean Davis wrote: > In psql, look at \i. > > Sean > > - Original Message - > From: basel novo > To: pgsql-general@postgresql.org > Sent: Monday, October 24, 2005 8:28 PM > Subject

Re: [GENERAL] newbie question: reading sql commands from script files

2005-10-24 Thread Sean Davis
Title: [GENERAL] newbie question: reading sql commands from script files In psql, look at \i.   Sean   - Original Message - From: basel novo To: pgsql-general@postgresql.org Sent: Monday, October 24, 2005 8:28 PM Subject: [GENERAL] newbie question: reading

[GENERAL] newbie question: reading sql commands from script files

2005-10-24 Thread basel novo
What is the equivalent of the mysql 'source' command for reading sql commands from ascii script files? Thanks. _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

Re: [GENERAL] Newbie question

2005-05-18 Thread Geoffrey
Kaloyan Iliev Iliev wrote: Hi Hugo, Yes, it is possible. Just write an outer perl script(in example), which to call this stored procedure. Then put in the cron to call whis perl script. As Far As I Know there isn't other way. Depending on whether you want to schedule a procedure on a regular basi

Re: [GENERAL] Newbie question

2005-05-18 Thread Bricklen Anderson
Hugo wrote: hi, is it possible to schedule the execution of an sql stored procedure in postgress on linux? thanks Hugo cron job: eg. Sat 2:30am 30 2 * * Sat psql -d dbname -c "select your_func()" -- ___ This e-mail may be privileged and/or confidential, and the sender

Re: [GENERAL] Newbie question

2005-05-18 Thread Hugo
thanks all for your help, I'll try your suggestions regards Hugo 2005/5/18, Kaloyan Iliev Iliev <[EMAIL PROTECTED]>: > Hi Hugo, > > Yes, it is possible. Just write an outer perl script(in example), which > to call this stored procedure. Then put in the cron to call whis perl > script. As Far As

Re: [GENERAL] Newbie question

2005-05-18 Thread Kaloyan Iliev Iliev
Hi Hugo, Yes, it is possible. Just write an outer perl script(in example), which to call this stored procedure. Then put in the cron to call whis perl script. As Far As I Know there isn't other way. Kaloyan Iliev Hugo wrote: hi, is it possible to schedule the execution of an sql stored procedu

Re: [GENERAL] Newbie question

2005-05-18 Thread Csaba Nagy
Dear Hugo, It is possible using cron and psql. Just "man cron" on unix if you're not already familiar with that. The command line you should use is something like: psql [connection options] -f sql_commands_file.sql Also "man psql" for the options you can use... Starting the procedure should be

Re: [GENERAL] Newbie question

2005-05-18 Thread Vlad
IMHO cron would be the best for that... > is it possible to schedule the execution of an sql stored procedure in > postgress on linux? -- Vlad ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.pos

Re: [GENERAL] Newbie question

2005-05-18 Thread Dann Corbit
in the file that you feed to psql. > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Hugo > Sent: Wednesday, May 18, 2005 8:24 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Newbie question > > hi

[GENERAL] Newbie question

2005-05-18 Thread Hugo
hi, is it possible to schedule the execution of an sql stored procedure in postgress on linux? thanks Hugo ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Newbie question on RULEs .. or .. bug ?

2005-05-18 Thread Leif Jensen
Hello Tom, Thank you for the enlightment, I think I understand what you say. There are however a few things I'm not sure about still. The update seems to work as I would expect when I include one or more in there where clause from the primary key. If I have a field not in the primary key

Re: [GENERAL] Newbie question on RULEs .. or .. bug ?

2005-05-17 Thread Tom Lane
Leif Jensen <[EMAIL PROTECTED]> writes: > CREATE RULE update_tasks2taskshead AS > ON UPDATE TO tasks WHERE NEW.seq = 0 > DO NOTHING > ; That rule looks a bit useless ... > CREATE RULE update_tasks2ganntinfo AS > ON UPDATE TO tasks > DO INSTEAD ( > update ganntinfo set > id = NEW

[GENERAL] Newbie question on RULEs .. or .. bug ?

2005-05-17 Thread Leif Jensen
Hello, I have been working with a great database system called PostgreSQL for many years ;-) but never had to use any RULEs. I now have to use and update through a view and have written a few rules to make this possible as per the manual. My insert rules seems to work fine, but I ca

Re: [GENERAL] Newbie question: returning rowtypes from a plpgsql function

2004-12-01 Thread Tom Lane
Larry White <[EMAIL PROTECTED]> writes: > mysql> create table t as ( select * from table_x); That works in Postgres too. The SELECT INTO construct is a bit broken since, as you discovered, it has a different meaning in plpgsql than in the main SQL language. So I recommend using CREATE TABLE AS w

Re: [GENERAL] Newbie question: returning rowtypes from a plpgsql function

2004-12-01 Thread Larry White
Please excuse my ignorance of databases and black holes. I don't have access to a Postgres db right now so I tried an experiment with mysql. Since they don't have a "select into" that creates a table, I tried this: mysql> create table t as ( select * from table_x); since table_x has no rows,

Re: [GENERAL] Newbie question: returning rowtypes from a plpgsql function

2004-11-30 Thread Tom Lane
Larry White <[EMAIL PROTECTED]> writes: > I wrote a function that returns a rowtype. The rowtype is assigned a > value by a query using SELECT INTO. The query sometimes will return > no rows. When it does, the function's return value is a row with no > values. > I would have expected it to retu

[GENERAL] Newbie question: returning rowtypes from a plpgsql function

2004-11-30 Thread Larry White
I wrote a function that returns a rowtype. The rowtype is assigned a value by a query using SELECT INTO. The query sometimes will return no rows. When it does, the function's return value is a row with no values. I would have expected it to return 0 rows, like the query itself. Am I doing some

Re: [GENERAL] Newbie Question, how to grant permissions on all tables in schema/db

2004-11-08 Thread Michael Fuhr
On Mon, Nov 08, 2004 at 05:00:49PM -0800, Kenji Morishige wrote: > I'm wondering what the easy way to grant user/group access on all tables > in a db. This comes up from time to time -- search the archives for phrases like "grant" and "all tables". The responses usually suggest writing a script

[GENERAL] Newbie Question, how to grant permissions on all tables in schema/db

2004-11-08 Thread Kenji Morishige
Hi guys, I'm wondering what the easy way to grant user/group access on all tables in a db. I just migrated about 200 tables from my MySQL database using a cool migration script, but now all the tables are owned by me in the schema public. That is all fine and all, but I wish I could run a comman

Re: [GENERAL] Newbie question about casting literals - oracle/postgres

2004-10-27 Thread Alvaro Herrera
On Tue, Oct 26, 2004 at 08:24:56PM -0500, Naeem Bari wrote: > The only way this works in postgres is by casting 'GREEN' to text using > 'GREEN'::text > > The problem is then this does not work with oracle. So use a standards-conformant cast, like cast('GREEN' as text) -- Alvaro Herrera () "T

Re: [GENERAL] Newbie question about casting literals - oracle/postgres

2004-10-27 Thread Dianne Yumul
hi, I think it works for me. what version of postgres do you have? maybe you just need to upgrade : ) test=# select cust_id, 'TEST' as test, cust_address from customers; cust_id | test | cust_address +--+-- 11 | TEST | 200 Maple Lane 100

Re: [GENERAL] Newbie question about escaping in a function

2004-10-27 Thread Thomas F.O'Connell
Try using EXECUTE. http://www.postgresql.org/docs/7.4/static/plpgsql- statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Oct 2

Re: [GENERAL] Newbie question about casting literals - oracle/postgres

2004-10-26 Thread Joshua D. Drake
The only way this works in postgres is by casting ‘GREEN’ to text using ‘GREEN’::text   The problem is then this does not work with oracle. Since my software has to support both databases, I am left in a bit of a bind. Any ideas on how to make postgres accept ‘GREEN’ as text without

[GENERAL] Newbie question about casting literals - oracle/postgres

2004-10-26 Thread Naeem Bari
Ok,   I have a query that runs fine in oracle:      select driver_id, 'GREEN' as color, pos_date, pos_lat, pos_lon    from driver_pos    where driver_id = 1    order by pos_date   The only way this works in postgres is by casting ‘GREEN’ to text using ‘GREEN’::text   The problem

Re: [GENERAL] Newbie question about escaping in a function

2004-10-26 Thread Naeem Bari
Thanks! Now I get it... naeem -Original Message- From: Oliver Elphick [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 3:05 PM To: Naeem Bari Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Newbie question about escaping in a function On Tue, 2004-10-26 at 11:57 -0500, Naeem

Re: [GENERAL] Newbie question about escaping in a function

2004-10-26 Thread Oliver Elphick
On Tue, 2004-10-26 at 11:57 -0500, Naeem Bari wrote: > I have a simple function defined thusly: > > > > CREATE OR REPLACE FUNCTION datemath(timestamp with time zone, int4, > varchar) > > RETURNS timestamp AS > > ' > > DECLARE > > tdat timestamp; > > rdat timestamp; > > BEGIN > >

[GENERAL] Newbie question about escaping in a function

2004-10-26 Thread Naeem Bari
I have a simple function defined thusly:   CREATE OR REPLACE FUNCTION datemath(timestamp with time zone, int4, varchar)   RETURNS timestamp AS ' DECLARE   tdat timestamp;   rdat timestamp; BEGIN   IF ($1 IS NULL) THEN     TDAT := NOW();   ELSE     TDAT := $1;   END IF;     se

Re: [GENERAL] Newbie question: OT

2004-03-17 Thread Tom Lane
"Robin 'Sparky' Kopetzky" <[EMAIL PROTECTED]> writes: > How do you pronounce PostgreSQl?? "post-gres" or "post-gres-cue-ell". See item 1.1 of the FAQ ;-) There used to be a .wav file on the website, but I can't find it at the moment. regards, tom lane

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Franco Bruno Borghesi
that's great, I didn't know about the information schema... guess I never read the 'what's new' document On Fri, 2004-02-06 at 13:15, Tom Lane wrote: Franco Bruno Borghesi <[EMAIL PROTECTED]> writes: > Does anyone know if the ansi sql standard defines any way to do this? > I've seen the DESC

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Tom Lane
Franco Bruno Borghesi <[EMAIL PROTECTED]> writes: > Does anyone know if the ansi sql standard defines any way to do this? > I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands > in other databases, but I don't really know if they are extensions or > not. They are extensions (an

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Richard Huxton
On Friday 06 February 2004 15:00, Franco Bruno Borghesi wrote: > > Does anyone know if the ansi sql standard defines any way to do this? > I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands > in other databases, but I don't really know if they are extensions or > not. There's

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Henrik Steffen
on Bratcher > Gesendet: Freitag, 6. Februar 2004 15:10 > An: [EMAIL PROTECTED] > Betreff: Re: [GENERAL] newbie question... how do I get table > structure? > > > Is there no way I can do it with a standard select command in a > different client? I don't need the in

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Franco Bruno Borghesi
this should work (don't forget to replace !!!): SELECT A.attname, pg_catalog.format_type(a.atttypid, a.atttypmod) AS typeName FROM pg_class C, pg_attribute A, pg_type T WHERE C.relname ILIKE '' AND (C.oid=A.attrelid) AND (T.oid=A.atttypid) AND (A.attnum>0) AND (NOT A.attisd

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Mark Gibson
Aaron Bratcher wrote: Is there no way I can do it with a standard select command in a different client? I don't need the indexes, just the column names/types. For PostgreSQL 7.3 and above: SELECT a.attname, format_type(a.atttypid, a.atttypmod) FROM pg_catalog.pg_class c INNER JOIN p

Re: [GENERAL] newbie question... how do I get table structure?

2004-02-06 Thread Aaron Bratcher
Is there no way I can do it with a standard select command in a different client? I don't need the indexes, just the column names/types. -- Aaron Bratcher ab DataTools http://www.abDataTools.com On Feb 6, 2004, at 8:12 AM, Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, "Joshua D. Drake" <[

Re: [GENERAL] newbie question on database structure

2004-01-19 Thread David Helgason
On 15. jan 2004, at 18:51, JustSomeGuy wrote: 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 *data; } myObject; a and b describe the type of object, len is the number of bytes that are

[GENERAL] newbie question on database structure

2004-01-18 Thread JustSomeGuy
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 *data; } myObject; a and b describe the type of object, len is the number of bytes that are required to hold the object. and of course da

Re: [GENERAL] Newbie-question

2003-10-29 Thread Andrew Ayers
Victor Spång Arthursson wrote: > Are presently converting from mysql to postgresql, and my first > newbiequestion is how to make all the rows in a result from a select > just "swosh" by? That is, I dont want to see them page for page; just to > scroll by so I can se the last line with the number

Re: [GENERAL] Newbie-question

2003-10-28 Thread Andrew Sullivan
On Wed, Oct 29, 2003 at 01:24:56AM +1100, Brendan Jurd wrote: > from your question that you are), then the results are reported back via > the utility "less" (or a less-like program internal to psql, can someone > else clarify?) Actually, it's your $PAGER environment variable (and there's the u

Re: [GENERAL] Newbie-question

2003-10-28 Thread Victor Spång Arthursson
2003-10-28 kl. 14.33 skrev Jeff: 1. in psql, \pset pager will turn paging off. Although, if you really want a row count, a much better way to do that is select count(*) from [rest of select statement] Thanks. I'm not new to SQL, just to postgresql, so I know about the Count-function ;) Reason

[GENERAL] Newbie-question

2003-10-28 Thread Victor Spång Arthursson
Are presently converting from mysql to postgresql, and my first newbiequestion is how to make all the rows in a result from a select just "swosh" by? That is, I dont want to see them page for page; just to scroll by so I can se the last line with the number of corresponding rows. And is there

Re: [GENERAL] !! Newbie question!!!! connecting to multiple databases

2001-09-05 Thread will trillich
On Fri, Aug 24, 2001 at 09:53:00PM +, uncleleo wrote: > I am attemping to create multiple databases with Postgresql ver. 7.0.3 > running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0. > > Can someone tell me how I can connect to different databases in a single > select s

Re: [GENERAL] !! Newbie question!!!! connecting to multiple databases

2001-08-31 Thread Stephan Szabo
On Fri, 24 Aug 2001, uncleleo wrote: > I am attemping to create multiple databases with Postgresql ver. 7.0.3 > running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0. > > Can someone tell me how I can connect to different databases in a single > select statement? Such as,

[GENERAL] !! Newbie question!!!! connecting to multiple databases

2001-08-31 Thread uncleleo
I am attemping to create multiple databases with Postgresql ver. 7.0.3 running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0. Can someone tell me how I can connect to different databases in a single select statement? Such as, I have a database named "Customer" and another n

Re: [GENERAL] Newbie Question

2001-05-04 Thread Peter Eisentraut
Clay & Judi Kinney writes: > How do I create an autoincrement field in a postgresql table??? See FAQ. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [GENERAL] Newbie Question

2001-05-04 Thread Ludwig Meyerhoff
Hallo! > How do I create an autoincrement field in a postgresql table??? > What are the correct field type and parameters Well, what about using sequences? create sequence tralalala; create table huibui ( id integer primary key default nextval('tralalala'), field1 references table1, and

Re: [GENERAL] newbie question -- oid

2001-04-19 Thread Peter Eisentraut
Cefull Lo writes: > What is the upper limit of OID? 2^31-1 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomai

[GENERAL] newbie question - INSERT

2001-04-10 Thread Cefull Lo
When I type INSERT INTO friend VALUES ('', '', ''); it returns INSERT 19748 1 what means of 19748 and 1? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to

Re: [GENERAL] newbie question - INSERT

2001-04-10 Thread Dominic J. Eidson
On Tue, 10 Apr 2001, Cefull Lo wrote: > When I type INSERT INTO friend > VALUES ('', '', ''); > it returns > INSERT 19748 1 > > what means of 19748 and 1? 19748 is the OID of that record, and 1 means one record was inserted. For information on OID's, look in the documentation. -- Dominic J.

Re: [GENERAL] newbie question

2001-02-26 Thread Doug McNaught
prashanth bhat <[EMAIL PROTECTED]> writes: > hi all, > > Is it possible to store java Objects in postgres and > invoke methods on them??. Is it possible to store XML > in postgres?. The answer to both your questions is "yes, but..." Any Java object that implements Serializable can be serialize

[GENERAL] newbie question

2001-02-26 Thread prashanth bhat
hi all, Is it possible to store java Objects in postgres and invoke methods on them??. Is it possible to store XML in postgres?. please reply ASAP thanx in adv. prashanth __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://pe

Re: [GENERAL] Newbie question :-)

2001-02-26 Thread Brett W. McCoy
On Sat, 24 Feb 2001, Bela Lantos wrote: > I just started learning Database Design, our programs have to work on > Oracle, but at home I run Linux. > > Can any of you tell me how portable are the programs written for Progresql? > Would they run on Oracle without problem? That all depends on the p

Re: [GENERAL] Newbie question

2001-01-14 Thread Anand Raman
what do u mean by the datadir problem.. if pg_ctl asks for a datadir then ucan set it in /etc/profile and start again.. Hope this helps Anand On Mon, Jan 08, 2001 at 03:44:34PM +0100, MUMCU, Burak wrote: > >Hi all, > >I'm using Suse Linux 7.0 and I have installed PostgreSQL. The problem is >when

Re: [GENERAL] newbie question:

2000-12-19 Thread Dan Wilson
ALTER USER postgres WITH PASSWORD '[enter password]' http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm - Original Message - From: "Leon van Dongen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 18, 2000 1

Re: [GENERAL] Newbie Question

2000-11-01 Thread Richard Poole
On Wed, Nov 01, 2000 at 12:32:58PM -0500, Nick Fankhauser wrote: > According to the documentation and Bruce M's book, there is no limit. I've > never hit a limit while putting some pretty large (three page) narratives in > a text field. There is no limit on the "text" type as such, but there is s

RE: [GENERAL] Newbie Question

2000-11-01 Thread Nick Fankhauser
chunks of data comingled with smaller chunks. -Nick Fankhauser > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of John Pilley > Sent: Wednesday, November 01, 2000 12:10 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Newbie Question >

[GENERAL] Newbie Question

2000-11-01 Thread John Pilley
Is there an upper limit on the size of a "text" character field? If so, how can I extend it? Thanks, John begin:vcard adr;dom:;;232 E. Lyons;Spokane;WA;99208; n:Pilley;John x-mozilla-html:FALSE org:Settlement Plus, Inc. version:2.1 email;internet:[EMAIL PROTECTED] title:Software Engineer tel

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Robert Vogt IV
Mr. Lane, >> Why is this? We're running 7.0.2 and have not performed any of these >> compile-time gymnastics...and we're not having any problems > > Did you compile from source? If so I'd expect things to be fine. It's > just the PPC RPMs that are (or, shortly, were) on our FTP server

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Tom Lane
"Robert Vogt IV" <[EMAIL PROTECTED]> writes: >>> Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is >>> a typical symptom of being compiled with higher optimization settings. >>> Unfortunately, it seems that our PPC RPMs for 7.0.2 were compiled with >>> the wrong -O level :-(.

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Larry Rosenman
* Robert Vogt IV <[EMAIL PROTECTED]> [001028 12:10]: [SNIP] > By the way- does anybody know of any resources related to securing > databases. We'd like to only allow certain users access to each database, > but cannot find the appropriate section in any of the documentation pages. Look at pg_

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Robert Vogt IV
Isaac and Tom, > Awesome, thanx. I thought i was doing something wrong. I suggest that some > sort of warning about this go on the pgsql website (and other places where > us PPC types will notice it) so no one else has to beat their head on the > wall over this. > >> Postgres 7.0.* doesn't wo

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Tom Lane
Isaac <[EMAIL PROTECTED]> writes: > ERROR: getattproperties: no attribute tuple 1259 -2 Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is a typical symptom of being compiled with higher optimization settings. Unfortunately, it seems that our PPC RPMs for 7.0.2 were compiled w

Re: [GENERAL] newbie question: ERROR: getattproperties: noattribute tuple 1259 -2

2000-10-27 Thread Isaac
Awesome, thanx. I thought i was doing something wrong. I suggest that some sort of warning about this go on the pgsql website (and other places where us PPC types will notice it) so no one else has to beat their head on the wall over this. AP2P --i on 10/27/00 10:52 PM, Tom Lane at [EMAIL PROTEC

[GENERAL] newbie question

2000-07-05 Thread Mike Sears
is it possible to pull a column from a postgres table then have it linked via html and php to the corresponding row. If so how would that be accomplished?

[GENERAL] Newbie question: Does PostgreSQL have stored procedures?

1998-12-14 Thread Andrew Hopper
I saw that you can have functions written in C or SQL, but can you write a precompiled SQL statement (such as SELECT * FROM tablename WHERE ...) that returns a set of rows? I couldn't find anything that addresses this in the documentation (does that mean it can't be done yet?). --