On Mon, 1 Mar 2004, Ron St-Pierre wrote:
> You're right I am getting the same results. I created the same table with:
>create table category (
> category_id serial not null primary key,
> category_name character varying(100) not null
>);
>
> alter table category alter column
On Mon, 1 Mar 2004, Alexander Cohen wrote:
> What sql query can i use to get all relative data to the types of
> fields that a table contains?
select column_name,data_type from information_schema.columns where
table_name='test';
works in 7.4
---(end of broadcast)-
On Sat, 21 Feb 2004, Simon Windsor wrote:
> Hi
>
>
>
> I am using the standard debian testing release of postgres(7.3.4) and was
> wondering how to produce and md5 string.
>
>
>
> I had thought
>
>
>
> Select md5('joe');
>
>
>
> Would be sufficient?
Doesn't that work? It works f
Have you tested it with regular pg_connects instead of pg_pconnect? while
many people expect pconnects to be faster, often, when they result in the
database having lots of open idle connections, they actually make the
system slower than just using plain connects.
You might want to look into s
On Fri, 20 Feb 2004, Tibor wrote:
> I am using PostgreSQL 7.4.1 (only through psql)
> I know, that the command
>
> ALTER TABLE OFFICES
> DROP PRIMARY KEY (CITY);
>
> and its foreign key equivalent:
>
> ALTER TABLE SALESREPS
> DROP CONSTRAINT
> FOREIGN KEY (REP_OFFICE)
> REFER
On 12 Feb 2004, Greg Stark wrote:
>
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > Now, if you don't mind using the ODBC connector, you're scott free. but
> > you WILL be bound by the GPL, and the GPL (not MySQL's interpretation,
&
On Wed, 12 May 2004, Peter Eisentraut wrote:
> Am Montag, 9. Februar 2004 06:06 schrieb David Garamond:
> > SQL Server only allow one NULL in a unique constraint column (it's the
> > unique index that does that, so the unique constraint behaves like that
> > too). The question is, what is the best
On Wed, 12 May 2004, Dirk Försterling wrote:
> Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes:
> >
> >>Do people think linux 2.6.5 is stable enough yet for a production
> >>PostgreSQL server?
> >
> > i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux
> > versi
On Tue, 11 May 2004, [EMAIL PROTECTED] wrote:
> hello,
>
> i'm very new to postgres and have a fundamental question.
> how do i make a pg-db most secure?
> i feel, that pg_user e.g. ist something very dangerous - isn't it? if
> someone hacks into a db, then he has lots of information at his/her
On Tue, 11 May 2004, Thomas LeBlanc wrote:
> I have 2 databases. I want to move data from table table1 in database db1 to
> table2 in db2.
>
> When I query 1 table from another database, I get a cross-database
> references are not implemented.
>
> server1% psql db1
> emdata=# select * from db2
; INSERT INTO db1.public.tables SELECT * FROM db2.public.table1
>
> Thanks,
> Thomas
>
>
> >From: "scott.marlowe" <[EMAIL PROTECTED]>
> >To: Thomas LeBlanc <[EMAIL PROTECTED]>
> >CC: <[EMAIL PROTECTED]>
> >Subject: Re: [GENERAL] H
t; for postgresql 7.3 ? without upgrading to 7.4
>
> Thanks for any input.
>
> Dias
>
> scott.marlowe wrote:
> > On Sun, 11 Apr 2004, Jerry McBride wrote:
> >
> >
> >>T. Relyea wrote:
> >>
> >>
> >>>Mike Cox wrote:
> >&g
On Mon, 10 May 2004, Jack Orenstein wrote:
> scott.marlowe wrote:
> >
> > shared_buffers is the amount of space postgresql can use as temp memory
> > space to put together result sets. It is not intended as a cache, and
> > once the last backend holding open a b
On Fri, 30 Apr 2004, CS Wagner wrote:
> I assume this issue has been solved repeatedly, but I cannot find any
> information on it...
>
> I have a website that runs reports on data from a postgres database. An
> average report takes about 10 minutes. I'd like to load balance it so I
> can hav
On Fri, 23 Apr 2004, Jerry Robertson wrote:
> We have been running Postgre for over a year and are very pleased with its ease of
> use and performance.
>
> We have encountered one problem that has been minor until today and that is:
>
> Occasionally a row in a table get populated with #Deleted
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
> On Tue, Apr 20, 2004 at 14:36:57 +0100,
> csysi <[EMAIL PROTECTED]> wrote:
> > Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
> > the databases are incompatible.
> >
> > Can i convert the databases ?
>
> You need to do a
On Mon, 19 Apr 2004, Gregory S. Williamson wrote:
> FWIW, this site gives:
> 404 - File Not Found
>
> "These aren't the droids files you're looking for."
>
> Sorry, but that file could not be found. And believe you me, we looked! We checked
> all the likely directories, then all the unlik
I'm not sure why you're doing it the exact way you are, but you basically
just call the same commands within a pg_query as you would on the psql
command line to make it work:
begin
declare mycurs cursor as select * from table
fetch 10
rollback / commit
---(end of bro
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
> > I always ran one of the 2 scripts (can't remember which one) and after that
> > started checking the dump file, because there were things that didn't get
> > changed correctly[1].
> >
> > [1]: I always remember the first conversion I did.
Maybe natural join is what you want?
On Wed, 14 Apr 2004, Dennis Gearon wrote:
> I will have a table with, among other things, two time columns.
> As per my last post, I will be using a variable time for the day-to-day
> boundary, versus the traditional 12pm.
> What I want to be able to do upon
On Mon, 12 Apr 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > On Fri, 9 Apr 2004, Christopher Browne wrote:
> >> See the "pgcrypto" contrib module in the source tree.
> >>
> >> It is not typically compi
On Tue, 6 Apr 2004, Bernhard Ankenbrand wrote:
> Hi,
>
> we have a table width about 60.000.000 entrys and about 4GB storage size.
> When creating an index on this table the whole linux box freezes and the
> reiser-fs file system is corrupted on not recoverable.
>
> Does anybody have experience
On Mon, 5 Apr 2004, C G wrote:
> Dear All,
>
> What's the best way to store jpgs in postgresql to use in a web page?
>
> I tried to use large objects, but how would you extract them from a table to
> be viewed in a web-page without having to write them to a scratch file
> somewhere first?
The
On Wed, 31 Mar 2004, Tom Lane wrote:
> "John Liu" <[EMAIL PROTECTED]> writes:
> > The original simple SQL -
> > select distinct atcode from TMP order by torder;
>
> This is not "simple", it is "broken SQL with an undefined result".
>
> If DISTINCT merges multiple rows with the same atcode, how a
On Mon, 29 Mar 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > And while we're at it, maybe we should have a setting somewhere should
> > someone execute the famous "update pg_shadow set usesuper = false" that
> > som
On 25 Mar 2004, Roger Dahl wrote:
> To find out which boxes contain a specific item, I would write a query
> like this:
>
> select b.name,
> from boxes b
> inner join item_box_maps m on m.box_id = b.id
> inner join items i on m.id = m.item_id
> where i.name = 'hammer';
Is this the actual query?
On Fri, 26 Mar 2004, Guy Rouillier wrote:
> (Resurrecting a subject I found searching the archives...)
>
> Newbie. We're investigating replacing our Oracle databases with
> PostgreSQL. Our largest database is currently 25 GB and growing. It
> contains time sequenced data. Under Oracle, we use
On Fri, 19 Mar 2004, Robert11 wrote:
> Hello:
>
> Am about to sign up for an on-line database course (introductory)
>
> Apparently, one must have on their PC for the course either
>
> Access
> postgre
> mysql
>
> Am really new at this.
> Access is a problem, as the package costs is $200.00 Wo
On Mon, 22 Mar 2004, marian wrote:
> When I do this,
> INSERT INTO orgdata ( name, fax, contact, email, phone, address,
> preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]',
> '987654321', 'wally way', 'f' )
>
> I get
> ERROR: query rewritten 100 times, may contain cycles
On Tue, 23 Mar 2004, Tom Lane wrote:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Was this true for some previous version? I could have swore I read somewhere
> > that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean
> > everything up (aside from anything locked in transac
On Wed, 17 Mar 2004, Robin 'Sparky' Kopetzky wrote:
> Good Morning!!
>
> I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL
> and converting them to Postgres. Question is this: The datetime format used
> in the script is 'MMDDHHMMSS' as a text string. Do I have to
On Tue, 16 Mar 2004, Tom Lane wrote:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > I've read threads like this before and because I've never lost data on
> > servers with IDE drives after doing some basic torture tests
> > (e.g. pulling the plug in the middle of an update et al), I don't
> >
On Wed, 10 Mar 2004, Christopher Petrilli wrote:
> On Mar 10, 2004, at 3:14 PM, Steve Wolfe wrote:
>
> >Before I shell out the $15k on the 4-way Opteron, I'm going to spend
> > some long, hard time looking for ways to make the system more
> > efficient.
> > However, after all that's already
On Tue, 9 Mar 2004, Sally Sally wrote:
> I wanted to do some quick load testing on a postgres database. Does anyone
> have any tips on how to go about doing this?
> Thanks much.
If you just wanna beat the database a bit to test for reliability etc,
look at contrib/pgbench in the distro.
If you
Have you run this update query again and again with vacuuming?
http://www.postgresql.org/docs/7.4/static/maintenance.html#ROUTINE-VACUUMING
If so, you might have millions and millions of dead tuples taking up
space and slowing things down. If you're running 7.4, install the
autovacuum daemon
On Wed, 3 Mar 2004, satish satish wrote:
> Hi,
>
> I am trying to do some reliability tests on postgre SQL. I have
> use-case where the power can go off abruptly. I initiated 10,000 insert
> operations and pulled out the cable in the middle. I had auto-commit
> option turned on. I observed 2
On Tue, 2 Mar 2004, Ara Anjargolian wrote:
> I've been searching the list archives and the web for a while about which
> locale is best used with PostgreSQL and I did not find a satisfactory answer
> so I
> thought I would ask the list.
>
> Right now my locale is en_US, but with this you can not
On 3 Mar 2004, Eric wrote:
> Hello.
>
> After I have performed several queries by an external program on the
> database, an error message appeared:
> "hard limit on result handles reached is not a valid query result"
>
> May I know how to solve the problem?
Sounds like an application issue, not
On Wed, 3 Mar 2004, Gunjeet Singh wrote:
>
> Hi,
>
> I could only find support for defining functions in pl/pgsql.
> With a function I can have only one return value. What if I need
> to have multiple OUT parameters (i.e multiple return values) ?
> Is there any support for something that is simi
On Wed, 3 Mar 2004, Bricklen wrote:
> Hi all,
>
> I've scoured the net for a simple way to set AUTOCOMMIT off in psql, for
> the duration of a session (not simply a transaction). The only real
> reference that I can find says that "\set autocommit off" will do what I
> want. It doesn't though.
On Mon, 8 Mar 2004, javier garcia - CEBAS wrote:
> Hi;
> Is it possible to directly create postgres tables with a timestamp column
> with some specific interval and within a specific range.
> For example every 5 minutes and between the beginning of 1999 and the end of
> 2003?
>
> I just need th
On Fri, 5 Mar 2004 [EMAIL PROTECTED] wrote:
>
> Hey all,
>
> I'm using PostgreSQL 7.3.4.
>
> I have a query that isn't using a particular index, and I'm wondering why.
>
> The query is:
> select i.ItemID, d.Extension from ITEM i, SHARING s, DOCUMENT d where
> i.ItemID = d.ItemID AND s.ItemID =
On Thu, 4 Mar 2004, phil campaigne wrote:
> Hello,
> when I login to linux and check the env's I see:
> PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin
> LD_LIBRARY_PATH=/usr/lo
On Wed, 3 Mar 2004, [UTF-8] Paulovič Michal wrote:
> Yes I know,
>
> But how you do this at PgSQL
OK, I just read the response where someone showed me how to make such a
table in mysql. What an odd, and non-intuitive behaviour that is.
Anyway, first off, upgrade your version of postgresql
On Wed, 3 Mar 2004, [iso-8859-15] Hervé Piedvache wrote:
> Hi,
>
> I have may be a stupid question, but I'm a little surprised with some explains
> I have, using date fields ...
>
> I would like to understand exactly when index are used ...
> I'm using PostgresQL 7.4.1
>
> I have a table with
On Mon, 1 Mar 2004, Phil Campaigne wrote:
> Hello,
> I originally installed postgresql as root user and now I am setting up a
> development environment with cvs and a java ide and tomcat. I have
> everything with the exception of postgresql integreted using a non-root
> user.
> THe process I am
On Sat, 28 Feb 2004, Rajat Katyal wrote:
> Hi:
>
> Whenever i try to insert the data, size of which is greater than that of column
> datatype size, I got the exception value too long for.
>
> However this was not in postgresql7.2.
>
> Can anyone please tell me, is there any way so that i
On Fri, 27 Feb 2004, Shane Wegner wrote:
> On Fri, Feb 27, 2004 at 06:00:36PM -0500, Sean Shanny wrote:
> > Shane,
> >
> > Can you give an example of a query that has gotten slower due to the
> > increasing size of the urls table with an explain analyze?
>
> The database is a simple traffic mon
On Fri, 27 Feb 2004, Bill Moran wrote:
> Hey all.
>
> I've hit an SQL problem that I'm a bit mystified by. I have two different
> questions regarding this problem: why? and how do I work around it?
>
> The following query:
>
> SELECTGCP.id,
> GCP.Name
> FROMGov_Capital_
On Tue, 17 Feb 2004, Linh Luong wrote:
> Hi All,
>
> 1. I have been reading and the max size of a tuple is 8K.
> I have also read that I can it to a larger size in some config file. Where is
> this file? is it called pg_config.h and is the variable called BLKSZ??
You'd have to set the way bac
On Tue, 17 Feb 2004, Chris Browne wrote:
> [EMAIL PROTECTED] (Jan Wieck) writes:
> >>> P.S. For example MySQL Databse have the commercial license for that.
> >
> > P.P.S. BSE is Bovine Spongiform Encephalopathy, also known as Mad Cow
> > Disease. Even if MySQL has a few features that might be desc
On Fri, 20 Feb 2004, Sally Sally wrote:
> Thank you all for replying. I appreciate the tips. Apologies to those who
> were offended by the html formating.
> Scott, quick question. The reason I assumed insert would be "safer" than
> copy is because the docs say that in the case of copy it fails o
On Fri, 20 Feb 2004, twosk wrote:
> Hi,
>
> I have a question, because i cannot find any information in online docs
> (maybe i'm just blind :P).
> I'm want to build application with embedded database, but i also need a
> possibility to have one global database, which can be accessed from internet
On Thu, 19 Feb 2004, Sally Sally wrote:
> I had a few questions concerning the backup/restore process for pg.
>
> 1) Is it possible to dump data onto an existing database that contains data
> (assumning the schema of
> both are the same). Has anyone done this? I am thinking of this in order to
On Thu, 19 Feb 2004, Ed L. wrote:
> On Thursday February 19 2004 9:13, Bruce Momjian wrote:
> > >
> > > The 7.3.4 doc (doc/html/runtime-config.html) does say the
> > > log_connections option can only be set at server start or in the
> > > postgresql.conf configuration file. That seems a little am
On Thu, 19 Feb 2004, Alex wrote:
> Hi,
> just a few questions on the Vaccum
>
> I run a vacuum analyze on the database every night as part of a
> maintenance job.
>
> During the day I have a job that loads 30-70,000 records into two tables
> (each 30-70k).
> This job runs 2-3 times a day; the fi
On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:
> The problem is that on "fire time", the load go to > 1 and stay long
> time. But with top (i use top -d 1 to have "real" load average) i can
> see that the CPU is more than 50% idling.
>
> For exemple, i have this kind of stat :
>
> 0s -
On Wed, 18 Feb 2004, Lincoln Yeoh wrote:
> At 04:14 PM 2/17/2004 -0700, scott.marlowe wrote:
> >custom type (hex, foobar, etc...) from one to another. What this means
> >too you, the user, is that:
> >
> >create table test (id int8, info text);
> >
> >selec
On Tue, 17 Feb 2004, Tom Lane wrote:
> Brendan Jurd <[EMAIL PROTECTED]> writes:
> > I'm not objecting to the incompatibility itself, but I do think more
> > information needs to be provided to the user. I humbly suggest that if
> > psql is not going to be fully backwards-compatible with previou
On Thu, 12 Feb 2004, Jason Tesser wrote:
> Hi
>
> > > I have the below query written. I have removed a lot from the
> select
> > > Statement for simplicity sake. The query takes way too long.
> > > I am moving from an Access backend to a Postgres back with
> > > Access in the front. The below
On Thu, 12 Feb 2004, Jason Tesser wrote:
> I have the below query written. I have removed a lot from the select
> Statement for simplicity sake. The query takes way too long.
> I am moving from an Access backend to a Postgres back with
> Access in the front. The below query is taking like 14-20
On Thu, 12 Feb 2004, Bas Scheffers wrote:
> Hi Scot,
>
> As "unrealistic" as it should be, I need <1 before Postgres takes the
> bait. Initialy 0.7, to be exact, but later It also worked at a little
> higher setting of 1. I have given PG 96Mb of memory to play with, so
> likely all my data will b
On Wed, 11 Feb 2004, C G wrote:
>
> > > Dear All,
> > >
> > > Could anyone explain why this function does will not work? The error
> >message
> > > is
> > > DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
> > >
> > > CREATE FUNCTION testing() RETURNS trigger AS'
> > >
> > > pl
On Wed, 11 Feb 2004, C G wrote:
> Dear All,
>
> Could anyone explain why this function does will not work? The error message
> is
> DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
>
> CREATE FUNCTION testing() RETURNS trigger AS'
>
> plan=plpy.prepare(''INSERT INTO t1 values
On Wed, 11 Feb 2004, NTPT wrote:
> Take 1900 ms.. In this case i try to increase effective_cache_size step
> by step 64,128,256,512,1024 but increase effective_cache_size up from
> 512 have no dramatic impact on performance.
Note that effective_cache_size ONLY affects the query plan chosen. I
On Tue, 10 Feb 2004, CSN wrote:
>
> I think that probably improves things (lower cost? -
> see my other post):
>
> explain select p.* from products p where p.id in (
> select product_id from product_categories pc where
> pc.category_id = 1016) order by p.title limit 25
> offset 0;
>
On Tue, 10 Feb 2004, CSN wrote:
> > 2. Vacuum analyze the tables concerned and post the
> > output of EXPLAIN ANALYSE
> > with your query.
>
> => explain analyze;
>
> results in:
>
> ERROR: syntax error at or near ";" at character 16
No silly. you do:
explain analyze select ... (rest of th
On Tue, 10 Feb 2004, CSN wrote:
> I have a pretty simple select query that joins a table
> (p) with 125K rows with another table (pc) with almost
> one million rows:
>
> select p.*
> from product_categories pc
> inner join products p
> on pc.product_id = p.id
> where pc.category_id = $category_id
On Tue, 10 Feb 2004, Jeff Bohmer wrote:
>
> I have a table in a PG 7.4.1 database with 380 duplicate rows,
> including duplicate oid and primary key values. Looking through our
> backups, the duplicates did not exist before Friday, 02/06/2004. I'm
> assuming neither pg_dumpall nor restoring
On Tue, 10 Feb 2004, Andrew Sullivan wrote:
> On Tue, Feb 10, 2004 at 12:06:43PM -0700, scott.marlowe wrote:
> > simple. They GPL'd their connection libs. So, if you write code that has
> > their connection libs in it, it's gotta be GPL'd.
>
> Yes. Bu
On Tue, 10 Feb 2004, Andrew Sullivan wrote:
> On Tue, Feb 10, 2004 at 09:50:31AM -0700, scott.marlowe wrote:
> > you would still be wholly bound by the GPL. I.e. all the code you write
> > that connects to MySQL would therefore have to be GPL'd. I.e. it does
> > no
On Mon, 9 Feb 2004, John Gibson wrote:
> Hi, all.
>
> I need to upgrade my dual Xeon PostgreSQL engine.
>
> Assuming similar memory and disk sub-systems, I am considering a Quad
> Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
> PostgreSQL code is written for 32 bit and not
On Thu, 5 Feb 2004, Carlos Ojea Castro wrote:
>
> Hello:
>
> I want to display graphics from my postgresql database, but I must
> choose the proper tool first.
> Which one is more suitable?:
> perl?
> php?
> pg_autodoc?
> another one?
php and the gdlib work pretty well. It's not as simple as
On Wed, 21 Jan 2004, Kragen Sitaker wrote:
> I'd like to be able to do queries like "select count(*), fromline from
> message where subject like 'Couldn%'" quickly. I see that, in current
> Postgres, I can do this with an index like "create index message_subject
> on message using btree(subject v
On Wed, 21 Jan 2004, Alex Madon wrote:
> One can see that at the maximum feeling of swap (74700k free swap), the
> full picture is:
>
>
> 22:51:54 up 3:58, 6 users, load average: 47.38, 18.53, 7.79
> 131 processes: 130 sleeping, 1 running, 0 zombie, 0 stopped
> CPU states: 5.3% user 3.
On Wed, 21 Jan 2004, Alex Madon wrote:
> Hello,
> I am testing a web application (using the DBX PHP function to call a
> Postgresql backend).
I'm not familiar with DBX. Is that connection pooling or what?
> I have 375Mb RAM on my test home box.
> I ran ab (apache benchmark) to test the behavio
On Mon, 19 Jan 2004, Joshua D. Drake wrote:
> scott.marlowe wrote:
>
> >Is it possible to institute phrase searching with that system?
> >
> >
>
> It seems to work fine???
>
> Sincerely,
>
> Joshua D. Drake
Not really. with htdig, I can do &q
On Thu, 15 Jan 2004, Julio Misael Gutierrez wrote:
> Good day,
> I´m testing PostGresql,
> I would like to Know why when I create a new table,
> postgresql create a new type with the same name of the table.
> Where I can find more information about this?.
To add to what Tom said, this allows you
On Tue, 13 Jan 2004, Harry Jackson wrote:
> David Teran wrote:
> >
> > The real question was: are there open known bugs where a select
> > statement does not return a correct result, meaning a wrong number of
> > rows? Were there a lot of errors like this?
> > We are asking this because this mak
On Sat, 17 Jan 2004, Joshua D. Drake wrote:
> Hello,
>
> Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
> reinitdb which means you do
You may have missed where bill said he wanted to change a default limit
for plpgsql function args from 16 to something else. that will req
On Fri, 16 Jan 2004 [EMAIL PROTECTED] wrote:
>
> I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
> Did nothing special, just make && make install and all was well.
>
> I now have updated my ports collection via cvsup and see that the 7.4.1 port
> is available. So no
Is it possible to institute phrase searching with that system?
I.e.:
"create unique index"
"select distinct"
etc...
???
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
> Hello,
>
> Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
> documentation
> all searchable using Open
On Tue, 13 Jan 2004, Keith G. Murphy wrote:
> I'm trying to get a feel for what most people are doing or consider best
> practice.
>
> Given a mod_perl application talking to a PostgreSQL database on the
> same host, where different users are logging onto the web server using
> LDAP for authen
On Tue, 13 Jan 2004, Joshua D. Drake wrote:
>
> > The real question was: are there open known bugs where a select
> > statement does not return a correct result, meaning a wrong number of
> > rows? Were there a lot of errors like this?
> > We are asking this because this makes trouble with the
On Mon, 12 Jan 2004, Richard Huxton wrote:
> On Sunday 11 January 2004 09:29, Dario Ottaviano wrote:
> > I use postgres on a window server (IIS 5.1)
> > Is there anybody that knows if is possible to make postgres no case
> > sensitive in the manipulating data into tables/views?
>
> There's no g
On Sat, 10 Jan 2004, Eric Freeman wrote:
> Is there any way in Postgres to SELECT a list of table names from inside of
> a C program using ECPG?
> Something similar to SELECT current_user that will give you all of the
> tables in the database you are connected to.
If you are running 7.4 and hav
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
> Right! Thus my quandry.
>
> Re inodes, how can I check this? But why would this be? Is Postgres
> sucking up inodes just sitting there as a read-only DB?
If you are out of inodes, I seriously doubt it is Postgresql's fault, as
you seem to be run
On Mon, 5 Jan 2004 [EMAIL PROTECTED] wrote:
> Hello,
> I am new in PostgreSQL world coming from Oracle.
> I have created two databases using command line as manual has suggested.
> For instance I have done like the following:
> createdb tanya
> createdb eps
> Now I would like to stop my "tanya"
On Wed, 7 Jan 2004, John Sidney-Woollett wrote:
> Is it possible to (automatically) force the reparse of a stored PL/pgSQL
> function following the deletion and recreation of an object that was
> referenced within the function (for example a table or another function)?
Would
CREATE OR REPLACE f
Another good way to handle this is to put a trigger on the table that
diverts inserts that would fail to a holding table. While this will slow
down the inserts, it will allow you to insert large lists of dubious
quality and worry about the bad rows later.
My preference is to fix the data feed,
On 16 Dec 2003, claudia wrote:
> Hi, I developing a program using postgres and linux like operating
> system. My problem is this:
> I have a quite complicated view with roughly 1 record. When I
> execute a simple query like this
> "select * from myview"
> postgres respond after 50 - 55 m
You're gonna have a hard time getting support for a version that old
(we've since seen 7.1, 7.2, 7.3, and 7.4 come out and 7.5 is in the cooker
right now.
If it's possible to backup your database, I'd highly recommend upgrading
postgresql on a test machine or something. It sounds like you migh
On Thu, 11 Dec 2003, Netto wrote:
> The way PostgreSQL deals with the date format is confusing me...
> I need PostgreSQL to return dates from selects at this format: "dd/mm/",
> but it insists in returning it as "-mm-dd". I say "insists" cause I had
> already set datestyle to "European" (i
On Mon, 15 Dec 2003, Johnson, Shaunn wrote:
> Howdy:
> Silly questions -
>
> Is it possible (or, has anyone got brave enough) to run
> PostgreSQL on Windows Server 2003?
>
> If so, what does it entail and how do I start?
The best and easiest way for normal folks is likely gonna be to use
cygwi
On Fri, 12 Dec 2003, Josué Maldonado wrote:
> Hello list,
>
> What's the "right" way to uninstall postgres 7.4 in Linux (RH 8)?.
That really depends on how it was installed. If installed via RPM, then
you do 'rpm -e postgrespackagenameshere'. If it was installed from
source, 'make uninstall'
On Tue, 2 Dec 2003, Randolf Richardson wrote:
> >>In dealing with web applications and frontends to database or
> >>even just a dynamic web site PHP has every bit the power and ability that
> >>Java does and the development time is way down.
> >
> > Uh, how about threads. I know that you don't n
On Tue, 2 Dec 2003, Jan Wieck wrote:
> scott.marlowe wrote:
>
> > On Mon, 1 Dec 2003, Jan Wieck wrote:
> >
> >> Jason Tesser wrote:
> >>
> >> > Quoted as gospel by various people:
> >> >>> MySQL cannot even handle sub-queries ye
On 1 Dec 2003, Greg Stark wrote:
>
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > Again, show me an area where PHP is actually deficient here. Something
> > Perl or Ruby does better that would pertain to a mailing list. Don't just
> > wa
On Mon, 1 Dec 2003, Jan Wieck wrote:
> Jason Tesser wrote:
>
> > Quoted as gospel by various people:
> >>> MySQL cannot even handle sub-queries yet.
> >
> >> BTW, is that really still true? I thought they had at least some
> >> support for subqueries by now.
> >
> > yes sub queries in 4.1 whic
On 1 Dec 2003, Randal L. Schwartz wrote:
> > "scott" == scott marlowe <[EMAIL PROTECTED]> writes:
>
> scott> This is simply not true. PHP comes in both a web ready
> scott> embedded version, as well as a CLI version, and is quite
> scott> capable, even of handling things like streams and suc
1 - 100 of 226 matches
Mail list logo
