On March 12, 2015 06:43:40 AM Gavin Flower wrote:
> Bill cannot comment, but it might be along the lines of assigning all
> intellectual property rights, or something of that ilk. In that case, it
> might give the company ownership of stuff he may have contributed (or
> intends to contribute) to
On March 25, 2015 09:31:24 PM David G. Johnston wrote:
> On Wed, Mar 25, 2015 at 8:58 PM, Mitu Verma wrote:
> > Correcting the subject
>
> And this is why it is considered good form to do "compose new message"
> instead of replying to an existing one. Injecting your new topic into an
> existin
On March 27, 2015 01:12:52 PM Eli Murray wrote:
> ERROR: syntax error at or near "json_build_object"
> LINE 1: insert into json(data) json_build_object(SELECT DISTINCT dep...
You may want to review the syntax of the INSERT command, i.e. this doesn't
have anything to do with JSON:
INSERT INTO fo
On March 27, 2015 11:38:42 AM David G. Johnston wrote:
> On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser wrote:
> > On March 27, 2015 01:12:52 PM Eli Murray wrote:
> > > ERROR: syntax error at or near "json_build_object"
> > > LINE 1: insert into json(data)
On March 28, 2015 06:18:49 PM Alex Magnum wrote:
> Hello,
> I am struggling with finding the right way to deal with arrays of composite
> types. Bellow is an example of the general setup where I defined an image
> type to describe the image properties. A user can have mulitple images
> stored.
The
On May 4, 2015 02:32:14 PM Yves Dorfsman wrote:
> > As for performance concerns, in 99% of cases code maintainability is going
> > to be way more important than performance microoptimization. If you're
> > *that* concerned about performance than plpgsql probably isn't the right
> > answer anyway.
>
On May 21, 2015 06:04:37 PM Brown, Joseph E.
wrote:
> Unsubscribe pgsql-general
This doesn't work. See the footer of the posts to the
mailing list.
On May 21, 2015 11:56:52 AM Steve Crawford wrote:
> The article does also display a couple attitudes that I feel are especially
> rampant in the web-development community. The first is that web developers
> shouldn't become educated about the capabilities of a database but rather
> use the database
On May 23, 2015 01:48:11 PM David G. Johnston wrote:
> On Sat, May 23, 2015 at 1:34 PM, Ravi Krishna
>
> wrote:
> > Is it true that PG does not log undo information, only redo. If true,
> > then how does it bring a database back to consistent state during
> > crash recovery. Just curious.
>
> W
On May 25, 2015 04:17:32 PM Piotr Gasidło wrote:
> test_uuid=# drop extension "uuid-ossp";
> ERROR: cannot drop extension uuid-ossp because other
objects depend on it
> DETAIL: default for table test column id depends on function
> uuid_generate_v4() HINT: Use DROP ... CASCADE to drop the
depe
On June 1, 2015 11:11:37 PM Arthur Silva wrote:
> In my opinion a twice a year schedule would be good.
> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported at
> all moments.
>
> Maybe this should be reposted to the hackers list?
Pretty sure this would be shot down pretty qui
On June 2, 2015 03:16:53 PM Zenaan Harkness wrote:
> On 6/2/15, Jan de Visser wrote:
> > On June 1, 2015 11:11:37 PM Arthur Silva wrote:
> >> In my opinion a twice a year schedule would be good.
> >> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions support
On June 3, 2015 02:04:28 PM Roxanne Reid-Bennett wrote:
> I think you should evaluate your unease with having to update the database
> on release (potentially many times) carefully for what it is and why you
> have it. [I'm not saying it is invalid - just know why you have it]
> Because no matter
On June 26, 2015 11:59:05 PM Robert Nikander wrote:
> Hi,
>
> (Maybe my subject line should be: `is not distinct from` and indexes.)
>
> In Postgres 9.4, I’ve got a table of ‘items’ that references a table
> ‘colors’. Not all items have colors, so I created a nullable column in
> items like:
>
On July 1, 2015 07:39:59 AM Urs Berner wrote:
> I installed Ubuntu 14.04 LTS
> apg-get update ... apt-get upgrade ...
>
> and looked at
> www.postgresql.org/download/linux/ubuntu
> then added apt repository /etc/apt/sources.list.d/pgdg.list
>
> When I try
>
> apt-get install postgresql-9.4
>
>
On July 1, 2015 02:51:37 PM Urs G. Berner wrote:
> Am 01.07.15 um 14:08 schrieb Jan de Visser:
> > On July 1, 2015 07:39:59 AM Urs Berner wrote:
> .
> .
>
> > I would uninstall the stock (Ubuntu) version before installing the pgdg
> > version.
>
> There is
On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote:
> On 2015-07-05 15:11 Charles Clavadetscher
>
> wrote:
> > I am not really an expert, but from your description I guess that you
> > assume an existing PostgreSQL installation on your customers' server.
>
> The application is a simple open sou
On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote:
> On 2015-07-05 15:13 Jan de Visser wrote:
> > You could set up a whole new server with a different $PGDATA on a
> > different port.
>
> I (and the user) don't want to setup anything - that is the point.
Well, you do
On September 13, 2015 03:57:51 PM Dale Seaburg wrote:
> I have reached my wit's end. lol I installed postgresql (9.3.9) and
> pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I
> get an error "password authentication failed for user "postgres" ".
> Ubuntu (14.04.3).
>
> I c
On September 14, 2015 07:22:58 AM Martín Marqués
wrote:
> I would recommend using psql's \password meta-
command instead of ALTER
> USER to change a password, as to avoid having the
password stamped in
> the logs.
You learn something new every day :-)
jan
On September 14, 2015 07:22:58 AM Martín Marqués
wrote:
> I would recommend using psql's \password meta-
command instead of ALTER
> USER to change a password, as to avoid having the
password stamped in
> the logs.
You learn something new every day :-)
jan
On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote:
> Now I am trying to call the same function through JDBC driver 9.4.1208.jre7:
>
> private static final String SQL_SKIP_GAME =
> "SELECT words_skip_game(?, ?)";
>
> try (PreparedStatement st =
> mDatabase
On Wednesday, June 15, 2016 4:21:47 PM EDT Alexander Farber wrote:
> Hello Jan,
>
> On Wed, Jun 15, 2016 at 4:17 PM, Jan de Visser wrote:
> > On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote:
> > > Now I am trying to call the same function through JDBC
On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote:
> On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote:
> > Point is that you're doing a SELECT. A SELECT returns a result, which can
> > be
> > empty. I would use executeQuery and ignore the result.
On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote:
> On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote:
> > Point is that you're doing a SELECT. A SELECT returns a result, which can
> > be
> > empty. I would use executeQuery and ignore the result.
On Wednesday, June 15, 2016 9:07:10 PM EDT Alexander Farber wrote:
> I only understand a quarter of what you guys are writing,
> but to me the JDBC driver throwing SQLException
> "A result was returned when none was expected"
> when my stored function is declared as "void" with
>
> CREATE OR REPLA
Please don't top post.
On Thursday, June 16, 2016 3:42:53 AM EDT Yogesh Sharma wrote:
> Dear David sir/All,
>
> Thanks for your help.
> Just wanted to confirm few things.
>
> (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for text
> search objects (Álvaro Herrera)
> As per m
Please don't top-post.
On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote:
> hi
> sir
> as per above discussion same error repeated even mentioned ip address of
> hostname
>
> ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly
> -allTables dbo
>
>
> TARGET_DB_UR
ettings.
> raghu=#
>
> On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser wrote:
> > Please don't top-post.
> >
> > On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote:
> > > hi
> > > sir
> > > as per above discussion s
On 2016-09-26 1:15 AM, Gavin Flower wrote:
On 26/09/16 17:58, Patrick B wrote:
Hi guys,
I've got this domain:
CREATE DOMAIN public.a_city
AS character varying(80)
COLLATE pg_catalog."default";
And I need to increase the type from character varying(80) to
character varying(2
On 2016-10-08 2:36 AM, Stephen Davies wrote:
On 07/10/16 19:24, Thomas Kellerer wrote:
Stephen Davies schrieb am 07.10.2016 um 10:46:
You can store the contents of a file in a bytea using plain JDBC no
lo_import() required
String sql = "insert into images (id, image_data) values (?,?)";
On 2016-11-24 9:06 PM, Yogesh Sharma wrote:
Dear John,
Thanks for your support.
I mean to say, the REINDEX calls hourly and insert query executes every minute
to update.
So, it might be race condition that these queries can call at same time.
Why do you need to run REINDEX every hour? That s
On Thursday, December 15, 2016 5:15:44 PM EST Thomas Kellerer wrote:
> Tom Lane schrieb am 15.12.2016 um 16:20:
> >> Still doesn't work:
> >> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\""
> >> pg_dump: no matching tables were found
> >
> > Hmm. It might shed some light if you put "echo" in
On Wednesday, December 28, 2016 6:02:51 AM EST Mike Sofen wrote:
> the natural lashup of plpgsql to postgres (I liked Alban’s term,
> “impedance”), is a key aspect.
Not to deprive Alban of any of his credit, but the term "impedance mismatch"
is at least 25 year old; as far as I know it was coined
On Thursday, December 29, 2016 5:10:08 AM EST rajmhn wrote:
> Gurus,
>
> Reading the data from file and loading it using pg_bulkload- C filter. As
> per documentation, C filter is much faster than SQL filter.
>
> I'm new to C. Gone through this documentation. Not clear, how to start.
> https://ww
>
> Hi guys,
>
> I've got the following Query:
>
> WITH
>
>query_p AS (
>
>SELECT CAST(6667176 AS
> BIGINT) AS client_id),
>
>
>
>
> clients AS (
>
>SELECT
>
On 2015-11-27 4:31 AM, NTPT wrote:
Thanx for help, I grab the source code that match old cluster fs
backup.
However: Should it run fine compiled with recent gcc 4.9.3 ?
You realize how old 9.0 is, right? And you understand how nonsensical
your question is? How can you guarantee that cod
On 2015-11-27 9:44 AM, Adrian Klaver wrote:
You realize how old 9.0 is, right? And you understand how nonsensical
your question is? How can you guarantee that code compiles properly on a
compiler which is released years after you write the code?
To me nonsensical would be trying to compile newe
[offtopic alert]
On 2016-01-06 12:46 PM, James Keener wrote:
How does one "start a new thread"?
'New Message' in your favourite email client.
'pgsql-general@postgresql.org' in the 'To' box.
I wasn't aware that changing the subject wouldn't be enough. I tried :/
Check the raw source of the
On March 8, 2016 12:18:08 AM da...@andl.org wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
>
>
>
> Yes, I was aware of GD and SD. My question is about what facilities Postgres
> provides for implementing such a thing. Wh
On March 8, 2016 11:35:00 AM da...@andl.org wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
>
> this stuff you're loading from the database once, that's just data about
> your language plugin's configuration, or is it user
On March 8, 2016 03:00:14 PM da...@andl.org wrote:
> At the moment I have two pressing problems.
>
> One is the start-up phase: getting the Andl runtime stoked up, load its
> catalog, set up its execution environment (including its own type system),
> ready for business. That process in Postgres s
On Friday, March 18, 2016 1:18:01 PM EDT ando...@aule.net wrote:
> Hi,
>
> After upgrading to PostgreSQL 9.4.6, our test system gave error messages
> like:
>
> ERROR: invalid salt
>
> The cause of these errors is statements like:
>
> WHERE password = crypt('secret', 'secret')
>
> After
On Friday, April 15, 2016 8:13:56 PM EDT Melvin Davidson wrote:
> *Thanks for the sympathetic feedback John. I understand people are
> reluctant to change. It was just my intent to enlighten others as to the
> true background behind it.*
> *So if it's not about to change, then I'll just have to cry
On Thursday, April 21, 2016 12:55:00 PM EDT Melvin Davidson wrote:
> WHY am I being vilified for making a simple request? How is it that
> developers proceed with other enhancements, yet so much negative attention
> is being given to my request because of unjustified fear that something bad
> will
On Wed, May 11, 2016 at 10:03 PM, Lucas Possamai
wrote:
>
>>>
>> Trying redoing the query with CTE as below:
>>
>> WITH ja_jobs as
>> (SELECT DISTINCT title
>> FROM ja_jobs
>> WHERE clientid = 31239 AND time_job > 1457826264
>> )
>> SELECT title
>> FROM ja_jobs
>> WHERE title ILI
On Tuesday, May 17, 2016 9:41:51 AM EDT Bryan Nuse wrote:
> On 05/17/2016 08:25 AM, Victor Yegorov wrote:
> > I had a bit of fun with this SQL version and came up with this query:
> >
> > WITH src(s) AS (
> >
> > VALUES
> >
> > ('729472967293732174412176b12173b17111752171927491b1744171b1741121
On Friday, May 20, 2016 3:14:54 PM EDT Venkata Balaji N wrote:
> Hi,
>
> "make" command is generating the following error while compiling
> postgresql-9.5.3 on Solaris SPARC.
>
> I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5.
... snip ...
>
> Regards,
> Venkata B N
>
On Monday, May 23, 2016 1:17:13 PM EDT Albe Laurenz wrote:
> David G. Johnston wrote:
>
> > On Mon, May 23, 2016 at 6:54 AM, aluka raju
> > wrote:
>
> >> As given in the FAQ's that postgresql cannot be embedded
> >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F .
> >>
> >>
tp://www.postgresql.org/docs/8.2/interactive/functions-sequence.html).
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
Baruk
On Friday 20 July 2007 12:51:47 Tom Lane wrote:
> Can someone make a reproducer that uses
> PQexecParams?
Does JDBC apply?
jan
--
------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad a
On Wednesday 15 August 2007 1:58:07 am Harpreet Dhaliwal wrote:
> So you mean to say something like this as far as oracle is concerned:
>
> BEGIN
> DDL 1 (commits right after its execution)
> DDL 2 (commits right after its execution)
> END
>
> That means there's no concept of putting DD
ace.
And yes, I've done this to (specified -d on a pg_dump command line, that is).
jan
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
On Thursday 27 September 2007 00:38:15 Tom Lane wrote:
> Jan de Visser <[EMAIL PROTECTED]> writes:
> > In my world two identical pilot errors within a short timeframe are
> > indicat= ive=20
> > of a bad interface.
>
> Yeah, it's inconsistent. How many people
; TIP 5: don't forget to increase your free space map settings
--
----------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
ver2
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 6
On 11/14/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> > On Mon, Nov 12, 2007 at 03:11:50PM -0800, Sarah Dougherty wrote:
> >> To recap with an example, the query below works fine, but how do I add a
> >> series to it?
>
> > generate_series will n
On 11/14/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Jan de Visser" <[EMAIL PROTECTED]> writes:
> > Any reason why this couldn't appear in the core of some future
> > version?
>
> You didn't read to the end of my post ;-). If a rownum() function
On 12/8/07, Charles <[EMAIL PROTECTED]> wrote:
> I am using Ubuntu 7.10. When trying to use Postgresql 8.2 I get the
> following errors:
>
> [EMAIL PROTECTED]:~# su -c postgres
> bash: postgres: command not found
Ignoring an error and just charging on seems quite dangerous to me,
especially when b
to rows shared by the two transactions are
done late in the process, but this lock happens almost immediately after the
second tx starts...
Comments?
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
to rows shared by the two transactions are
done late in the process, but this lock happens almost immediately after the
second tx starts...
Comments?
jan
--
----------
Jan de Visser [EMAIL PROTECTED]
On December 21, 2014 04:08:43 PM Andomar wrote:
> It is not always easy to tell the query type (function, prepared or
> ad-hoc.) We use Python in mod_wsgi with psycopg2. The code shows ad-hoc
> SQL, but who knows what the many layers between Python and the database do.
psycopg2 sends the SQL you
On February 28, 2015 03:39:06 PM inspector morse wrote:
> Is it a good idea to write a simple application (consisting of just data
> entry interfaces) in pure pgsql?
>
> Basically, we would have each page has a stored function in postgresql that
> is called by php+apache (the http get/post values
On March 1, 2015 09:45:24 AM inspector morse wrote:
> This is just for fun/research, I don't need a web framework because PHP is
> actually picking up the incoming requests and sending it to a pgsql stored
> function. The pgsql will concatenate all the html that is required for the
> page and send
On Friday, February 10, 2017 6:46:08 PM EST David G. Johnston wrote:
> In short - this is the wrong list (pgsql-j...@postgresql.org is the
> appropriate one; or the official GitHub repo) and you need to provide some
> working self-contained examples showing exactly what you are doing.
>
> On Fri
On Tuesday, April 11, 2017 5:43:29 AM EDT Osahon Oduware wrote:
> Hi,
>
> I am using Windows 7 OS and I have installed a GDAL with support for MrSID
> format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to
> point to this new GDAL.
>
> How do I accomplish this in a Windows OS?
T
On Thursday, April 20, 2017 3:38:42 AM EDT Tim Kane wrote:
> The pgss_query_texts.stat still wants to live in the default *pg_stat_tmp*
> directory, wether by design or not.. but that's a non-issue for me now.
A 30 second investigation of the source seems to indicate that that directory
is hardc
On Thu, Apr 27, 2017 at 6:18 AM, basti wrote:
> Hallo, we have a Postgres database Server and around that there are 8
> clients get data from it.
>
> All servers are the the same datacenter i think (traceroute only 4-5 hops)
>
> Now we plan to move the server to an other hoster/datacenter.
>
> I h
On Wednesday, May 10, 2017 9:08:16 AM EDT Ron Ben wrote:
>
Ron,
You need to figure out how you can make your email client send something else
than base64 encoded HTML with right-aligned text. Your messages are so hard to
parse for me I just ignore them, and I assume there's other people t
On Tuesday, June 6, 2017 10:32:16 PM EDT Patrick B wrote:
> Hi guys,
>
> I've got tableA with 3 columns.
>
> id(seriaL) | type(character varying(256)) | string(character varying(256))
>
> I have the type/string value stored in another table, and from that i would
> like to get the id.
>
> Examp
On Sunday, June 25, 2017 11:02:41 PM EDT Alain Toussaint wrote:
> > Narrowing down the entire file to a small problem region and posting a
> > self-contained example,
>
> The url here contain the set of xml records from a publication I
> worked on many years ago:
>
> https://www.ncbi.nlm.nih.gov/
On Monday, October 2, 2017 2:32:34 AM EDT Frank Millman wrote:
> From: Frank Millman
> Sent: Friday, September 22, 2017 7:34 AM
> To: pgsql-general@postgresql.org
> Subject: Re: a JOIN to a VIEW seems slow
>
> On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:
> > On Thu, Sep 21, 2017 at 3:54
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote:
>
>
> In the java code below, I set the transaction isolation to serialization.
>
> public class IsolationTest {
>
> private static String select = "select * from tmp where url = 'aaa'";
>
> public static void main(String[] args) throws Exception{
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote:
>
>
> In the java code below, I set the transaction isolation to serialization.
>
> public class IsolationTest {
>
> private static String select = "select * from tmp where url = 'aaa'";
>
> public static void main(String[] args) throws Exception{
king for an awful lot of data...
>
> Wei
>
jan
--
--------------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)
arning (0.00 sec)
mysql> select * from test;
++
| td |
++
| -00-00 |
| -00-00 |
| 2007-02-19 |
| 0000-00-00 |
++
4 rows in set (0.00 sec)
mysql>
On Thursday 08 March 2007 11:40:21 am Kevin Hunter wrote:
> I do not know what the setting 'sqlbl' does in Oracle.
SET SQLBLANKLINES ON makes sqlplus not choke on empty lines in your input.
Don't get me started.
jan
--
-------
cast)---
> TIP 1: 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
--
---
connection, since I saw an improvement in the performances without that
> flag and moreover I wanted to make transactions on my own.
Makes sense.
>
> I will change as you told me!
>
> Thanks!
jan
--
--
--
--
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 6: explain
On Wednesday 08 March 2006 11:59, Eduardo Muñoz wrote:
> statement.setObject(2, null);
> statement.setObject(3, null);
You need to use setNull( 2, Types.WHATEVER ).
--
------
Jan de
--------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 3: Have you che
rows, right?
jan
--
--------------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)
rough to the mailing list cleanly
--
--------------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--
---(end of broadcast)---
TIP 9: I
84 matches
Mail list logo
