Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

2018-05-06 Thread Ken Tanzer
On Sun, May 6, 2018 at 10:22 PM, George Neuner wrote: > >> That's the patent database. Microsoft tried to get a *copyright*. I > >I don't think in general you can copyright a file format. > > And you absolutely can *patent* use of any data format for a given > purpose [assuming the purpose it

Re: psycopg2.DataError: invalid input syntax for integer: ""

2018-05-06 Thread David G. Johnston
On Sunday, May 6, 2018, tango ward wrote: > Yes, my apologies. > > May I also ask if there's a limitation for the number of timestamp with > timezone fields in a table? > Not one that is likely to matter in practice. There's a page discussing limitations on the website/docs somewhere if you wis

Re: psycopg2.DataError: invalid input syntax for integer: ""

2018-05-06 Thread tango ward
Yes, my apologies. May I also ask if there's a limitation for the number of timestamp with timezone fields in a table? On Mon, May 7, 2018 at 1:37 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > Please keep replies on-list, don't top-post, and double-check that the > database table

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

2018-05-06 Thread George Neuner
On Sun, 6 May 2018 15:26:22 -0700, Ken Tanzer wrote: >On Fri, May 4, 2018 at 1:03 PM, George Neuner wrote: > >> On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver >> wrote: >> >> >On 05/03/2018 09:47 AM, George Neuner wrote: >> >> >> >> ..., I would not discount the possibility that Microsoft rea

Re: Add schema to the query

2018-05-06 Thread Rob Sargent
> On May 6, 2018, at 8:19 PM, Igor Korot wrote: > > Hi, ALL, > > Is there an easy way to add the schema to the following query: > > SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid = > c.relowner AND relname = ? > > Thank you. > Are you looking for the owner of a particular sche

Re: Add schema to the query

2018-05-06 Thread Igor Korot
Hi, Melvin, On Sun, May 6, 2018 at 9:37 PM, Melvin Davidson wrote: > > > On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson > wrote: >> >> >> >> On Sun, May 6, 2018 at 10:19 PM, Igor Korot wrote: >>> >>> Hi, ALL, >>> >>> Is there an easy way to add the schema to the following query: >>> >>> SELEC

Re: psycopg2.DataError: invalid input syntax for integer: ""

2018-05-06 Thread David G. Johnston
On Sunday, May 6, 2018, tango ward wrote: > cur_p.execute(""" > > INSERT INTO a_recipient (created, mod, agreed, address, > honor,) > VALUES (%s, %s)""", (current_timestamp, current_timestamp, > current_timestamp, '', '')) > > That code doesn't even run (extra co

psycopg2.DataError: invalid input syntax for integer: ""

2018-05-06 Thread tango ward
Good day to all, I need advice on how to solve this problem. I am new to this kind of task. I want to insert data into my PostgreSQL DB. The field that I will store data is a textfield but I am getting an error invalid input syntax for integer: "" My code so far is this: cur_p.execute("""

Re: Add schema to the query

2018-05-06 Thread Melvin Davidson
On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson wrote: > > > On Sun, May 6, 2018 at 10:19 PM, Igor Korot wrote: > >> Hi, ALL, >> >> Is there an easy way to add the schema to the following query: >> >> SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid = >> c.relowner AND relname = ? >

Re: Add schema to the query

2018-05-06 Thread Melvin Davidson
On Sun, May 6, 2018 at 10:19 PM, Igor Korot wrote: > Hi, ALL, > > Is there an easy way to add the schema to the following query: > > SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid = > c.relowner AND relname = ? > > Thank you. > > >Is there an easy way to add the schema to the follow

Add schema to the query

2018-05-06 Thread Igor Korot
Hi, ALL, Is there an easy way to add the schema to the following query: SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid = c.relowner AND relname = ? Thank you.

Re: pg_stat_statements : how to catch non successfully finished statements ?

2018-05-06 Thread legrand legrand
Progress report on this subject: 1/ Some clarifications: What is expected here is to update pgss counters for ALL the queries that have been executed, taking into account queries finished in SUCCESS and thoses finised with ERROR. Main interest here is to catch queries that are cancelled or inte

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

2018-05-06 Thread Ken Tanzer
On Fri, May 4, 2018 at 1:03 PM, George Neuner wrote: > On Thu, 3 May 2018 11:02:00 -0700, Adrian Klaver > wrote: > > >On 05/03/2018 09:47 AM, George Neuner wrote: > >> > >> ..., I would not discount the possibility that Microsoft really > >> has patented some variation of CSV. They absolutely d

Re: User defined functions in Postgresql, troubles with the c code

2018-05-06 Thread Adrian Klaver
On 05/05/2018 06:58 AM, Christof Priller wrote: Hi, I'm searching somebody who has experience with C user defined functions in PostgreSQL. Testing out a simple program which includes the postgres.h file does not work and gives me the following error code in Eclipse. C:\Program Files\Postgre

User defined functions in Postgresql, troubles with the c code

2018-05-06 Thread Christof Priller
Hi, I'm searching somebody who has experience with C user defined functions in PostgreSQL. Testing out a simple program which includes the postgres.h file does not work and gives me the following error code in Eclipse. C:\Program Files\PostgreSQL\10\include\server/c.h:99:21: fatal error: libin

Re: Known Bugs on Postgres 9.5

2018-05-06 Thread Vick Khera
On Sat, May 5, 2018 at 7:49 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > If you want an opinion, opting for more than one release behind current on > fear grounds is an ultra-conservative position - you might as well minimize > the pain and go recent and keep it longer. At this po

Re: what's the error meaning? on mast/slavery replication .

2018-05-06 Thread Laurenz Albe
林晓东 wrote: > > hi,all >I got this when setup two replication server: > > 致命错误: 在主用服务器和备用服务器之间,数据库系统标识符是不一样的。 > 详细信息: 主用服务器的标识符是6551342231479624101,备用服务器的标识符是6551367700460643417。 > ---fatal erro: in main and backup server ,the database 's system id is not > same... > what's mean of