Re: [GENERAL] Linux v.s. Mac OS-X Performance

On Nov 27, 2007, at 8:36 PM, Gregory Stark wrote: I think (but I'm not sure) that the kernel in OSX comes from BSD. Kind of. Mach is still running underneath (and a lot of the app APIs use it directly) but there is a BSD 'personality' above it which (AIUI) is big parts of FreeBSD ported

Re: [GENERAL] Last modification time

Johan Vromans <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: >> Yeah, LISTEN/NOTIFY is definitely a lighter-weight solution--I didn't >> think of that before. > > LISTEN/NOTIFY looks like a synchronisation mechanism. You can notify

Re: [GENERAL] Last modification time

Philippe Ferreira <[EMAIL PROTECTED]> writes: >>Yeah, LISTEN/NOTIFY is definitely a lighter-weight solution--I didn't >>think of that before. >> >> > Hi, > > I'm interested too in using this method ! > > Can anyone give a simple example of how to use/implement it ? > Or good links to clear/quick d

Re: [GENERAL] Last modification time

Johan Vromans <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: > >> I would put an AFTER trigger on all the tables concerned that >> inserts a row into an audit table. [...] Audit tables are useful for >> other things too, if you can

Re: [GENERAL] Last modification time

Johan Vromans <[EMAIL PROTECTED]> writes: > Greetings, > > For a big application, I want to generate reports from the database and > keep these on-line as long as they reflect the actual contents of the > database. I only want to regenerate the reports when needed, i.e., > when the database conten

Re: [GENERAL] Sequences/defaults and pg_dump

Bruno Wolff III <[EMAIL PROTECTED]> writes: > On Tue, Feb 07, 2006 at 15:28:31 +0300, > Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: >> The real situation would be as the following. >> I want to use some algorithm to hide real number of registered users >> in my table user. So, I don't want to

Re: [GENERAL] plpgsql direct from C?

"James Harper" <[EMAIL PROTECTED]> writes: > Is there an API method to be able to execute pl/pgsql (or any other > language) code directly from C? > > Eg (please excuse the line wrapping, and the fact that this doesn't > represent a case where this would actually be useful!) > > result = PQexecPL(

Re: [GENERAL] Automating backup

Richard Sydney-Smith <[EMAIL PROTECTED]> writes: > pch := pchar('pg_dump -C -h '+host+' -U '+usr+' -p '+pswd+ ' -f > '+bckup_path+' '+dbase); > > to postgres. > > as the operator is obviously logged in how do I > (1) trap their user id > (2) Send the call to pg_dump without knowing their pas

Re: [GENERAL] PostgreSQL + hibernate

"Myatluk Andrey" <[EMAIL PROTECTED]> writes: > Hi, Chris! > > I've set the sequence owner to my database user. It hasn't changed > anything. > > I guess I have to connect through psql as user and then see what > happens. > If it fails, what could be my next step? That would depend on the error me

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Tue, 31 Jan 2006, Devrim GUNDUZ wrote: > >> On my RHEL boxes, I do never ever recompile the kernel since Red Hat >> does not provide support if I do so :) > > Is everything 'loadable modules' then? I can't imagine you have some > mammoth kernel

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote: > >> What value does this bring to systems that have a good package system >> and up-to-date repositories? I can install Postgres today on Ubuntu >> using a GUI tool

Re: [GENERAL] New project launched : PostgreSQL GUI Installer for

Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > http://pgfoundry.org/projects/pgnixinstaller/ > > We are actively looking for developers for the project. Please drop me > an e-mail if you want to join this project. We will use Python, so you > need to be a Python guy to join the project. We are in pla

Re: [GENERAL] How to change the default database for a user

Alexander Farber <[EMAIL PROTECTED]> writes: > but I do specify the database username: > > h754814:afarber {109} psql --help | grep -w user > -U NAME database user name (default: "phpbb") > > h754814:afarber {110} psql -U punbb > psql: FATAL: database "phpbb" does not ex

Re: [GENERAL] How to change the default database for a user

Alexander Farber <[EMAIL PROTECTED]> writes: > Hello, > > I've created a user and a database both wrongly named "phpbb". > After that I have renamed both to "punbb" using "ALTER DATABASE" > and "ALTER USER". Now everything works fine, except I always > have to specify the database when connecting

Re: [GENERAL] Viewing Database Scheme

Rich Shepard <[EMAIL PROTECTED]> writes: > On Sat, 28 Jan 2006, Eric B. Ridge wrote: > >> Again, you can't use redirection via the psql prompt. But you can do it >> via your shell command line: >> $ psql -c "\dt" > xrms.tables > >Well, that doesn't seem to be working here, either: > > [EMAIL

Re: [GENERAL] Viewing Database Scheme

Rich Shepard <[EMAIL PROTECTED]> writes: >When installing the application I specified the database name as 'contacts' > (not very innovative or clever, but descriptive). When I open the database > with 'psql contacts' and ask to have the tables dumped (with \d), they go > streaming by on the d

Re: [GENERAL] Are rules transaction safe?

Oliver Fürst <[EMAIL PROTECTED]> writes: > But is nowhere stated if (multiple) commands inside a rule are treated > as an implicit transaction as a whole. If you don't specifically open a transaction at the top level (i.e. in 'psql' or SQL from your application's code), PG will encapsulate every

Re: [GENERAL] Are rules transaction safe?

Oliver Fürst <[EMAIL PROTECTED]> writes: > Basically I'm worried that the whole "relying on the last value of a > sequence" isn't such a great idea. 'currval()' is specifically written to Do The Right Thing. See the docs. -Doug ---(end of broadcast)-

Re: [GENERAL] Are rules transaction safe?

Oliver Fürst <[EMAIL PROTECTED]> writes: > Hi all, > > I have a question regarding rules on views. Are the commands inside a > ON INSERT (or UPDATE) DO INSTEAD (implicit) transactions for postgres? > I tried to put BEGIN; and COMMIT; around the commands in a ON ... DO > INSTEAD ( ) block, but keep

Re: [GENERAL] Accessing an old database from a new OS installation.

"A. Kretschmer" <[EMAIL PROTECTED]> writes: > am 27.01.2006, um 14:21:31 + mailte Matthew Henderson folgendes: >> Okay, so if I have 7.4 installed and I have the old >> harddisk mount under /mnt/hda can I do something >> like >> >> pg_dump /mnt/hda/path_to_old_database > dump.txt > > No,

Re: [GENERAL] Access Problem After Version Upgrade -- FIXED

Rich Shepard <[EMAIL PROTECTED]> writes: > On Thu, 26 Jan 2006, Joshua D. Drake wrote: > >> Although I am glad you were able to get up and running, typically you don't >> want to "move" libs like that. Instead update your /etc/ld.so.conf and run >> ldconfig. > >True, Josh. What I'd prefer to d

Re: [GENERAL] Access Problem After Version Upgrade -- Update

Rich Shepard <[EMAIL PROTECTED]> writes: >So, now I can see the tables in the various databases, but SQL-Ledger still > cannot: > > Internal Server Error > The server encountered an internal error or misconfiguration and was unable > to complete your request. > >How do I get this fixed, pl

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

Patrick Hatcher <[EMAIL PROTECTED]> writes: > Here is the trigger the way it is currently written. I add some additional > information from another table: If you're modifying each row before it goes in, it should definitely be a FOR EACH ROW trigger. -Doug ---(end of br

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

Patrick Hatcher <[EMAIL PROTECTED]> writes: > Attempting to do my first trigger and I'm confused about which FOR EACH I > should use: ROW or STATEMENT. I import about 80K rows into an existing > table each day. If I do a STATEMENT, will the changes only happen on the > new 80K rows I inserted or

Re: [GENERAL] Postgresql Segfault in 8.1

Benjamin Smith <[EMAIL PROTECTED]> writes: > in /var/log/messages, I see > > Jan 24 17:00:04 kepler kernel: postmaster[26185]: segfault at > 2516d728 > rip 0043c82c rsp 007fbfffddd0 error 4 > > The insert statement is long, but doesn't seem to violate anything strange - > n

Re: [GENERAL] numeric data type?

Zlatko Matić <[EMAIL PROTECTED]> writes: > So, it seems that numeric without parameters (precision, scale) behave > similar to float, but is much exact. Am I right or I missunderstood? Right. It's also considerably slower, since floating point calculations can use the hardware. Unless you're do

Re: [GENERAL] Page-Level Encryption

David Blewett <[EMAIL PROTECTED]> writes: > In reading the documentation of Peter Gutmann's Cryptlib, I came > across this section: > "The use of crypto devices can also complicate key management, since > keys generated or loaded into the device usually can't be extracted > again afterwards. This

Re: [GENERAL] sequences not restoring properly

Brian Dimeler <[EMAIL PROTECTED]> writes: > I'm trying to transition a database from one server to another, the > old one running Postgres 7.4.1 and the new, 8.1.1. When I try to > restore using a pg_dump plaintext sql file from a nightly backup via > the usual > > psql thedb < backup.sql The bes

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >Using the 8.1.2 pg_dumpall from the 2004 data directory produces a 819K > file. But, when I then cd to the new data directory and run: > > [EMAIL PROTECTED]:/var/lib/pgsql/data$ pg_restore /var/tmp/backup.sql > pg_restore: [archiver] input file does no

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >Well, so much for the book. It did seem to be rather sparse on the upgrade. > Hmmm-m-m. Wonder what is the most efficient way to get going again. Think > I'll try the 'pg_dumpall -format=c' from the old directory and see if there's > a new file there.

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: > On Thu, 19 Jan 2006, Doug McNaught wrote: > >> Did you tell pg_restore to read from a file? Otherwise it will try to read >> from your terminal, which probably isn't what you want. > > Doug, > >No, I didn&

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >7) back to /usr/local/pgsql; as postgres ran 'pg_restore' >8) I see nothing in the virtual terminal. The cursor sits on the following > line. Did you tell pg_restore to read from a file? Otherwise it will try to read from your terminal, which pro

Re: [GENERAL] mount -o async - is it safe?

Shane Wright <[EMAIL PROTECTED]> writes: > Actually I thought that *all* the database had to have fsync() work > correctly; > not for integrity on failed transactions, but to maintain integrity during > checkpointing as well. But I could well be wrong! I think you're write, but what I was thi

Re: [GENERAL] Insert a default timestamp when nothing given

Martijn van Oosterhout writes: > Not directly. I suppose you could create a view that converted the > value to the right date on insert. I think a trigger might make more sense. -Doug ---(end of broadcast)--- TIP 9: In versions below 8.0, the pla

Re: [GENERAL] mount -o async - is it safe?

Martijn van Oosterhout writes: > That depends. As long as the data is appropriately sync()ed when > PostgreSQL asks, it should be fine. However, from reading the manpage > it's not clear if fsync() still works when mounted -o async. > > If -o async means "all I/O is asyncronous except stuff expl

Re: [GENERAL] bigger blob rows?

Eric Davies <[EMAIL PROTECTED]> writes: >Back in the days of 7.4.2, we tried storing large blobs (1GB+) in >postgres but found them too slow because the blob was being chopped >into 2K rows stored in some other table. >However, it has occurred to us that if it was possible to conf

Re: [GENERAL] Moving PostgreSQL data directory on Windows

Doug McNaught <[EMAIL PROTECTED]> writes: > Dumb question, but are you sure you exported the PGDATA variable? Is > it pointing to the directory that actually contains postgresql.conf? > > If you still have problems, post the exact error message that appears > in the logs. D

Re: [GENERAL] Moving PostgreSQL data directory on Windows

Ottó Havasvölgyi <[EMAIL PROTECTED]> writes: > Hello, > > I would like to move the data directory to another location. I have done this: > 1. Stop PostgreSQL > 2. Move data directory > 3. Create a PGDATA env. variable to the new location > 4. Start PostgreSQL > > And it cannot start, because it ca

Re: [GENERAL] Plans for 8.2?

Jeff Trout <[EMAIL PROTECTED]> writes: > Isn't the [expensive db name here]'s replication/failover just an > expensive addon? > As in if you don't pay for it you don't get it. > > So we're basically in the same boat as them.. just an add on. we just > offer more variety. Well, [cheap and crappy o

Re: [GENERAL] (Select *) vs. (Select id) from table.

Scott Ribe <[EMAIL PROTECTED]> writes: >> The time the DB needs to find the record >> should be the same since the record has to be found before the resultset is >> assembled. > > What if the query can be satisfied from an index? I don't know if PostgreSQL > has this kind of optimization or not.

Re: [GENERAL] PGError: server closed the connection unexpectedly

Dave Steinberg <[EMAIL PROTECTED]> writes: >> You're not using the same PG connection from two different threads, or >> fork()ing and trying to use the same connection in the parent and the >> child, or anything like that? > > Aha! In the ruby code, I am forking! I'll make the child reconnect >

Re: [GENERAL] PGError: server closed the connection unexpectedly

Dave Steinberg <[EMAIL PROTECTED]> writes: >>>My biggest problem is the lack of any real error message on the server. >>>I don't see anything wrong in the system logs, and there's no core >>> file in the /var/postgresql directory. >> Are you sure core files are enabled; i.e. the server is runn

Re: [GENERAL] PGError: server closed the connection unexpectedly

Dave Steinberg <[EMAIL PROTECTED]> writes: > My biggest problem is the lack of any real error message on the server. > I don't see anything wrong in the system logs, and there's no core > file in the /var/postgresql directory. Are you sure core files are enabled; i.e. the server is running w

Re: [GENERAL] Moving Tablespaces

Allen Fair <[EMAIL PROTECTED]> writes: > Our databases can get large and we want to find the best way to plan for > when a database outgrows its current server. > > How about a replication scheme and cutover? If so, is there a preferred > replication package to support this? Slony-I was designed

Re: [GENERAL] storing PDFs

Leonel Nunez <[EMAIL PROTECTED]> writes: > You can use ByteA but the size will be about 4 times bigger Are you sure? The intermediate form for bytea (escaped single-quoted strings) is pretty inefficient, but once in the database the data is stored as binary and can even be compressed. Plus

Re: [GENERAL] restarting after power outage

"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes: > Is this just me or did anyone actually think about adding a UPS to > the machine and monitor it with NUT ? That way the machine would > shut down properly, making the whole stale pid-file issue > irrelevant. UPSs fail. People kick out power cords

Re: [GENERAL] restarting after power outage

Tom Lane <[EMAIL PROTECTED]> writes: > Jon Lapham <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> It is. We have been fooling with the postmaster startup logic to try to >>> eliminate this gotcha, but it's only very recently (8.0.2) that I think >>> we got it right. > >> So, then it would be c

Re: [GENERAL] [HACKERS] plPHP in core?

Robert Treat <[EMAIL PROTECTED]> writes: > If by "stripped down" you mean without postgresql database support then > I'll grant you that, but it is no different than other any other pl > whose parent language requires postgresql to be installed. If packagers > are able to handle those languages t

Re: [GENERAL] Upgrade data

josue <[EMAIL PROTECTED]> writes: > I did a pg_dumpall and this sentence to restore it back > > ./psql template1 -U postgres -p 9981 < /home2/tmp/dbtest.tar You need to use 'pg_restore' for tar format dumps. -Doug ---(end of broadcast)--- TIP 3: i

Re: [GENERAL] libpq usage in Samba

Fernando Schapachnik <[EMAIL PROTECTED]> writes: > I'm trying to figure out why Samba is failing at high loads if using > Postgres as a backend (7.3.9 in my setup). On startup in makes one > connection only against the database which is shared among all the > Samba processes. In turn, each issue a

Re: [GENERAL] Problem connecting to postmaster

Glenn Sullivan <[EMAIL PROTECTED]> writes: > Hi, > > I have installed native postgresql8.0.1 on a PC running Windows XP > professional. > I am having trouble connecting to it from my application. The application > is a combination of java and C++ which was developed on Sun Solaris (Unix). > Thus

Re: [GENERAL] prelimiary performance comparison pgsql vs mysql

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: >> Also, a 32-bit machine can only hold so much RAM. If I'm correct, there >> are ways to address more memory than that on a 32 bit machine, but I >> wonder at what cost? In other words, is it a good idea to address more >> than 4GB on a 32 bit machine

Re: [GENERAL] Referencing created tables fails with message that

Tommy Svensson <[EMAIL PROTECTED]> writes: > I have just installed Postgresql and tried it for the first time. > > One very serious problem I ran into was when actually trying to use > created tables. > Creating a simple table without any foreign keys works OK, but after > creating the > table it

Re: [GENERAL] PGSQL 8.0.1 Win 2K Installation Problem

John DeSoi <[EMAIL PROTECTED]> writes: > On Feb 19, 2005, at 2:14 PM, S.D. wrote: > >> I downloaded the PostGreSQL Windows installer from another FTP site >> but I still ended up with the same arcane error message when I tried >> to install PostGreSQL 8.0.1 on W2K running inside Virtual PC 6 >> (M

Re: [GENERAL] Update command too slow

Venkatesh Babu <[EMAIL PROTECTED]> writes: > Hello, > > Thanks for providing info... I tried disabling > autocommit, as suggested by Mr. Greg Stark, I tried > issuing the command "set autocommit to off", but got > the following error message: > > ERROR: SET AUTOCOMMIT TO OFF is no longer supporte

Re: [GENERAL] Introducing the future Debian

Martin, This looks really good. I wish it were going into Sarge, though of course the timing isn't right for that. :) A couple things I noticed about the automated upgrade procedure (pg_version_upgrade): 1) Since it uses pg_dumpall, it doesn't seem to be capable of handling databases with l

Re: [GENERAL] postmaster listening on specified addresses

Administrator <[EMAIL PROTECTED]> writes: > Hello, > > I was wondering if there's a correct method for running postmaster > with the option of listening on a select group of addresses. Does > postmaster accept multiple "-h hostname" options on the command-line, > or alternatively a comma-separate

Re: [GENERAL] Adding UNIQUE constraint on NULL column

Dave Smith <[EMAIL PROTECTED]> writes: > On Thu, 2005-01-13 at 10:12, Doug McNaught wrote: >> Are you really saying that you want 'NULL = NULL' to return 't'? > Yes Well, that's not how NULL works. -Doug ---(end of broadcast

Re: [GENERAL] Adding UNIQUE constraint on NULL column

Dave Smith <[EMAIL PROTECTED]> writes: > I am trying to add a unique constraint on a column that can be null. The > documentation states that null is treated as non equal values but I want > them to be equal. Is there another way of doing this other than writing > a before insert trigger? UNIQUE

Re: [GENERAL] Shared disk

Nageshwar Rao <[EMAIL PROTECTED]> writes: >Hi, > >I would like to use shared disk for two Postgresql database. I mean >that two Postgresql Database point to same $PGDATA directory. Is this >possible in Postgresql Clarification is appreciated. No, this is not possible. You may wan

Re: [GENERAL] Natural ordering in postgresql? Does it exist?

"Clark Endrizzi" <[EMAIL PROTECTED]> writes: > Hi all, > I have a field that I'll be ordering and I noticed that ordering is > done logically and would confuse my users here (1,12,16,4,8, etc). Sounds like you're storing a number in a text field. Numeric fields sort in numerical order. -Doug

Re: [GENERAL] Postgres not using shared memory

"Karl O. Pinc" <[EMAIL PROTECTED]> writes: > Hi, > > I can't seem to get postgresql to use shared memory and performance is > terrrible. 1) Linux doesn't track shared pages (which is not the same as shared memory) anymore--the field the in 'free' output is just there to avoid breaking softw

Re: [GENERAL] Network authentication

Bob Parnes <[EMAIL PROTECTED]> writes: > I am having trouble connecting to a database on a debian server from a > client system, also debian. Acccording to the documentation, this is > possible without a password and offers the following example, > > hosttemplate1 all 192.168.93.0

Re: [GENERAL] SSL confirmation

Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sun, Dec 05, 2004 at 09:10:42PM +, Andrew M wrote: > >> The map i make reference to is a Jboss map used to make a jndi >> connection to postgreSQL. What document do I need to access to get hold >> of the envireonment variables, namely PGSSLMODE?

Re: [GENERAL] Dont let those int8's drive you mad!!

Jeff Amiel <[EMAIL PROTECTED]> writes: > If postgres knows the field is an int8, why do I have to cast it in my query? This is fixed in 8.0. -Doug ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] general questions on Postgresql and deployment on

Calvin Wood <[EMAIL PROTECTED]> writes: > symbolic link. But on win32, there is no equivalent. However, even under > *nix system, I believe symbolic link can only be created for directories on > the same hard drive. This seems less than optimal. Typically, one would > place database files on RA

Re: [GENERAL] relation does not exist error

Simon Wittber <[EMAIL PROTECTED]> writes: > WMSDV=# \dt > List of relations > Schema | Name| Type | Owner > +---+---+--- > public | Customers | table | simon > public | Persons | table | simon > (2 rows) > > WMSDV=# select * from Customers; > ERROR: re

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists

"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > No, the poster will still be included as part of the headers ... what > happens, at least under Pine, is that I am prompted whther I want to > honor the reply-to, if I hit 'y', then the other headers *are* strip'd > and the mail is set right back to

Re: [GENERAL] Moving/Using Postgres Binaries on multiple machines

Francis Reed <[EMAIL PROTECTED]> writes: > If I want to create a postgres database on multiple machines, is the > practice of tarring or zipping up binaries compiled on one machine and > untarring them on another, and using the binaries (initdb etc) acceptable?. > This removes the need for having

Re: [GENERAL] Any equivalent of MSSQL Detach?

Kenneth Downs <[EMAIL PROTECTED]> writes: > I am wondering if it is possible to pick up a database from one computer and > move it over to another and then just plug it back in. No, unless you do the whole database cluster, and the two machines are the same architecture and have the same version

Re: [GENERAL] How to clear linux file cache?

Janning Vygen <[EMAIL PROTECTED]> writes: > So how do i easily empty all page/file caches on linux (2.4.24)? Probably the closest you can easily get is to put the Postgres data files on their own partition, and unmount/remount that partition before running yuour tests. Unmounting will sync and t

Re: [GENERAL] DROP DATABASE, but still there

Robert Fitzpatrick <[EMAIL PROTECTED]> writes: > What does it mean when you drop a database and then recreate with the > same name and all the objects are still there. I want to wipe out the db > and put back from pg_restore. After I re-create the db, all the old > tables are back before I run pg_

Re: [GENERAL] Transaction rollback - newbie

"A. Mous" <[EMAIL PROTECTED]> writes: > Hi, > > I've got clients connected to pgsql via ODBC. If they lose their connection > abruptly, all un-committed transactions are automatically rolled-back (I'm > assuming) but is there anything left behind that needs to be cleaned up on > the server side w

Re: [GENERAL] Reasoning behind process instead of thread based

[EMAIL PROTECTED] writes: > "The developers agree that multiple processes provide > more benefits (mostly in stability and robustness) than costs (more > connection startup costs). The startup costs are easily overcome by > using connection pooling. > " > > Please explain why it is more stable and

Re: [GENERAL] Importing a tab delimited text file - How?

Ken Tozier <[EMAIL PROTECTED]> writes: > I've been looking though the PostgreSQL documentation but can't seem > to find a command for importing files. I read the documentation > related to large objects but this isn't what I'm looking for as I > don't want to import the entire file into a single f

Re: [GENERAL] '1 year' = '360 days' ????

Tom Lane <[EMAIL PROTECTED]> writes: > "Ricardo Perez Lopez" <[EMAIL PROTECTED]> writes: >> I have observed that, for PostgreSQL, one year is actually 360 days: > >> SELECT '1 year'::timestamp = '360 days'::timestamp; > >> ?column? >> - >> t > > Nonsense. > > regression=# SELECT '1

Re: [GENERAL] OID's

Eddy Macnaghten <[EMAIL PROTECTED]> writes: > The other thing to be aware of is if a large number of people are > writing to the database concurrently it can go wrong (any method). That > is if you insert a record (using nextval for the sequence), then someone > else quickly inserts a row too bef

Re: [GENERAL] How to increase number of connections to 7.2.1

Edwin New <[EMAIL PROTECTED]> writes: >I need to increase the number of connections to PostgreSQL 7.2.1. > > >I have tried changing the value of max_connections in >Postgresql.conf. It was commented out (as are all other entries >except "tcpip_socket = true"). Setting it to any o

Re: [GENERAL] dealing with invalid date

Mage <[EMAIL PROTECTED]> writes: > Hi, > > can pgsql acceppt invalid date values? Sometimes it would be nice to > convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically > instead of throwing back an error message. If you want MySQL, you know where to find it. -Doug -- Let us

Re: [GENERAL] Message-ID as unique key?

Jerry LeVan <[EMAIL PROTECTED]> writes: > Hi, > I am futzing around with Andrew Stuarts "Catchmail" program > that stores emails into a postgresql database. > > I want to avoid inserting the same email more than once... > (pieces of the email actually get emplaced into several > tables). > > Is

Re: [GENERAL] Help on copy function

Tom Lane <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> writes: >> It's also possible that PG is trying to create a new table file and >> he's out of inodes... > > Good thought, although I think that this particular error message woul

Re: [GENERAL] Help on copy function

Tom Lane <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] writes: >> And an error occurs : >> psql:lineitem.loader.psql:1: ERROR: could not extend relation >> 24342131/24342133 >> /24342324: There is not enough space in the file system. >> HINT: Check free disk space. > >> but my fileSystem has s

Re: [GENERAL] default select ordering

Matt Roberts <[EMAIL PROTECTED]> writes: > Please accept my apologies if this is answered elsewhere in the archives > or docs but I have searched without luck. > > I've always assumed that default ordering of selects are based on a first > in first out principle and that this remains true at the r

Re: [GENERAL] newby question

Scott Frankel <[EMAIL PROTECTED]> writes: > Additional note: configure warned of an old version of bison when I > attempted an install of postgresql7.4.5 the other day. Seems the > version > that comes with OSX 10.3.x is too old for postgres. You only actually need Bison if you are building fro

Re: [GENERAL] Custom Functions

Matthew Metnetsky <[EMAIL PROTECTED]> writes: > On Tue, 2004-09-28 at 10:55, Katsaros Kwn/nos wrote: >> > So, does anyone know of (or have) good examples of queries within >> > functions (and returning sets of data)? >> >> I'm not very experienced in PostgreSQL but maybe SPI functions is what you

Re: [GENERAL] To OID or not to OID

"David Parker" <[EMAIL PROTECTED]> writes: > Is there any concrete reason NOT to create tables WITHOUT OIDS? We are > going to have some very large tables in our app, so saving the space and > not worrying about int-wrap seems like a good idea, but I'm worried that > I'm missing something. Nothin

Re: [GENERAL] serial data type

Joseph Healy <[EMAIL PROTECTED]> writes: > On Sat, Sep 25, 2004 at 07:20:23PM -0400, Tom Allison wrote: >> >> Any idea how to set up a timestamp=now on every insert/update ? > > when you create your table, use: > > create table mytable ( > id serial primary key, > updated timestamp d

Re: [GENERAL] serial data type

Tom Allison <[EMAIL PROTECTED]> writes: > Doug McNaught wrote: >>>Is it realistic to use the serial data type as a KEY? >> Lots and lots of people do. If you're just looking for a unique key >> column for a single table, it works fine. >> -Doug >

Re: [GENERAL] serial data type

Tom Allison <[EMAIL PROTECTED]> writes: > Can I use the serial data type in lieu of an 'auto_number' field? What are the exact semantics of an "auto_number" field? > I asked something like this some months ago and it seems that > auto_number fields were addressed through a combination of trigger

Re: [GENERAL] Oracle / Postgres Interface

"Shah, Sameer" <[EMAIL PROTECTED]> writes: > 1. I have DataBase-A which is Oracle on Server A with FunctionA >(PLSQL) > 2. I have DataBase-B which is Postgress on Server B with FunctionB >(PgSQL) > 3. I need to call FunctionA from FunctionB As far as I know, the on'y w

Re: [GENERAL] abnormal data grow

Reynard Hilman <[EMAIL PROTECTED]> writes: > Hi, > > I have been having this problem where the database size suddenly grows > from the normal size of about 300Mb to 12Gb in one night. > When I look up the table size, the biggest one is only 41Mb and the > total of all table size is only 223Mb. > B

Re: [GENERAL] Can't connect to Windows port + other

"Anony Mous" <[EMAIL PROTECTED]> writes: > A few days ago there was a fellow that had trouble connecting remotely to > the 8.0 beta win port. I had the same problem, but have since found the > solution. In postgresql.conf file, ensure the line "listen_addresses" is > set to '*', ie, > > listen_a

Re: [GENERAL] Change config of running PGSQL

"McDougall, Marshall (FSH)" <[EMAIL PROTECTED]> writes: > I made sure that readline was indeed installed to no avail. The configure > still does not see the libs. Any ideas? You don't say what system you're on, but most Linux distributions split library packages like readline into 'runtime' and

Re: [GENERAL] Change config of running PGSQL

"McDougall, Marshall (FSH)" <[EMAIL PROTECTED]> writes: > I have an existing installation of 7.3.4 that appears to have been made with > "--without-readline and --without-zlib" parameters used at build time. How > do I change those parms without reinstalling the whole thing. I would > normally

Re: [GENERAL] upgrading minor versions

Jeff Amiel <[EMAIL PROTECTED]> writes: > So I downloaded postgresql-7.4.5.tar.gz > > uncompressed... > configure... > make > make install > > I run psql and it gives me the" Welcome to psql 7.4.5, the PostgreSQL > intera

Re: [GENERAL] Problem to connect to the Windows Port

Tom Lane <[EMAIL PROTECTED]> writes: > "Cornelia Boenigk" <[EMAIL PROTECTED]> writes: >> C:\>psql -h 192.168.1.8 -U postgres -d minitest >> psql: could not connect to server: Connection refused >> Is the server running on host "192.168.1.8" and accepting >> TCP/IP connections on po

Re: [GENERAL] COPY not handling BLOBs

Jan Wieck <[EMAIL PROTECTED]> writes: > On 8/4/2004 1:58 PM, David Rysdam wrote: > >> bytea will only go up to "several thousand bytes" according to the >> docs. I assume it's not very precise because the maximum is 8196 - >> $other_fields_in_row. My binary data could be a couple times that >> o

Re: [GENERAL] Question about linux filesystem and psql

Marcus Wegner <[EMAIL PROTECTED]> writes: > Is it possible to keep data safe with linux and psql after crash? > > The short description of the scenario is: > -> writing data with psql (using transactions), store process completed > -> user hits the reset button or kernel crashes (whatever left the

Re: [GENERAL] altering a table to set serial function

Prabu Subroto <[EMAIL PROTECTED]> writes: > If I read your suggestion, that means...I have drop > the column "salesid" and re-create the column > "salesid". and it means, I will the data in the > current "salesid" column. > > Do you have further suggestion? You can do it "by hand" without droppin

Re: [GENERAL] Insert images through ASP

"Dylan Milks" <[EMAIL PROTECTED]> writes: > What I want to do is upload an image from an ASP page and insert it > into a table. I don't want to store the image on the file system, > even if it's only temporary. Well, if you want to use bytea, you'll need to load the whole image into memory, bytea

  1   2   3   >