Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 06:39:25PM -0600, Jim C. Nasby wrote: > > If you do manage to write a function that will do this I hope you can > share it with the community. IMHO PostgreSQL could do with more > functions for querying the system catalogs. Here's a first attempt at a view that shows table

[GENERAL] Bogus subscription instructions on website

Found at http://archives.postgresql.org/pgsql-general/ If you hate getting many mail messages per day then you should consider a digest (where you receive multiple messages to the list as one message to you). To subscribe or unsubscribe from the digested list, send mail to [EMAIL PROTECTED]

Re: [GENERAL] speaks psql unicode?

On Jan 10, 2005, at 10:20 AM, Thomas Chille wrote: if i try to import data via SQL-Inserts (exported with pgManager) out from an utf-8 file i get always parse errors in the first line. After switching to ascii and using of SET client_encoding TO 'latin1' i can import all lines, but some unicode-cha

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

"Frank D. Engel, Jr." <[EMAIL PROTECTED]> writes: > Yep, that could cause problems. Okay, now I'm joining the program. > > The only thing I can see that would fix this > ... There are well understood mechanisms to fix this. It's a "SMOP" or "simple matter of programming". What you would do is

Re: [GENERAL] Problems with a trigger

Perhaps you need to do a FOR EACH ROW trigger? If that doesn't solve it, I need more details. Regards, Jeff On Thu, 2005-01-13 at 15:03 +0200, Valentin Militaru wrote: > Hi! > I have a problem with an AFTER INSERT row-based trigger. It returns > <>. Any ideas? > > Thanks! > Valentin Mi

Re: [GENERAL] Open Source Database Opportunity

You might try searching the mailing list archives. On Fri, Jan 14, 2005 at 03:05:07PM +0100, TOUBLANC Christophe wrote: > Hello all > > I am looking for a survey which compares functionalities of the 3 following > databases : Oracle, Mysql and PostreSQL > Do somebody could send me some link or so

Re: [GENERAL] Open Source Database Opportunity

Title: Open Source Database Opportunity A web search turned this stuff up: http://www.linuxlinks.com/local/business/databases.shtml http://www.3asoft.com/article/10210.html http://www.eweek.com/article2/0,1759,1433850,00.asp   I am sure you can find plenty more with a few well directed

[GENERAL] Problems with a trigger

Hi! I have a problem with an AFTER INSERT row-based trigger. It returns <>. Any ideas? Thanks! Valentin Militaru [EMAIL PROTECTED] SC Telcor Communications SRL Tel. fix: 0316900015 Fax: 031691 Telefon mobil: 0741168267 <>

Re: [GENERAL] Benchmarks

You might find something useful here: http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Tenorio Avila Sent: Monday, January 10, 2005 9:09 PM To: pgsql-general@postgresql.org Subject:

[GENERAL] Open Source Database Opportunity

Title: Open Source Database Opportunity Hello all I am looking for a survey which compares functionalities of the 3 following databases : Oracle, Mysql and PostreSQL Do somebody could send me some link or some documentation about this Thanks Regards Christophe TOUBLANC Architecture Tec

Re: [GENERAL] PostgreSQL 8 on windows very slow

What queries are you running? What sort of a machine are the database systems running on? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of lol Sent: Tuesday, January 11, 2005 6:47 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL 8 on wi

[GENERAL] to_char(interval, text) deprecated in future - how do we get consistent interval output without it?

I saw the note in the docs that to_char(interval, text) is deprecated, and will be removed. I searched the archives and saw more mentions of this, but no real explanation as to how it is planned for us to get consistent output formatting when querying a column containing interval data. For exampl

[GENERAL] PostGreSQL on Access Report

I'm nearing the end of my PostGreSQL migration from Access/Access to Access/PostGreSQL and I wanted to let everyone know how it is going. 1) ADO and access do not go well together, at least not in access 2000. Recordsets are not updatable, the internal access sort and filter functions work sporadic

Re: [GENERAL] PostgreSQL 8 on windows very slow

I have tried RC4, but there's no differences My results using my configuration are : MySQL 4 is 6 times faster than pgSQL Firebird 1.5 is 3 times faster than pgSQL Are these results coherent ? May be the problem comes more from ZeosLib than pgSQL8 ---(end of broadcast)-

Re: [GENERAL] Function for retreiving datatype

Brendan, I have had similar problems and the way I resolve it is by running the SQL statement directly in PGAdmin and in the resultset it tells you what the field types are. For example. create or replace function test1(vara int, varb int) returns setof record as $$ declare row record; begin

[GENERAL] Benchmarks

Is there any benchmark of Postgres 8.00 comparing with previous versions and others DBMS?   Bruno

[GENERAL] speaks psql unicode?

Hi, if i try to import data via SQL-Inserts (exported with pgManager) out from an utf-8 file i get always parse errors in the first line. After switching to ascii and using of SET client_encoding TO 'latin1' i can import all lines, but some unicode-characters are, like expected, damaged. Now my

[GENERAL] PostgreSQL v7.3.6

Hi   Could you provide me with a link to where I can download v7.3.6 of PostgreSQL for win32, This is for some testing of mine, Thanks in advanced.   Jason

[GENERAL] serial increments on failed insert

Ive noticed what seems to be an odd effect in psql 7.3. It works like this: 1> Create a table: CREATE TABLE foo ( sval serial, uval int UNIQUE ); 2> Run 3 inserts, the second of which fails because it fails the unique constraint: INSERT INTO foo VALUES (DEFAULT,1); INSERT INTO foo VALUES (D

[GENERAL] StartTransact back at Debug2 in v8?

Dear Gurus, Please point me to the right way to find the answer, if it's already answered, and forward the mail to the right list if I missed. Also, please CC: answers to me, since I'm unsure if I'm subscribed to the list right now... ;) In v7.3, our logfiles got bloated by Start/CommitTransacti

Re: [GENERAL] Books for experienced DB developer

Tino, Multiple recordsets means returning multiple setof results, not just one. As an example in a SQL Server Stored Procedure you can have the following in the same stored procedure: create proc getdata as select * from table1 select * from table2 go and it will return 2 resultsets. This is not p

Re: [GENERAL] PostgreSQL 8 on windows very slow

I use zeoslib 6.1.5 for Delphi 7. I have also tried 6.5.1-alpha. It's faster (especially with firebird). I will take a look at dbExpress. Thank you. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] PYTHON, ODBC

thanks for the advice, matt On Sun, 09 Jan 2005 20:47:08 +0100, Pierre-Frédéric Caillaud <[EMAIL PROTECTED]> wrote: > > > > due to the complicated nature of the database, and inability of zope > > Well, I've found that Zope is very good to do a few things, and very > bad > at the res

[GENERAL] PostgreSQL 8 on windows very slow

Hi, I'm currently testing several databases for an application written in Delphi 7. I use zeos lib to access PostreSQL8-RC1 on MS-Windows 2000 SP4. PostrgreSQL is extremly slow, with a lot of disk access on INSERT request. Have-you seen this problem ? May be some parameters should be adjusted. Wha

Re: [GENERAL] pgpool

> John Cunningham wrote: > > concerned that if I drop the number of connections to less than the > > number of databases I have, that pgpool would open the limit of > > connections, hold them open and not allow any connections to the > > remaining databases. Is this a concern? If I set up pgpool

Re: [GENERAL] PYTHON, ODBC

we won't be using any tools aside from psycho pg, no gui application frameworks, ie we're not using zope, ruby on rails, etc. The front end will only work for this particular database. This has come about due to the complicated nature of the database, and inability of zope to do what we need, and

Re: [GENERAL] serial increments on failed insert

On Fri, Jan 14, 2005 at 04:57:19PM -0800, David Kammer wrote: > Notice that even though the second insert failed, it still incremented > the serial value. This seems counter intuative to the way that serial > should work. Is this truly a bug, or is there a good work around? See the "Sequence

Re: [GENERAL] serial increments on failed insert

On Fri, Jan 14, 2005 at 04:57:19PM -0800, David Kammer wrote: > Notice that even though the second insert failed, it still incremented > the serial value. This seems counter intuative to the way that serial > should work. Is this truly a bug, or is there a good work around? That's correct, do

Re: [GENERAL] serial increments on failed insert

David Kammer <[EMAIL PROTECTED]> writes: > Notice that even though the second insert failed, it still incremented > the serial value. This seems counter intuative to the way that serial > should work. Is this truly a bug, No. nextval() calls never roll back; see the documentation. > is there

[GENERAL] serial increments on failed insert

I've noticed what seems to be an odd effect in psql 7.3. It works like this: 1> Create a table: CREATE TABLE foo ( sval serial, uval int UNIQUE ); 2> Run 3 inserts, the second of which fails because it fails the unique constraint: INSERT INTO foo VALUES (DEFAULT,1); INSERT INTO foo VALUES (D

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 05:10:10PM -0300, Alvaro Herrera wrote: > On Fri, Jan 14, 2005 at 12:20:50PM -0700, Michael Fuhr wrote: > > On Fri, Jan 14, 2005 at 07:44:18PM +0100, Bo Lorentsen wrote: > > > Alvaro Herrera wrote: > > > > > > >You can create a function to get the sequence name attached to

Re: [GENERAL] MOVE

Use an after inset trigger. Well I did the reverse, an after delete trigger on the live table which inserts the deleted row in the history table, and it works very well. Thanks. ---(end of broadcast)--- TIP 9: the planner will ignore your desire

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

On 1/14/05 5:37 PM, "Martijn van Oosterhout" wrote: > If that's all you want, what about the row estimate from pg_class? It > has the number of rows active at last vacuum... For really large tables > I imagine it'd be easily close enough... For showing the changes in a given day (or even week),

Re: [GENERAL] MOVE

BEGIN; INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...; DELETE FROM active WHERE user_id = ...; COMMIT; The DELETE can only delete the rows returned by the select, that's the whole point of transactions... Well, in the case of having a unique index on user_id, and if no-one

Re: [GENERAL] Parsing of backslash in statements via ODBC

Martijn van Oosterhout writes: > I'm not totally sure about how ODBC works, but if it's anything like > Perl DBI, surely it's the responsibility of the ODBC layer to escape > the baackslashes? Maybe it depends on whether they're using > placeholders or not... I suppose they are not using placehol

Re: [GENERAL] OID Usage

It's not very hard to do. I just got rid them. It took me about a day. Our application is an X-Windows front end written is C. I wrote a function to return the next value of the serial key for any table. Here is the select statement buitl with sprintf: "SELECT relname FROM pg_class WHERE relkind

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

On Fri, Jan 14, 2005 at 03:11:32PM -0800, Dann Corbit wrote: > A cardinality estimate function might be nice. > SELECT cardinality_estimate(table_name) > If it is off by 25% then no big deal. > It would be useful for the PostgreSQL query planner also, I imagine. If that's all you want, what about

Re: [GENERAL] Parsing of backslash in statements via ODBC

"Frank D. Engel, Jr." <[EMAIL PROTECTED]> writes: > Given that this issue is a violation of SQL compatibility, shouldn't > there really be an option to turn off interpretation of backslash > characters in string literals as escapes? Maybe as a session variable > of some kind, with a default bei

Re: [GENERAL] OID Usage

On Sat, Jan 15, 2005 at 12:06:41AM +0100, Bo Lorentsen wrote: > Ok, Tom told me about the same :-( But why are oid's still in PG, that > are they good for ? Will there be a real unique row id, like there is in > Oracle, or will this be keept as an internal value only ? Most system catalogs use

Re: [GENERAL] OID Usage

On Sat, Jan 15, 2005 at 12:06:41AM +0100, Bo Lorentsen wrote: > Martijn van Oosterhout wrote: > >It means using OIDs as you described has very well known problems and > >they will break on you eventually. You can mitigate the damage by > >creating a UNIQUE index on the oid column but you'd better b

Re: [GENERAL] ntfs for windows port rc5-2

I don't think that Windows isn't worth using some versions such as XP are quite stable for most purposes. By no means am I saying go put a production database server like Postgres or Oracle on it. SMB's (Small - to - Medium Businesses) may benefit from Windows 2000 if there aren't able to get so

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

A cardinality estimate function might be nice. SELECT cardinality_estimate(table_name) If it is off by 25% then no big deal. It would be useful for the PostgreSQL query planner also, I imagine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wes Sent: Frid

Re: [GENERAL] OID Usage

Michael Fuhr wrote: See the "System Catalogs" chapter in the documentation. Ok, I think I will compile all the given information in this thread, to make a new and more non oid'ish solution, as the dataset I manage are going to grow quite a lot :-) If you run "psql -E" you'll see the queries t

Re: [GENERAL] OID Usage

Alvaro Herrera wrote: Yeah, though things get hairy that way because you have to peek at pg_attribute to match the objsubid in pg_depend; and self-join pg_class to get to the index itself. Not sure if it all can be done in a single query. Sounds like my task, to make an oid free insert/select,

Re: [GENERAL] OID Usage

Michael Fuhr wrote: The PostgreSQL documentation discourages the use of OIDs for primary keys. For example, the "Object Identifier Types" section in the "Data Types" chapter says: ... Thanks for taking you the time to snip this together, I think I will try to find a way to find the propper pri

Re: [GENERAL] OID Usage

Martijn van Oosterhout wrote: It means using OIDs as you described has very well known problems and they will break on you eventually. You can mitigate the damage by creating a UNIQUE index on the oid column but you'd better be sure your application can handle the side-effects. Ok, Tom told me a

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

On 1/14/05 12:47 PM, "Frank D. Engel, Jr." <[EMAIL PROTECTED]> wrote: > It's probably too messy to be worthwhile this > way, though. More trouble than it would be worth. It would be rather useful if there was a way to get a reasonably accurate count (better than analyze provides) in a very short

Re: [GENERAL] ntfs for windows port rc5-2

Frank D. Engel, Jr. wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You may wish to consider a different database for your project. SQLite may be a better choice, for example, depending on the project's specific needs (www.sqlite.org). Win95/98/ME is poor technology, no matter how many user

[GENERAL] developers map

hi, maybe this is a bit off-topic but is the map in the developer page dinamyc? if so, is taking data from a postgresql database? where can i found info for doing something like that? what language is used for doing that? regards, Jaime Casanova __

Re: [GENERAL] 7.4.6 FC2 MUCH slower from 2.6.9-1.11 to 2.6.10-1.8

Just tried 2.6.10-1.9_FC2 with the same bad results. Am I the only one experiencing this? What would be special? The hardware? It has nothing special, a popular Asus motherboard, 1GB memory, a modern Maxtor HD and nothing else. Clodoaldo --- Clodoaldo Pinto <[EMAIL PROTECTED]> escreveu: > 31 m

Re: [GENERAL] Parsing of backslash in statements via ODBC

On Fri, Jan 14, 2005 at 04:59:57PM -0500, Frank D. Engel, Jr. wrote: > Given that this issue is a violation of SQL compatibility, shouldn't > there really be an option to turn off interpretation of backslash > characters in string literals as escapes? Maybe as a session variable > of some kind,

Re: [GENERAL] ntfs for windows port rc5-2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You may wish to consider a different database for your project. SQLite may be a better choice, for example, depending on the project's specific needs (www.sqlite.org). Win95/98/ME is poor technology, no matter how many users it still has. It's prob

Re: [GENERAL] MOVE

Martijn van Oosterhout writes: > Why not just do it in a single transaction? I don't think you need to > use SERIALIZABLE at all, I think normal read-committed mode will do > what you want, no? > BEGIN; > INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...; > DELETE FROM active W

Re: [GENERAL] Parsing of backslash in statements via ODBC

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Given that this issue is a violation of SQL compatibility, shouldn't there really be an option to turn off interpretation of backslash characters in string literals as escapes? Maybe as a session variable of some kind, with a default being set in po

Re: [GENERAL] Parsing of backslash in statements via ODBC

"aboster" <[EMAIL PROTECTED]> writes: > Since MS-SQL & Oracle (both via ODBC) work fine with this app, I would > suspect the issue is that Postgres is interpreting backslashes as escape > characters in situations that the supported databases do not. Postgres definitely considers backslashes to be

Re: [GENERAL] ntfs for windows port rc5-2

Martijn van Oosterhout wrote: On Fri, Jan 14, 2005 at 08:39:28AM -0800, J. Greenlees wrote: why? since an app that I'm working on would be useless for 60% of potential clients, using posgresql with the requirement for ms' corrupted ntfs means postgresql isn't going to work for it. I think what y

Re: [GENERAL] MOVE

On Fri, Jan 14, 2005 at 08:49:24PM +0100, PFC wrote: > the auto-expiration cron > job, I must also expire ALL his open chatroom connections. > INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...; > DELETE FROM active WHERE user_id = ...; > > Now, if the user inserts a connection b

Re: [GENERAL] MOVE

Use an after inset trigger. On Fri, 2005-01-14 at 15:38, [EMAIL PROTECTED] wrote: > PFC wrote: I'd really like to have a sql command, say MOVE, or SELECT AND > DELETE, whatever, which acts like a SELECT, returning the rows, but > deleting them as well. > > Oracle implements this with the syntax D

Re: [GENERAL] C locale + unicode

Thanks for the info - to the point and much appreciated! John Sidney-Woollett Tom Lane wrote: John Sidney-Woollett <[EMAIL PROTECTED]> writes: Do upper() and lower() only work correctly for postgres v8 UTF-8 encoded databases? (They don't seem to work on chars > standard ascii on my 7.4.6 db). Is

Re: [GENERAL] postmaster listening on specified addresses

On Fri, Jan 14, 2005 at 03:28:24PM -0500, Administrator wrote: > I was wondering if there's a correct method for running postmaster with the > option of listening on a select group of addresses. PostgreSQL 8.0 will allow this -- it'll replace the virtual_host configuration variable with listen_a

Re: [GENERAL] Problem Dropping a Database with users connected to it

On Fri, 2005-01-14 at 10:58 -0600, Bruno Wolff III wrote: > On Fri, Jan 14, 2005 at 11:16:16 -0500, > Eric Dorland <[EMAIL PROTECTED]> wrote: > > > > * Disconnecting all other users before dropping the db, but that doesn't > > seem possible (I could start and stop the db, but that doesn't stop a

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

PFC wrote: I'd really like to have a sql command, say MOVE, or SELECT AND DELETE, whatever, which acts like a SELECT, returning the rows, but deleting them as well. Oracle implements this with the syntax DELETE FROM ... RETURNING ...; There is also UPDATE ... RETURNING ...; Where the deleted rows

[GENERAL] is there anyway to get the backends IP address from the PID?

Hi, Does anyone know if there is a way to get the backends IP address from the PID? I am using the view pg_stat_activity and it would be nice if it would also display the IP address along with the PID. I can see the IP address when I do a ps -ef but it would be nice to be able to get it via a s

[GENERAL] postmaster listening on specified addresses

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-separated list of hostnames or addresses? What if you have

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 12:20:50PM -0700, Michael Fuhr wrote: > On Fri, Jan 14, 2005 at 07:44:18PM +0100, Bo Lorentsen wrote: > > Alvaro Herrera wrote: > > > > >You can create a function to get the sequence name attached to a table. > > >Of course, you should take into account the fact that there

[GENERAL] MOVE

Hello, Here I'm implementing a session management, which has a connections table partitioned between active and archived connections. A connection represents a connection between a user and a chatroom. I use partitioning for performance reasons. The active table contains all the data for the a

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 07:44:18PM +0100, Bo Lorentsen wrote: > Alvaro Herrera wrote: > > >You can create a function to get the sequence name attached to a table. > >Of course, you should take into account the fact that there could be > >more than one (two serial fields in a table are rare but not

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 07:39:16PM +0100, Bo Lorentsen wrote: > But, does this mean that the oid sollution I have decriped (and > implimentet) have some unknown problems, or will oid's become obsolete > in the near future ? It means using OIDs as you described has very well known problems and th

[GENERAL] Parsing of backslash in statements via ODBC

We are trying to use a suite of third party applications, which run on Windows 2000, that can make use of a database backend via ODBC. Most of the apps work just great with Postgres. One of the components (a key visualization application) does not. Note that this all works fine, as is, using Ora

Re: [GENERAL] ntfs for windows port rc5-2

On Fri, Jan 14, 2005 at 08:39:28AM -0800, J. Greenlees wrote: > why? > since an app that I'm working on would be useless for 60% of potential > clients, using posgresql with the requirement for ms' corrupted ntfs > means postgresql isn't going to work for it. I think what you are referring to is

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 07:39:16PM +0100, Bo Lorentsen wrote: > > But, does this mean that the oid sollution I have decriped (and > implimentet) have some unknown problems, or will oid's become obsolete > in the near future ? The PostgreSQL documentation discourages the use of OIDs for primary

Re: [GENERAL] OID Usage

Tom Lane wrote: The thing you have to worry about is the possibility of duplicate OIDs once your DB has been running long enough for the OID counter to wrap around (2^32 OIDs). You should make sure that index is specifically declared as UNIQUE, so that any attempt to insert a duplicate OID will fa

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yep, that could cause problems. Okay, now I'm joining the program. The only thing I can see that would fix this for the integer would be to keep track of the number of 'committed' records using the integer, then for each new transaction, make a copy

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

On Fri, Jan 14, 2005 at 12:39:04PM -0500, Frank D. Engel, Jr. wrote: > This is probably stupid for some reason, but why not use a 64-bit > integer to track the number of records in the table? Increment when > adding records, decrement when deleting them... then COUNT(*) could > just return that

Re: [GENERAL] OID Usage

Alvaro Herrera wrote: You can create a function to get the sequence name attached to a table. Of course, you should take into account the fact that there could be more than one (two serial fields in a table are rare but not impossible), but if your tables have only one sequence you should be OK.

Re: [GENERAL] OID Usage

Michael Fuhr wrote: You could query the system catalogs for the table's primary key, either on the client side or in a server-side function. The pg_attrdef table even has the default value's nextval() expression with the sequence name, which could be converted into a currval() call. This is not

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

Frank D. Engel, Jr. wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This is probably stupid for some reason, but why not use a 64-bit integer to track the number of records in the table? Increment when adding records, decrement when deleting them... then COUNT(*) could just return that in c

Re: [GENERAL] C locale + unicode

John Sidney-Woollett <[EMAIL PROTECTED]> writes: > Do upper() and lower() only work correctly for postgres v8 UTF-8 encoded > databases? (They don't seem to work on chars > standard ascii on my > 7.4.6 db). Is this locale or encoding specific issue? Before 8.0, they don't work on multibyte chara

Re: [GENERAL] C locale + unicode

Tom, thanks for the info. Do upper() and lower() only work correctly for postgres v8 UTF-8 encoded databases? (They don't seem to work on chars > standard ascii on my 7.4.6 db). Is this locale or encoding specific issue? Is there likely to be a significant difference in speed between a database

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 11:47:25AM +0100, Bo Lorentsen wrote: > Michael Fuhr wrote: > > >PostgreSQL 8.0 will have a pg_get_serial_sequence() function that > >returns the sequence name for a particular column so you don't have > >to construct it. This is useful when a table or column has been > >r

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This is probably stupid for some reason, but why not use a 64-bit integer to track the number of records in the table? Increment when adding records, decrement when deleting them... then COUNT(*) could just return that in cases where a query is known

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

Wes <[EMAIL PROTECTED]> writes: > On 1/13/05 6:44 PM, "Greg Stark" <[EMAIL PROTECTED]> wrote: > > > That's simply false. Oracle does indeed have to count the records one by > > one. > Ok, I stand corrected - I was given some wrong information. However, my > experience has been that count(*) on

Re: [GENERAL] [HACKERS] Much Ado About COUNT(*)

On 1/13/05 6:44 PM, "Greg Stark" <[EMAIL PROTECTED]> wrote: > That's simply false. Oracle does indeed have to count the records one by one. > > It doesn't have to read and ignore the dead records since they're in a > separate place (but on the other hand it sometimes have to go read that > separa

Re: [GENERAL] Problem Dropping a Database with users connected to it

Eric Dorland <[EMAIL PROTECTED]> writes: > I'm basically trying to do what the subject says, through various means > with no success. The basic situation is that every night we recreate our > development database with a complete copy of our live data. The problem > is some of the developers (well m

Re: [GENERAL] C locale + unicode

John Sidney-Woollett <[EMAIL PROTECTED]> writes: > Does anyone know if it's permitted to use the 'C' locale with a UNICODE > encoded database in 7.4.6? Yes. > And will it work correctly? For suitably small values of "correctly", sure. Textual sort ordering would be by byte values, which might

Re: [GENERAL] Problem Dropping a Database with users connected to it

On Fri, Jan 14, 2005 at 11:16:16 -0500, Eric Dorland <[EMAIL PROTECTED]> wrote: > > * Disconnecting all other users before dropping the db, but that doesn't > seem possible (I could start and stop the db, but that doesn't stop any > clients from just reconnecting right away). You could use an a

[GENERAL] ntfs for windows port rc5-2

why? since an app that I'm working on would be useless for 60% of potential clients, using posgresql with the requirement for ms' corrupted ntfs means postgresql isn't going to work for it. since ms does not include a compiler, and the source for 8.0 won't cross compile from linux. ( gcc 3.3.0

Re: [GENERAL] Problem Dropping a Database with users connected to it

Just kill the processes. You can grep for postgres AND idle. It doesn't prevent new connections, but doesn't look like an issue in your scenario. If you need that, you can restart with a copy of pg_hba.conf that only allows localhost, do your drop & recreate, and then restart again. Regards.

[GENERAL] C locale + unicode

Does anyone know if it's permitted to use the 'C' locale with a UNICODE encoded database in 7.4.6? And will it work correctly? Or do you have to use a en_XX.utf8 locale if you want to use unicode encoding for your databases? John Sidney-Woollett ---(end of broadcast)

Re: [GENERAL] pl/pgsql trigger: syntax error at or near "ELSEIF"

# [EMAIL PROTECTED] / 2005-01-14 13:27:24 +0100: > Roman Neuhauser wrote: > >Hello, what is the parser trying to tell me? (7.4.2 if it matters) > >test'# ELSEIF TG_OP = ''DELETE'' THEN > > You typed ELSEIF, the parser doesn't know what that means (It's either > ELSIF or ELSE IF). Thank

[GENERAL] Problem Dropping a Database with users connected to it

Hi, I'm basically trying to do what the subject says, through various means with no success. The basic situation is that every night we recreate our development database with a complete copy of our live data. The problem is some of the developers (well me especially) leave open connections to the

Re: [GENERAL] Problem running native windows Postgres 8 pg_dump etc on

> > You should run the Cygwin tools from Cygwin. They work fine > against a > > native backend. > > Thanks, I'll have to wait for the port of P8.0.0 rc4 to > cygwin as the current cygwin port of pg_dump is 8.0.0 B2 and > does not work correctly for reason of the error 'column > "nsptablespace

Re: [GENERAL] Invalid input for numeric problem

mike wrote: WHEN to_number(vw_expend.code::text, '999'::text) < 50::numeric THEN '2'::text When I do for example SELECT * FROM vw_budget WHERE period = '1'; I get the following error ERROR: invalid input syntax for type numeric: " " Probably vw_expend.code contains a space in one or m

Re: [GENERAL] Problem running native windows Postgres 8 pg_dump etc on

Magnus wrote: > You should run the Cygwin tools from Cygwin. They work fine against a > native backend. Thanks, I'll have to wait for the port of P8.0.0 rc4 to cygwin as the current cygwin port of pg_dump is 8.0.0 B2 and does not work correctly for reason of the error 'column "nsptablespace" does

Re: [GENERAL] OID Usage

Bo Lorentsen <[EMAIL PROTECTED]> writes: > I use normal tabel ID (SERIAL and BIGSERIAL) all over the place for FK > constaints, but I use OID in one special situation. When I insert a > single row into a table, I like my low level code to be kompatible with > mysql ( mysql_insert_id ), and fetch

Re: [GENERAL] Problem running native windows Postgres 8 pg_dump etc on cygwin from bash

You should run the Cygwin tools from Cygwin. They work fine against a native backend. //Magnus > -Original Message- > > I have many database build scripts written for cygwin bash. > These scripts use the cygwin port of postgres 7.4 and its > client tools like psql, pg_dump etc. > I hav

Re: [GENERAL] Version Control Software for Database Objects

PG Lightning Admin has version control(with a diff viewer) for functions built in. It wouldn't be that difficult to add other objects after I release 1.0 Here is a screen shot: http://www.amsoftwaredesign.com/downloads/pg_screenshots/function_version_control.PNG It creates a table in the public s

Re: [GENERAL] OID Usage

On Fri, Jan 14, 2005 at 11:39:54AM +0100, Bo Lorentsen wrote: > Thanks, but this demands you to have the table and id_column name in > your hand, and I don't right now. You can create a function to get the sequence name attached to a table. Of course, you should take into account the fact that t

[GENERAL] Problem running native windows Postgres 8 pg_dump etc on cygwin from bash

I have many database build scripts written for cygwin bash. These scripts use the cygwin port of postgres 7.4 and its client tools like psql, pg_dump etc. I have modified my bash scripts to use the Postgres 8 native windows tools. Unfortunately these bash scripts don't seem to work. Some example r

  1   2   >