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

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 '%'?

> > 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

[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] 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] 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] 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.

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

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. &

[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] [ADMIN] $libdir/mysql_fdw

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

[GENERAL] $libdir/mysql_fdw

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] could not create shared memory segment: Invalid argument

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

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

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] 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

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

[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

[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

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

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] 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 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

[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

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

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] 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] 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] 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] 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] 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] 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] 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

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] 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

[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] 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

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] 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] 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] 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 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

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

[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] 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

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] 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] 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 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] 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] 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] 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] 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 ( > >

[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

[GENERAL] Postgres Installation Password

password. Ryan Magruder

[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] 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'

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] 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] 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] 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

[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] 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] 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] 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] 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

[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] 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] 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] 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] Returning XML with SELECT statements? IS THIS POSSIBLE?

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

[GENERAL] Permission's question

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]

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] 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

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

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?

| 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

[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] 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

[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

[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] 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] PostgreSQL License Question

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

Re: [GENERAL] Porting Code to Postgresql

'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] Recreating unique index for primary key

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] business perspective

>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] postgresql.com

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 -

[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

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] ERROR: relation_info: Relation 41069 not found

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

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

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] Updating a view

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: [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] "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] 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] 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] 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] 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] 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] THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEEEASE

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.

  1   2   >