[GENERAL] reusing column labels in select

Hello, Is there any way to reuse a column label in a select list like this: SELECT 1 + 1 AS a, a + 1 AS b; I vaguely remember being able to do something like this in oracle. Any ideas? Thanks! ~RvR ---(end of broadcast)--- TIP 1: subscribe and

[GENERAL] Initdb problem installing 8.1.3-1 on winXP

a directory "C:/apps/PostgreSQL8.1/data" == I have tried removing the postgres user and letting the installer create it, installing to different directories, ect without any luck. Any pointers would be appreciated. Ryan ---(end of broadcast)--

[GENERAL] Sig 11 bug

t I'd like to bring up this... I think I've found a serious bug... -ryan -- Ryan Rawson System Administrator Binary Environments Ltd. [EMAIL PROTECTED]

Re: [GENERAL] Stored procs: PL/Tcl only? Settable privs for them?

rns tuples... but I'd like to know when can a stored proc return a set not just a tuple? I'd love to have stored procs returning large record sets, or storing a huge query with multiple set differences and subselects in a sql stored proc that way the query plan can be done only once..

Re: [GENERAL] nested transactions

BA from BEA doesn't support nested transactions either... Since All the transaction stuff comes from tuxedo, tuxedo doesnt support nested transactions. It can suspend a transaction, start and commit another transaction and resume the suspended one, but that'd hardly what I'd call

Re: [GENERAL] grant permissions

dont read standards (that often ;-) Hope this helps. -ryan -- Ryan Rawson System Administrator Binary Environments Ltd. [EMAIL PROTECTED]

[GENERAL] PHP and PostgresSQL beta

I know this issue has been discussed, currently I can't find the resolution. What needs to be done to the latest php release to get it to successfully compile with the latest beta version of pgsql? Below is the error I get when compiling php - make[2]: Entering directory `/usr/local/etc/php-4.

[GENERAL] Re: Query not using index

I vacuum every half hour! Here is the output from EXPLAIN: NOTICE: QUERY PLAN: Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296) EXPLAIN Thanks! On Thu, 10 May 2001 18:19:16 + (UTC), [EMAIL PROTECTED] (Stephan Szabo) wrote: > >Have you vacuum analyzed recently and

[GENERAL] Re: Query not using index

No the query usually returns between 0 and 5 rows. Usually not zero - most often 1. -r On Thu, 10 May 2001 19:47:32 + (UTC), [EMAIL PROTECTED] ("Mitch Vincent") wrote: >Does that query really return 9420 rows ? If so, a sequential scan is >probably better/faster than an index scan.. > >-Mi

[GENERAL] Re: Query not using index

You and Stephan hit it right on the nose - our table has been maliciously propagated with thousands of faulty values - once gone index are in use and DB is SPEEDING along 8) Thanks for your help!!! -r On Thu, 10 May 2001 21:49:28 + (UTC), in comp.databases.postgresql.general you wrote: >

[GENERAL] VACUUM notices

VACUUM ANALYZE; NOTICE: RegisterSharedInvalid: SI buffer overflow NOTICE: InvalidateSharedInvalid: cache state reset VACUUM What does this mean? TIA! -Ryan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [GENERAL] Regarding "Point-in-time Recovery" feature

I have archiving enabled for PITR but it has been causing problems. So I changed the archive_command to ‘cd .’ to disable for now. However, I’m currently looking for a script/process that will rotate the logs every week or so, and also ensure archived wal files don’t pile up. I > On Feb 27, 2015

Re: [GENERAL] Copy Data between different databases

Have you considered using dblink() or foreign data wrappers to transfer the data? You can do a select from source, insert into target using one of these methods. RC > On Mar 3, 2015, at 12:09 PM, Francisco Olarte wrote: > > Hi Adrian: > > On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver

[GENERAL] postgres question: Views with duplicate field names

al reason why views can't be allowed to have duplicate columns, just like the result set above? Thanks! Ryan

Re: [GENERAL] postgres question: Views with duplicate field names

Interesting, thanks! Do you know why the first one fails instead of doing that renaming process, while your version succeeds? On Monday, September 5, 2016, Adrian Klaver wrote: > On 09/05/2016 12:55 PM, Ryan Murphy wrote: > >> Hello, I have a question about views in Postgres. &

Re: [GENERAL] postgres question: Views with duplicate field names

> You're confused about the input vs. the output. The output columns > of a view all have to have distinct names, just like you can't do > "create table foo (f1 int, f1 int)". They can be reading the same > values, though. > > regards, tom lane > Ok, that makes sense. Tha

Re: [GENERAL] postgres question: Views with duplicate field names

> You're confused about the input vs. the output. The output columns > of a view all have to have distinct names, just like you can't do > "create table foo (f1 int, f1 int)". They can be reading the same > values, though. > > regards, tom lane > Ok, that makes sense. Tha

Re: [GENERAL] postgres question: Views with duplicate field names

> Because I specifically aliased the first task reference using AS task_1. > > Ok, totally. I missed that when I first read your query, didn't read it closely enough. Thanks.

[GENERAL] Running on Docker, AWS with Data Stored on EBS

faster if the data is served from the same instance. If my application was larger, all of this would be moot because I'd run a dedicated PostgreSQL instance or just use RDS... but it isn't so I'd rather save money :) Thanks in advance for your help, Ryan

Re: [GENERAL] Running on Docker, AWS with Data Stored on EBS

With Appreciation, Ryan From: David G. Johnston Sent: Tuesday, November 8, 2016 3:19:02 PM To: Ryan Mahoney Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Running on Docker, AWS with Data Stored on EBS On Tue, Nov 8, 2016 at 12:48 PM, Ryan Ma

[GENERAL] Cannot start Postgres : invalid data in PID file

Problem: Cannot start Postgres Platform: Postgres 8.3, Windows Vista Home Error Message: pg_ctl: invalid data in PID file "C:/Program Files/PostgreSQL/8.3/data/postmaster.pid" I run postgres on Windows Vista Home Edition. It normally runs as a service but is not starting. I created a command

[GENERAL] Function Syntax Help

I having trouble with correct syntax to get this trigger function to compile. I have tried every combination of removing the ‘;’ characters but the function will not compile. Can someone tell me what I am doing wrong, I am stumped. I will be adding addition when clauses the case statement once

[GENERAL] SELECT, GROUP BY, and aggregates

om GROUP BY, it throws another exception. If I put something there that doesn't belong, I get a different exception. So it already knows how to do this! :P -- Regards, Ryan Delaney ryan.dela...@gmail.com https://github.com/rpdelaney GPG ID: 4096R/311C 10F2 26E0 14E3 8BA4 3B06

Re: [GENERAL] Importing 120 csv files bulk multiple

You can use \i /path/to/file.txt -Ryan On Tue, Feb 02/12/13, 2013 at 03:14:03PM +, Andrew Taylor wrote: > Hi, > > As per title I need to import a load of csv files. So I wrote a bash script > to generate the statements I needed (attached). However, this is failing on > my ubu

Re: [GENERAL] Rewritten rows on unchanged values

really seeing a new row. > I'm having trouble understanding why it is necessary to generate a new tuple even when nothing has changed. It seems that the OP understands that MVCC is at work, but is questioning why this exact behavior occurs. I too have the same question. Perhap

Re: [GENERAL] PostgreSQL EXCLUDE USING error: Data type integer has no default operator class

. > > I've spent quite a bit of time searching for hints on figuring out how to > make this work, or figuring out why it won't work. I've also been trying to > understand CREATE OPERATOR and CREATE OPERATOR CLASS, but those are over my > head for now. Could anyone point

Re: [GENERAL] pulling year out of a timestamp

stamp > where timestamp has the format: "2009-01-01 00:00:00" > > I've tried > > date_trunc('year', table2.timestamp) = table1.year You want date_part, not date_trunc. -Ryan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] run COPY as user other than postgres

COPY > TO. Here is a simple example where the location > '/some/path/to/file/file.csv' is owned by another user and it would be > very spiffy if I could run the COPY TO as that user. Any ideas? > You should use \copy if you're using psql. That will run on the clien

Re: [GENERAL] problem with lost connection while running long PL/R query

iller has killed your backend. Please see the documentation here: http://www.postgresql.org/docs/9.2/interactive/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT -Ryan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] greatest cannot be used as sfunc for CREATE AGGREGATE

quot;greatest", STYPE = TEXT); ERROR: function greatest(text, text) does not exist Which I would assume is because greatest is variadic and not simply a function of two arguments. I'm sure I'm just being dense and missing something obvious here... -Ryan P. Kelly -- Sent via

[GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

g. it can would with LIKE as well as =. But is there any way to do: select * from post where any(tags) LIKE 'music%'; ?? This doesn't work because ANY is only allowed on the right. Thanks! Ryan

Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

> > I'm not sure why we've never got round to providing such a thing > in core ... probably lack of consensus on what to name the reverse > operator. You'd need to support regex cases as well, so there's > more than one operator name to come up with. > Interesting! It seems like one "simple" poss

Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

> I'm pretty sure it doesn't work syntactically. Don't recall the details offhand. Ok, thanks!

Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?

Thanks, I saw that page earlier; what I'm looking for is kind of the opposite - instead of comparing a single value to see if it matches any of a list of patterns, I'm trying to take a list of values and see if any of them match a given pattern. Best, Ryan On Tue, Sep 5, 2017 at 8:01 A

[GENERAL] String Encoding Conversion Problem

is may actually be more of a .NET string conversion issue, but I wanted to check and make sure there's not some obvious database angle we're missing. Does anyone have any experience with or insight into these sorts of string compatibility issues? Thanks! Ryan Ryan Wells Applicatio

[GENERAL] Query with varchar not using functional index

is the exact same setup works as expected on our 7.4.7 database server (the problem server is 7.4.19). Has something changed that would cause this behavior since 7.4.7? Also, why is PostgreSQL requiring an explicit cast to 'text'? I thought varchar and text were functionally identical data types. Thank you so much for your help. PostgreSQL is a phenomenal product. Ryan VanMiddlesworth

Re: [GENERAL] psql client memory usage

row-mode.html I do not expect psql will be adjusted to utilize the new API: http://www.postgresql.org/message-id/caeykp92z2w3vbs4uxwpwub7k4hgw-vepw_wnsui9r5t+cgp...@mail.gmail.com -Ryan Kelly -- 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] psql swallowed my "BEGIN;" on reset... user beware?

have this same problem. I also agree with the proposed solution. The current code seems to have the connection reset logic down inside the result processing routines. It looks like it would be relatively straightforward to add two calls to ConnectionUp in ProcessResult and ProcessResult to res

Re: [GENERAL] psql swallowed my "BEGIN;" on reset... user beware?

it; > > WARNING: there is no transaction in progress > > COMMIT > > > > This seems like a pretty serious issue. My opinion is that psql should > refuse to execute further commands on a line of input if any of them fails > due to a terminated connection. Err, meant Sen

Re: [GENERAL] any psql \copy tricks for default-value columns without source data?

t works most of the time. If you have any issues or feature requests feel free to open an issue on github. -Ryan Kelly On Tue, May 6, 2014 at 4:22 PM, David G Johnston wrote: > So, I am trying to import a file into a table and want to assign a sequence > value to each record as it is import

[GENERAL] Duplicated Fields

I am designing a database that will include at lot of duplicated data. Does Postgres perform many optimisations to eliminate duplications of fields or should I create additional tables to reference myself? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] Inserting / Selecting / Getting the Index.

I have a table with just 2 columns, 1 for a character array and one an integer index. I need to process a string such as to find out the index for it in the table if it is already there or insert it and then find out it's index which is auto generated otherwise. Is there a way to do this in a

[GENERAL] Search for lists

Hello, I need to search a table to find sets of rows that have a column matching itself for the whole set and another column matching row for row with a list I am going to supply. The result I should receive should be value of the column that matches itself. For example given the following

Re: [GENERAL] Search for lists

are those with a count equal to the number of entries in the original IN condition. Basically count how many of values each distinct key in column 1 matches and keep those keys where the count and the number of values match. David J. On Jun 18, 2011, at 17:51, Daron Ryan wrote: Hello, I

[GENERAL] Select from Java Strings

I have strings from java and need to check which ones are not present in the db. Can I use a select statement to do this by making it search my strings as though they are a table?

Re: [GENERAL] Select from Java Strings

On 4/07/2011 1:45 AM, David Johnston wrote: On Jul 3, 2011, at 11:13, Daron Ryan <daron.r...@gmail.com> wrote: I have strings from java and need to check which ones are not present in the db. Can

[GENERAL] Problem creating GIN index on multiple weighted columns

select setweight(to_tsvector('english', name), 'A') || setweight(to_tsvector('english', description), 'B') from profile_profile; I would prefer not to store the precomputed tsvector in a separate column if I can avoid it, although I'll do that if I can'

[GENERAL] Switching from OSX to Linux, multi-line queries in \copy don't work anymore

) 4.5.2, 64-bit -Ryan Kelly -- 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] Switching from OSX to Linux, multi-line queries in \copy don't work anymore

On Fri, Jul 27, 2012 at 09:49:06PM +0800, Craig Ringer wrote: > On 07/27/2012 09:28 PM, Ryan Kelly wrote: > >I recently switched from OSX to Linux and \copy in psql no longer > >accepts multi-line queries. For instance: > > > >\copy ( > >

Re: [GENERAL] Switching from OSX to Linux, multi-line queries in \copy don't work anymore

On Fri, Jul 27, 2012 at 02:06:01PM +, Mark Morgan Lloyd wrote: > Craig Ringer wrote: > >On 07/27/2012 09:28 PM, Ryan Kelly wrote: > >>I recently switched from OSX to Linux and \copy in psql no longer > >>accepts multi-line queries. For instance: >

Re: [GENERAL] array_length of an empty array

th the standard: > 1) An specifies a collection whose cardinality > is zero. -Ryan Kelly -- 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] psql & unix env variables

om<http://www.orbitz.com/> | > ebookers.com<http://www.ebookers.com/> | > hotelclub.com<http://www.hotelclub.com/> | > cheaptickets.com<http://www.cheaptickets.com/> | > ratestogo.com<http://www.ratestogo.com/> | > asiahotels.com<http://www.asiaho

Re: [GENERAL] Official C++ API for postgresql?

On Mon, Sep 17, 2012 at 10:58:30PM +0400, niXman wrote: > Hello, > > Tell me please, whether there is an official C++ API for postgresql? http://pqxx.org/development/libpqxx/ > > Thanks, > > -- > Regards, > niXman -Ryan Kelly -- Sent via pgsql-general

Re: [GENERAL] log_destination = csvlog

espace character) from SQL statements? Or there > is an "regexp" I can use for this purpose? CSV parsers should handle this correctly. What tools are you trying to use? > > Thanks, > > Edson > -Ryan Kelly -- 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] Official C++ API for postgresql?

On Mon, Sep 17, 2012 at 11:52:13PM +0400, niXman wrote: > 2012/9/17 Ryan Kelly: > > > http://pqxx.org/development/libpqxx/ > > Last question... > According to the link provided by you, it is said that libpqxx comes > with postgres. But in the archive with postgre

Re: [GENERAL] RFE: Column aliases in WHERE clauses

proper mailing list for such feature requests? I think this is explicitly disallowed by the spec. And by Tom: http://archives.postgresql.org/pgsql-general/2002-11/msg01411.php > > Thanks in advance, > Daniel Serodio > -Ryan Kelly -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] Question about permissions on database.

. You can alternatively make the user a super user: ALTER ROLE your_user WITH SUPERUSER; But this is an even worse idea. If one role owns all the tables in that database, you can make your role a member of that role: GRANT owner_role TO your_role; But are you really sure that your user needs permi

[GENERAL] PostgreSQL, OLAP, and Large Clusters

fort, of course), but given my experiences with Postgres and the support provided by the community that is second to none, I'd very much like to stay with PostgreSQL. Thoughts? -Ryan Kelly -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

Re: [GENERAL] PostgreSQL, OLAP, and Large Clusters

On Thu, Sep 27, 2012 at 08:51:31AM +1000, Ondrej Ivanič wrote: > Hi, > > On 26 September 2012 21:50, Ryan Kelly wrote: > > The size of our database is growing rather rapidly. We're concerned > > about how well Postgres will scale for OLAP-style queries over terabytes &g

Re: [GENERAL] PostgreSQL, OLAP, and Large Clusters

On Thu, Sep 27, 2012 at 08:58:05AM +1200, Gavin Flower wrote: > On 26/09/12 23:50, Ryan Kelly wrote: > >Hi: > > > >The size of our database is growing rather rapidly. We're concerned > >about how well Postgres will scale for OLAP-style queries over terabytes >

Re: [GENERAL] PostgreSQL, OLAP, and Large Clusters

d-hoc and probably can't be solved with a materialized approach. > > Thanks, > > Stephen Thanks, -Ryan Kelly signature.asc Description: Digital signature

Re: [GENERAL] PostgreSQL, OLAP, and Large Clusters

On Wed, Sep 26, 2012 at 03:18:16PM -0600, Scott Marlowe wrote: > On Wed, Sep 26, 2012 at 5:50 AM, Ryan Kelly wrote: > > Hi: > > > > The size of our database is growing rather rapidly. We're concerned > > about how well Postgres will scale for OLAP-style qu

Re: [GENERAL] Strategies/Best Practises Handling Large Tables

sharing on the pros and cons of the above, or > if there are any other strategies that I could put in place. > > Thanking you in advance. -Ryan Kelly -- 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] Strategies/Best Practises Handling Large Tables

That link will be helpful in understanding how partitioning could benefit you. -Ryan Kelly -- 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] How to verify pg_dump files

to check whether the output file > > is "valid" in the sense that it is complete and syntactically correct? > > Reload it and test your application against it? > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie > > Would that entail over-writing good data with possibly bad data? Ryan

[GENERAL] Set returning functions in the SELECT list

nt/static/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET but it doesn't seem to be explicitly mentioned there. And yes, I understand doing this is deprecated and my results would probably be better achieved with LATERAL when 9.3 comes out. -Ryan Kelly -- Sent via pgsql-general mailing

Re: [GENERAL] Using a GIN index on an integer array to model sets of tags

iltered by a certain set of tags. The original design used one-to-many to store the association between items and tags. When it was replaced with an approach using arrays with gin indexes, the speed up for finding large numbers of items was 20x, and finding smaller subsets was 60x. This was about 18

Re: [GENERAL] output inserted

INSERT INTO a_001 > OUTPUT INSERTED.* INTO a_002 --mssql > SELECT 'text for insertion'; > > SELECT vl FROM a_002; WITH data AS ( INSERT INTO a_001 SELECT 'text for insertion' RETURNING * ) INSERT INTO a_002 SELECT * FROM data; This is one possible soluti

Re: [GENERAL] When does CLUSTER occur?

the "ALTER TABLE gen1011 CLUSTER ON > xgen1011_si_sn" actually clusters the table at that point or if it just tells > it to use that index for clustering? If the latter I assume I need to add a > "CLUSTER gen1011 ON xgen1011_si_sn" line at the end along with an ANALY

[GENERAL] Large temporary file generated during query

lso, I suppose this data on-disk can be kept in memory instead by increasing work_mem to a suitable value? Thanks, -Ryan Kelly -- 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] Large temporary file generated during query

On Fri, Dec 12/07/12, 2012 at 05:33:45PM -0800, Jeff Janes wrote: > On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly wrote: > > I have a very large query that also touches quite a bit of data. It > > generates a large temporary file (actually, several, because the total > > size

[GENERAL] Creating a comprehensive search that queries multiple tables

word 'dog', I would like to be able to find all items which were either made in 'Dog River', made by 'Dog the Bounty Hunter', have the name 'dog collar', or have a note attached to them stating that they were 'used to tame wild dogs'. I would also like to know which field the text was matched in. The data associated with the item doesn't change very often, so I was thinking of creating a tsvector column in the items table which holds all the text associated with each item, for the purpose of searching. I am not sure how I would be able to figure out which field was matched using this approach, however. Does anyone have any thoughts or ideas on this issue? Any pokes in the right direction would be much appreciated. Thanks, Ryan Wallace

[GENERAL] How to list installed pl languages

Is there a way to list the installed pl languages for a database and/or server cluster? thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Returning XML with SELECT statements? IS THIS POSSIBLE?

you for information on this issue!   Ryan Griggs [EMAIL PROTECTED]  

[GENERAL]

unsubscribe [EMAIL PROTECTED] unsubscribe ryan richards ___ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com ---(end of broadcast)--- TIP 4: Don't

[GENERAL] Exporting postgres query to CSV

Greetings, I am running postgres 7.4.7 on debian sarge. I need to run an SQL query and store the results in a file. The format needs to be comma separated values (CSV), so I can import this later in Excel. Any ideas on how to accomplish this? much appreciated, Ryan

[GENERAL] PANIC: XX000: right sibling is not next child in "pg_depend_reference_index"

DEBUG: 0: StartTransactionCommand LOCATION: start_xact_command, postgres.c:1981 DEBUG: 0: ProcessQuery LOCATION: ProcessQuery, pquery.c:128 STATEMENT: INSERT INTO links VALUES ($1, $2, $3) PANIC: XX000: right sibling is not next child in "pg_depend_reference_index" LOCATION: _bt_p

[GENERAL] Large DB

Hello, I have a single table that just went over 234GB in size with about 290M+ rows. I think that I'm starting to approach some limits since things have gotten quite a bit slower over the last couple days. The table is really simple and I'm mostly doing simple data mining queries like the quer

[GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

Hi All! Trying to upgrade to Apache 2.0.49 and getting compile errors related to mod_auth_pgsql, any clue?: make[1]: Entering directory `/usr/src/httpd-2.0.49' /usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread -I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -DAP_HAVE

[GENERAL]

Trying to upgrade to Apache 2.0.49 and getting compile errors related to mod_auth_pgsql: make[1]: Entering directory `/usr/src/httpd-2.0.49' /usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread -I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -DAP_HAVE_DESIGNATED_INITIALI

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

I'm using mod_auth_pgsq, version 2.0.1... it's for use with apache 2.0.x got it from their site: http://www.giuseppetanzilli.it/mod%5Fauth%5Fpgsql2/ -Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joseph speigle Sent: Thursday, April 0

Re: [GENERAL] 1 foreign key to 2 different tables?

| Flag|| | +--++-++--+ Kind Regards, -Ryan Riehle http://www.buildways.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Saturday, May 01, 2004 4:18 PM To: Ryan Riehle Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] 1 foreign ke

Re: [GENERAL] 1 foreign key to 2 different tables?

since I have not created a check onstraint that is above common complexity and and have never tried a trigger. Kind Regards, -Ryan Riehle http://www.buildways.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Riehle Sent: Saturday, May 01

Re: [GENERAL] 1 foreign key to 2 different tables?

with a trigger or another method - if there is a better way. -Ryan Riehle http://www.buildways.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Saturday, May 01, 2004 9:40 PM To: Ryan Riehle Cc: [EMAIL PROTECTED] Subject

[GENERAL] Syntax error at or near "$1"

r the error below: ERROR: syntax error at or near "$1" at character 30 CONTEXT: PL/pgSQL function "list_devices" line 6 at for over select rows Any help would be greatly appreciated! Thanks, Ryan CREATE FUNCTION list_devices(macaddr) RETURNS text AS ' DECLARE macAddress

Re: [GENERAL] max_expr_depth

I don't know the cause, but if you only have to run this procedure once in a while, you could select all the records that need to be updated, and use a text editor to build a few thousand single update statement, then save this file and echo it to the postgres backend through psql. Good Luck!

Re: [GENERAL] RedHat Open Database?

Read the message archives ;) -r At 06:30 PM 7/7/01 +, Dr. Evil wrote: >I saw an announcement somewhere that RedHat is working on its own Open >Database, based on PG. What do people think about this? > >---(end of broadcast)--- >TIP 2: you c

Re: [GENERAL] Bad news for Open Source databases, acording to survey

e the market to ensure it's place in the industry today and in the future. -Ryan Mahoney CTO Payment Alliance, Inc. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Dat

[GENERAL] interpretting pgsql log messages

In my logs, I find a lot of these: NOTICE: current transaction is aborted, queries ignored until end of transaction block should I be concerned? Is there a place where I can read about the difference messages that may appear in the log file? Thanks! - Ryan Mahoney --- Outgoing

Re: [GENERAL] vacuum and 24/7 uptime

Hi Mark, This is being worked on now. I believe the 7.2 release will have enable you to run a vacuum with no downtime. -r At 03:39 PM 7/11/01 -0600, Mark wrote: >Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb >requires downtime, and if one does this nightly as sugge

Re: [GENERAL] Postmaster

your postgresql.conf file (usually located in /usr/local/pgsql/data/postgresql.conf). Your Connection Parameters section should read like this: # # Connection Parameters # tcpip_socket = true #ssl = false Good Luck! -Ryan Mahoney --- Outgoing mail is certified Virus Free. Check

Re: [GENERAL] Intermittent Startup Failures

There may be some errors in the script that's loads postgres at startup. Look in the "/etc/rc.d/init/" directory and see if there is an executable named postgres or something similar. If so, post the source of this file to the group so we can take a look. Good Luck! -Ryan Ma

Re: [GENERAL] replication?

http://www.greatbridge.org/genpage?replication_top All you could ever want to know about pgsql replication. God Luck! -r At 04:31 PM 7/18/01 -0400, Fran Fabrizio wrote: >Does postgres support replication? I think this is the feature I need. >I have a table in one db that I need to use from

Re: [GENERAL] dual processors

If you are running on a dedicated postgres machine, run the command "top" from the command line. The third and fourth line should read like: CPU0 states: 0.0% user, 5.0% system, 0.0% nice, 94.0% idle CPU1 states: 0.1% user, 0.0% system, 0.0% nice, 99.0% idle (my system is idle now, but

RE: [GENERAL] dual processors

Possibly. If your OS does not support or is not currently configured for dual processor utilization, then your machine will not use the other CPU. What OS/Version are you running? -r At 04:31 PM 7/23/01 -0500, Jack Long wrote: >uh-oh, top looks like this for me: > > 3:35pm up 43 min, 3

Re: [GENERAL] php error

Call phpinfo() and see if you have postgres support compiled into php.  This would cause your error. Good Luck! -r At 04:13 PM 7/26/01 +1200, Mike C wrote: Hello, Err message within a browser(http://its-macman.otago.ac.nz/~mike/index.php) = Fatal error: Call to undefined function: pg_connec

Re: [GENERAL] "Oracle's ROWNUM"

manipulate and display returned values. Hope this answers your question! -Ryan At 11:03 PM 7/28/01 +0200, Svenne Krap wrote: >Hi, > >is there any way to get the number of the tuple in the result set... > >in Oracle you can write > >select rownum, * from mytable; > >and

Re: [GENERAL] database information

SELECT datname FROM pg_database WHERE datname NOT LIKE 'template_'; -r At 04:22 PM 7/30/01 -0400, Peter Choe wrote: >how do i get the names of the databases that are created in postgres? > >is there a select statement similar to oracle? > >peter choe > >---(end of broad

Re: [GENERAL] Index usage question

What does your data look like? If you have a lot of duplicate id's, a sequential scan may be better than an index scan. If you are not sure if this is the case, try: SELECT id, count(*) AS count FROM test GROUP BY id ORDER BY count DESC LIMIT 50; This should show you the top 50 most duplicate

[GENERAL] business perspective

this direction as well as who else may be interested in this project. Although I only occasionally chime in, I read the general and hackers lists daily (er, hourly ;) ) and have a deep respect for the individuals who participate on these lists. Looking forward to your feedback, Ryan Mahoney BTW, I

  1   2   >