[GENERAL] BYTEA data type

2001-07-15 Thread Ben-Nes Nimrod
Howdie im trying to make a table which will hold information about files and i need to use the "blob" data type {im a former mysql user} now i understood that there is a better data type which is called "bytea". is it true? and y i cant find it at the manual? {and also at pgaccess program} a

[GENERAL] pg_dump problem with PostgreSQL v7.1.2

2001-07-15 Thread Dominick
I keep the same message when trying to dump any database. I haven't a clue; consequently, I'd appreciate any help that you could provide. postgres@ibook:/usr/local/pgsql/bin > ./pg_dump -o discuss -f /tmp/ibook_discuss_db getDatabase(): SELECT failed. Explanation from backend: 'ERROR: More th

[GENERAL] PASSWORD() function for postgresql?

2001-07-15 Thread geniusj
I am looking for a postgresql PASSWORD() function that produces hashes compatible with MySQL's implementation. I am converting from MySQL and I know of no other way to use the passwords I have in the old database other than having a compatible PASSWORD() function. I have searched around for on

[GENERAL] ODBC driver for Mac?

2001-07-15 Thread Randall Perry
Any plans to work on a Mac version of PgSQL ODBC driver? -- Randy Perry sysTame Mac Consulting/Sales ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [

Re: [GENERAL] Postgres User and Password

2001-07-15 Thread Justin Clift
Hi Bob, This sounds more like a general Unix security problems than anything PostgreSQL specific. If you are only changing to the "postgres" user to start the database server, then would it be better for your Linux startup scripts to automatically start PostgreSQL when the server starts, then ha

Re: [GENERAL] Translators wanted

2001-07-15 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > You have a few days to ask me questions about this, then I'll be off on > vacation and looking forward to a lot of progress when I get back. ;-) What's the procedure for updating the NLS files when messages change in the source text? I think I've al

Re: [GENERAL] Need feedback on possible new feature

2001-07-15 Thread Martijn van Oosterhout
On Sat, Jul 14, 2001 at 10:09:02PM -0400, Tom Lane wrote: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > Yes, you actually do the query and the show what took how long. As for > > seperating the parent and child nodes, is that really necessary? > > If you're going to label the nodes ind

Re: [GENERAL] [PATCH] To remove EXTEND INDEX

2001-07-15 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > Hi, > > As promised, here is a patch to remove all support for the (non-functional > anyway) EXTEND INDEX statement. See e