Re: [GENERAL] serial column

to figure out how you know which device number 2 (as an example) you are looking at. I am assuming these devices exist as actual entities. So are these numbers applied to the actual device and if so are you going to be constantly renumbering them? -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Restart after poweroutage

issues with ACPI and has to be powered off. After the most recent event I saw a message similar to that reported above. I checked and there were no other Postgres instances running. What information I could collect is included in the attached file. -- Adrian Klaver [EMAIL PROTECTED] Error

Re: [GENERAL] serial column

of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Restart after poweroutage

On Monday 25 September 2006 02:48 pm, Tom Lane wrote: Adrian Klaver [EMAIL PROTECTED] writes: On Sunday 24 September 2006 09:17 am, Tom Lane wrote: Jon Lapham [EMAIL PROTECTED] writes: FATAL: pre-existing shared memory block (key 5432001, ID 65536) is still in use This is extremely

Re: [GENERAL] alter integer field to serial integer primary key

to set the nextval(sequence) as the DEFAULT value. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] basic SQL request

articletype i'm confused now, if i use LEFTJOIN it's the same, so where is the trouble ? thx, AL. The table name in the FROM clause has an s on the end. The name in the WHERE clause does not. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] R and postgres

both being apparently defunct projects. What is the Right Thing for a guy who wants R to talk to postgresql? Thanks, and send aspirin, Reece You might want to take a look at PL/R a procedural language for R in Postgres. http://www.joeconway.com/plr/ -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] R and postgres

On Monday 06 November 2006 07:38 pm, Reece Hart wrote: On Mon, 2006-11-06 at 19:13 -0800, Adrian Klaver wrote: You might want to take a look at PL/R a procedural language for R in Postgres. http://www.joeconway.com/plr/ PL/R is indeed neat, but I want to go the other way: within R, fetch

Re: [GENERAL] posgres headers

! Music Unlimited. I answered this question for you on the psycopg list. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Data conversion tools?

run against my Postgres DB. Short of installing an older Postgres DB that PGAdmin II will work with - does anyone else know of a tool that can do what I want? Is there a script of some sort that I can run that would go through a set of tables and lowercase everything? Thanks, Dan -- Adrian

Re: [GENERAL] After Update Triggers

://www.postgresql.org/docs/faq -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Data

could copy the files I would hesitate because of the corruption issue. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Version 8.1

Pawley http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html See add_missing_from (boolean) -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [GENERAL] PG Admin

sequential and gapless. Bob I am trying to figure how you keep track of the physical devices. Do they get renumbered also? -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] PG Admin

integer column. Have an AFTER INSERT/UPDATE/DELETE trigger that does a count on the table and renumbers all the rows in the id column. This is the brute force method. The alternative would be to search for the gaps and renumber from the first gap up. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] need help with plpgsql execute insert

will automatically use the real value. Like if it is a date it will handle it like a java prepared statement. Am I wrong? I have tried all kinds of things but I truly have no idea what the problem is. thanks See inline comment, but I think you are missing a comma in your columns list. -- Adrian

Re: [GENERAL] could not open relation:no such file or directory

itemsbytitle? If so you may need to quote the table name- SELECT title FROM itemsbytitle; See below for full explanation http://www.postgresql.org/docs/8.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Generic timestamp function for updates where field

+fld_name TD[new][full_name]=now() return MODIFY $Body$ LANGUAGE plpythonu SECURITY DEFINER; -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Installing support for python on windows

on this (ie ten hours g) I hope someone can knock out a line or two to steer me in the right direction. Just for reference sake, did you try createlang -d mydb plpythonu See URL below for more information http://www.postgresql.org/docs/8.2/interactive/app-createlang.html -- Adrian Klaver

Re: [GENERAL] Installing support for python on windows

that it sees there. I also tried plpython (no trailing u) and had the same error as the earlier experiment. At this point I don't know what to say. Hopefully someone with with experience installing Postgres on Windows can help out. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Installing support for python on windows

I broke down and installed Postgres on Windows. I had the same problem with installing plpython until I did as Magnus suggested, rebooted Windows. I then ran createlang -d template1 -U postgres plpythonu to install it into the template1 database and it succeeded. -- Adrian Klaver [EMAIL

Re: [GENERAL] How to convert money columns to numeric?

Take a look at the GeneralBits column below for a possible solution(see heading Convert money type to numeric)- http://www.varlena.com/GeneralBits/75.php -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [GENERAL] Installing support for python on windows

. The server was restarted and the path modified was for the server. Thanks Depends is a windows program. To get it I had to load the Windows support tools from the Windows install disc(in my case the image on my harddrive). -- Adrian Klaver [EMAIL PROTECTED] ---(end

Re: [GENERAL] Installing support for python on windows

needs python 2.4, which needs IE 6??? I installed with python 2.5 and IE7 with no problem. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Generic timestamp function for updates where field

On Wednesday 03 January 2007 12:13 am, novnov wrote: Adrian Klaver wrote: On Sunday 31 December 2006 8:48 am, novnov wrote: OK. python would be the preference, if anyone is interested in showing me how it would be done, I've never used one of the dynamic languages with postgres. Why

Re: [GENERAL] Generic timestamp function for updates where field

On Wednesday 03 January 2007 9:10 am, novnov wrote: Adrian Klaver wrote: On Wednesday 03 January 2007 12:13 am, novnov wrote: Adrian Klaver wrote: On Sunday 31 December 2006 8:48 am, novnov wrote: OK. python would be the preference, if anyone is interested in showing me how it would

Re: [GENERAL] TRIGGER BEFORE INSERT

, amount int not null, dnia int references test_days(id)); to: CREATE TABLE test_utarg(tm timestamp not null, nic int, amount int not null, dnia int references test_days(id) INITIALLY DEFERRED); per Toms suggestion. This eliminates the need for the SET CONSTRAINTS DEFERRED statement. -- Adrian

Re: [GENERAL] How can I list the function.

/interactive/sql-grant.html -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Count(*) throws error

-- Original message -- From: Jasbinder Singh Bali [EMAIL PROTECTED] Hi, I'm using the following statement in my plpgsql function SELECT INTO no_rows COUNT(*) FROM tbl_concurrent; I have decalred no_rows int4 and initialized it to zero Running the

Re: [GENERAL] Tables dissapearing

on its own and the developer is certain the CMS software is not doing schema changes. As I understand it logging has been cranked up to test both those assumptions. My question is, how are legitimate schema changes done? Just wondering if there is a third party involved. -- Adrian Klaver

Re: [GENERAL] Export data to MS Excel

directly from a table to a spreadsheet. Just save as *.xls. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] pg_dump

projects (not all pertain to your question) http://www.postgresql.org/download/commercial -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: re[GENERAL] lations does not exist

with quotes in a form other than 'party' then selecting for 'party' will result in the error above. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [GENERAL] Question regarding Hibernate ORDER BY issue

/html/mapping.html See esp. section 5.4 on SQL quoted identifiers -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] Select Command

col where col LIKE '%LT%'; See also: http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#FUNCTIONS-LIKE -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [GENERAL] Photos from the PostgreSQL Conference Fall 2007

of the event: http://db.endpoint.com/pgcon07/ Now if one could put names to those faces ... :} Daniel Browning Cheers, Andrej I figured the name tags took care of that. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6

Re: [GENERAL] select count() out of memory

you do a Copy to a single table instead of multiple inserts and avoid the index overhead. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] select count() out of memory

-- Original message -- From: Thomas Finneid [EMAIL PROTECTED] Adrian Klaver wrote: I might be missing the point, but couldn't you do a Copy to a single table instead of multiple inserts and avoid the index overhead. Are you saying, have one large

Re: [GENERAL] pg_restore

it to restore to named file. It won't do both. I used the same command to successfully install the same pg_dump file into PostgreSQL 8.1 running on the same computer. Maybe 8.1 ignored the error. Any thoughts would be much appreciated. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] pg_restore

to aurel (..8,2\bin) or when aurel is not even mentioned. Is this really the path -(..8,2\bin)? Note the ','. This is becoming quite frustrating. The other thing to check is whether you have the necessary permissions to read the file. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] pg_restore

. regards, tom lane Well there is your problem. Might help if I was using both eyes. Thanks for the heads up Tom. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_restore

and pg_restore only works with the custom formats. If you want to use the plain text version than you need to use psql. This maybe how you got to the point of having both pg_restore and psql on the same line. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] pg_restore

at the URL below before proceeding further. http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] dbf to pgsql

Peter ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Adrian Klaver [EMAIL PROTECTED

[GENERAL] plpythonu and return void

and not actually returning anything. I have searched for an explanation and can't seem to locate one. Obviously I have missed something I just don't know what? Any suggestions would be appreciated. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] plpythonu and return void

On Monday 08 August 2005 08:02 pm, Tom Lane wrote: Adrian Klaver [EMAIL PROTECTED] writes: I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The only problem I have run into is that a plpythonu function that returns void will not run under 8.03. The error message states

Re: [GENERAL] Column does not exist when trying to insert data.

on the psycopg list. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] plpy prepare problem

/ -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list

Re: [GENERAL] Upgrade Process

containing the old version so that Postgres listens on a different port and start it up. I can then use the pg_dump(all) commands from the new version to pull from the old version. The catch is that you need enough room for both copies of the database. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Date Math

not have to declare the INTERVAL . Is date_issued stored as a date? If so it would not need to be cast. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [GENERAL] Date Math

On Monday 07 May 2007 10:56 am, Rich Shepard wrote: On Mon, 7 May 2007, Adrian Klaver wrote: If term and process_time are stored as intervals then it will work. Also if they are stored as INTERVALS you can do CURRENT_DATE+process_time. In other words not have to declare the INTERVAL

Re: [GENERAL] Date Math

On Monday 07 May 2007 12:00 pm, Tom Lane wrote: Adrian Klaver [EMAIL PROTECTED] writes: With this setup you will have to use an explicit string- date_issued + INTERVAL term|| 'years'. This will involve constructing a string and passing it to INTERVAL. No, that's a truly awful way to do

Re: [GENERAL] Date Math

+ process_time + '2 week'::INTERVAL); is now correct syntax and use? Thanks all, Rich Yes. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [GENERAL] cube

of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match I found instructions in ~/contrib/cube/README.cube -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] plpython and error catching

, by using plpy.error or plpy.fatal. In other words the opposite of what you are counting on. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] postgres schema printer

On Sunday 25 November 2007 1:32 pm, Dave Potts wrote: Is there such a thing as an opensource schema printer for postgres ? Dave. See Autodoc at: http://www.rbt.ca/autodoc/ -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have

Re: [GENERAL] \copy ... with null as '' csv doesn't get nulls

as '\'\'' CSV HEADER -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

to log and CUSTOMIZED OPTIONS. I would suggest keeping it under What to log. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] relation deleted while in use encountered with Postgresql 8.0.8

be greatly appreciated. thanks, Gautam Is it possible to show the python script? Also were you using the logging functions in Postgres? If so what does the log file show? Was another application/person accessing the database at the same time? -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Better alternative for Primary Key then serial??

/functions-sequence.html As to preventing updates. You have a couple of choices. 1)Do not let that field be changed by the user. I usually in either hid the field or prevented data entry on that field. 2) Create an ON UPDATE TRIGGER that does what you want with the field. -- Adrian Klaver [EMAIL

Re: [GENERAL] mssql migration and boolean to integer problems

. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Finding bad bye in invalid byte sequence error

import file. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] spreadsheet interface

seem to. Any suggestions? OpenOffice. Set up a datasource using the Base component. You can drag and drop to the spreadsheet component. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [GENERAL] spreadsheet interface

OO with either the Postgres JDBC driver or the native SDBC driver. I tried the ODBC driver with not too much success. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] spreadsheet interface

list, it pounces so quickly. Regards, H.Jenkins -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] After Installing a Program I get this error: psql:sql/Pg-database.sql:825: ERROR: language plpgsql does not exist

, Robin The solution is in the HINT:. The language needs to loaded with createlang. plpgsql is shipped with Postgres it is not, however, loaded by default. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [GENERAL] temp sequence

-- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] How can I get the first and last date of a week, based on the week number and the year

','IW YY'); to_date 2008-02-25 (1 row) Where 9 is the ISO week number and 08 is the year. See below for more details: http://www.postgresql.org/docs/8.2/interactive/functions-formatting.html -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] How can I get the first and last date of a week, based on the week number and the year

On Tuesday 26 February 2008 8:39 pm, Tom Lane wrote: Adrian Klaver [EMAIL PROTECTED] writes: On Tuesday 26 February 2008 5:32 pm, Bruno Baguette wrote: I have a week number (ISO 8601) and a year, based on theses values, I would like to get the first and the last dates of that week

Re: [GENERAL] [SQL] Documenting a DB schema

-table.html) However, Postgres doesn't support the comment keyword. Is there an alternative? Thanks, --S See: http://www.postgresql.org/docs/8.2/interactive/sql-comment.html -- Adrian Klaver [EMAIL PROTECTED] ---BeginMessage--- Im looking

Re: [GENERAL] Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP

ON COMMIT DROP; Thanks for your help David I am missing something here. What is wrong with the above statement? -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP

On Thursday 13 March 2008 2:46 pm, Colin Wetherbee wrote: Adrian Klaver wrote: On Thursday 13 March 2008 4:49 am, David Gagnon wrote: Hi all, I think the title says everything:-) I just what a way to create a TEMP for the current transaction only. If possible I don't want

Re: [GENERAL] postgre vs MySQL

out their have done this or will advice to do that? cheers, Rahul. -- View this message in context: http://www.nabble.com/postgre-vs-MySQL-tp15976517p16024988.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql

Re: [GENERAL] GRANT giving error on sequence in 7.4.19

ON object_seq TO tester; There is no SEQUENCE keyword in the GRANT command in 7.4 and a SEQUENCE is basically a one row table. -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Loging of postgres requests

by the application generating invalid SQL or if there is a problem with the desgin of the database tables. Dave. See: http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html In particular you will want to set log_statement to 'all' to see the SQL. -- Adrian Klaver [EMAIL

Re: [GENERAL] Updating

can be constrained to fire for each row. Inside the trigger function you can test to see if the column in question has been updated and do the appropriate thing. If the column has not been changed do nothing and RETURN NEW which makes the function non-op. -- Adrian Klaver [EMAIL PROTECTED

Re: [GENERAL] Updating

On Sunday 16 March 2008 5:36 pm, Bob Pawley wrote: Would it be possible to get an example of such coding?? Bob - Original Message - From: Adrian Klaver [EMAIL PROTECTED] To: pgsql-general@postgresql.org Cc: Bob Pawley [EMAIL PROTECTED] Sent: Sunday, March 16, 2008 5:14 PM

Re: [GENERAL] Updating

On Monday 17 March 2008 4:54 am, Daniel Verite wrote: Adrian Klaver wrote: CREATE FUNCTION foo() RETURNS trigger AS $Body$ BEGIN IF NEW.colname != OLD.colname THEN ...Do something..; RETURN whatever; ELSE RETURN NEW: END

Re: [GENERAL] Row size overhead

with other overheads. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Insert

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver [EMAIL PROTECTED] - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Insert

occurring in the IF and ELSEIF clauses. There can only be one value on each side of the comparison. - Original Message - From: Adrian Klaver [EMAIL PROTECTED] To: pgsql-general@postgresql.org Cc: Bob Pawley [EMAIL PROTECTED] Sent: Sunday, March 23, 2008 2:24 PM Subject: Re

Re: [GENERAL] Insert

understand monitoring_fluid=pipe_id. - Original Message - From: Adrian Klaver [EMAIL PROTECTED] To: pgsql-general@postgresql.org Cc: Bob Pawley [EMAIL PROTECTED] Sent: Sunday, March 23, 2008 2:58 PM Subject: Re: [GENERAL] Insert On Sunday 23 March 2008 2:40 pm, Bob Pawley wrote

Re: [GENERAL] Insert

execute procedure monitor_install(); - Original Message - From: Adrian Klaver [EMAIL PROTECTED] To: pgsql-general@postgresql.org Cc: Bob Pawley [EMAIL PROTECTED] Sent: Sunday, March 23, 2008 2:58 PM Subject: Re: [GENERAL] Insert On Sunday 23 March 2008 2:40 pm, Bob Pawley wrote

Re: [GENERAL] date and time

() which records the current time. -- Adrian Klaver [EMAIL PROTECTED] - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pl/pgsql and controling loops

on a NULL value. You will need to use IS NULL or IS NOT NULL. thx. -- Alain Windows XP SP2 PostgreSQL 8.2.4 / MS SQL server 2005 Apache 2.2.4 PHP 5.2.4 C# 2005-2008 -- Adrian Klaver [EMAIL PROTECTED] ---BeginMessage--- Hi,ive read several books

Re: [GENERAL] pl/pgsql and controling loops

-- Original message -- From: Tom Lane [EMAIL PROTECTED] [EMAIL PROTECTED] (Adrian Klaver) writes: From: Alain Roger [EMAIL PROTECTED] once to do a comparison they use : IF (ret == 1) THEN ... once, IF (ret = 1) THEN... Both are correct

Re: [GENERAL] dunction issue

/ but not in table users.) so i think my eyes are tired, because i do not see an error... thanks. -- Alain Windows XP SP2 PostgreSQL 8.2.4 / MS SQL server 2005 Apache 2.2.4 PHP 5.2.4 C# 2005-2008 -- Adrian Klaver [EMAIL PROTECTED] ---BeginMessage--- Hi,i have

Re: [GENERAL] dunction issue

(SELECT email FROM users) u ON s.email = u.email; Why not put a foreign key on the email column to the users table---one less error to handle that way? Sam Or a simpler way to do handle my previous suggestion: IF (ret_email IS NULL ) OR (ret_email='') THEN         RETURN ('-3') -- Adrian

Re: [GENERAL] Using tables in other PostGreSQL database

. But I thank the forum here for all the input. Regards, Barry Pettis CSO Atmel Corp Project Tech http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Using tables in other PostGreSQL database

its own terminology that does not translate well. -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2008 8:30 AM To: pgsql-general@postgresql.org Cc: Pettis, Barry Subject: Re: [GENERAL] Using tables in other PostGreSQL database

Re: [GENERAL] Multiline plpython procedure

function circ DETAIL: exceptions.SyntaxError: invalid syntax (line 2) How to get Postgres to accept a normal looking python function? Greetings -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your

Re: [GENERAL] Multiline plpython procedure

of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] How to query pgsql from a BASH script ?

be able to do what you want. http://www.edlsystems.com/shellsql/ -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL as a filesystem

not subscribed to this list. Thanks in advance! -={C}=- You might be interested in the following site. It is a Python DBAPI driver that uses the file system as a database. http://fssdb.sourceforge.net/ -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Howto prevent write based on date

just such an option in the administrator options. This would save you from having to play around with the back end. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] Storing Snapshot Data

the timestamp to the time at the beginning of the transaction. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] windows distribution

. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [GENERAL] Errors after power failure

? http://www.postgresql.org/docs/faqs/FAQ.html -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Best way to represent values.

a gap there. :) Though I will try to glean something out of the link. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Numbers

://archives.postgresql.org/pgsql-general/2005-01/msg01646.php -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

  1   2   3   4   5   6   7   8   9   10   >