Am Donnerstag, den 14.07.2005, 00:57 -0400 schrieb Alvaro Herrera:
> On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
> > Vivek Khera wrote:
> > >The first sentence rules out MySQL, so the second sentence should read
> > >"So that leaves Postgres". Your problem is solved ;-)
> > >
>
Am Dienstag, den 12.07.2005, 12:47 -0300 schrieb Adam O'Toole:
> I am trying to INSERT multiple rows to a table using a stored procedure
> something like this:
>
> CREATE FUNCTION test(varchar) RETURNS int2 AS '
> DECLARE
> id_list ALIAS FOR $1;
> BEGIN
> INSERT INTO history (media_id, media_type
Am Dienstag, den 12.07.2005, 17:16 + schrieb Ted Slate:
> Hello Everyone,
>
> I considering moving a product to Solaris/Linux and trying to find a good
> DB. Oracle is out due to cost so as far as i know the only reasonable
> alternatives are Postgres or Codebase or MySQL. Does anyone here
Am Mittwoch, den 06.07.2005, 11:35 -0700 schrieb Mike Fahrenkrog:
> Hi,
> Does anyone know an efficient way to script database objects
> (preferably all objects, but particularly functions) to separate
> files? I would like to have a separate file for each object, so that I
> can easily add them t
Am Montag, den 20.06.2005, 21:28 -0500 schrieb Andrew L. Gould:
> I've been backing up my databases by piping pg_dump into gzip and
> burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> problems dealing with very large files (>1GB?) on DVD media. One of my
> compressed databas
Am Montag, den 20.06.2005, 11:57 -0400 schrieb Hrishikesh Deshmukh:
> Hi All,
>
> I have 7.4.7 version, my question is what are OIDS user for? What can
> one do with it!
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is
Am Montag, den 13.06.2005, 11:42 -0400 schrieb Chris Browne:
> [EMAIL PROTECTED] (Tatsuo Ishii) writes:
> >> For the contents too. I dont think the source code installation
> >> should be so much in the focus of the certification.
> >
> > Since PostgreSQL is an open source database, I think it is i
for someone to
> come up with inputs that hash to a target value, but if you're not too worried
> about people trying to do that then MD5 is probably overkill.
>
Sha1 is said to be faster.
(And less likely to collisions)
--
Tino Wildenhain <[EMAIL PROTECTED]>
Am Sonntag, den 12.06.2005, 23:12 +0200 schrieb Zlatko Matić:
> How could I retrieve information about actual user password, if md5
> method is set in pg_hba.conf ?
> I want to create VBA procedure that compares value in text box with
> actual password to determine if it is the same. As the passwo
Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii:
> > For the contents too. I dont think the source code installation
> > should be so much in the focus of the certification.
>
> Since PostgreSQL is an open source database, I think it is important
> to understand how to install Postgre
Am Sonntag, den 12.06.2005, 14:36 +1000 schrieb CaT:
> On Sun, Jun 12, 2005 at 12:24:30PM +0900, Tatsuo Ishii wrote:
> > Thank you for interested in PostgreSQL CE. There is a sample
> > examination problems page:
> >
> > http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
> >
> > You c
Am Freitag, den 10.06.2005, 08:42 +0400 schrieb go:
> Hi,
>
> Help me please to resolve the problem:
> Just After commiting transaction - writing ,say 90 rows,I try to select
> the same 90 rows - and get wrong set of rows (some of them: 1-2 replaced
> by unknown data). But after 10-20 seconds the
But my problem was the language is already installed but getting error
> on creation of the function.
> And if any one is creating this function who is not owner of database,
> this problem occurs.
>
No, thats only a coincidence. Check the docs pretty please :-)
And try to send mails to
Am Freitag, den 10.06.2005, 11:51 +0100 schrieb Richard Huxton:
> Tino Wildenhain wrote:
> >
> > No :-) But if you are able to create databases, you are a superuser :-)
> > And as a superuser you can also create the untrusted functions.
>
> Not quite - if you can creat
Am Freitag, den 10.06.2005, 15:21 +0530 schrieb Dinesh Pandey:
> Hi Richard/ Michael
>
>
>
> Thanks for your great help.
>
>
>
> I got the problem.
>
>
>
> Actually, I was not getting the cause of this problem, because it was
> working properly at our end.
>
>
>
> Actually this prob
ed a sequence and want assign just another free key.
If not, you need SELECT ... FOR UPDATE instead.
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
Am Freitag, den 03.06.2005, 00:36 +0200 schrieb Peter Eisentraut:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
> is supposed to have
Am Donnerstag, den 02.06.2005, 15:06 +0530 schrieb Nageshwar Rao:
> Can we write/read a file in postgresql procedure ?
Yes.
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list
Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb [EMAIL PROTECTED]:
> It will be a very pleasant idea. Although I am
> an application developer I don't know if I have
> enough knowledge to do that. Do you know how could
> I help the PostgreSQL development ?
>
> Another feature I missed is the "re
Am Dienstag, den 24.05.2005, 10:37 -0500 schrieb Mike Nolan:
> > > I hope anybody can help me on this subject. The problem is not to find
> > > a substitute for the Oracle synonyms, but a way to write queries
> > > which, reliably, can be used no matter the schema which owns the
> > > tables.
> >
Am Montag, den 23.05.2005, 23:21 -0300 schrieb [EMAIL PROTECTED]:
> So the search_path can not substitute the Oracle synonyms function
> which in a single way allow us to write generic queries for an
> application no matter the schema which is being used.
>
> I can not find a solution on this matt
t databases are
> > available though.
>
> Everyone realizes that even Oracle doesn't provide this functionality,
> right?
>
And you can get close to that if you carefully moc around with
the system tables and views and their permissions.
But if you do it wrong - restore is yo
crypt the password...
>
You just use the password in pgadmin and thats all.
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Am Sonntag, den 08.05.2005, 14:30 +0900 schrieb Tatsuo Ishii:
...
> Actually I myself thought as you are before. Later I found that it was
> not so good idea. People already have invalid encoded data in their
> precious database and have very hard time to migrate to newer version
> of PostgreSQL be
Am Montag, den 02.05.2005, 14:05 +0200 schrieb Craig Bryden:
> Hi
>
> Thanks for the reply. Since I don't intend using any of the interfaces at
> the moment, How would I write the script below in SQL then.
> Please keep in mind that I will be sending this script to other people to
> run and that i
Am Freitag, den 29.04.2005, 16:40 -0400 schrieb [EMAIL PROTECTED]:
> I can connect to the database on the server machine using pgadminIII
> and, it installed as a windows service. And I created one test
> database called usfo
>
> I have not succeeded in getting it to work yet using pg explorer fr
stand
> UNICODE file (UCS-2)? Is there a way I can make the COPY command with
> a UNICODE UCS-2 encoding
Yes, postgres Unicode means utf-8.
Windows programs which store unicode text are usually prepending
the file with a BOM (byte order mark) (just google for unicode
and BOM)
So you would
Am Donnerstag, den 03.03.2005, 14:35 -0500 schrieb Hrishikesh Deshmukh:
> Hi All,
>
> A question about "joins" i have 17 tables in my postgres-DB how does
> one perform a join on these many tables!!! :(
you just use 16 times the word "JOIN" ?
HTH
Tino
---(end of broadca
Hi,
Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > > Thanks!
> > >
> > > Is there any documentation on how to upgrade to 8.0?
> > >
> > > Is it possible to upgra
Am Sonntag, den 27.02.2005, 18:50 -0500 schrieb Tommy Svensson:
> 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
> c
Am Mittwoch, den 09.02.2005, 10:39 -0200 schrieb Clodoaldo Pinto:
> On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> >
> > Will this go into the same database?
>
> Yes, this *went* into the same database.
>
> > If so, you
Am Montag, den 07.02.2005, 20:05 -0200 schrieb Clodoaldo Pinto:
> On Mon, 07 Feb 2005 13:51:46 -0800, Joshua D. Drake
> <[EMAIL PROTECTED]> wrote:
>
> > Well your first email didn't explain that you were doing the below :)
>
> In the first email I was not doing the insert. I was executing a psql
t least we can state "it runs" ;)
> -tfo
>
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
>
> On Feb 9, 2005, at
Am Mittwoch, den 09.02.2005, 16:39 +0100 schrieb renato.barrios:
> Please tell me if Postgresql runns in an iMac.
IIRC postgres is even part of Mac OS X.
(perhaps not the latest version)
Regards
Tino
---(end of broadcast)---
TIP 2: you can get off
ole cluster gets created.
If you dont want to recreate your cluster and your db,
you probably need to write a function to lower()
according to your datas locale.
Regards
Tino
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Am Dienstag, den 25.01.2005, 08:36 -0500 schrieb Alex Turner:
> Actualy max() works just fine. It's not the solution I use in the
> middle tier, but it works for a functional example. both max() and
> currval() are bad because they can cause a race condition where the
> sequence has been incremen
Am Sonntag, den 23.01.2005, 07:46 -0800 schrieb Lonni J Friedman:
...
> I'd suggest uninstalling all postgresql RPMs, deleting /var/lib/pgsql,
> reinstalling the RPMs and then just start /etc/init.d/postgresql. If
> that fails to work, then set PGLOG in /etc/init.d/postgresql to
> something other
Am Samstag, den 22.01.2005, 11:14 +0100 schrieb Ralph van Etten:
> Hoi,
>
> I searched the archives but couldn't find an answer to this:
>
> I have a table (simplyfied)
>
> CREATE TABLE test (
> id INT PRIMARY KEY,
> name VARCHAR(250)
> );
>
> I insert records with
>
> INSERT INTO test (
just like plpgsql
should be perfectly valid.
--
Tino Wildenhain <[EMAIL PROTECTED]>
---(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
Am Donnerstag, den 20.01.2005, 06:09 -0800 schrieb J. Greenlees:
> Tino Wildenhain wrote:
> > Hi,
> >
> > Am Mittwoch, den 19.01.2005, 15:02 -0800 schrieb J. Greenlees:
> >
> >>Roman Neuhauser wrote:
> >>
> >>># [EMAIL PROTECTED] / 200
Hi,
Am Mittwoch, den 19.01.2005, 15:02 -0800 schrieb J. Greenlees:
> Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2005-01-20 01:35:32 +1100:
> >
> >>i have a unique index on a table over multiple columns. If now one of
> >>the records has a null value in one of the indexed columns i can inse
Am Montag, den 17.01.2005, 17:47 -0800 schrieb Jeff Davis:
> On Tue, 2005-01-18 at 07:43 +0700, David Garamond wrote:
> > Tzahi Fadida wrote:
> > > I recommend you don't use ext3 for any database:
> > > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> > >
> > > apparently its still bugg
Hi,
Am Dienstag, den 18.01.2005, 07:43 +0700 schrieb David Garamond:
> Tzahi Fadida wrote:
> > I recommend you don't use ext3 for any database:
> > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> >
> > apparently its still buggy.
>
> So what is the recommended fs under Linux? I don't
Am Freitag, den 07.01.2005, 06:45 -0800 schrieb Culley Harrelson:
> Hi,
>
> I am using Postgresql 7.4. I have a table with 1.5 million rows. It
> has a primary key. VACUUM FULL ANALYZE is run every night. There are
> 2000-5000 inserts on this table every day but very few updates and
> deletes.
On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote:
> No, this is only one result-set.
> MS SQL Server is able to return multiple result-set.
>
> For example, one SQL Server function can return the result of the following
> queries :
> SELECT * FROM Table1
> SELECT * FROM Table2
> SELECT * FRO
On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote:
> 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...
see
http://techdocs.postgresql.org/guides/SetReturningFunctions
or
http:
On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:
> Hi Craig,
>
> 2 years ago, I had to do some porting from MS SQL to Postgres.
> All the application logic was coded in stored procedures...
>
> The major problem I was faced to, was to port procedures returning multiple
> result-sets...
At
Am Montag, den 03.01.2005, 21:04 + schrieb Luis Neves:
> Peter Eisentraut wrote:
> > Robby Russell wrote:
> >
> >>agreed. Font sizes are a little 'too' small in some areas. The font
> >>size for the body is set to "font-size: 69%;"
> >>
> >>maybe 72% would be a little less of a strain. ;-)
> >
Hi,
Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
> Hi,
>
> I was just wondering is it possible to encrypt a filed in the database
> with md5? i know it is possible to do it with DB users
No. You cannot encrypt with md5 because you cant decrypt.
md5 is a hash function. But you
Am Freitag, den 17.12.2004, 10:55 +1100 schrieb Jamie Deppeler:
> Tino Wildenhain wrote:
> > Hi,
> >
> > Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
> >
> > > Hi,
> > >
> > > I was just wondering is it possible to encr
Hi,
On Mon, 2004-12-13 at 10:58 +0100, Janning Vygen wrote:
> Am Samstag, 11. Dezember 2004 20:06 schrieb Bruno Wolff III:
> > On Thu, Dec 09, 2004 at 18:32:19 +0100,
> >
> > Janning Vygen <[EMAIL PROTECTED]> wrote:
> > > "id" should be positive
> > > "id" should not have gaps within the same ac
Hi,
Am Montag, den 06.12.2004, 15:07 +0300 schrieb Konstantin Danilov:
> Hello List!
>
> PostgreSQL 8 does not correctly sort words written in cyrillic. It is a bug I
> suppose :)
No, its not a bug ;) You have to make sure you used the correct locale
while you set up your database cluster (init
Hi,
Am Mittwoch, den 01.12.2004, 16:46 +1100 schrieb Russell Smith:
> Regarding the "Natural Order" of columns.
>
> Why if we can delete a column from the middle of a table now, change the type
> of that column to something totally different, eg text -> int.
> Can we not move the order of the ro
Hi,
Am Dienstag, den 30.11.2004, 02:29 -0800 schrieb [EMAIL PROTECTED]:
> Hello,
>
> I am passing the ip address as a varchar. Eg: 133.9.4.11
>
> Later on i am splitting the ip address with the delimiter as '.'
>
>
> ip1t:= split_part($1,'.',1); // returns a text value
> ip2t:= split_part($1,'
Hi,
Am Dienstag, den 30.11.2004, 11:31 +0100 schrieb Joolz:
...
> > If you want to have a given ordering, why not just specify your
> > column names in that order in your statements? Or just refer to
> > them by column name if your host language allows it.
>
> The frondend functions are made so t
Hi,
Am Dienstag, den 30.11.2004, 10:26 +0100 schrieb Joolz:
> Hello everyone,
>
> When I create a table and later on (say, because customers want to
> store extra info) add a column, like this:
>
> create table test (lastfield varchar);
> alter table test add column firstfield varchar;
>
>
Am Sonntag, den 28.11.2004, 23:06 -0800 schrieb Uwe C. Schroeder:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Sunday 28 November 2004 10:43 pm, Michael Fuhr wrote:
> > On Sun, Nov 28, 2004 at 06:41:50PM -0800, Uwe C. Schroeder wrote:
> > > I need to search a lot of locations based on
Hi,
Am Donnerstag, den 25.11.2004, 19:42 +0300 schrieb ON.KG:
> New question:
>
> i have tables like
> table_20041124,
> table_20041125,
> etc...
>
> i'm trying to make function (for example):
> =
> CREATE FUNCTION get_count(text, text)
> RETURNS int2 AS '
>
Hi,
Am Mittwoch, den 24.11.2004, 11:17 -0500 schrieb Larry White:
> Is it possible for one stored procedure to call another?
yes.
More specifically these are stored functions rather then
stored procedures in the M$-like way.
Regards
Tino
---(end of broadcast)--
Hi,
Am Dienstag, den 16.11.2004, 11:22 +0100 schrieb Stefano Farina:
> Hi all
> I have to develop an embedded database using memory FLASH and memory
> RAM
> Some tables must be saved in RAM and some tables in FLASH ( RAM and
> FLASH are two different mounted directories in the file system).
> I sa
He is responsible for all this Usenet c
Tino Wildenhain
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
This is all the fault of that penis breath Mike Cox. FUCK HIM!
Tino Wildenhain
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 2004-11-16 at 12:32, Holger Klawitter wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> A little bit OT, but:
> is there a way of removing duplicate rows in a table without OIDs?
>
ALTER TABLE ... ADD COLUMN myoid int;
CREATE TEMP SEQUENCE myoidsequence;
UPDATE ... SET m
Hi,
On Tue, 2004-11-16 at 14:17, [EMAIL PROTECTED] wrote:
> Hi Chris and Karim,
>
> I haven't been following this thread, so excuse me if I suggest something
> that has already been tossed out.
>
> Solaris allows multiple IP addresses to be assigned to a single NIC. I
> just looked at the man p
Am Sonntag, den 14.11.2004, 18:10 +0100 schrieb Michelle Konzack:
> Am 2004-11-13 02:47:04, schrieb BARD ROCK:
> > It is now time to cast your vote as to whether you would like these
> > mailing lists to become legal USENET newsgroups.
>
> NO mercie !!!
>
> I get already 2500-8000 SPAMs per day o
Hi,
Am Sa, den 06.11.2004 schrieb Leo Martin Orfei um 13:52:
> ok. I gonna explain a little more my situation.
>
> I have a postgres server (Linux) and clients
> (Win2k+delphi application).
> I need create a text file with some columns from a
> table in the server machine, but this file must be
Hi,
On Tue, 2004-11-02 at 09:05, Alex P wrote:
> Hi,
>
> when creating a query with a subselect
>
> SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name) AS
> max_pop
> FROM states;
>
> then it is not possible to sort after max_pop or use max_pop in a function or a CA
Hi,
On Tue, 2004-11-02 at 07:47, Katsaros Kwn/nos wrote:
> Hi!
>
> I want to parse a query (SFW) and create new queries: one for each
> table referenced, if that possible.
> I've written a function for this in the Query struct level after
> parse&rewrite (not very general ofcourse :-)) but I wou
Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:
> [EMAIL PROTECTED] (Tino Wildenhain) writes:
> > Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:
> >> On Thu, 28 Oct 2004 04:14 am, Eric wrote:
> >> > Is there something to interface postgreSQL with QMail
Hi,
Am Sa, den 30.10.2004 schrieb Joshua D. Drake um 18:25:
> >Do you know anything else? dbmail seems too much mysql
> >centric while at least providing access to postgresql
> >which is a pro. The storage of mails in big chunks
> >seems less then ideal and you need clever views to
> >get local p
Hi,
Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:
> On Thu, 28 Oct 2004 04:14 am, Eric wrote:
> > Is there something to interface postgreSQL with QMail to store mails in
> > pgsql instead of using mbox or maildir?
> >
> > Or maybe it's not a good idea to do that?
> >
> > I think there is
Am Di, den 26.10.2004 schrieb Scott Frankel um 21:39:
> I'm attempting to debug a script that should perform a simple INSERT of
> values,
> but for some reason doesn't. The insert appears to occur without
> error, printing
> "INSERT 18015 1 upon completion." Nonetheless, no data values appear
Hi,
On Tue, 2004-10-26 at 15:25, Henk Ernst Blok wrote:
...
> the TPC-H query set in particular). So decision support and datamining
> are in that area for instance. My topic of interest is IR (information
> retrieval) in a database context. My experiments behave like an OLAP
> load at the moment
On Tue, 2004-10-26 at 13:56, Henk Ernst Blok wrote:
> Hi,
>
> My question was more of a fundamental nature as this count by scan
> seemed to contradict the theory about how to optimize it.
It is hard or next to impossible to optimize count() or more generally
aggregates in a MVCC environment. Not
hi,
On Tue, 2004-10-26 at 10:16, Henk Ernst Blok wrote:
> Hi Posgres users/developers,
>
> Can anyone explain why PosgreSQL (version 7.4.5 on Linux) does a full
> table scan to compute a count(*) on a base table after a vacuum analyze
> has been done with no following updates that might have ou
Hi,
Am Do, den 21.10.2004 schrieb Dennis Gearon um 1:30:
> I am designing something that may be the size of yahoo, google, ebay, etc.
>
> Just ONE many to many table could possibly have the following
> characteristics:
>
> 3,600,000,000 records
> each record is 9 fields of INT4/DATE
>
Hi,
Am Mi, den 20.10.2004 schrieb Eric E um 19:52:
> Hi Tino,
> Many thanks for helping me.
>
> I know that the sequence issue is a troubling one for many on the list.
> Perhaps if I explain the need for a continuous sequence I can circumvent
> some of that:
>
> This database is for a
Hi,
On Tue, 2004-10-19 at 01:16, Eric E wrote:
> Hi,
> I have a question about sequences. I need a field to have values with
> no holes in the sequence. However, the values do not need to be in order.
>
> My users will draw a number or numbers from the sequence and write to
> the field.
Am Mi, den 13.10.2004 schrieb Michael Kleiser um 17:44:
> I found on
> http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html
> that it is not poosible to use start or end a transaction in plpgsl.
>
> I tried to create a plplsql-function on PostgreSQL 8.0 beta 3
Hi again,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
> hello everybody,
> i ve got two big tables with the same structure.
>
> i would like to add the second one to the first one directly without
> generating a sql file. (each table is about 1 Million line)
> Is it a way with an sql command?
Hi,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
> hello everybody,
> i ve got two big tables with the same structure.
>
> i would like to add the second one to the first one directly without
> generating a sql file. (each table is about 1 Million line)
> Is it a way with an sql command?
> INSE
Hi,
Am Di, den 12.10.2004 schrieb DEHAINSALA Hondjack um 20:43:
> Hi !
> sorry for my english ! I am french :-)
>
> I want to test postgreSQL v8 native Windows! Where i can get a version
> which
> allows more than 64 characters (NAMEDATALEN ~=128) to the name of
> tables and
> columns ?
>
> I g
On Tue, 2004-10-12 at 17:01, Jerry LeVan wrote:
> 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).
column = origcolumn;
ALTER TABLE yourtable DROP COLUMN origcolumn;
ALTER TABLE yourtable RENAME tempcolumn TO origcolumn;
COMMIT work;
Since text and (unlimited) varchar are quite the same,
you could get away with modifying the system tables.
But I would not recomment to do so.
Regards
Tino Wild
-t tablename | sed -e "s/tablename/newtablename/" | psql
HTH
Tino Wildenhain
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
quot;over the shoulder looking") but not more.
Otoh, if one needs security, there is a pretty (open)ssl - layer
and it even supports client certificates...
Regards
Tino Wildenhain
PS: the hash would suit better when used in a challenge authorization,
meaning the server sends a
t for exchange
(PostgreSQL/Email/LDAP/iCalendar)?
Is this compareable to DBMail?
http://www.dbmail.org/
Regards
Tino Wildenhain
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi Casey,
Casey Allen Shobe wrote:
Alex Satrapa (Sunday 28 December 2003 22:16)
Just convince your distribution's
My what? I don't use no stinkin' distribution :).
postgresql package maintainer
That would be postgresql.org, I know not of binary packages.
"suggests/recommends" portion of
uit_name,
fruit_qty
FROM fruit_table;
Provided you modify your monitor_table
to have monitor_id, fruit_name (perhaps fruit_id is better here),
fruit_qty
If you got a table with fruit_id:fruit_name, you can always retrive
your information via LEFT OUTER JOIN, otherwise you would only
. I dont think there
is a xor yet, but otoh, xor is inherently insecure if its
cryptography you are trying.
However you might be able to use the examples to write
your own XOR function or use one of the other language
modules to do so.
HTH
Tino Wildenhain
---(end of broadcast
Hi fuzzy,
fuzzy schrieb:
How cvan i install the postgresql ODBC Driver for Windows if i have only a
DLL ?
Thanx in Advance
You first move the DLL into the trashcan and then download
the installer from http://odbc.postgresql.org/
or ftp://ftp.postgresql.org/pub/odbc/versions/msi/
Alternatively, yo
Ron wrote:
...
If you are just running the occasional query and want the results placed
into an Excel spreadsheet, you should look at pgAdmin. You run it from
your windows box and you can run queries and have the results displayed
-> on screen, ->written to a file, ->or to an Excel spreadsheet.
alue FROM table WHERE key=%s",("your'key",))
for example.
HTH
Tino Wildenhain
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Hi,
CSN wrote:
Just wondering - is there something similar to this
(clustering) for PostgreSQL? If so, how does it
compare?
http://www.mysql.com/press/release_2003_30.html
Marketing... they're lying the hell out of anything.
"mission critical business apps" *muhahaha*
"640K are enough for everybo
t.
(There must be some explaination why postgresql (and Oracle as well) do
not have CREATE OR REPLACE TABLE as it does for VIEWs, and FUNCTIONs.
Anybody know?)
Nobody needs this?
There is:
1) delete from table;
2) truncate table;
to remove all the data
3) alter table ...
to ch
postgresql is very close to SQL-spec,
so you arent so much walking on the dark side
if you adopt postgres style SQL.
Regards
Tino Wildenhain
---(end of broadcast)---
TIP 8: explain analyze is your friend
L it is easy to understand how they come to that
conclusion.
Usually Macromedia avoids to support anything good :-)
You can however try to script the support into Dreamweaver
using Javascript (most of DWs functionallity is written
in Javascript)
Regards
Tino Wildenhain
--
units (unit_id int4, unitname text, baseunit_id int4, factor
numeric)
attributes (product_id int8, attr_id int4, unit_id int4, attrtxt text,
attrvalue numeric)
I think you get the picture :-)
Good luck
Tino Wildenhain
---(end of broadcast)---
Hi Kallol,
Kallol Nandi wrote:
Tino,
Thanks for the information.
I already have a database with SQL_ASCII encoding.
Is there any way that I can change the encoding to UNICODE.
The only way I know is pg_dump and dropdb, createdb and pg_restore.
HTH
Tino Wildenhain
Regards,
Kallol.
-Original
Hi Viorel,
what are the exact circumstances for this? I'm not experiencing
that behavior. Maybe it depends on your settings in pg_hba.conf?
And are you using -X set-session-authorization and so on?
Regards
Tino Wildenhain
Viorel Dragomir wrote:
As i experienced with pg_dump it looks like i
301 - 400 of 403 matches
Mail list logo