[GENERAL] RLS & SEpgsql

the permissions necessary to read this row. Thanks, -Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [PERFORM] Inaccurate Explain Cost

/9.2/static/runtime-config-query.html section "18.7.2. Planner Cost Constants". -Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Gist cost estimates

have the same problem with postgres' cube data type (tested on 9.1 and which also estimates exactly 5104 rows). And postgis indexes have a similar (though maybe unrelated) problem. Do you have any explanation for these grossly wrong cost estimates? Are they unimplemented? What can I do to de

[GENERAL] Temporal foreign keys

Hey, how can I implement temporal foreign keys with postgresql? Is writing triggers the only way to enforce temporal referential integrity currently? -Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Encryption - searching and sorting

because the most interesting index operators for me are not supported, nor do I know how well it performs in reality, but the section on encryption and fast searching with the different algorithms is a really interesting read. -Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql

[GENERAL] How to handle larger databases?

I am currently creating a database with less than 20 simple tables (only SQL 92 types, simple constraints, no PostgreSQL specific stuff, no stored procedures...) Unfortunately, some of those tables will contain up to 4 Million entries, making the size of the entire database 700-1000MB. In order t

[GENERAL] How to deal with almost recurring data?

I am creating a database which is supposed to contain many data entries (events) that differ only in the date they occur. So let's say event 1 occurs every Monday, Tuesday and Sunday between January 1st and May 30th 2005. How do I store and manage such data in a meaningful way? The simple idea w

Re: [GENERAL] How to deal with almost recurring data?

Thanks for the answer. If I go that way, though, I am afraid I will have very long query times. And I have no idea how to handle large databases of that kind without losing performance. If I store the pattern - is there a way to still perform the query in the database? Or do I have to do that in m

Re: [GENERAL] How to deal with almost recurring data?

Thanks The standard case is: I enter a date and 2 parameters of the event and I get the result set. Even though with Java date arithmetics are quite simple and I could therefore extend my software in that fashion, I would much rather perform all queries entirely in the database. So in case I go abo

[GENERAL] Problems importing Unicode

I have batch files with entries such as INSERT INTO country VALUES (248,'ALA','AX','Åland Islands'); INSERT INTO country VALUES (384,'CIV','CI','Côte d\'Ivoire'); I tried to execute them using "pgsql \i filename.sql" Unfortunately, I keep getting an error message: "ERROR: invalid byte sequence

[GENERAL] How to suppress echo while executing batch files?

I have to execute fairly large batch files (200-300MB) with several million INSERT commands. When I do that from pgsql using the \i switch, I get the echo INSERT 0 1 for every single insert statement of my batch file. Since I assume that this slows down the whole process I would like to know if

Re: [GENERAL] Problems importing Unicode

Well, they were generated by MySQL and I can open them with e.g. the Windows Editor Notepad. But I don't know if they are actually encoded in UNICODE. Since I can open the file with Notepad and read the statements, I assume, it is not UNICODE. They look just like in the email below. The problem ar

Re: [GENERAL] postgresql 9.4 streaming replication

http://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html. cheers Matthias

[GENERAL] pg_dump crashing

he same backup mechanism. I hate to consider a downgrade as a possible solution. May be an info, which might be useful: my machine has 64 GB RAM. Any ideas where to continue my search? Best regards Matthias Schmitt magic moving pixel s.a. 23, Avenue Grande-Duchesse Charlotte L-3441 Dudelange

Re: [GENERAL] pg_dump crashing

nswer. But sorry, no, this does not change anything. Same server crash when executed in a cron job. It runs perfectly when executed manually from the shell. Best regards Matthias Schmitt magic moving pixel s.a. 23, Avenue Grande-Duchesse Charlotte L-3441 Dudelange Luxembourg Phone: +352 54 75 75 h

Re: [GENERAL] pg_dump crashing

Hello, > On 16 Mar 2016, at 14:55, Adrian Klaver wrote: > > On 03/15/2016 08:10 AM, Matthias Schmitt wrote: >> Hello, >> >> since two weeks I am trying to get PostgreSQL 9.5.1 to run on Debian 8.3. >> Everything is fine except the daily backup. When calling

Re: [GENERAL] pg_dump crashing ... solved

be a difference if the job is running as a “normal” user or a “system” user. So I modified my existing postgres user to be a system user usermod -u mmppostgres an now my backup is running. I cannot remember finding such a hint in the PostgreSQL documentation. It would be worth mentioning it.

Re: [GENERAL] max_stack_depth problem though query is substantially smaller

ge and thus a query string that only has 1.7 MB exceeds the stack ? From: Tom Lane [t...@sss.pgh.pa.us] Sent: Friday, April 08, 2016 4:20 PM To: Charles Clavadetscher Cc: pgsql-general@postgresql.org; Bannert Matthias Subject: Re: [GENERAL] max_stack_

Re: [GENERAL] max_stack_depth problem though query is substantially smaller

. Thanks for the pointer to the stack trace backend. I'll try to set that up and report what I find. From: Tom Lane [t...@sss.pgh.pa.us] Sent: Friday, April 08, 2016 9:39 PM To: Bannert Matthias Cc: Charles Clavadetscher; pgsql-general@postgresql.org Su

Re: [GENERAL] max_stack_depth problem though query is substantially smaller

AD/postgresql-9.3-9.3.11/build/../src/backend/main/main.c:227 Detaching from program: /usr/lib/postgresql/9.3/bin/postgres, process 1521 Is this of any help at all? I really how you can get almost 70 MB done and I can't even get 2-5 MB done. Maybe you can share a brief part of you 70 MB quer

Re: [GENERAL] max_stack_depth problem though query is substantially smaller

e on that operator being deprecated? regards, matt bannert From: Tom Lane [t...@sss.pgh.pa.us] Sent: Saturday, April 09, 2016 5:25 PM To: Bannert Matthias Cc: Charles Clavadetscher; pgsql-general@postgresql.org Subject: Re: [GENERAL] max_stack_depth pr

Re: [GENERAL] Seeking advice on database replication.

might be a second database on the replicated db- server that is working in normal mode (not hot standby) and is filled up by the replicated database, which works in read-only mode. PG can easily handle multiple clusters that contain 80MB on one "normal" server. Matthias Am Donnerstag, 11.

Re: [GENERAL] Understanding PG9.0 streaming replication feature

cluster software (i.e. pacemaker). If you can live without load balancing, read the page of Satoshi. But the slaves can handle read requests (SELECT). Maybe this helps a little bit. Regards Matthias Am Mittwoch, 22. Dezember 2010, um 00:31:14 schrieb Satoshi Nagayasu: > Hi Ben, >

Re: [GENERAL] Como usar interval con un variable

Hola, hay una portal en espanol sobre postgres con listas de correo y IRC: http://www.postgresql-es.org/comunidad Aqui hablamos ingles. Sorry. saludos desde Alemana. Matthias Am Dienstag, 4. Januar 2011, um 21:26:33 schrieb liliana lazarte: > Hola gente: > Estoy haciendo un f

[GENERAL] unexpected data offset flag 0

tore: [archiver] unexpected data offset flag 0 Even listing the contents doesn't work: pg_restore -l db.dump pg_restore: [archiver] unexpected data offset flag 0 I couldn't find anything in the documentation about this error message. Is it possible that the dump is corrupted? What can I do to fix this? Matthias

[GENERAL] Slow delete with with cascading foreign keys

lain" on this won't yield any information for example. Is there any way to get PostgreSQL to do an analys of a delete statement like the way I need? // Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Slow delete with with cascading foreign keys

Tom Lane skrev: "Matthias Karlsson" <[EMAIL PROTECTED]> writes: I have a rather complex set of relations, connected with cascading foreign keys on delete. I'm experiencing very slow performance when deleting *the* lead node, which everything eventually depends on.

Re: [GENERAL] How best to implement a multi-table constraint?

Why do you need to store the total area at all (property_area)? This value can easily be calculated with an group by query. On Mon, Oct 20, 2008 at 10:56 PM, Karl Nack <[EMAIL PROTECTED]> wrote: > Hello all, > > I'm a bit of a newb designing a database to hold landcover information for > propertie

Re: [GENERAL] Visualizer

DbVisualizer is a tool I have used in the past for exactly this. // Matthias On Wed, Nov 5, 2008 at 1:18 PM, Mohammad Ali Darvish Darab <[EMAIL PROTECTED]> wrote: > Hello everybody, > > I have got an already existing Porstgres DB which is pretty large > (including more t

[GENERAL] Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore

ble for me to get it from somewhere. What can I do? How can I dump the data from the 32bit database? Does someone has built a postgres binary for this issue? Thanks in advance, Matthias -- rainboxx Software Engineering Matthias Dietrich, Freelancer rainboxx | Mobil:

[GENERAL] Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore

ble for me to get it from somewhere. What can I do? How can I dump the data from the 32bit database? Does someone has built a postgres binary for this issue? Thanks in advance, Matthias -- rainboxx Software Engineering Matthias Dietrich, Freelancer rainboxx | Mobil:

[GENERAL] "Compressed data is corrupt"

address slightly (eg from "..6" to "..5") makes the error disappear. Any clue what may be going on? Any more things I should try and test? Running Postgresql 8.4.7 on an openSuSE machine (64bit). -- Matthias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to do an UPDATE for all the fields that do NOT break a constraint?

ent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > You could always extend your update statement to include an additional check to see if there are already rows present with the same v

Re: [GENERAL] How to do an UPDATE for all the fields that do NOT break a constraint?

On Mon, Jan 26, 2009 at 2:53 PM, Phoenix Kiula wrote: > On Mon, Jan 26, 2009 at 9:45 PM, Matthias Karlsson wrote: >> On Mon, Jan 26, 2009 at 2:09 PM, Phoenix Kiula >> wrote: >>> I wonder if this is an SQL limitation or something I'm missing in the >>> PG

Re: [GENERAL] Which SQL is the best for servers?

> > Should you choose an open-source, make sure your code AND your DDL uses as > much ANSI standards as possible so when you do need to move to something > else, it won't be as painful. (auto-incrementing columns vs. sequences > etc...). I really wouldn't go for database independence ... Choos

[GENERAL] Foreign Keys Question

n is: Is this a good idea? I have no idea if this will be fast enough, or if I will have lots of problems afterward Could anyone help me with this ? Thanks in advance, Matthias Loitsch -- THEK Matthias Loitsch www.studiothek.com/ pgpPyT3vJZehW.pgp Description: PGP signature

Re: [GENERAL] Access to databas from the Internet

iptables rules and also the HowTos at http://www.netfilter.org/ how to create a port forwarding. Be aware that this will also attackers from the internet will enable them to use exploits onto your server! So make sure, that this machine is properly secured. Best regards, Matthias > -Origi

[GENERAL] Strange database corruption with PostgreSQL 7.4.x on Debian Sarge

7.4.10 we don't have any problems. Kernels are 2.4.33 on the Sarge machine, 2.4.28 on the Woody machine. Both are SMP kernels. Does anyone of you perhaps have some hints what's going wrong here? Best regards, Matthias ---(end of broadcast)---

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x o

roller but even with that i don't get any message in my logs... Any ideas how i could check the hardware? Best regards, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe > Sent: Wednesday, September 20, 2006 2:5

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x o

ompaq to run some hardware diagnostic checks on our machine. I will try this out as soon as possible. I will inform you when i know more :) -- Matthias > -Original Message- > From: Scott Marlowe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 20, 2006 4:12 PM > To: [EMAI

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x o

Hello Tom! Not yet, but i will try this one too. Anything special i should look for when dumping out the bad pages? -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Wednesday, September 20, 2006 4:32 PM

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x o

ver has a firmware issue. The problem are incomplete writes onto disk while on high I/O load... We will check this one first. If it won't help, we will try the hardware diagnostics and some other tests... Meanwhile thank you all for your suggestions :) -- Matthias > -Original Messa

[GENERAL] Good books about PL/PGSQL programming?

Hello there! Are there any good and recommendable books about PL/PGSQL programming? Covering new features of PostgreSQL 8.x is no must but would be nice to have. Best regards, Matthias ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [GENERAL] Backup / export DB

Title: Nachricht Simply dump the database with pg_dump, copy the dump to the other machine and restore the dump there. See the man pages of pg_dump how to use the tool. If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.   -- Mat

Re: [GENERAL] Backup roles / users

Title: Nachricht Hi Alain!   To get all the users and so on to the other machine, you have to use the pg_dumpall tool with the -g switch. This will dump out all the users, groups and roles i think.   -- Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x o

abase corruption, so i think the one disk with the firmware bug is the cause of our problems. Since only the database does a lot of I/O onto the disks, this will help us for the next days till we can upgrade or replace the bugged disk. Thank you all for your hints and suggestions! -- Mat

Re: [GENERAL] PG_DUMP without asking password

e the dump script under a privileged user. For my machines here, the user postgres can dump all databases without entering a password. If you backup your database via a cron job started by root, you can simply do a su postgres -c ... to run the backupjob under user postgres.   -- Mat

Re: [GENERAL] copy db1 to db2

What kind of errors? Just saying "i got some errors" isn't very helpfull for us to be able to help you properly ;) So, what exact error messages you get when trying to restore the database? -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EM

[GENERAL] Definition of return types for own functions?

SETOF table_name AS '... And i need the table table_name with the structure: CREATE TABLE table_name( datum DATE, zahl INTEGER); Can i somehow define this structe inside the function declaration without having some empty tables or views around? Thank you all! Best regards, Mat

Re: [GENERAL] Fwd: Help with function

Just curious but since which version these IN/OUT parameters are supported? -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer > Sent: Wednesday, October 04, 2006 4:01 PM > To: pgsql-general@postgresql.or

Re: [GENERAL] Help required

Title: Nachricht Hello Vijay!   Not 100% sure but Ubuntu should have the database set up similar to Debian on which it's based. This means, you can start the database via: /etc/init.d/postgresql start This should use the distribution specific startup scripts.   Greetings, Mat

Re: [GENERAL] Intentionally produce Errors

In PL/pgSQL you could use the RAISE command: http://www.postgresql.org/docs/8.1/interactive/plpgsql-errors-and-messages.h tml Best regards, Matthias > -Original Message- > > Hi, > > this is sort of a silly question, but: what's the proper way to > intentionally

Re: [GENERAL] adjusting primary key

existing table take a look at the ALTER TABLE commands. Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rafal Pietrak > Sent: Tuesday, October 10, 2006 3:59 PM > To: pgsql-general@postgresql.org > Subject: [

Re: [GENERAL] Maximum size of database

Title: Nachricht What disk subsystem do you have? Single disks? Raid? Raid with battery buffered write cache? Last one can improve your performance massively.   -- Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa

[GENERAL] Modifying SQL parser with extensions?

er to modify the parser? Any suggestions are appreciated. Regards, Matthias ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Modifying SQL parser with extensions?

the code that needs to be written might be implemented with the existing extension mechanism, though the parser does not belong to that category. Regards, Matthias ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [GENERAL] Modifying SQL parser with extensions?

7;s possible to implement it directly in an RDBMS, i.e. PostgreSQL. Regards, Matthias ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Modifying SQL parser with extensions?

more complex, the self cooked dialect is considered to be more readable and intuitive to the end user. Regards, Matthias ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Modifying SQL parser with extensions?

teractive/server-programming.html and the source itself that you can recommend? I'm especially interested in how the typical implementation scheme for RDBMS found in textbooks maps to pgsql. You see, I'm looking for the K&R for pgsql. Regards, Matthia

Re: [GENERAL] [PL/pgSQL] How should I use FOUND special variable.

Title: Nachricht Hi!   Just use this:   FETCH crs_cnt into row_cnt; EXIT WHEN NOT FOUND;   Greetings, Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremiasz MiedzinskiSent: Thursday, November 09, 2006 1:15 PMTo: pgsql-general

Re: [GENERAL] autovacuum blues

Hi Anton! I'm not sure how this is with 8.1 but on 7.4.14 we have to enable row level statistics collection for autovacuum: stats_row_level = true Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Anton Melser &g

Re: [GENERAL] Why overlaps is not working

Hm, why not this one: select ('2006-10-31'::date, '-12-31'::date) OVERLAPS ('2006-10-16'::DATE, '2006-10-31':: DATE); overlaps -- f (1 row) Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAI

Re: [GENERAL] SQL - update table problem...

Hi! According to the synopsis of UPDATE you just can update one table at a time. Just use more UPDATE commands inside a transaction. -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marko Rihtar > Sent: Monday, November 1

Re: [GENERAL] can't start postgresql

#x27;t have any idea how to solve this issue :( -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Enrico > Sent: Tuesday, November 14, 2006 4:22 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] can't

[GENERAL] Question about query optimization

ory entry for a given date than this query? Queries of this kind are often used in our application and getting a more performant solution would speed up things a lot. Thank's for your suggestions! Greetings, Matthias ---(end of broadcast)---

Re: [GENERAL] Question about query optimization

Title: Nachricht Hello Gurjeet!   Tried your suggestion but this is just a marginal improvement. Our query needs 126 ms time, your query 110 ms.   Greetings, Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gurjeet SinghSent

Re: [GENERAL] build for none standard socket

Hi! You can at least configure the socket directory, the socket group and the socket permissions in your postgresql.conf. Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > garry saddington > Sent: Wednesday, No

Re: [GENERAL] PGSQL Newbie

Hi Robert! Sure, why not? Both databases run on different directories, ports, sockets and so on. Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wolfe, Robert > Sent: Wednesday, November 22, 2006 4:53 PM > To

Re: [GENERAL] returning parameters from function

You have to call the function in the following form: SELECT * FROM get_test_data(1) AS (field1 type, field2 type, ...) In words, you have to tell the database how the data returned by the function has to be interpreted. Greetings, Matthias > -Original Message- > From: [EMAIL PRO

Re: [GENERAL] Postgresql 8.1: plperl code works with LATIN1, fail

st tells Perl that the source code is written in UTF-8 and noting more. For converting from and to UTF-8 in data usually the Encode modul is used. Or is this different for plperlu? Greetings, Matthias ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Storing database in cluster (Memory)

ables is caused by not performing any vacuum runs. Greetings, Matthias

Re: [GENERAL] Very strange error

n the same error message also on the BUGS mailing list concerning a broken CHECK constraint on a table row. Perhaps this is the cause of the error messages. Greetings, Matthias ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Very strange error

ong time. Any help is appreciated. Regards, Ümit Öztosun Hello there! I suggest to post this on the BUGS mailing list. As said before, there has been some other mail with exact the same error message and with the latest version something concerning data type checks had been fixed. Greetings, Matthias

[GENERAL] Combining several rows

ist of all name-fields in the test-table) in the main-query ( SELECT (whatever is a solution) AS name, other, fields FROM tables...). Thanks in advance Matthias Nagl ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

[GENERAL] postgres replication only some datas

half gig and we need the changed entries directly on the online db within seconds. Anybody how could help? Greetings Matthias ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] More Red Hat information

They might have "issues". Or "features". -- Matthias Urlichs ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] More Red Hat information

crosoft name (and FUD). > RHDB has a price tag of zero if all you need is the database. This is not what I was talking about, though. -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ ---(end of broadcast)--- TIP 2:

[GENERAL] group by problem

.kunde=T1.id group by T1.id; Where is the problem? Thanks for any hints Bis dann Matthias

[GENERAL] Why isn't that null

SQL query didnt cause this if statement: insert into aufpos(auftrag, artikel, best_menge, vkp, lieferwoche, cuser, ctime, uuser, utime) values ('175','8501900','12','','3500','matthias', now (), 'matthias',now ()) If I change t

Re: [GENERAL] Why isn't that null

what type vkp is, but if it's a string type then comparing it > against a numeric shouldn't work IMHO. no it isn't. It is a float8 type. I changed my program in that way that the query includes NULL instead of ''. Bis dann Matthias -- Matthias Teege -- [EMAIL PROTECTED] -- http://emugs.de make world not war PGP-Key auf Anfrage

[GENERAL] Was an insert successfully?

Moin, how can I check if an insert was successfully in an plpgsql function? I use 6.5.1 under FreeBSD. Many thanks Matthias

[GENERAL] Get the OID after an insert

Moin, ist there any possibility to get the OID returned by an insert clause in a plpgsql function? Something like "select into intAuftragID id from auftrag ..." but only for insert. Bis dann Matthias

[GENERAL] Unions in views

Moin, I use PostgreSQL 6.5.1 and PHP4 under FreeBSD and now I want to use unions in views. But PostgreSQL says "ERROR: Views on unions not implemented.". Are unions in views implemented in the current version (7.x)? Must I reinstall PHP if I update PostgreSQL? Many thank's Matthias

[GENERAL] Last x records

Moin, is there any way to get the last x records of an query result? I can use "... order by x DESC LIMIT n" but I need ASC not DESC, the last records in the correct order. Many thanks Matthias -- Matthias Teege -- [EMAIL PROTECTED] -- http://emugs.de make world not war PGP-Key auf Anfrage

[GENERAL] Connect PostgreSQL 6.0 Server with php4b

ion scheme 131072. in /usr/local/share/apache/htdocs/matthias/hellodb.php on line 2 An error occured. Were is the Problem? Many thanks Matthias

Re: [GENERAL] Connect PostgreSQL 6.0 Server with php4b

is possible. I've tried an explicit line in pg_hba.conf for the webserver but without any success. Any other hints? :-) Thanks Matthias On Sun, Oct 10, 1999 at 04:51:24PM -0300, Charles Tassell wrote: > Your problem is probably in the /usr/local/pgsql/data/pg_hba.conf file. > That

[GENERAL] Connect from a new psql to an old 6.0 postmaster

stgres user 'olduser' using authentication scheme 131072. What does it mean and how can I fix this. Many thanks Matthias

[GENERAL] upgrade postgreSQL

k's for your help __ Matthias Zehnder - Informatique E-mail: [EMAIL PROTECTED] __ M & C net M&C Management & Communications SA A VIA NET.WORKS COMPANY Rue de Romont 35, CH-1700 Fribourg Tél.: ++41 (0)26 347 20 40, fax: ++41 (0)26 347 20 49 E-mail: [EMAIL PROTECTED], http://www.mcnet.ch