Hi,
I am building a web app backed by database postgresql and currently the
site is under a humongous torrent of hits. I have a question regarding
the database backend config.
The database folder has a file called postgresql.cons where we can
specify no of active connections to the database -N
hi
i want to know
how to add a list of items to a database
it is basically text, but different fields
but the problem is i dont know how many fields are there before hand
so i m not sure how to store them in the db
sometime i need to store 10 elements and some other times 5
thanks a lot
a
you mean there are 3 tables
the list of items purchased - this is what i am asking for
the list of items purchased
What is difference between
T_SALES_CC_DETAIL and > T_SALES_DETAIL
thanks a lot
elements in LINK
thanks
Stijn Vanroye wrote:
> a schreef:
> > "select unique id" - i found this line in google search
> > but i want to make
> > select * as unique
> >
> > select unique * is
> > or select distinct
> >
> > pls point out
it returns nill now
or nuthing
and it is very very very slow
Stijn Vanroye wrote:
> a schreef:
> > this doesnt work
> >
> > SELECT DISTINCT on link *, rank(ts_vec, to_tsquery('default', $qtxt))
> > FROM feed_entry WHERE ts_vec @@ to_tsquery('
When stress test Postgres, It can only hold about 200 cocurrent connection
while keep calling DriverManager.getConnection()
Is this number configurable? Or it is the limitation of postgres?
Any suggestion?
Thanks
Feng
Hi,
My DB has has 5TB, it's on Google Cloud Compute, mostly on SSDs, part on
Standard Persistent Disks.
Querying is ok, but deleting, moving between tablespaces, dropping tables,
etc, etc is hugely slow
(note: I do have a number of indexes)
Instance RAM: 60GB
Instance CPU: 16Cores
I&#
am Tue, dem 22.05.2007, um 16:19:55 -0400 mailte Pablo Hume folgendes:
> Hi, sorry for my english, i?m from Paraguay.
>
> I need to know if exists a way to call a program like CMD (command prompt)
> from
> a procedure or a trigger, and execute an external application.
Yes, t
am Mon, dem 21.05.2007, um 18:29:46 -0700 mailte camb folgendes:
> Hey all,
> Is there any way to add some kind of sequence of auto-incrementing
> column to the result set returned by a SELECT?
Yes.
You can use an sequence similar this:
test=# select * from foo;
col1 | co
am Tue, dem 29.05.2007, um 10:48:21 -0400 mailte Robert James folgendes:
> I'd like to be able to detect if a record has associations. I don't want to
> actually delete it, just know if it could be deleted. (This is to build an
> intelligent menu on a GUI)
Set a savepoint
before corruption.
You also confirm you problem like this. And I strongly believe that, there
is some bug in PostgreSQL.
Kindly don't forget to alert me once u find solution/cause.
Regards,
Purusothaman A
On 5/30/07, Paolo Bizzarri <[EMAIL PROTECTED]> wrote:
On 5/30/07, Richa
find any pattern to corrupt the file objects.
Regards,
Purusothaman A
On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Paolo Bizzarri" <[EMAIL PROTECTED]> writes:
> Any hint?
Please provide a reproducible test case ...
regards, tom lane
am Sun, dem 03.06.2007, um 10:34:47 +0200 mailte Badawy, Mohamed folgendes:
> Hi all
>
> am very new to postgres & actually am just collecting information about but I
> having a problem with time so I was asking if someone could help me with quick
> anserws about these f
am Tue, dem 05.06.2007, um 11:49:20 +0200 mailte Marc Compte folgendes:
> Dear list,
>
> This might be too basic for a question but I just couldn't find the
> answer so far.
>
> Does PostgreSQL create an implicit index also for foreign keys?
No, only for primary keys to
etable
(7 rows)
test=*# select word_a || ',' || word_b as pair,
count(1)
from ( select a.word as word_a, b.word as word_b from foo a join foo b on
a.id=b.id where a.word != b.word and a.word > b.word) as bla
group by pair;
pair | count
-+---
0 6
> 1235 1 0 1 7
> 1235 1 1 1 12
>
> I have to create a new table B:
>
> IDB1 B2 B3 S
> 1234 4 8 5 17
> 1235 6 7 12 25
>
> The combination (A1=1,A2=0,A3=0) gives B
am Thu, dem 14.06.2007, um 10:57:43 -0700 mailte Lza folgendes:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all chan
ort of "id", account names, etc., which are
> often not only stored in the database but also in external places so
> changing is just a definitive DON'T).
>
> Obviously I can check this with triggers, but it occured me that some kind
> of "CONSTANT" field a
am Fri, dem 15.06.2007, um 8:21:45 -0400 mailte Francisco Reyes folgendes:
> Lza writes:
>
> >I have a table in my database that holds information on policies and
> >this table is linked to a number of other tables. I need to be able to
> >keep a history of all chang
am Mon, dem 18.06.2007, um 10:14:32 -0300 mailte Ranieri Mazili folgendes:
> Hello,
>
> I'm creating a function that will create a select statement into a
> while, this select will be stored into a text variable, after while ends
> I need to execute this query stor
am Mon, dem 18.06.2007, um 14:59:34 +0200 mailte Stefan Schwarzer folgendes:
> Hi there,
>
> my app is creating views for a certain task; now, I would like to run
> on a regular basis a script which deletes these views. As they are
> named with the date/hour/min/sec-append
am Tue, dem 19.06.2007, um 12:23:51 +0200 mailte Philippe Lang folgendes:
>
> I'd like to prevent any kind of modification (insert, update, delete) in
> a order (and its lines, and steps) if all the steps in the lines of the
> order are "checked". If that condition is
am Thu, dem 28.06.2007, um 16:04:48 -0400 mailte Jasbinder Singh Bali
folgendes:
> Hi,
>
> I have a timestamp field in my talbe.
> I need to check its difference in days with the current date.
>
> field name is time_stamp and I did it as follows:
>
> select age(tim
am Fri, dem 29.06.2007, um 13:31:03 +0530 mailte Ashish Karalkar folgendes:
> Hello All,
>
> I am trying to create a user and i dont understand why it is showing me any
> massage even after giving parameter -e to the command.
Maybe you should use -q:
-q
--quiet
am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar folgendes:
> Hello All,
> I am trying to create databse with script.
> I run this script from root prompt with command
>
>
> $ su - postgres -c 'path to script.sql'
>
>
> In the script I follow following steps
>
>
> 1) cr
am Tue, dem 03.07.2007, um 12:11:01 -0400 mailte Mike Gould folgendes:
> Is there a way to determine the order that triggers are executed? We are
alphabetically
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C,
ay');
> Result: 2007-04-26
Write you own function. You can get the last date for a month like this:
select '2007-04-01'::date+'1month'::interval-'1day'::interval;
You can get the weekday with:
select extract('dow' from
'2007-04-01'::date+&
am Tue, dem 03.07.2007, um 23:37:57 +0100 mailte Raymond O'Donnell folgendes:
> Hi all,
>
> Is it still possible to get PostgreSQL merchandise? A friend of mine is
> looking for some, but I can't seem to find where its available.
Can you or your fried visit the pgday.it
am Mon, dem 09.07.2007, um 2:53:48 -0400 mailte Jasbinder Singh Bali
folgendes:
> Hi,
>
> If I have a series of Insert statements within a loop in a function on the
> same
> table.
> Would an Insert be able to see the values of previous insert in that table ?
Inside
am Tue, dem 10.07.2007, um 14:32:58 +0200 mailte Zlatko Matic folgendes:
> Hello.
> Is there any free program/utility for batch imports from .csv files, that
> can be easily scheduled for daily inserts of data to PostgreSQL tables?
> Regards,
You can use the scheduler from your OS. For Unix-like
am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes:
> Hello,
please don't hijack other threads. If you only change the subject for a
new question, your mail will be sorted completely wrong.
(within modern email-clients such thunderbird or mutt)
>
> I use MS A
am Wed, dem 11.07.2007, um 14:55:28 +0200 mailte Zlatko Matic folgendes:
> I have already tried COPY.
> But, it has problems with type castings.
> For example, COPY operation fails because PostgreSQL can't copy value
> 7.844,000 into NUMERIC field...
Either copy such values i
am Fri, dem 13.07.2007, um 18:50:26 +0200 mailte Zlatko Mati? folgendes:
> When using multirow INSERT INTO...VALUES command, are all rows inserted in a
> batch, or row by row?
Within one transaction, yes.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639
Hi,
I want to take a plan generated by the postgres optimizer and insert a
constant in place of another constant in the plan. There is a function
OidOutputFunctionCall() to get the constant. Similarly, is there any
function to set the value of the constant? What does
OidInputFunctionCall() do
am Wed, dem 18.07.2007, um 15:39:01 +0530 mailte Ashish Karalkar folgendes:
> Hello all,
>
> I want to take backup from one server and save it to another machine hard
> drive.
> The backup will be taken through a shell script attached to a cron job.
>
> something l
am Mon, dem 23.07.2007, um 13:58:22 -0400 mailte Robert Fitzpatrick folgendes:
> Is it possible to use COALESCE function inside a function as a cursor
> variable?
Yes, why not?
>
> test cursor (myvar varchar) for
> (coalesce(SELECT...,0));
I guess: wrong syntax. Try
am Mon, dem 23.07.2007, um 7:50:35 -0700 mailte [EMAIL PROTECTED] folgendes:
> Hi all,
>
> I would like to change a sub-string in a text-field by using
>
> UPDATE tablename SET
> fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)
> WHERE (fieldname
am Fri, dem 10.08.2007, um 17:46:11 +0800 mailte carter ck folgendes:
> Hi all,
>
> I am facing a performance issue here. Whenever I do a count(*) on a table
> that contains about 300K records, it takes few minutes to complete. Whereas
> my other application which is counting
am Thu, dem 16.08.2007, um 10:30:01 +0200 mailte Ji?í N?mec folgendes:
> Hello,
>
> I would like to ask you for an advice.
>
> There are two tables in my PostgreSQL database - main table with datas and
> second with translations for all languages of these records.
>
>
lpgsql trigger function which will UPDATE a record (or
> INSERT new record) when the record is not found. But as far as I know
> a trigger is not executed when a updated record is not found, so this
> solution doesn't work for me. I don't want to change my application -
> I woul
Thanks again guys =)
I've managed to use temp table to load the data and create new table/s
Now, how do I convert a text field with 'YY/MM/DD' to date field 'DD/MM/YY'?
On 13/08/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Paul Lambert <[EMAIL PROTECTED]&
am Wed, dem 15.08.2007, um 17:29:17 -0400 mailte Madison Kelly folgendes:
> What I would like to do is create a function that would do the same
> thing so I could read out the IP addresses as standard dotted-decimal
> format. Could anyone help me with this? I am quite the n00
Hi, We have the following three tables.
safety=> SELECT record_id, record_date FROM record;
record_id | record_date
---+
1 | 2007-07-23 11:30:37+10
2 | 2007-07-27 11:30:14+10
3 | 2007-07-17 13:15:03+10
(3 rows)
safety=> SELECT obser
am Tue, dem 21.08.2007, um 20:20:38 +0200 mailte Robin Helgelin folgendes:
> Hi,
>
> I want to save history for a few tables using triggers on update and
> creation. What's the best approach to do this in a webapp environment
> where I want to save which webapp user that is d
am Mon, dem 27.08.2007, um 9:40:45 -0300 mailte Marcelo de Moraes Serpa
folgendes:
> Hello list,
>
> I'm trying to execute the following sentences in a pl/pgsql function.
> aNomeProcAudita and pTabAudit are both variables.
>
>DROP FUNCTION IF EXISTS aNomePro
am Tue, dem 28.08.2007, um 10:56:38 +0530 mailte Ashish Karalkar folgendes:
> Hello all,
>
> I have a database abc with owner c .
> I want to grant only read access on this DB abc to user d.
> More specificaly to a schema abcs in the databse abc.
> Is ther any way to do so?
am Tue, dem 28.08.2007, um 8:08:36 -0400 mailte Kynn Jones folgendes:
> I'm hoping to get some advice on a design question I'm grappling with.
> I have a database now that in many respects may be regarded as an
> collection of a few hundred much smaller "parallel data
am Tue, dem 28.08.2007, um 14:23:00 +0200 mailte Kamil Srot folgendes:
>
> Kynn Jones wrote:
> >I'm hoping to get some advice on a design question I'm grappling with.
> > I have a database now that in many respects may be regarded as an
> >collection of a
QUERY PLAN
> -
> Sort (cost=958786.20..970734.55 rows=4779338 width=28)
>Sort Key: f2,f3
>-> Seq Scan on t (cost=0.00..85501.38 rows=4779338 width=28)
>
> I'd like to know a hint about a technicque to avoid the se
am Thu, dem 30.08.2007, um 14:59:06 +0800 mailte Ow Mun Heng folgendes:
> Is there a way to do a dump of a database using a select statement?
A complete database or just a simple table?
>
> eg: \copy trd to 'file' select * from table limit 10
Since 8.2 you can use COPY (
am Wed, dem 05.09.2007, um 6:58:30 -0700 mailte Rob folgendes:
> What is the proper why to deal with temp tables and sequences? Why aren't they
> being dropped after the function ends? Why do I get OID errors if I delete the
> temp table/sequence at the end of the function and then try to rerun t
correction:
> The result I'm expecting for the above to be
>
>notification_time| finished_time | actual
> ++-
> 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00
> 2007-07-07 12:30:00+10 | 2007-07-09 07
am Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes:
> Hi group,
>
> Does anybody know of an tutorial for EXPLAIN for idiots like me?
> (I am fairly confortable with Postgres, but never used EXPLAIN before.)
>
> I need to optimize a few slow running que
am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus folgendes:
> Hello,
>
> I am looking for a tool which is able to generate a database diagramm
> including the relationships from an existing database schema. The only
> tool I know for this purpose is the Clay data
am Wed, dem 12.09.2007, um 7:32:45 -0600 mailte Dennis Muhlestein folgendes:
> I've been passively collecting data for a few months. I realized, after
> a while, that I never added a timestamp column to the table the data is
> being stored in. I've since added that.
>
am Wed, dem 12.09.2007, um 15:41:44 +0200 mailte A. Kretschmer folgendes:
> am Wed, dem 12.09.2007, um 7:32:45 -0600 mailte Dennis Muhlestein folgendes:
> > I've been passively collecting data for a few months. I realized, after
> > a while, that I never added a timestamp
am Thu, dem 13.09.2007, um 10:44:41 +0200 mailte Ottavio Campana folgendes:
> > http://ads.wars-nicht.de/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
>
> since I already use triggers on that table, can I use table_log?
>
> I mean, can I have two triggers for the same even
am Thu, dem 13.09.2007, um 11:25:39 +0200 mailte Kai Behncke folgendes:
> But always if I sent as user xy the
> "UPDATE pg_catalog.pg_class SET reltriggers = 0;"-command I get:
>
> "SQL error:
>
> ERROR: permission denied for relation pg_class"
>
>
test=*# \h alter table
Command: ALTER TABLE
Description: change the definition of a table
Syntax:
ALTER TABLE [ ONLY ] name [ * ]
Okay:
ALTER TABLE foo DISABLE TRIGGER ALL;
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID
in my UNIX System?
>
> If yes, how do I do this and if no, thanks for telling.
You can do this, you need a untrusted language like plperlU or plsh.
Then you can write a TRIGGER and call external programs.
Hope that helps, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150,
am Mon, dem 17.09.2007, um 9:21:22 +0800 mailte Ow Mun Heng folgendes:
> CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> timestamp, code text)
> RETURNS SETOF foo AS
> $BODY$
> SELECT
> TRH.ID,
> TRH.data1,
> TRH.data2,
> FROM D
> INNER JOIN
am Wed, dem 19.09.2007, um 22:36:02 +1200 mailte [EMAIL PROTECTED] folgendes:
> Hello
>
> I want to know about the size of my database. For example, I want to know
> how many Mb of data for current myDatabase database in a postgres server.
http://www.postgresql.org/docs/8.1
am Thu, dem 20.09.2007, um 14:13:40 +1000 mailte Chester folgendes:
> Hi
>
> I have a question regarding foreign keys, I just cannot get it to create
> them for meI must be doing something wrong but I have no idea what
> that might be :)
>
> I have a table "clien
am Fri, dem 28.09.2007, um 11:56:46 -0400 mailte Mike Charnoky folgendes:
> Hi,
>
> I am still having problems performing a count(*) on a large table. This
>
> Now, certain count(*) queries are failing to complete for certain time
> ranges (I killed the query after about 24
am Fri, dem 28.09.2007, um 12:50:34 -0400 mailte Alvaro Herrera folgendes:
> A. Kretschmer wrote:
> > am Fri, dem 28.09.2007, um 11:56:46 -0400 mailte Mike Charnoky folgendes:
> > > Hi,
> > >
> > > I am still having problems performing a count(*) on a
am Thu, dem 04.10.2007, um 18:47:01 +0500 mailte test tester folgendes:
>
>
> On 10/4/07, test tester <[EMAIL PROTECTED]> wrote:
>
> i have version 8.1 and i want to know how to insert multiple rows in this
> version.
Please no silly top post.
You can insert multiple values with one i
am Fri, dem 05.10.2007, um 11:43:09 +0530 mailte Ashish Karalkar folgendes:
> Hello All,
>
> I am getting following error when trying to create new database.
>
>
> createdb: database creation failed: ERROR: could not create directory "base/
> 1923827": No space left on device
> can anybody
am Fri, dem 05.10.2007, um 8:20:32 +0200 mailte Stefan Schwarzer folgendes:
> Before I was used that the yearly values were all to be found in a
> single SQL row; now for each year of each country I have a separate
> row. How do I convert that into a single (HTML) row again?
Yo
am Fri, dem 05.10.2007, um 9:13:10 +0200 mailte Stefan Schwarzer folgendes:
> >>
> >>And the next question coming up is: How should my query look like so
> >>that I can sort the (HTML) table by a specific year in ascending or
> >>descending order? So, that
come through as
Do you mean me?
> flagged messages in Outlook, it throws off my email rules processing
> and the messages end up into the wrong groups. (With the volume of
This header is a special Outlook-Feature. If this header realy make
problems in _this_ software, then i think, _this
am Mon, dem 08.10.2007, um 3:28:04 -0700 mailte marwis1978 folgendes:
> I have a following table
> -+
> day | quantity
> -+
>
> where day is a date and quantity is an integer value. Now I need to
> make a SELECT statement on this table wh
ick to jump on my use of Outlook as an email client (thus assuming
> I was just one of "those" terrible horrible know-nothing Windows users).
I can speak only for myself, but when i see damaged mails (with, for
instance, broken quoting-line as you can see above, then i think:
'apparent
am Mon, dem 08.10.2007, um 12:00:30 -0700 mailte Richard Broersma Jr folgendes:
> --- "A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> > > > at least post them and see what kind of response you get,
> > > > rather than judge the list as a whole due to th
am Mon, dem 08.10.2007, um 15:46:04 -0500 mailte Scott Marlowe folgendes:
> Actually CC to the sender is the norm on this list. I believe there
Okay, no problem. I'm knowing other lists like the german debian user
list and there is this CC to the sender unwanted.
Andreas
--
Andreas Kretschmer
am Fri, dem 12.10.2007, um 5:06:38 +0100 mailte manju arumugam folgendes:
> Hi,
>
>
> In my site when am update the edit user info page its
> prperly works in firefox .But not works in IE...But
> the updation takes place in the database but the page
> is not displayed...Wats the reason?
IE is
am Wed, dem 17.10.2007, um 13:01:25 +0200 mailte Christian Rengstl folgendes:
> Hi list,
>
> Whenever I try dropping a view using DROP VIEW myschema.myview the
> query runs forever. The last time I tried was ten minutes ago and the
> query is still running even though the view qu
am Wed, dem 17.10.2007, um 22:30:26 -0400 mailte Bret Schuhmacher folgendes:
> Does anyone else invoke a process on a remote server? How do you do it?
You can use any untrusted programming language like pl/perlU or plsh.
Other solution: use LISTEN/NOTIFY, see
http://www.postgresql.org/docs/
am Tue, dem 16.10.2007, um 21:55:38 -0700 mailte Bret Schuhmacher folgendes:
> Does the PG/Tcl interface allow expect scripts? I want to create a stored
> procedure that ssh's to another server and runs a Perl script. Expect could
> do
> it, but can I load the expect modu
am Wed, dem 24.10.2007, um 15:08:51 +0200 mailte Stefan Schwarzer folgendes:
> Now, I want to enable queries which display national as well as
> regional values. I could probably work with independent queries, but
> I think it would be "cleaner" and more efficient to get ev
am Thu, dem 25.10.2007, um 5:25:14 -0700 mailte Evandro Andersen folgendes:
> In Oracle you can use this:
>
>
>
> DELETE FROM A WHERE A1 = 10 ORDER BY A2
>
>
>
> There is something in the Postgresql ?
Can you explain this a little bit more? I can't see any
RETURN;
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
>
> ERROR: query has no destination for result data
> HINT: If you want to discard the results of a SELECT, use PERFORM
> instead.
> CONTEXT: PL/pgSQL function "query_time2" line 3 at SQL sta
am Tue, dem 30.10.2007, um 14:51:33 -0300 mailte João Paulo Zavanela folgendes:
> Hi,
>
> I would like to know how many active connections exist.
> Is necessary show the number ip of client.
ask pg_stat_activity
(select * from pg_stat_activity;)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz
am Wed, dem 31.10.2007, um 17:14:02 -0400 mailte Gauthier, Dave folgendes:
> When I run a query, and the number of lines exceeds what the screen can hold,
> the results seem to get piped into ?more? (or ?less?). How can I turn that
> off
> and just have everything stream out with
am Wed, dem 31.10.2007, um 16:34:44 +0200 mailte Anton Andreev folgendes:
> Hi,
>
> I have records with date column. Is there a way I can get which day of
> week this date is?
Yes, no problem. select extract (dow from date).
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz:
am Sat, dem 03.11.2007, um 11:09:05 +0400 mailte rihad folgendes:
> Hi,
>
> Should an index be used on a created_at timestamp column if you know you
> will be using "ORDER BY created_at ASC|DESC" from time to time?
Yes. And you should use EXPLAIN.
Andreas
--
Andr
am Mon, dem 12.11.2007, um 10:54:53 -0500 mailte Gauthier, Dave folgendes:
> Is there a function that?ll return the position of the last occurance of a
> char
> in a string?
>
>
>
> For Example, in the string ?abc/def/ghi? I want the position of the 2^nd ?/?.
write a f
am Mon, dem 12.11.2007, um 8:48:29 -0800 mailte David Fetter folgendes:
> > > Is there a function that?ll return the position of the last
> > > occurance of a char in a string?
> > >
> >
> > write a function to revert the string and use strpos().
mn names in your output. However
I was unable to find any information regarding using column aliases
as variables, like in the code above. I'm not sure why this works
in access, but does postgreSQL support using a column alias like a
variable within the query that the alias was defined in
am Wed, dem 14.11.2007, um 15:16:48 +0800 mailte froast folgendes:
> in mysql, I used :"set foreign_key_check = 0;" to disable the foreign key
> check, now I'm trying to migrate from mysql to postgres, how should I do
> to disable it?
You can define the constraints as deferrable. Later you can
, action, table_name) VALUES(current_user,
> act, tab);
>
> Now the problem is that a tuple gets added to the table history, but
> the field "action" (whatever the user did) is 99% empty, whereas the
> others are filled and I don't see why...
>
> Any hint is great
am Thu, dem 29.11.2007, um 15:48:45 +0100 mailte Pau Marc Munoz Torres
folgendes:
> Hi everybody
>
> I'm doing a two table query as follow
>
> mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as
> t1, precalc as t2 where t1.ce='ACIAD
am Fri, dem 30.11.2007, um 5:22:34 -0500 mailte Madison Kelly folgendes:
> Hi all,
>
> If there a ./configure switch (or config file/command line switch) to
> tell postgresql to put the lock file '.s.PGSQL..lock' and socket
> '.s.PGSQL.' in a different
hive\DBArchive\myfile<< failed: error code
> 1
> >>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
> 1
> >>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code
> 1
> WARNING: transaction log file could not be archived: too
am Mon, dem 03.12.2007, um 12:29:39 +0100 mailte Christian Rengstl folgendes:
> Hi list,
>
> a have a problem using the following archiving command on windows:
> 'copy %p C:\\Archive\\DBArchive\\%f'
According the doc, the command should be:
archive_command = 'copy
am Tue, dem 04.12.2007, um 12:05:41 +0100 mailte Christian Rengstl folgendes:
> >> a have a problem using the following archiving command on windows:
> >> 'copy %p C:\\Archive\\DBArchive\\%f'
> >
> > According the doc, the command should be:
> >
am Wed, dem 05.12.2007, um 10:24:04 + mailte Ashish Karalkar folgendes:
> Hello List member,
>
> Iha a table containing two columns x and y . for single value of x there are
> multiple values in y e.g
>
> X Y
>
> 1 ABC
> 2 PQR
>
am Wed, dem 05.12.2007, um 14:42:32 +0100 mailte Przemyslaw Bojczuk folgendes:
> Hello!
>
> I have a problem joining two tables. I tried various types of join and
> none seems to work as I expect
>
> Table 1:
>
> id | stuff
> ---
> 1 | sth1
> 2
am Wed, dem 05.12.2007, um 3:46:26 -0800 mailte David Fetter folgendes:
> Use the array_accum aggregate from the docs as follows:
>
> SELECT x, array_to_string(array_accum(y),':')
> FROM your_table
> GROUP BY x;
Yes, no noubt a better solution as my new aggregat
am Wed, dem 05.12.2007, um 10:47:44 + mailte Ashish Karalkar folgendes:
> > X Y
> >
> > 1 ABC
> > 2 PQR
> > 3 XYZ
> > 4 LMN
> > 1 LMN
> > 2 XYZ
> >
> > I want a query that will
am Thu, dem 06.12.2007, um 10:25:26 +0100 mailte Cedric Boudin folgendes:
> Most honourable members of the list,
>
> this is a simple one, but I can't find the solution ( probably a
> forest/tree problem).
>
> update table set bolean_column = set_it_to_its_inverse where f
1 - 100 of 1430 matches
Mail list logo
