Re: [GENERAL] GUID/UUID Support

of implementations and messages about it) that is supported by other databases (such as oracle and mssql). I hope that we can dot our Is and cross our Ts and get this feature into the next version. Patrick ---(end of broadcast)--- TI

Re: [GENERAL] GUID/UUID Support

#x27;t map nicely to those higher level types. Patrick On 1/17/07, Chad Wagner <[EMAIL PROTECTED]> wrote: On 1/17/07, Patrick Earl <[EMAIL PROTECTED]> wrote: > Certainly support for the GUID field type itself is most important. > As for the generators, though they are

[GENERAL] Explain output question

g  (cost=0.00..1469685.99 rows=26921450 width=46)                                        Filter: (((fed_div)::text = 'MCE'::text) OR ((fed_div)::text = 'MCW'::text) OR ((fed_div)::text = 'BUR'::text) OR ((fed_div)::text = 'BON'::text) OR ((fed_div)::text = 'RLG'::text)) TIA Patrick Hatcher Macys.Com

Re: [GENERAL] Explain output question

thank you.  I thought it was correct but just wanted to make sure. Patrick Hatcher Macys.Com Tom Lane <[EMAIL PROTECTED]> 10/08/04 11:34 AM To Patrick Hatcher <[EMAIL PROTECTED]> cc [EMAIL PROTECTED] Subject Re: [GENERAL] Explain output question Patrick Hat

[GENERAL] Possible bug with LABEL and LOOP in 8.0

--   When I call SELECT TEST(), I get the error message : ERROR:  control reached end of function without RETURNCONTEXT:  PL/pgSQL function "test"   If I just change EXIT LOOP1 to EXIT -> everything is OK I think we previously had the possibi

Re: [GENERAL] Tables and Indexes

Hi, I think that TABLESPACE is what you need... It's now available in Postgresql, just look at the syntax in documentation. > -- - > Patrick Fiche > email : [EMAIL PROTECTED] > tél

[GENERAL] Number of months

;Year', CURRENT_DATE) -date_part('Year', SOMEDATE)) * 12 +date_part('Month', CURRENT_DATE)-date_part('Month',SOMEDATE) TIA Patrick Hatcher

[GENERAL] how to edit a function from psql?

How can I view and edit a function in psql?  I have been using PgAdmin to do this but wanted to try the command line TIA Patrick Hatcher

Re: [GENERAL] how to edit a function from psql?

Thanks Alvaro. That was what I was looking for. Patrick Hatcher Alvaro Herrera <[EMAIL PROTECTED]> 11/04/04 03:40 PM To "Thomas F.O'Connell" <[EMAIL PROTECTED]> cc Patrick Hatcher <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject Re: [GENERAL]

[GENERAL] Vacuum hangs

16560 mode        | ShareUpdateExclusiveLock granted     | t TIA Patrick Hatcher

Re: [GENERAL] Vacuum hangs

Will do thanks. I ended up dropping and recreating the index and that seems to have fixed the problem. Patrick Hatcher Tom Lane

Re: [GENERAL] query with table alias

Title: query with table alias The correct query would be "select f.c1, f.c2 from foo f;" if you want to use alias   Patrick   --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 2

Re: [GENERAL] Help with syntax for timestamp addition

Have a try at this syntax SELECT number FROM procedures WHERE date + CAST( numdays || ' days' AS interval ) <= CURRENT_TIMESTAMP; Patrick > -- ----- > Patrick Fiche > email : [EMAIL PROTE

Re: [GENERAL] Creating index on a view?

Some time ago, an excellent tutorial on materialized views with PostgreSQL was pointed at this address http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Patrick > -- - > Patrick

[GENERAL] DELETE versus TRUNCATE during pg_dump....

s are empty while we do our daily backups. TIA Patrick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the ma

Re: [GENERAL] DELETE versus TRUNCATE during pg_dump....

. Does this make a difference? Tom Lane wrote: Patrick Hatcher <[EMAIL PROTECTED]> writes: Curious: Why would a DELETE FROM tablename work while a pg_dump is occurring but a TRUNCATE tablename will stay in a lock state until the pg_dump is complete? TRUNCATE requires an exclusive lock

Re: [GENERAL] Books for experienced DB developer

in PostgreSQL, so you have to set all parameters and modify calling applications to do so... I have written some tips for porting but in French. If you face to special problems, don't hesitate to ask for and if I perhaps encountered the same problem... Pa

Re: [GENERAL] Books for experienced DB developer

I'm afraid this is still a problem. >From my knowledge, Postgres function is able to return a single result-set not multiple. I may have missed some facility... Regards, Patrick --- Patrick Fich

Re: [GENERAL] Books for experienced DB developer

... For example, you can navigate in the result-sets in ODBC using the SQLMoreResults function... That's probably not a very usual way of programming but we did it and experienced problems for porting Regards, Pa

Re: [GENERAL] Best Linux Distribution

On Fri, Jan 21, 2005 at 03:23:47PM -0200, Bruno Almeida do Lago wrote: > Any info about NetBSD? That's all we use - no problems, so never had to do any comparisons.. Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at o

[GENERAL] is this index bloat?

runcated 64 to 64 pages DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: analyzing "public.kst" INFO: "kst": 64 pages, 919 rows sampled, 919 estimated total rows VACUUM # - Free Space Map - max_fsm_pages = 300 # min max_fsm_relations*16, 6 bytes

[GENERAL] Trigger question: ROW or STATEMENT?

ently about 12M. TIA Patrick Hatcher ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Trigger question: ROW or STATEMENT?

ELSE NEW.cost :=0; NEW.owned :=0; END IF; RETURN NEW; END;' LANGUAGE 'plpgsql' VOLATILE; Patrick Hatcher Development Manager Analytics/MIO Macys.com 415-422-1610 Doug McNaught

Re: [GENERAL] Trigger question: ROW or STATEMENT?

Would I gain any advantage by changing to it to fire after the insert? thanks again for the help Patrick Hatcher Development Manager Analytics/MIO Macys.com 415-422-1610 Doug McNaught

Re: [GENERAL] Trigger question: ROW or STATEMENT?

that answered my question. Thanks everyone Patrick Hatcher Development Manager Analytics/MIO Macys.com Michael Fuhr <[EMAIL PROTEC

[GENERAL] RAISE function misuse ?

ONTEXT: SQL statement "SELECT hello()" PL/pgSQL function "test" line 2 at perform I use PostgreSQL/psql 8.1.0 Thanks, Patrick ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] RAISE function misuse ?

Michael Fuhr wrote: On Mon, Apr 03, 2006 at 05:44:18PM +0200, Patrick Refondini wrote: idns_target=# select test(); INFO: hello ! CONTEXT: SQL statement "SELECT hello()" PL/pgSQL function "test" line 2 at perform [...] 1. Is there anything wrong using RAISE thi

[GENERAL] PL/PgSQL composite parameter usage?

I read in the documentation (section 37.4.3 of the 7.4 docs) that "Parameters to a function can be composite types," but when I try to call such a function, I get an error. I've attached my test functions below. Can anyone tell me what's wrong? I've tried the same function using RECORD types, and i

[GENERAL] Prefix operator error to type OID?

to update any data within the grid, I get the same error as the above. Everything works fine if I try to SELECT, UPDATE, or DELETE. Any ideas? Patrick Hatcher Macys.Com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] OID problem

er ways around this problem? Thanks for your help, Patrick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] referential integrity constraints not checked inside PL/pgSQL functions?

> > select f(); > > yields an error message about constraint violation when executing > 'delete from a;'. Off the top of my head, the constraints would be checked when the transaction ends, i.e., after both the "delete from a" an

[GENERAL] Q: upgrading from 7.4.1 to 7.4.3.

I'm about to update a server that is currently using 7.4.1 to 7.4.3. I see that in the instructions for upgrading to 7.4.2 from 7.4.1 it said to either do a dump or follow a set of special instructions. Should I still follow these instruction when I upgrade? TIA Patrick Hatcher Macy

[GENERAL] Implicit join

Hi, Is there any way to prevent implicit join in version 7.3.x? I tried to put 'ENABLE_IMPLICIT_FROM = false' in postgresql.conf but it did not work. Thanks a lot, Patrick _ Take charge with a pop-up guard built o

[GENERAL] Implicit join

Hi, Is there any way to prevent implicit joins in 7.3.x? I tried to put 'ENABLE_IMPLICIT_FROM = false' in postgresql.conf but it did not work. Thanks, Patrick _ Powerful Parental Controls Let your child discover th

[GENERAL] Confused with LABEL and LOOP

trol reached end of function without RETURNCONTEXT:  PL/pgSQL function "test"   If I just change EXIT LOOP1 to EXIT -> everything is OK I think we previously had the possibility to indicate the LABEL in EXIT statement...   Regards,   Patrick -----

[GENERAL] psql : how to make it more silent....

." Is there a way to get rid of these messages   Thanks   ------- Patrick Fiche email : [EMAIL PROTECTED

Re: [GENERAL] Time at end of transaction

Hi, I think that timeofday() should solve your issue. Just take care that this function returns text instead of timestamp... You will have to cast it. Patrick > -- - > Patrick Fiche > email

[GENERAL] re: 7.1.2 and foreign key unique constraint.

ion for a foreign key is that it has to be unique itself. Thanks for your time, -- patrick keshishian Gnu __ _ -o)/ / (_)__ __ __ /\\ /__/ / _ \/ // /\ \/ / _\_v __/_/_//_/\_,_/ /_/\_\ ---(end of broadcast)--- TIP 2: you

[GENERAL] null answer - how?

ow can this be? select * from stats where timesliced is null or timeslicet is null select * from trans where deltafromoctets is null both retun 0 rows. stats_id and stats.id are "not null" timesliced date, timeslicet time, deltrafromoctets bigint. Any hints? Cheers, Patrick --

Re: [GENERAL] null answer - how?

om trans; min | max --+--- 5415 | 12532 (1 row) transatlantic=# select min(id),max(id) from stats where timesliced<'01-May-2001'; min | max -+-- 10 | 2345 (1 row) Cheers, Patrick ---(end of broadcast)--- TIP 1:

Re: [GENERAL]

ansaction in progress. > > Same happens with commit. > We are used to SQL PlUS > > Without these facilities we really cannot go ahead with postgres db. Could you >please help us out on this. -- patrick keshishian Gnu __ _ -o)/ / (_)__ __ __

Re: [GENERAL] Convert TimeStamp to Date

s a date before 2000, and it seems to give the right answer.. I tend to be pedantic and use select cast('1993-08-10 17:48:41.074' as date) Cheers, Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Using YY-MM-DD date input

e would also want to move the window 32][33 above etc, so simplest is if 03-02-01 would just be 3rd Feb 1AD, 2nd Mar 1AD or 1st Feb 3AD according to DMY, MDY or YMD. Still not clear to me how you make a difference between input and output encoding with a single DateStyle GUC variable

Re: [GENERAL] PostgreSQL Question

On Thu, Jul 31, 2003 at 11:52:42AM +0800, Ryan F. Bayhonan wrote: > Hi Patrick, > > Have read your reply in the web about postgreSQL. > (http://archives.postgresql.org/pgsql-interfaces/2001-01/msg00170.php) > > My name is Ryan, and I would like to ask some help about PostgreSQ

[GENERAL] how to drop table named user

ion on how to remove this table? I thought maybe going through Pg Class, but I'm terrified of mucking something else up. TIA Patrick Hatcher ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] process hangs using perl?

/bash TIA Patrick Hatcher ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Index on timestamp to date field

able1 USING btree to_char(field2, 'MM-DD-'); but I get an error message error at or new to_char TIA Patrick Hatcher Macys.Com Legacy Integration Developer 415-422-1610 office HatcherPT - AIM ---(end of broadcast)--- TIP 5: Have you checke

[GENERAL] gborg cvs ?

Is something up with gborg cvs, or have the settings changed? % cvs update cvs [update aborted]: connect to gborg.postgresql.org:2401 failed: Connection timed out % cat CVS/Root :pserver:[EMAIL PROTECTED]:/usr/local/cvsroot/libpqxx % cat CVS/Repository libpqxx Cheers, Patrick

Re: [GENERAL] PLPERL function error - utf-8 to iso8859-1

Ah there in lies the problem. I have my database encoding set to LATIN1 and I have this value stored in my table and can even write SQL to search against it: select * from mdc_products where description ~* '?' Patrick Hatcher Macys.Com Legacy Integration Developer 415-422-1610 office

Re: [GENERAL] no records returned

prtnl where stck_sym like 'ZRAN%'; ? (What is the definition of your table?) Cheers, Patrick ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] PostgreSQL with MS Query?

from the menu select Data, Get External Data, New Database Query. Follow the wizard from there. hth Patrick ***You wrote Hi there, I'm trying to access my postgreSQL database using Excel (through MS Query). I've been reading a bit about ODBC and I'm pretty sure that this is

[GENERAL] dump schema schema only?

to export only schema X from the database? TIA Patrick Hatcher ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] Pg Dump error

ut issue Patrick Hatcher Macys.Com Legacy Integration Developer 415-422-1610 office HatcherPT - AIM ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] error loading shared libraries: libpq.so.3

directory exists. However, if I do a find for this file, I find it in my PG directory: /usr/local/postgresql7.4/lib I'm not sure what to do now. Any suggestions? TIA Patrick Hatcher ---(end of broadcast)--- TIP 7: don't forget to inc

Re: [GENERAL] error loading shared libraries: libpq.so.3

Thanks that did itPatrick Hatcher-Martin Marques <[EMAIL PROTECTED]> wrote: -To: "Patrick Hatcher" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]From: Martin Marques <[EMAIL PROTECTED]>Date: 2003-11-22 03:08PMSubject: Re: [GENERAL] error loading shared libraries: libpq.

Re: [GENERAL] 32KB Tuples

thers. The first time the 8k limit struck was with with a pg_dump/restore were obviously the entire row was used, so maybe it's just the size of the reply?) Cheers, Patrick

[GENERAL] Performance for indexes on functions

function used when creating the index : SELECT ... WHERE substr( col1, 1, 5 ) = '.'. Do you recommend or not to use this kind of indexes ? Excuse me it it's not really clear but if necessary, I will try to explain it better... Thanks a lot Patrick FICHE

Re: [GENERAL] Figured it out (psql and Gnu readline)

On Fri, Jul 14, 2000 at 12:33:20AM +0200, Peter Eisentraut wrote: > Patrick Welche writes: > > > .. of course for me it's in libedit: > > > > % nm -g /usr/lib/libedit.a | grep using_history > > 028c T using_history > > Is libedit readline c

Re: [GENERAL] Regression Tests

;s in the source directory pgsql/doc or on our > web site at http://www.postgresql.org. > FATAL 1: InitProcGlobal: IpcSemaphoreCreate failed Simplest solution: quit the other postmaster, then make runcheck. Otherwise double your IPC settings - depending on the OS this might involve building a new kernel. Cheers, Patrick

[GENERAL] split up tables or one big one?

split up the tables (as I've currently programmed it) or to put everything into one gigantic, multi-GB table? This is for the web, so transaction speed is important. Patrick.

Re: [GENERAL] FOREIGN KEY questions

/* ... */ ); CREATE TABLE threads ( id serial PRIMARY KEY /* ... */ ); cf. Bruce's book: http://www.postgresql.org/docs/aw_pgsql_book/node156.html Cheers, Patrick

Re: [GENERAL] Re: LOCK TABLE

select * from person order by surname for update limit 1 offset 10; as there is no where clause, am I locking the whole table? Cheers, Patrick

Re: [GENERAL] performance hit with --enable-debug

ry is compile with --enable-debug, then strip the resultant executable, and see if it is as fast as (should be identical to?) executable generated without --enable-debug.. Cheers, Patrick

Re: [GENERAL] Re: MySQL file system

ap n) is to a field in the table. > In other words Postgresql does not recognize "Number" and thinks it is "number" > > Any idea of what is going on or where should I look in the documentation? Try: select * from avi_f_amm where "Number" > 1; Cheers, Patrick

Re: [GENERAL] character sets

does --enable-recode do anything if you don't have --enable-multibyte? I would be interested in say ISO8859-1 <--> ISO8859-2 but without the overhead of wide chars.. Cheers, Patrick

Re: [GENERAL] problem with copy

copy: line 1, Bad timestamp external representation '' > PQendcopy: resetting connection > > Thanx for ur help > Anand What does just \copy artists from STDIN using delimiters '|'; do for you? Cheers, Patrick

Re: [GENERAL] undefined reference to xxx

r message as soon as possible? > Please! I would guess a typo: PQerrorMessage, on my system, is in libpq.a, not libpg.a (which I don't have) Cheers, Patrick

[GENERAL] order of clauses

uated in any order (A and B = B and A). I obviously would like (y>0) to happen first, but I don't see how this can be achieved.. Any ideas? Cheers, Patrick

Re: [SQL] Re: [GENERAL] MySQLs Describe emulator!

On Tue, Mar 06, 2001 at 10:38:43AM -0500, Michael Fork wrote: > try starting psql with the -E option -- this displays all queries used > internally to the screen, i.e.: Sorry, hadn't read this one before posting... Thanks to the "moderating" it'll all be out of s

[GENERAL] Two tables for the price of one?

doing it). I may just recompile and dump and resoter the tables from scratch but I'd like to avoid it if possible. Thanks. -- ---- Patrick Aland [EMAIL PROTECTED] Network Administrator

[GENERAL] Re: Access 97/Postgres migration

the query and retrieve the value 5. Call this function in the BeforeInsert event of the form. This will overcome the potential problem mentioned. -- === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Then the end

[BUGS] Re: Possible ODBC driver error

On Mon, 16 Apr 2001 17:21:16 +1200 AD in comp.databases.postgresql.bugs, Patrick Dunford said: >On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general, >Patrick Dunford said: > >>I recently copied five tables to the server using the Postgres ODBC driver &

[BUGS] Re: Possible ODBC driver error

On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general, Patrick Dunford said: >I recently copied five tables to the server using the Postgres ODBC driver >with MS Access. > >The tables can be viewed in MS Access but not using PHP or Zeos Database >Explo

[GENERAL] Possible ODBC driver error

ble in ZDO and the column names can be viewed. All the names of the tables also appear in pg_tables. Is this a bug in the ODBC driver i.e. it does not make the full entries needed in Postgres for it to know about tables? -- =====

[GENERAL] Re: Table names / mixed case / Postgresql 7.0.3

n't bother changing the case and then you are stuck with it :( -- ======= Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Then the end will come, when he hands over the kingdom to God the Father after he has destroyed all dominion, authority and power. -- 1 Corinthians 15:

[GENERAL] bpchar type

the MS Access type representation of what is on the server, not the server's datatype). Zeos Database Explorer shows the type of these fields to be "bpchar", is this a Postgres data type? -- ======= Patrick Dunford, C

[GENERAL] Re: Access 97/Postgres migration

to the hassles you'll encounter if you try >to do it any other way. 1. Create a sequence 2. Create a ODBC passthrough query to get the NEXTVAL result 3. Write some DAO code to get the result of the query 4. Call the DAO code in BeforeInsert event of the form. -- ====

Re: [GENERAL] very odd behavior

parser knows you are using it as a field name and doesn't wonder about what should be descending.. Cheers, Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Re: Query not using index

set enable_seqscan to off; explain select ... and see what the cost is. Compare it with the value above. Cheers, Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister

Re: [GENERAL] psql shell problem

feature is GONE! > > Is there some way to get this functionality back (hopefully without > changing a compile-time option and compiling from source)? Did you install GNU readline on one and not the other? Does OpenBSD 2.8 come with /usr/include/readline/readline.h and /usr/lib/libed

[GENERAL] DBD::Pg & cursors & total results

ve way to find out what $num_rows is going to be for a select statement? Am I missing something obvious? I'd be grateful for any help / thoughts. Cheers. Patrick -- #===# \ KAN Design & Publishing Ltd / / T: +44 (0)1223 511134\ \ F: +44 (0)1223 571968/ / E: mailto:[EMAIL PROTECTED] \ \ W: http://www.kan.co.uk / #===#

[GENERAL] NOTICE: SIAssignBackendId: discarding tag 2147483647

ow what is going on here and how I can fix it? Will 6.4 fix it? I know it's worth trying 6.4 but do you know why it would fix it? I have included some debugging output below. Also - is this the right list to mail such problems to? Thanks. Patrick -- query is: SELECT * FROM image

[GENERAL] Digital UNIX

ction environment on this platform? What are the minor problems mentioned here? Should I avoid Digital Unix? Cheers. Patrick -- #===# \ KAN Design & Publishing Ltd / / T: +44 (0)1223 511134\ \ F: +44 (0)1223 571968/ / E: mailto:[EMAIL PROTECTED]

[GENERAL] Odd termination

. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. happened instead. Is this right? Cheers, Patrick (source supped Sep 9)

[GENERAL] macaddr

Is there some documentation on the macaddr type anywhere? Cheers, Patrick

[GENERAL] dbase converter

key) which of course PostgreSQL does. Anyone know of something more recent? Cheers, Patrick

Re: [GENERAL] dbase converter

a spurious character followed by comma in INSERT ( á,fieldname1,fieldname2) Thanks again, Patrick Oleg Broytmann wrote on 21 Feb 1999: > Hello! > >Just found on FreshMeat: > > http://w3.man.torun.pl/~makler/prog/pg2xbase.html >Tool to convert Postgres to/from DBF files

[GENERAL] insert iff !exist

I'm pretty sure someone already answered this, but the mail archive isn't very searchable at the moment. How can you if(update row fails because doesn't exist, ie. returns 0)then(insert row) in SQL? Or am I misremembering and it was in some other language? Cheers, Patrick

Re: [GENERAL] datetime datatype question

999 CDT > > Is there a way I can retrieve the information from a datetime field, and > format it like the first example ? rfb=> \h set Command: set Description: set run-time environment Syntax: SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'European'

Re: [GENERAL] Postgres ODBC driver and BLOBs

quot; and here is the command used to create it: create type lo ( internallength=4, externallength=10, input=int4in, output=int4out, default='', passedbyvalue ); quoted from http://www.insightdist.com/psqlodbc/psqlodbc_faq.html under "Can I use large objects or OLE?" Cheers, Patrick

Re: [GENERAL] Re: can't seem to use index

> I then tried changing the btree index to a hash talbe and went through the > same procedure of vacumming and restarting a psql session. Yet again, the > index wasn't being used. But did you try vacuum analyze or just vacuum?

[GENERAL] Date format

-mm-dd (at least for sufficiently large years). Sorry I can't remember your email address. Cheers, Patrick

[GENERAL] vacuum analyze [table]

umn [, ...] ) ] ] regression=> vacuum analyze num_result; NOTICE: Vacuum: table not found VACUUM The same is true for me with any table, any database, using source cvs'd yesterday. Cheers, Patrick

[GENERAL] Variable case database names

e "newnham" does not exist in the system catalog. Previous connection kept How can I connect to a database with a variable case name? Cheers, Patrick

Re: [GENERAL] scheduling table design

On Fri, Feb 25, 2000 at 09:56:59AM -0600, [EMAIL PROTECTED] wrote: > > do not use date, use datetime. why? it's sql92 standard (another > good reason: M$sql only has datetime :-). A lot of useful functions > only apply to datetime, not date. On a side note: if I have a date d and a time t column

Re: [GENERAL] select ... FROM ... WHERE .. IN (select ...) takes FOREVER... Can someone help me optimize this?

OSPHERE' and de_center.de_id = de_parameters.de_id ) order by data_center; ? (Wish I could test it first...) Cheers, Patrick

Re: [GENERAL] using NOT EXISTS

bout no extra and, and sum(case when (t.jobid=s.subproject_id and p1.project_id=s.projectid) then t.timespent else 0::float4 end) ? Just guessing, Patrick

Re: [GENERAL] demande d'aide

Postgres fait partie de RedHat linux. Postgres ne se compare pas facilement a MYSQL car il est un vrai RDBMS (relational database). MYSQL est une emulation partielle. Patrick Robin chriqi abdelkarim wrote: > bonjour; > tout d'abord, je me presente. je suis un étudiant marocain

[GENERAL] Physical data storage

Hi, Does anyone know where I could find a documentation describing physical storage format in Postgres ? Thanks Patrick Fiche

[GENERAL] pg_dump return failed sanity check

led sanity check, type with oid 457690 was not found Thanks Patrick -- ____ Patrick Robin [EMAIL PROTECTED] Walt Disney Feature Animation 500 South Buena Vista Street Burbank,California 91521-4817

<    1   2   3   4   5   6   >