[GENERAL] postgresql.com

2001-09-12 Thread Ryan Mahoney
postgresql.com takes you to greatbridge.com as of today - did it always - or am I losing my mind? -r --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 -

Re: [GENERAL] business perspective

2001-09-12 Thread Ryan Mahoney
>The website is currently undergoing a rewrite. > >Vince. Are there architectural designs, use cases, mock-ups, color schemes, requirements, etc. that we can view online so we can understand the direction things are moving in and offer our input and talents? If this project is worked on by a

[GENERAL] Recreating unique index for primary key

2001-09-28 Thread Ryan Ho
Hi, I've dropped an primary key index in order to re-create it. but i realized that i can't recreate a primary key index. Will a unique index be an adequate replacement? will the database integrity be at risk as a result? Thanks! -- Ho Siaw Ping, Ryan

Re: [GENERAL] Porting Code to Postgresql

2003-10-15 Thread Ryan Mahoney
's, so it would be very convenient for us to achieve this. > > > Best Regards, > > Errol U. Neal > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > >http://www.

[GENERAL] PostgreSQL License Question

2003-11-02 Thread Ryan Mack
was unable to find them in the archive. Also, please reply to me directly, I am not subscribed. Thank you, Ryan Mack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Sequences do not obey transactions...

2000-06-20 Thread Ryan Kirkpatrick
--- Philippians 1:21 (KJV) | --- | Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ | ---

Re: FW: [GENERAL] Count & Distinct

2000-08-24 Thread Ryan Williams
I find that if I create the table described in the email, in psql I recieve 'ERROR: Attribute 'row' not found'... But this isn't exactly 'ERROR: parser: parse error at or near "distinct"'... - Original Message - From: "John McKown" <[EMAIL PROTECTED]> To: "anuj" <[EMAIL PROTECTED]> Cc

Re: FW: [GENERAL] Count & Distinct

2000-08-24 Thread Ryan Williams
mp; Distinct > On Thu, Aug 24, 2000 at 10:35:49AM -0700, Ryan Williams wrote: > > I find that if I create the table described in the email, in psql I recieve > > 'ERROR: Attribute 'row' not found'... > > > > But this isn't exactly 'ERROR

Re: [GENERAL] C++ Example

2000-08-30 Thread Ryan Williams
What do you need an example of? I can send you some C++ code that uses ODBC to connect to PostgreSQL, if that's what you need. - Original Message - From: "Miguel Omar Carvajal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 29, 2000 2:45 PM Subject: [GENERAL] C++ Examp

[GENERAL] View Queries to server

2001-05-03 Thread Ryan Mahoney
Is it possible to view the last 100 queries issued to the database? -r --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 ---(end of broadcast)---

[GENERAL] Re: [NOVICE] psql with PHP question

2001-05-07 Thread Chris Ryan
; Hope this helps. Chris Ryan [EMAIL PROTECTED] Jason wrote: > > Hi, I want to try and optimize my calls to postgreSQL from PHP. If > I only need one field from a select statement, what should I use? I am > currently using: > $q = pg_Exec("SELECT id FROM article

Re: [GENERAL] Performance aggregates

2001-05-15 Thread Ryan Mahoney
If your query is not using the correct index files, you're query will run slowly. Please post the output from EXPLAIN. -r At 09:00 PM 5/15/01 +0200, snpe wrote: >On Tuesday 15 May 2001 17:28, Stephan Szabo wrote: > > On Tue, 15 May 2001, snpe wrote: > > > Table e_kalkn have 4668 rows and e_ka

Re: [GENERAL] SQL help...

2001-05-15 Thread Ryan Mahoney
Please post the sql statement that creates these tables. -r At 12:15 AM 5/16/01 -0400, Alex Hochberger wrote: >To any SQL wizards out there, > >I have finally exhausted my SQL knowledge. > >I have 3 tables that I need to do a fancy join on... > >1 stores the users >1 stores the questions >1 sto

RE: [GENERAL] SQL help...

2001-05-15 Thread Ryan Mahoney
t;questions" ("survey_id"); > > >User Answers: >-- >CREATE TABLE "user_answers" ( >"ua_id" int8 DEFAULT nextval('ua_id_seq'::text) NOT NULL, >"user_id" int8 NOT NULL, >"question_id" int8 NOT NU

Re: [GENERAL] Tiiiiiiiiiiiiime

2001-05-16 Thread Ryan Mahoney
This is a guess - have you tried: SELECT * FROM tableName WHERE time = CURRENT_TIMESTAMP - '3 months'::interval let me know if it works! -r At 05:49 PM 5/15/01 +0900, hiroko wrote: hi all.   from a DB table, I'd like to SELECT out the date of 3months before. the command should be   => select

Re: [GENERAL] Postgres CPU usage

2001-05-24 Thread Ryan Mahoney
I have never had the postmaster die on me, although I have made is slow to almost a halt ;) Performance really depends what your doing. It is possible to write a query that uses all system resources. I recommend restarting postgres and take a look at the CPU utilization and make sure at sta

Re: [GENERAL] Backend cache invalidation initialization failed... HUH?

1998-12-06 Thread Ryan Schutt
We are upgrading from 6.3.2 to 6.4 today on solaris 2.5.1. I'll let you know how it goes.. -Ryan -Original Message- From: Herouth Maoz <[EMAIL PROTECTED]> To: Bruce Momjian <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Sunday, December 06, 1

[GENERAL] listing all tables

1998-07-16 Thread Ryan Mchale
Hi, How would I list all tables in a database? Ryan

[GENERAL] clean database

1998-08-11 Thread Ryan Mchale
Hi, What's the clean command called? (To clean the db?) Ryan

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Ryan Kirkpatrick
ng on your Linux/Alpha box, feel free to email me. --- | "For to me to live is Christ, and to die is gain."| |--- Philippians 1:21 (KJV) | ----

Re: [GENERAL] Postgres on Linux Alpha

1999-11-09 Thread Ryan Kirkpatrick
t than hacking Postgres. :( --- | "For to me to live is Christ, and to die is gain."| |--- Philippians 1:21 (KJV) | --- | Ryan Kirkpatri

[GENERAL] Postgres Installation Password

2012-06-11 Thread Magruder, Ryan S.
password. Ryan Magruder

[GENERAL] Permission's question

2005-03-13 Thread Ryan J. Cavicchioni
is that when creating databases, is there a way to deny everyone except for the owner? Is this something that would be done in the pg_hba.conf. Is there a way to specify permissions on an entire database? If I overlooked something in the manual, please send me the link. Thank you. - Ryan

[GENERAL] Returning records from function

2001-06-26 Thread ryan . a . roemmich
one field for a particular row. I've played with the RECORD datatype but it seems you can't return it from a function. TIA, Ryan Roemmich ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subs

RE: [GENERAL] index skipped in favor of seq scan.

2001-07-10 Thread ryan . a . roemmich
On the other end of the spectrum there are many addresses with only one entry. When I use one of these addresses in the WHERE clause it takes just as long as the address with 150k rows. If the sequential scan is better for 150k rows out of 800k rows, what about 1 out of 800k? It seems that

RE: [GENERAL] THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEEEASE

2001-07-18 Thread Ryan C. Bonham
If you already have the information on the labels, all you need is to set the font on the text box to a "Bar Code Font". If you dont have a barcode font, try "elfring soft fonts" http://64.21.138.30/. Hope that helps.. If you have any question email me directly and i wil see if i can help.

[GENERAL] Updating a view

2001-08-15 Thread Ryan C. Bonham
on the form the update fails. I tried running hte dame update from PGAdmin and it also fails with the following message. I just dont understand what i need to create i guess.. Thanks for the help.. Ryan *** * pgAdmin v7.1.0: Error - 2001-07-19 11

RE: [ODBC] Re: [GENERAL] Updating a view

2001-08-20 Thread Ryan C. Bonham
Hi, Thanks to everyone who answered my questions.. I got the problem solved. Thanks Ryan > -Original Message- > From: Fernando Schapachnik [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 15, 2001 12:28 PM > To: Ryan C. Bonham > Cc: [EMAIL PROTECTED]; [EMAIL PROTE

[GENERAL] ERROR: relation_info: Relation 41069 not found

2001-08-20 Thread Ryan C. Bonham
eSQL said: ERROR: relation_info: Relation 41069 not found Ryan ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] MS SQL 7.0 to PostgreSQL 7.1

2001-05-09 Thread Ryan C. Bonham
tool.. It successfully creates the tables, but fails to import any data, with a error stating that the relationship doesn't exist. So there goes the easy route and MS POS tool.. What's the correct way of doing this?? Thanks in advance Ryan C. Bonham ---(end of

Re: [GENERAL] could not create shared memory segment: Invalid argument

2015-07-13 Thread Ryan King - NOAA Affiliate
Apologies ahead of time for not knowing which group to send to, but I wanted to see if anyone has encountered and resolved this type of error. I'm setting up postgresql 9.2 streaming replication on RH and after copying the master data directory over to the slave, the psql service refuses start and

Re: [GENERAL] could not create shared memory segment: Invalid argument

2015-07-15 Thread Ryan King - NOAA Affiliate
I tried that too - same result. I updated another box w/ the same issue to 9.4.4, and all is well there. Thanks for your reply. On Tue, Jul 14, 2015 at 8:59 AM, Andy Colson wrote: > On 7/13/2015 7:08 PM, Ryan King - NOAA Affiliate wrote: > >> Apologies ahead of time for not knowing

[GENERAL] $libdir/mysql_fdw

2015-08-27 Thread Ryan King - NOAA Affiliate
When attempting to create the required functions and extensions for the MySQL FDW, I get the following errors: dbname=# CREATE FUNCTION mysql_fdw_handler() RETURNS fdw_handler AS '$libdir/mysql_fdw' LANGUAGE C STRICT; ERROR: could not access file "$libdir/mysql_fdw": No such file or directory d

Re: [GENERAL] [ADMIN] $libdir/mysql_fdw

2015-10-21 Thread Ryan King - NOAA Affiliate
Hi Devrim, I have already installed that: "Package mysql_fdw_94-2.0.1-1.rhel6.x86_64 already installed and latest version..." We're looking into some other options though. Thanks though. Ryan King Internet Dissemination Group, Kansas City Shared Infrastructure Services Branch N

<    1   2