FAQ

PostgreSQL > pgsql-general > July 2003

Search Discussions

366 discussions - 1,557 posts

  • I have a table with a primary field and a few other fields. What is the fastest way to do an insert into that table assuming that sometimes I might try to insert a record with a duplicate primary key ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Jul 2, 2003 at 12:11 am
    Jul 2, 2003 at 8:35 am
  • Hello, We are currently working on a project where we need to limit number of records in a table to a certain number. As soon as the number has been reached, for each new row the oldest row should be ...
    Kirill PonazdyrKirill Ponazdyr
    Jul 16, 2003 at 3:59 pm
    Jul 18, 2003 at 1:41 pm
  • Does anyone use YY-MM-DD for date input? Right now, it only works mostly for pre-2000 dates because we can detect that 97-02-03 is a year, while we can not detect that in 03-02-01. We are considering ...
    Bruce MomjianBruce Momjian
    Jul 25, 2003 at 8:02 pm
    Jul 30, 2003 at 1:20 am
  • Hi, this is a general RDBMS question, not specific to pg. It occurred to me while I was trying to design an interface between application and SQL. Suppose that the user fills in a complex query form, ...
    Antonios ChristofidesAntonios Christofides
    Jul 13, 2003 at 10:24 am
    Jul 17, 2003 at 6:52 pm
  • Couple of questions on datat types and performance 1. varchar vs varchar(2) I created a database schema and based on the test data I had to work with, I couldn't really determine the max size of a ...
    Jay O'ConnorJay O'Connor
    Jul 4, 2003 at 3:16 pm
    Jul 21, 2003 at 2:31 am
  • Here is a problem a ran into: testdb=# create table test (x int); CREATE TABLE testdb=# create table test_view as select * from test; SELECT testdb=# create rule insert_test as on insert to test_view ...
    Dmitry TkachDmitry Tkach
    Jul 15, 2003 at 4:14 pm
    Jul 22, 2003 at 7:35 pm
  • Hi @ all, i've a little problem with two tables and FOREIGN KEYs. I've read about this long time ago, but didn't remember me where. Well, I hope you can help me. I've create two TABLEs "counties" and ...
    Kay-uwe.genzKay-uwe.genz
    Jul 28, 2003 at 4:24 pm
    Jul 29, 2003 at 8:07 pm
  • I cannot build the latest release on OS X Jaguar. Any ideas? Details below... Running GCC 3.3 from Apple: hunter% gcc -v Reading specs from /usr/libexec/gcc/darwin/ppc/3.3/specs Thread model: posix ...
    Hunter HillegasHunter Hillegas
    Jul 28, 2003 at 3:39 am
    Sep 28, 2003 at 2:00 am
  • Hi all, I have received a question via the Advocacy site and I am not knowledgeable enough to answer. Can you help? The question is: can PostgreSQL handle between 10'000 and 40'000 simultaneous ...
    Francois SuterFrancois Suter
    Jul 18, 2003 at 3:00 pm
    Jul 20, 2003 at 3:55 am
  • Anyone seen this ad lately? ;) http://ads.osdn.com/?ad_id=83&alloc_id=1055&site_id=2&request_id=1792929&1059014249841 Wonder why SAP is so unsung ... Jean-Christian Imbeault
    Jean-Christian ImbeaultJean-Christian Imbeault
    Jul 24, 2003 at 2:45 am
    Jul 25, 2003 at 6:24 am
  • Just having a small argument with an application developer ... is using 0/1 for boolean types SQL compliant? I am trying to convince him that the proper SQL compliant (and postgresql compliant) ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Jul 23, 2003 at 6:48 am
    Jul 24, 2003 at 4:43 pm
  • The echo feature of psql echos the query after its executed. does it makes more sense to have the reverse. when we execute an sql batch we are more interested to know the query when psql apparently ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jul 24, 2003 at 6:23 am
    Jul 31, 2003 at 4:24 am
  • Nigel J. AndrewsNigel J. Andrews
    Jul 20, 2003 at 12:33 pm
    Jul 21, 2003 at 5:07 pm
  • Hi, yesterday I ran vaccumdb on one of our postgresql databases. As of today, whenever I try to connect to the postmaster from Windows using the latest ODBC driver the postmaster crashes and restarts ...
    Luis MagañaLuis Magaña
    Jul 16, 2003 at 4:32 pm
    Jul 17, 2003 at 8:59 pm
  • I'm testing a database against the 7.4 CVS, so I did a pg_dumpall and a restore on another system. The database has around 130 user tables which take up a bit under 15GB of disk space. The dump file ...
    NolanNolan
    Jul 16, 2003 at 5:16 pm
    Aug 17, 2003 at 3:14 am
  • Hi, Have question.... How to do such like this: I have: select <column list form <tables where <where statement ; how to make one column be row numbers in result? and second one: have select like ...
    Robert PartykaRobert Partyka
    Jul 30, 2003 at 12:17 pm
    Aug 6, 2003 at 2:33 pm
  • How to go about scheduled backup in Postgresql. What are the exact steps to be followed? Does anyone know this? Thanks and Regards, Kallol.
    Kallol NandiKallol Nandi
    Jul 18, 2003 at 10:28 am
    Jul 18, 2003 at 2:44 pm
  • Hello, I am planning to implement a system, where there is one Master database running on a Linux box with as many resources as necessary, and there are one or more client pc computers,with processor ...
    GogulusGogulus
    Jul 29, 2003 at 4:59 pm
    Jul 30, 2003 at 9:14 pm
  • Suppose the following: create table test (a int primary key); insert into test values (1); select * from test; a = 1 In Postgresql if you do the following in a transaction (either with autocommit=off ...
    Jörg SchulzJörg Schulz
    Jul 14, 2003 at 7:47 am
    Jul 14, 2003 at 3:36 pm
  • I still having that same error on my simple query: Tables has been rebuild, reindexed, and DB has been moved to another computer, worked for a while, and now aging same story. We run PG 7.3 I repeat ...
    Maksim LikharevMaksim Likharev
    Jul 8, 2003 at 2:19 am
    Jul 12, 2003 at 11:59 pm
  • Hi, all, I've met a wierd problem on a Solaris 8/sparc box with postgresql 7.3.3: the server would automatically shutdown after a period of time of not operating. The log show something like this: ...
    Weiping HeWeiping He
    Jul 4, 2003 at 6:54 am
    Jul 8, 2003 at 9:49 am
  • hi, we are running Postgres 7.3.3 successfully on our portal sites under Solaris. For a new project we have the requirement that N processes need to write update/insert within the same time and ...
    Andreas JungAndreas Jung
    Jul 29, 2003 at 10:32 am
    Jul 30, 2003 at 3:08 pm
  • All, What impact in performance does vacuum have on an active database? I'm being asked about this...or rather...someone is questioning the use of postgresql because of this Thanks Jay
    Jay O'ConnorJay O'Connor
    Jul 14, 2003 at 8:18 pm
    Jul 21, 2003 at 9:01 pm
  • Hello, had Somebody compared Postgresql vrs Firebird? What is the main diferent between this DBs? performance? support? flexibility?. Best Regards! -----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG ...
    Erick DennisErick Dennis
    Jul 15, 2003 at 8:26 pm
    Jul 16, 2003 at 2:49 pm
  • in 7.2 doing a data only dump (pg_dump -a -x db dump) would give output like: UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'status'; COPY "status" FROM stdin; 0 INFO 1 WARNING 2 CRIT \. ...
    Robert TreatRobert Treat
    Jul 31, 2003 at 2:31 pm
    Aug 1, 2003 at 3:47 pm
  • Please, help. versions: 7.3.3, 7.3.4 Server don't recycles or removes WAL files at all, generating 12-20 files every day. -rw------- 1 postgres postgres 16777216 Jul 29 01:54 0000000000000000 ...
    Michael GovorunMichael Govorun
    Jul 30, 2003 at 5:52 pm
    Jul 31, 2003 at 8:16 am
  • Hi All, I have posted this before, but have not yet got any resolutions on it. I am hoping someone with experience can help me out. I am running Postgresql 7.3.2 on Solaris 5.9. I am trying to ...
    Errol NealErrol Neal
    Jul 24, 2003 at 3:54 pm
    Jul 25, 2003 at 5:29 pm
  • This one is irritating. Here's some psql output: ================================================================================ dumps=# \d fal_profdel Table "fal_profdel" Attribute | Type | ...
    Philip GreerPhilip Greer
    Jul 21, 2003 at 5:05 pm
    Jul 21, 2003 at 7:46 pm
  • Hi, everybody! I was getting these errors (see subject) from time to time on 7.2.1 when trying to analyze tables... trying to repeat the statament would usually work.... I then saw somebody else post ...
    Dmitry TkachDmitry Tkach
    Jul 18, 2003 at 3:49 pm
    Jul 18, 2003 at 10:45 pm
  • Hello, Vacuum analyze is taking a really long time on a fairly small table and during the time the vacuum is running all "select * from <the table ;" seems to hang untill the vacuum is done. Any help ...
    Joe MaldonadoJoe Maldonado
    Jul 15, 2003 at 8:09 pm
    Jul 17, 2003 at 5:51 pm
  • I define an SQL function: CREATE FUNCTION foo(timestamptz) AS ' ...' LANGUAGE 'SQL'; Does the plan for the body get built at creation or execution time? I could have sworn it was execution time, but ...
    Richard HuxtonRichard Huxton
    Jul 7, 2003 at 9:03 pm
    Jul 8, 2003 at 7:01 pm
  • Hy, I am trying to enter 19.00 in a float field... no error but the data (select) is showing 19 without the "trailing" zeros... But for format and standard presentation of money, I need to keep any ...
    MarkMark
    Jul 3, 2003 at 7:42 pm
    Jul 6, 2003 at 7:33 am
  • Hello, I have an attribute in a table which stores hexadecimal numbers as a two-character string, i.e. the attr definition is char(2). Now I need to display these values in decimal, but I wasn´t able ...
    Claudio LapidusClaudio Lapidus
    Jul 30, 2003 at 7:49 pm
    Jul 31, 2003 at 5:44 am
  • All: I don't remember I even seen a document saying PostgreSQL are case sensitive. I just figure out that my column name are case sensitive. Is there any way that I can turn it off or force the ...
    Terence ChangTerence Chang
    Jul 24, 2003 at 11:34 pm
    Jul 25, 2003 at 2:53 pm
  • Have an Access 97 database being migrated to Postgres 7.3.3. Access 97 clients will query and write to the Postgres database across a WAN via ODBC. A few questions: 1) How does one pass a record from ...
    RaymondRaymond
    Jul 18, 2003 at 3:50 am
    Jul 18, 2003 at 10:50 pm
  • Hi, I've run in to this problem with a database we are working. When I restore a database schema, I need to restore the schema 5 times to ensure that the schema is complete. Also some of the ...
    Timothy BrierTimothy Brier
    Jul 9, 2003 at 2:16 am
    Jul 9, 2003 at 11:31 am
  • Oops forgot to CC the list.
    Vincent HikidaVincent Hikida
    Jul 13, 2003 at 5:13 pm
    Jul 25, 2003 at 4:29 am
  • So I have to adjust a primary key by adding one to every existing record. Obviously this isn't a routine operation, my data model isn't that messed up. It's a one-time manual operation. However when ...
    Greg StarkGreg Stark
    Jul 24, 2003 at 4:26 pm
    Jul 24, 2003 at 8:43 pm
  • Hi all, I am trying to convert a timestamp field to a date. ('1993-08-10 17:48:41.074' to '1993-08-10'). I used date(TIMESTAMP_FIELD), but it seemed working only for date after year 2000 and return ...
    ShuaiShuai
    Jul 23, 2003 at 5:36 pm
    Jul 24, 2003 at 12:31 am
  • Hi Does anyone else find the site postgresql.org kinda unreliable? Many times it's stalled for a while. And it's not just today, but very often. It's really frustrating especially when I regularly ...
    Reuben D. BudiardjaReuben D. Budiardja
    Jul 1, 2003 at 10:01 pm
    Jul 2, 2003 at 3:06 am
  • We're about to buy a new server for dedicated Postgres serving. It'll be serving 4 - 10 databases (average dump size 20Gb) for various web applications. What is the list's advice on optimum ...
    Tom dysonTom dyson
    Jul 24, 2003 at 3:27 pm
    Aug 5, 2003 at 10:28 pm
  • In Postgresql 7.3, a datatype can be int, text, etc, and also pseudo-types like RECORD, any, etc. These pseudo types are mainly used in CREATE FUNCTIONs, but what if it's used in a CREATE TABLE, esp. ...
    Ang Chin HanAng Chin Han
    Jul 31, 2003 at 10:38 am
    Aug 2, 2003 at 2:35 am
  • I'm searching for projects that would serve as good PostgreSQL examples. In fact it would be nice to have a place on the PostgreSQL web page that featured some good examples. (If such a place exists ...
    Steve CrawfordSteve Crawford
    Jul 23, 2003 at 8:55 pm
    Jul 29, 2003 at 4:23 pm
  • I'm interested in producing a list of all sequence names and the corresponding last value. Starting with a list of sequence names generated by SELECT c.relname FROM pg_class c WHERE (c.relkind = ...
    BtoberBtober
    Jul 24, 2003 at 12:41 pm
    Jul 24, 2003 at 9:21 pm
  • Hi, Can anyone tell me what the limitations are regarding records? Say I have a table with 50 fields of 20 characters each. If a table can be 16 TB, how many records can it hold? If you all have any ...
    John BercikJohn Bercik
    Jul 15, 2003 at 1:45 pm
    Jul 21, 2003 at 9:44 pm
  • Is there a way to automagically execute a function at connect/disconnect? I was thinking about the possibility to have some kind of automatic cleanup when the client disconnects. I would like to: - ...
    Mattias KregertMattias Kregert
    Jul 3, 2003 at 3:31 pm
    Jul 20, 2003 at 6:31 pm
  • Can two postgresql processes (running in different machines) access and work with the same database files in a shared storage scenario? Would there be any problem? Thanks :)
    Jordi Sánchez LópezJordi Sánchez López
    Jul 17, 2003 at 12:59 pm
    Jul 18, 2003 at 5:04 pm
  • Hello, i'm evaluating Postgresql on win32 (winnt, win2k). I'm using a small java benchmark from FirstSQL (see attachments). I've ran the benchmark on three pc's 1) Pentium III 750 MHz Winnt Sp6a, 372 ...
    Markus HeinzMarkus Heinz
    Jul 17, 2003 at 12:04 pm
    Jul 17, 2003 at 11:29 pm
  • I'm trying to convince another open-source project (phpOpenTracker) to modify their current INSERT sql queries. Currently they just do an INSERT into a table without first checking if their might be ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Jul 2, 2003 at 5:16 am
    Jul 2, 2003 at 8:08 am
  • Hi, Still working on converting our schemas over to postgres from mysql, and trying to get the hang of the differences between the two products. I'm trying to figure out how to put comments in our ...
    Chad N. TindelChad N. Tindel
    Jul 24, 2003 at 4:36 am
    Aug 1, 2003 at 3:08 pm
Jul 2003
12345…8
Group Navigation
period‹ prev | Jul 2003 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions366
posts1,557
users347
websitepostgresql.org
irc#postgresql

347 users for July 2003

Tom Lane: 139 posts Scott.marlowe: 53 posts Dmitry Tkach: 46 posts Bruce Momjian: 43 posts Richard Huxton: 38 posts Shridhar Daithankar: 37 posts Andrew Sullivan: 34 posts Dennis Gearon: 32 posts Ron Johnson: 32 posts Alvaro Herrera Munoz: 31 posts Maksim Likharev: 31 posts Jean-Christian Imbeault: 27 posts Nolan: 25 posts Stephan Szabo: 25 posts Jonathan Bartlett: 21 posts Nigel J. Andrews: 17 posts Joe Conway: 16 posts Andrew Gould: 15 posts Bruno Wolff III: 15 posts Martijn van Oosterhout: 14 posts
show more
Archives